Remote Access using Enterprise Manager

[ResolutionsNET]

Hi,

Can anyone help me. I need to access an SQL Server (7) on an internet site via our network. Ideally, I would like to use Enterprise Manager. Can anyone advise?

Thanks

 

[foxdev]

You didn't ask a specific question, so I'm guessing:

Set the client protocol to TCP/IP, and connect to the server using its IP address (you can also create a server name alias that matches to the IP address in the Client Network Manager). Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com

 

[ResolutionsNET]

Thanks,

Basically using the Enterprise manager I would like to amend a remote database.

I've checked the server machine (based on the internet) it is setup to listen for TCP/IP connections on port 1433. I added a server alias on the client machine (using the web ip address). But when I try and register, via the IP address I still receive a timeout message.

Any ideas?

 

[tlbroadbent]

Does the remote Internet site have a firewall that is preventing your access? The system administrator may need to open access for you. Terry

http://members.home.net/tlbroadbent/index.htm

 

[foxdev]

I should have mentioned the firewall possibility in my post (thanks, Terry). Try pinging the target server (run PING IP address) to see if you can ping it. If you can't, then you have network issues (firewalls, etc).

If you can ping it, make sure that you've set up the client machine (not just the server) to use TCP/IP protocol, rather than the default Named Pipes.

Let us know what happens. Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com

 

[ResolutionsNET]

Thanks guys I've got it working now, the first solution did work, but because the internet connection we have it was timing out before a response could be recieve. Well, it's working now, ta