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

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
add comment

1 Answer

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

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
add comment

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.