up vote 7 down vote favorite
3
share [g+] share [fb]

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.

link|improve this question
100% accept rate
Hmmm.....even after following all the tips in this, I still can't connect to my SQL server remotely! – Sam Schutte Dec 19 '09 at 1:08
feedback

2 Answers

up vote 8 down vote accepted

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
link|improve this answer
Spot on! That worked! :) – Kjensen May 13 '09 at 14:34
Other think that should should see is of the Broker Service is ON. – Jedi Master Spooky May 13 '09 at 15:43
feedback
up vote 2 down vote

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.

link|improve this answer
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 May 13 '09 at 14:59
Actually, if you want to use Kerberos in any capacity, to include just authentication. – K. Brian Kelley May 13 '09 at 15:09
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.