Kjensen Asked: 2009-05-14 06:25:45 +0800 CST2009-05-14 06:25:45 +0800 CST 2009-05-14 06:25:45 +0800 CST How to enable remote connections for SQL Server 2008? 772 How do I enable remote connections on an SQL Server 2008 installation? I have created a rule in the windows firewall to allow traffic through port 1433, but that does not seem to be enough. sql-server-2008 2 Answers Voted Best Answer CPU_BUSY 2009-05-14T06:29:46+08:002009-05-14T06:29:46+08:00 SQL Server Configuration Managaer SQL Server Network Configuration Protocols for MSSQLServer Enable TCP/IP Also in SQL server Mgmt Studio on the server Right click the server Properties Connections Make sure "Allow remote connections to this server" is checked K. Brian Kelley 2009-05-14T06:41:08+08:002009-05-14T06:41:08+08:00 If it's a named instance, you'll also want to set the TCP/IP port to a static value and enable that in the firewall. Otherwise it's a dynamic port, meaning it could change over time.
SQL Server Configuration Managaer
SQL Server Network Configuration
Protocols for MSSQLServer
Enable TCP/IP
Also in SQL server Mgmt Studio on the server
If it's a named instance, you'll also want to set the TCP/IP port to a static value and enable that in the firewall. Otherwise it's a dynamic port, meaning it could change over time.