I used to do this all the time till recently when we discovered that EM uses a hell of a lot of network chatter between client and server, which seemed to cause trouble with our router. now we connect to the server with terminal services and use the local EM. You might be OK though.
It also requires that the remote SQL Server is not hiding behind a firewall, as a large number are (more since the slammer worm, actually)|||Another handy way to do it, particularly if you've just got the IP address but would rather use a name, is to create an alias using the Sql Server Client Network Utility:
1. Click Start->Programs->Microsoft Sql Server->Client Network Utility
2. Select the Alias tab and click the Add button.
3. Provide the Server alias name in the top text box. This will be the name you will eventually see in Enterprise Manager.
4. In the Network libraries radio box select TCP/IP (which is probably what you want).
5. For the Server Name enter the IP address of the server to which you're trying to connect.
6. Click OK.
7. Go back to Enteprise Manager and select "New Sql Server Registration". For the server click the "..." button and you should see the Alias on the list. Select it and continue with the registration (passwords and so on).|||Thank you... :)
I already obtained the connection to the server.
No comments:
Post a Comment