"I have installed and reinstalled SQL 2008 Server Standard and everytime I try to connect using MS Sql Server Management Studio I recieve the following. A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2) I get this error wether I use AD credentials or SA user. Or if I point the (LOCAL) or I spell out the database name. Note that this is on Microsoft Windows server 2008 R2."
$0Try using the IP address if it is the default instance, or IP address plus the instance name (eg. 192.168.1.1\server1). If the port is not the default port, create an alias for the server and try using the alias to connect.$0
$0Hope this works for you.$0