SQL Server Connection Problems

I just upgraded to a Windows 7 box and installed MS SQL Server 2005 and am trying 开发者_StackOverflowto open and connect to my local machine using Windows Authentication.

I keep getting 'Cannot connect to CHRISW7O980'. Do I have to start a server locally?

Suggest using this fantastic ServerFault answer to a similar question to help troubleshoot connectivity issues to new instances of SQL Server. There are a few configuration points to check.

Some likely culprits:

• W7 firewall allowing SQL Server traffic on 1433.
• SQL Server services running?
• SQL Server Configuration Manager not allowing TCP connections.

SQL Server Can't Connect

Check in Sql Server Configuration Manager to ensure your instance of SQL Server is running. If not, you can start it and set the Start Mode to Automatic to automatically start it when windows reboots.

Maybe you are running SQLExpress? Try this for the instance name:

Try using .\SQLEXPRESS.

When you installed SQL Server on your local machine, did you install SQL EXPRESS? If so, you may have to use the instance name CHRISW7O980\SQLEXPRESS.

Also, remember that connections over TCP/IP are disabled for newly installed SQL servers. You'll have to enable that in the SQL server manager.