Connecting to Remote Database using EM

Hi to all:

I always had a problem connecting to SQL Server from home using EM.

I do add a new server registration, but i always get the following exception:

A Connection could not be established to IP ADDRESSReason: SQL Server does not exist or access denied.ConnectionOpen(Connect())

At the same time, I do use a utility, found athttp://sql.bhaidar.net to connect to the same database and works perfect.

Is there any configuration I should do to my pc, don't know maybe some port configuration or so, to allow EM to connect to those remote databases?

Thanks in advance.

Regards

Can you 'ping' the IP address successful? If yes, can you 'telnet' the IP with the port used by SQL server service?(use Network Utility to configure it) How about force to connect with TCP/IP? That means when you register the server in EM, using 'tcp:xxx.xx.xx.xx,yyyy' as server identifier (where x stands for IP address, and y for port number)|||

Well, I am unable to ping it, although it is a working server. Is it something related to Win XP FireWall? Should I allow a port or so?

Thanks

|||

Maybe. As I know the Internet Connection Firewall (ICF) on WinXp does not allow resposing to ICMP packages (used by ping) from unknown IP. You can configrue this in ICF: go to 'Advance' pannel->'Local Area Connection'->Find ICMP pannel->enable 'Allow Response...'(something like this, I don't remember exactly options on WinXP, please be patient to find it out).

If after 'ping' enabled and you can 'ping' successful, then you can try to create a alias for the SQL Server and connect via the alias on the client machine.. You'd better enable both TCP/IP and Named Pipe network protocols on the SQL machine. Go to 'Start'->'All Programs'->'Microsoft SQL Server', you can find 'Client Network Utility' and 'Server Network Utility, where you can configure your SQL connection options. The 'Alias' pannel can be found in 'Client Network Utility'.

Hope this helps:)

sqlsql