Currency ' Euro - Pound
Languages › Dutch • English • French • Italian • Spanish • German • Swedish
Delivery time ' EMAIL with key delivered within 2 minutes
I can’t connect to SQL Server—what should I do?
I can’t connect to SQL Server—what should I do?
First, check the full error message, server name, and login method. A network error, failed login, and certificate error can have different causes. Therefore, do not reinstall SQL Server right away.
Step 1: Check the server name
In SQL Server Management Studio (SSMS), use the correct server and instance:
- Default instance: SERVERNAME.
- Specified instance: SERVERNAME\INSTANCENAME.
- Common TCP port: tcp:SERVERNAME,PORTNUMBER.
Use localhost only if SQL Server is running on the same computer as SSMS. Check the actual instance name; SQLEXPRESS is not the correct name for every installation.
Step 2: Check whether the database service is running
On the server, open SQL Server Configuration Manager → SQL Server Services. Check the status of SQL Server (MSSQLSERVER) or SQL Server (your instance name).
Restart the service if it has stopped. If the restart fails, save the error message and have the SQL Server ERRORLOG reviewed.
Step 3: Verify your registration
- Windows Authentication: Your Windows account must have access to the instance.
- SQL Server Authentication: Use an existing SQL login; the server must support this authentication method.
If you encounter a “Login failed” error or error 18456, have the administrator check the login, permissions, and additional error information in the server log. A Windows administrator account does not automatically have SQL Server access.
Step 4: Check external accessibility
Does the connection work locally but not from another computer? If so, have it checked:
- Whether the server name points to the correct address.
- Whether TCP/IP is enabled for the correct instance.
- Which TCP port does SQL Server listen on?
- Or the firewall that allows the connection.
Port 1433 is the default port for a standard instance, but not every installation uses this port. Plan for a service restart if necessary after making configuration changes.
I’m getting a certificate or SSL error
Verify that the server certificate is valid, trusted by the client, and matches the server name being used. Do not disable certificate verification by default just to make the notification disappear.
Need help connecting?
Email your SQL Server version, login method, and a screenshot of the full error message to info@cd-keys.uk, or use the contact page. Please specify whether the connection failed locally or remotely and whether it worked previously. Include your order number if your question is about a purchase. Do not share passwords or database contents.
