Home > IT Answers > Microsoft Windows > MS SQL Server 2000
Sudh2k
0 pts.
 MS SQL Server 2000
Access, Application development, Backup & recovery, CLP, Data analysis, Data mining/analysis, Data warehousing applications, Database, DataCenter, DB2, DB2 Universal Database, Desktops, Email, IBM Marketing Sound Off, Management, Microsoft Office, Microsoft Windows, Oracle, OS, Patch management, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, Servers, SQL, SQL Server, Web development
Hi All, Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

Software/Hardware used:
ASKED: November 8, 2006  12:53 AM
UPDATED: November 13, 2006  5:20 AM
RELATED QUESTIONS
Answer Wiki:
You need public IP for that SQL server machine if your server is located behide firewall u need to config your firewall to redirect to SQL server machine with specific port that sql server use.
Last Wiki Answer Submitted:  November 8, 2006  1:37 am  by  Davemonk   0 pts.
All Answer Wiki Contributors:  Davemonk   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

You need to have public ip to access that sql server machine. If your server is located behind firewall, u have to configure firewall to redirect to sql server with specific port (default is 1433) then using enterprise manager to connect to that internet ip.

Another way is to use VPN connect to your office network and use EM like u sit in the office.

Davemonk
 0 pts.
 

Thanks so very much,Devmonk. I tried it through firewall via port forwarding, but failed. I’m trying on it, will let you know.

Thanks
Sudh.

Sudh2k
 0 pts.