Saturday, August 3, 2013

Can' Connect to SQL Server 2008 R2 Advanced Services

Are you connecting to Database Engine or one of the other options? What are you entering for "Server name" when you try to connect? If you're connecting to localhost / 127.0.0.1, go into SQL Server Configuration Manager, SQL Server Network Configuration, Protocols for MSSQLSERVER, and check in the TCP/IP properties (assuming it's already enabled). In the IP Addresses make sure the interface you're using to connect is enabled.

No comments:

Post a Comment