Contents
What to do if your SQL Server is not connecting?
Check if you are able to connect to SQL Server from other client systems and different user logins. If you are able to, then the issue could be specific to the client or login that is experiencing the issue. Check the Windows event logs on problematic client for additional pointers. Also check if network drivers are up to date.
How to start and stop the SQL Server browser service?
If the browser service is not started, the connections would fail. On the system running your SQL Server instance, either use the SQL Server Configuration manager or the Services applet in Control panel and start the SQL Browser Service if it is not already started. For more information, see How to: Start and Stop the SQL Server Browser Service
What to do when SQL Server defaults to non-standard port?
If your SQL server default instance is using a non-standard port, see Running SQL Server ‘Default’ instance on a non-default (or non-standard) TCP port: : tips for making application connectivity work. Try appending the port number of SQL Server to the server name using the format , portnumber and see if that works.
What to do if SQL Server is running on Port 2000?
Try appending the port number of SQL Server to the server name using the format , portnumber and see if that works. For example, if your SQL instance name is MySQLDefaultinstance and it is running on port 2000, specify the server name as MySQLServer, 2000 and see if that works.
What is the name of the SQL server connection provider?
Named pipes: Server local connection provider is ready to accept connection on [\\\\.\\pipe\\sql\\query ]. TCP/IP and port number: Server is listening on [ ::1 1433]. Application and System event logs from SQL Server and Client systems. If the connections are failing from an application, the connection string from the app.
How can I tell if my SQL server connection is maintained?
If you have connection pooling enabled in the connection string for the SQL Server Native Client, then connections are maintained to the SQL Server. Check this MSDN blog for some technical details about how you can confirm if connections are being maintained.
What to do if your SQL Server instance is using a non-standard port?
Determine the port number your SQL instance is running. If your SQL server default instance is using a non-standard port, see Running SQL Server ‘Default’ instance on a non-default (or non-standard) TCP port: : tips for making application connectivity work.