Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

It's actually SQL Server Management Studio Express. Do I need the full version? How do I connect?

share|improve this question

2 Answers 2

up vote 5 down vote accepted

SQL Management Studio Express will work just fine. The normal setup pattern would be something like this:

  • enter the server's IP address (and optional \instancename) in the connect window
  • select SQL or Windows authentication as appropriate. Hosters typically assign SQL logins.
  • username and password as assigned.

This connection should work on any home subscriber internet package. Your ISP may be blocking those ports, so keep that in mind.

Ensure your Windows firewall is configured to allow SQL Management Studio access to outbound connections. Ensure your home router firewall is allowing traffic out. If NAT is doing its job properly, you shouldn't need to configure your hardware firewall.

Above all, check your host's knowledge base. They may have an FAQ page that has the appropriate steps documented.

share|improve this answer
    
It worked the first time I tried it. Awesome. Thanks! –  Robert Harvey Jul 16 '09 at 5:52

You will need to ensure the SQL Server is configured to allow remote connections.

By default this option is not enabled. You didn't mention which version of SQL, so I can't give specific instructions.

You will also need to be running the SQL Server Browser service, which listens for incoming requests for SQL resources and provides info about instances running on the computer.

Firewalls may also cause an issue, but I'd check the above first.

share|improve this answer
    
The ISP says they're configured properly. They're probably running 2008. Will it work over DSL? –  Robert Harvey Jul 16 '09 at 5:22

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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