How to Configure SQL Server for Remote Connections ?
Enable SQL Server for Remote Connection on SQL Server 2005, using SQL Server 2005 Surface Area Configuration.
- Enable the TCP/IP protocol using the Surface Area Configuration Utility
- Make sure the TCP/IP protocol is enabled in the SQL Server Configuration Utility
Microsoft has removed the Surface Area Configuration tool in SQL Server 2008. In SQL Server 2008 onwards, Microsoft has launched a new tool named SQL Server Configuration Manager for managing SQL Server Connectivity options.
In case you want to Configure SQL Server 2008 for Remote Connections, follow these steps
Configure SQL Server 2008 for Remote Connections
Enabling TCP/IP protocol for SQL Server 2008 so that you can connect to SQL Server from remote clients.
Open Start >> Programme >> Microsoft SQL Server >> Configuration tools >> SQL Server Configuration Manager and enable the TCP IP Protocol
Configure SQL Server 2012 for Remote Connections
To Connect to SQL Server 2012 from a remote system, you need to Enable TCP/IP protocol for SQL Server 2012 so that you can connect to SQL Server from remote clients.
To Enable TCP / IP for SQL Server 2012, Open Start >> Programme >> Microsoft SQL Server 2012 >> Configuration tools >> SQL Server Configuration Manager and enable the TCP IP Protocol
SQL Server for Remote Connections is enable, but still unable to connect ?
Once you enable to SQL Server for remote connections, you should be able to connect to SQL Services either by name / IP address.
If you still unable to get thru, make sure,
- SQL Services and running and you are connecting to correct TCPIP port
- Check Firewall rules, If there is firewall is placed between your Machine and Server which you are trying to connect, make you SQL Server port is opened.
If you are unsure, how to configure Firewall or which port should be opened in Firewall for SQL connections, please check my previous article, "Port For SQL Server", which answers these questions, here is quick summary of that
We should open a TCP port in firewall on which SQL Services is actually running that means
- open TCP 1433 is SQL Services are installed as default instance and using default port of SQL Services, else
- let SQL SERVER browser services to run in Server as an automatic mode and open UDP port 1434 in firewall, this will allow users to connect to SQL Server instances that are not running on port 1433, without knowing the port number
IF you still have question on how to Configure SQL Server 2005 |2008 |2012 for Remote Connections, post that to QA section.