Home / server / Questions / 175095
In Process
Jason
Asked: 2010-08-27 20:22:40 +0800 CST

Connect to Remote SQL Server Using Management Studio

  • 772

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?

sql-server

1 Answers

  1. 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

    • 1