Connecting to SQL Server after installation

After installing SQL Server, you will need to configure it so you can connect.

Open SQL Server Configuration Manager

SQL Server Network Configuration:

Protocols for YOURINSTANCENAME
TCP/IP: Enabled

Restart YOURINSTANCENAME

SQL Server Network Configuration:

Protocols
TCP/IP
IP Addresses
TCP Port: 9999 (your chosen port)

Create a Firewall Rule for the port:

Name it something like SQLServer 9999 TCP

Your connection to this new instance from SQL Server Management Studio will be:

yourdomain.com\YOURINSTANCENAME,9999

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.