Reg connecting to the remote server

[unicorn11]

Hi Everybody

I am presently in india and we have a server in the US
I have to connect to the server at us then the steps that
i have to follow are open my SQL Server Enterprise manager
Select my SQL Server Group then Choose New SQL Server Registeration
I get a Wizard
When i select next i get it shows a list of available servers i then add the ip of the server in the US and i select add then next enter the username and password then it confirms where to add the server when u select next it tries to connect but it says connection failed

Please help

Regards
Unicorn11
unicorn11@mailcity.com

[red]Luck is not chance, it's toil; fortune's expensive
smile is earned.[red]

 

[tlbroadbent]

There are several possible reasons. A little more info is needed.

1- Which protocol are you using to connect?
2- Are there any firewalls between your location and the remote server?
3- Do you have the correct IP address for the remote sever? And the correct SQL listen on portal?
4- How fast are the respective internet conections? Is it possible that the connection is timing out?
5- Do you have permissions on the remote server? Do you have a correct login/password for the remote server?
6- Does the failure provide any message that indicates why it occurred?
Terry

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

 

[foxdev]

Terry gave a great enumeration of the issues. Unicorn11, can you PING the server using the IP address of the server? If yes, make sure you've set the client protocol to TCP/IP (using Client Network Utility) and verify that the server is listening on TCP/IP (in addition to any other protocols it may be using). Robert Bradley

http://www.lowcostprints.com

http://www.foxdev.com