Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a server running on my VPS which hosts the .com that it runs off of. Normally I Remote into this VPS and open management studio and do what I need to do.

How can I connect to the database on my webserver from my office using Management Studio. Can I?

Also, what security concerns are there when doing remote connections?

share|improve this question
Which version of SQL server is this, the methods for allowing remote access differ between 2005 and 2008 – Sam Aug 27 '10 at 9:51
I am using MSSQL 2008 – Blankasaurus Sep 10 '10 at 20:34

You will need to check with your hosting if the sql tcp port is open or firewalled (typically port 1433)

You will also need to configure the sql server to allow remote connections.

share|improve this answer
Ill give it a try. Are there (m)any security risks I face by doing this? – Blankasaurus Sep 10 '10 at 20:35
There is a possibility that someone guesses or brute forces your password. Also make sure the SQL server has the latest security updates. – WilfriedVS Sep 12 '10 at 11:51

Your Answer


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.