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?

  • Which version of SQL server is this, the methods for allowing remote access differ between 2005 and 2008 – Sam Cogan Aug 27 '10 at 9:51
  • I am using MSSQL 2008 – Jason 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) http://support.microsoft.com/kb/287932

You will also need to configure the sql server to allow remote connections.http://support.microsoft.com/kb/914277

| improve this answer | |
  • Ill give it a try. Are there (m)any security risks I face by doing this? – Jason 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 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.