Managing remote Server with EM

[REK2]

Hi all,
I've search for it and all result where not very effecient..

Am trying to set register a remote sql server in enteprise manager so I could manage it the same way as I am doing with the one I am locally.

My problem is that I always have the "Sql server does not exist or access denied" message.. I've follow all general step that we find a bit accros the web and in the book's online, that is set up the alias/tcp-ip in the network client tools, etc... with no success.

Can somebody point me out to a step by step way of doing it?
Any help will be greatly appreciated.
Thanks
Greetings

 

[SQLBill]

Do you have permissions on the remote database? Do you have access to the remote machine? How have you tried to register it, by NAME or IP Address? Depending on how your network is set up, you may have to use the IP Address.

-SQLBill

 

[REK2]

Hello SQLBill, I've try to acces the server with the host name, the same I use to ftp's my files on...

Does this help's..?

Cheers

 

[SQLBill]

Open a command prompt (DOS Window), go to Start > Run and type in cmd then enter. In that window, type:

PING <servername>

Replace the <servername> with the actual SQL Server name.

like: PING MYServerforSQL

You should get REPLYs back. Your sysadmin can help with this. If you get errors then you can't connect by hostname and may need to use the IP address.

-SQLBill