Tuesday, March 27, 2012

connecting to sql server

i want to connect to an remote sql server 2005 from my office , where there remote sql server is in USA and my office is at india, i have done all the setting on the server where i have enabled remote connections and tcp/ip, i need to connect to the sqlserver using sql server management studio at my office, is it not possible to connect to an remote sql server without VPN

Few things to check

1. Does US SQL server machine has Firewall enabled? (considering opening the corresponding port)

2. Does INDIA machine has Firewall enabled?

3. If Windows Login is used to connect to US SQL server, is the login granted?

4. If you still see connection errors, you may consider to post the error message, error number and connecting scenario to "SQL Server Data Access " forum.

Thanks.

This posting is provided AS IS with no warranties, and confers no rights

No comments:

Post a Comment