Enterprise Manager Question

I have two clients who are on the same Remote SQL server with a webhost (SQLSERVERS1500.COM). Is there a way to connect to add this server to enterprise manager twice so I can connect to each of their accounts separately? Currently when I try to do this Ent. Manager tells me that the Server name already exists. I tried addding one of the servers to a different group, but that gave me the same error message.
thanksYes. You want to use client network utility (cliconfg.exe) to create an
alias then connect via the alias.
--
-oj
RAC & QALite!
http://www.rac4sql.net
"max" <ljp007@.hotmail.com> wrote in message
news:F95280E5-2635-4A09-B9D6-2C6BF69E5D3B@.microsoft.com...
> I have two clients who are on the same Remote SQL server with a webhost
(SQLSERVERS1500.COM). Is there a way to connect to add this server to
enterprise manager twice so I can connect to each of their accounts
separately? Currently when I try to do this Ent. Manager tells me that the
Server name already exists. I tried addding one of the servers to a
different group, but that gave me the same error message.
> thanks|||Create aliases in the client network utility, such as Servername_userA and
Servername_userB, that point to the same IP address or domain name. Then
you can create a registration for each "dynamic server name" with different
users.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"max" <ljp007@.hotmail.com> wrote in message
news:F95280E5-2635-4A09-B9D6-2C6BF69E5D3B@.microsoft.com...
> I have two clients who are on the same Remote SQL server with a webhost
(SQLSERVERS1500.COM). Is there a way to connect to add this server to
enterprise manager twice so I can connect to each of their accounts
separately? Currently when I try to do this Ent. Manager tells me that the
Server name already exists. I tried addding one of the servers to a
different group, but that gave me the same error message.
> thanks|||Use the client network utility to define an alias for one.
>--Original Message--
>I have two clients who are on the same Remote SQL server
with a webhost (SQLSERVERS1500.COM). Is there a way to
connect to add this server to enterprise manager twice so
I can connect to each of their accounts separately?
Currently when I try to do this Ent. Manager tells me
that the Server name already exists. I tried addding one
of the servers to a different group, but that gave me the
same error message.
>thanks
>.
>|||Actually, I see it now, its in the sql server groups when I add a new
server. That worked.
Thanks
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!