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
  • 1
    Hmmm.....even after following all the tips in this, I still can't connect to my SQL server remotely! 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
3
  • Spot on! That worked! :)
    – Kjensen
    May 13 '09 at 14:34
  • Other think that should should see is of the Broker Service is ON. May 13 '09 at 15:43
  • The TCP/IP was what was giving me the issues! Thank you!
    – Jaskier
    Jul 16 '20 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.

2
  • 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. 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.