Connect SQL Server 2005/2008 over the Internet

Question

How to connect to SQL Server 2005/2008 using Management Studio or another desktop application over the Internet?

Answer 1

Check WCF Data Services :

http://msdn.microsoft.com/en-us/data/bb931106.aspx

Thus, you do not need to fully disclose your database server on the Internet, but you get fine control over what is exposed and who (what type of user) can see or change what.

Mark

Answer 2

I finally solved this:

SQL- 8080 1433 ( - )

Windows . , , , , . , 8080 SSMS . SSMS ( , ).

, . 8080 .

Windows, , SSMS.

: Windows 7 Pro 64- 24

Answer 3

"" SQL- ( , ) ... , ...

VPN.

Answer 4

sql IP .

: IP\_

.

Answer 5

, , , , , , , . SQL Server.

Management Studio VPN-, , IP- , .

- WCF, .

, .

Answer 6

Firstly, if we consider the security issue, you need to configure the SQL server (sql surface configuration) to receive traffic, then you need to open the appropriate ports on your server and allow incoming traffic through your router to the SQL server.