Search code examples
sql-serverconnectionpymssql

SQL Server Connection Problems

I just upgraded to a Windows 7 box and installed MS SQL Server 2005 and am trying to 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?

Solution

  • 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