Sunday, February 26, 2012

EM - connect to correct server

Hello -
I can connect to other servers through QA with no problem, however, when I
try to access another server through Enterprise Manager, I cannot find where
I can change the server. It is defaulting to my local machine.
Can someone tell me how to do this?
Any help is greatly appreciated!
SandyIn EM, right click on your LOCAL connection. When the menu comes up you hav
e
two option "Edit SQL Server Registration properites" or "New SQL Server
Registration". Use the "New.." item to create a new item to your other
server, or if you what to change the LOCAL registration ot point to a
different server then pick the "Edit..." item.
"Sandy" wrote:

> Hello -
> I can connect to other servers through QA with no problem, however, when I
> try to access another server through Enterprise Manager, I cannot find whe
re
> I can change the server. It is defaulting to my local machine.
> Can someone tell me how to do this?
> Any help is greatly appreciated!
> --
> Sandy|||Check out in the BOL:
Administering SQL Server -> Managing Servers -> registering Servers
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/|||Thanks for your response, Greg!
Does this just register it on my local machine so I can access and use it?
In other words, am I changing any settings of the particular instance of Sql
Server on the server by doing this?
Also, it does not give any options for using Mixed Mode. The instance of
Sql Server I'm using is Mixed. How would you handle this situation?
Thanks again,
--
Sandy
"Greg Larsen" wrote:
> In EM, right click on your LOCAL connection. When the menu comes up you h
ave
> two option "Edit SQL Server Registration properites" or "New SQL Server
> Registration". Use the "New.." item to create a new item to your other
> server, or if you what to change the LOCAL registration ot point to a
> different server then pick the "Edit..." item.
> "Sandy" wrote:
>

No comments:

Post a Comment