How To Enable Remote Connections In SQL Server 2012

By default, remote connections should be enabled in SQL Server 2012, but if you are having trouble connecting to SQL you may need to enable this setting. To enable remote connections in SQL Server 2012, do the following:

  1. On the SQL Server, open Microsoft SQL Management Studio 2012
  2. Connect to the SQL Server instance
  3. Right click the SQL Server and click Properties
  4. On the Connections page, under Remote server connections, put a tick in the checkbox to Allow remote connections to this server
  5. Check to see if this has enabled remote connections by trying to connect remotely using Microsoft SQL Management Studio 2012. If not, go to step 6
  6. On the SQL Server, open SQL Server Configuration Manager
  7. Under SQL Server Network Configuration, click on Protocols for MSSQLSERVER (where MSSQLSERVER is ths SQL instance name you are trying to enable remote connections for)
  8. Make sure that TCP/IP is set to Enabled. If the problem still isn’t fixed, you might want to check the properties of TCP/IP, find the TCP Port number that’s being used to connect to the SQL Server instance and ensure that connections are enabled in the Windows Firewall
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)

Leave a comment

Your email address will not be published. Required fields are marked *