I am new to SQL Server. I just installed SQL Server 2005 on a new server, and am trying to access it for the first time so I can attach a database to it.
I'm pretty sure I missed something in the installation because when I bring up Management Studio and try to connect as follows:
Server Type: Database Engine
Server Name: (this is blank so I type in the server's IP address)
Authentication: Windows Authentication
Username: (my credentials)
results in this error message:
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server as not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remove connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 51)
I've also tried logging on with SQL Server authentication and the sa password but get a similar error message.
Do I need to run the install again and create a named instance?
Any thoughts appreciated.