Home > IT Answers > Microsoft Windows > Managing SQL 2000 server over the internet
SQLDEV
5 pts.
 Managing SQL 2000 server over the internet
Access, DataCenter, Desktops, Management, Microsoft Office, Microsoft Windows, OS, Patch management, Security, Servers, SQL Server
I have an SQL 2000 server behind a firewall. I have set the ports to be forward to this server. I would like to manage this server from home using enterprise manager. How can I accomplish this.

Software/Hardware used:
ASKED: January 18, 2007  12:20 PM
UPDATED: January 19, 2007  8:34 AM
RELATED QUESTIONS
Answer Wiki:
If you have assigned a public ip address to your SQL Server than just connect to it with the tools you have. You would need to connect to the ip address, not the machine name. If the SQL Server has a private ip then you will not be able to connect to it by simply opening the port. Charles Deaton www.SQLSIG.org
Last Wiki Answer Submitted:  January 18, 2007  12:46 pm  by  ChasTheDataGuy   0 pts.
All Answer Wiki Contributors:  ChasTheDataGuy   0 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


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

 

Not the most elegant solution, but if the SQL server is behind the firewall you could run Windows Terminal Server, PCAnywhere or even use a GotoMyPc type service. Connect to the actual server or another workstation that is setup with enterprice manager, I would recommend the latter.

Jline6
 0 pts.