up vote 0 down vote favorite
share [g+] share [fb]

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?

link|improve this question
57% accept rate
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
feedback

1 Answer

up vote 1 down vote

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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