I just installed SQL server 2008 on a new desktop computer. I created the default instance of MSSQLSERVER and I cannot connect to it with management studios.
Here is the error I get:
Cannot connect to .\MSSQLSERVER.
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: SQL Network Interfaces, error: 25 - Connection string is not valid) (Microsoft SQL Server, Error: 87)
I have tried many things and verified the following:
MSSQLSERVER is currently running
The TCP and Named pipes have been enabled
Port 1433 is open on the windows firewall
username and password is correct
Named instance it correct .\MSSQLSERVER
I can't think of anything else to check. I've done this before on my home computer and it worked. Now I'm trying it on a new work computer. This computer is on a network, could that have something to do with it? Maybe there is another firewall... I'm stumped