Question

  Asked: Nov 8 2006   0:53 AM GMT
  Asked by: Sudh2k


MS SQL Server 2000


Application development, Backup & recovery, CLP, DB2 universal database, Email, IBM Marketing Sound Off, PC/Windows Connectivity, Printing, RPG, RPGLE, Security, DataCenter, Web development, Data analysis, Data mining/analysis, Data warehousing applications, Database, Oracle, DB2, SQL, OS, Servers, Desktops, Management, Access, Microsoft Office, Microsoft Windows, Patch management, SQL Server

Hi All,
Can we connect remotely (from outside LAN) to a MS SQL server 2000 using enterprise manager? If so, what are the steps?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window

Answer Wiki (Improve, edit or add to this answer)


 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0



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.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development, Storage and AS/400.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

davemonk  |   Nov 8 2006  1:42AM GMT

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.

 

Sudh2k  |   Nov 13 2006  5:20AM GMT

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.