Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kish
Starting Member
45 Posts |
 Posted - 2004-02-27 : 04:37:57
|
| hi,I have 2 sql servers on which i have configured log shipping.Now i have one more server which is geographically placed somewhere else, and i want to get that server in the EM of one of the server on which i have configured log shipping. Basically I want to connect a remote server and access it through Enterprise manager. Pls. help. |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2004-02-27 : 04:55:34
|
| u can register the server in EM under register new server option u need to give the ip or the webname like db.database.com etcHe is a fool for five minutes who asks , but who does not ask remains a fool for life! |
 |
|
|
kish
Starting Member
45 Posts |
Posted - 2004-02-27 : 05:28:17
|
| i have connected by using ip address. but it connects to only the default instance. If there are more than one instances on the remote server than how do i go about. |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-02-27 : 09:03:50
|
| I might be missing something here. You should be able to register it as 192.168.1.1\INSTANCE. This allows you to register instances other than the default.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-02-27 : 12:36:24
|
| Or you could create an alias on the client using Client Network Utility. In the alias, you specify the port number for the instance.Tara |
|
|
|
|
|
|
Remote server in EM