cannot connect to remote SQL server

Hi,

From the SQL Enterprise Manager, i can connect to MS SQL database in server1, but not on Server2. On Server2 its giving Timeout.

When i login into Server2 by Terminal services and open Enterprise Manager, i can connect to the database.

What could be the reason that within the Server2, can connect to the database, but cannot connect from outside the server.

Any ideas?

Thanksany firewalls between the 2 servers ?
both internal ips ?
can you connect server2 to server1 ?|||No there are no firewalls... (i can login through Terminal services)
And i'm connecting from my local PC to either Server through Enterprise manager.

MS SQL Server of Server1 is giving Timeout.
Any network settings in MS SQL server going wrong?|||Originally posted by reliableHost
No there are no firewalls... (i can login through Terminal services)
And i'm connecting from my local PC to either Server through Enterprise manager.

MS SQL Server of Server1 is giving Timeout.
Any network settings in MS SQL server going wrong?

Two options:

1. Add the server using the Client Network Utility under Microsoft SQL Server. Add the servername u want to use, if you have the IP address of the server add it in. Go under alias -> TCP/IP or if the server is local go alias -> Named pipes

2. Also you could try adding the server name and the ipaddress in the hosts file under 'C:\Winnt\system32\drivers\etc\hosts'.
For eg: 1x.xx.x.xx SERVERNAME

just append this to the end of the host file

Hope this helps