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.
1
- 1Hmmm.....even after following all the tips in this, I still can't connect to my SQL server remotely!Sam Schutte– Sam Schutte2009-12-19 01:08:22 +00:00Commented Dec 19, 2009 at 1:08
Add a comment |
2 Answers
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
- Spot on! That worked! :)Kjensen– Kjensen2009-05-13 14:34:10 +00:00Commented May 13, 2009 at 14:34
- Other think that should should see is of the Broker Service is ON.Jedi Master Spooky– Jedi Master Spooky2009-05-13 15:43:42 +00:00Commented May 13, 2009 at 15:43
- The TCP/IP was what was giving me the issues! Thank you!Jaskier– Jaskier2020-07-16 19:34:53 +00:00Commented Jul 16, 2020 at 19:34
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.
- You'll also want a static port if you're using impersonation as the delegation trusts require a port number when set up in AD.squillman– squillman2009-05-13 14:59:43 +00:00Commented May 13, 2009 at 14:59
- Actually, if you want to use Kerberos in any capacity, to include just authentication.K. Brian Kelley– K. Brian Kelley2009-05-13 15:09:36 +00:00Commented May 13, 2009 at 15:09