Currency ' Euro - Pound
Languages › Dutch • English • French • Italian • Spanish • German • Swedish
Delivery time ' EMAIL with key delivered within 2 minutes
How do I connect to SQL Server?
How do I connect to SQL Server?
Open SQL Server Management Studio (SSMS), enter the server name and login method, and click Connect. You’ll need a working SQL Server instance and an account with access rights.
Step 1: Open the connection window
- Launch SQL Server Management Studio.
- If necessary, select Connect → Database Engine in Object Explorer.
- Under “Server type,” select the “Database Engine” option, if this field is displayed.
Step 2: Enter the server name
| Situation | Example for Server name |
|---|---|
| Standard installation on the same computer | localhost |
| Named instance on the same computer | localhost\INSTANCE_NAME |
| Standard instance on a different server | SERVER NAME |
| The specified instance on a different server | SERVER NAME\INSTANCE NAME |
| Connection via a known TCP port | tcp:SERVER_NAME,PORT_NUMBER |
Replace the example names with your own information. For example, use `localhost\SQLEXPRESS` only if the instance is actually named `SQLEXPRESS`.
Step 3: Choose the registration method
- Windows Authentication: Use your current Windows account. This account must have access to SQL Server.
- SQL Server Authentication: uses a separate SQL login and password. The server must be configured for this.
Check the connection settings and click Connect. If the connection is successful, you’ll see the server in Object Explorer.
What if the connection fails?
Check the server name, instance name, and whether the SQL Server service is running. When connecting from another computer, the network protocol, the port being used, and firewall rules must also be configured correctly.
Are you getting a certificate error? Have the server certificate and the server name used checked. The full error message will determine which solution is appropriate.
Need help connecting?
Email your SQL Server version, chosen login method, and a screenshot of the full error message to info@cd-keys.uk, or use the contact page. Please specify whether you’re connecting locally or from another computer, and include your order number if your inquiry is regarding a purchase. Do not share passwords or database contents.
