Cadzow Knowledgebase

Normal view

SQL Server: General Connectivity Troubleshooting Checklist

  • Check the server & instance name.

  • Check the SQL Server instance is using the required protocol. For example, TCP/IP is not enabled by default.

  • Check the SQL Server instance is configured to listen over the port you think it is.

  • Check the SQL Server instance is actually listening over the port. For example, use the following command:

    netstat -an | find "1433"

    This shows all processes active using port 1433.

    (If the SQL Server instance is configured to use a listening port that falls within Windows' ephemeral port range, that port will need to be reserved. See Various Windows Services Fail After Reboot.)

  • Check the firewall is allowing access to the desired port, and for all interfaces required (domain/private etc), and the desired scope (local subnet etc).

  • Check the SQL Server instance is allowing the desired authentication types, eg Windows authentication only or Mixed Mode (Windows authentication & SQL Server logins).

  • Check the username and password if using SQL Server logins.





Copyright © 1996-2023 Cadzow TECH Pty. Ltd. All rights reserved.
Information and prices contained in this website may change without notice. Terms of use.

Question/comment about this page? Please email webguru@cadzow.com.au