11

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
    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
14

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
| 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
  • The TCP/IP was what was giving me the issues! Thank you! – Symon Jul 16 at 19:34
3

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.

| 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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