Register same SQL Server more than once in EM
-
Does anybody know if there's a work-around, which makes it possible to register the same SQL Server twice in Enterprise Manager?
I have 2 different databases with dirrefent logins and I would like to be able to access both without having to edit my registration when switching between them.
Thans in advance
-
Run cliconfg.exe from Start | Run. Create an alias to the server. Register the Alias in EM with the second set of credentials.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley -
That was probably the fastest (usable) response I've ever had in any forum.
Thanks, you've just solved a problem that's been annoying me for a while 🙂
-
quote:
Run cliconfg.exe from Start | Run. Create an alias to the server. Register the Alias in EM with the second set of credentials.K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
Nice to know as well, Brian.
Actually I was hoping to hunt you down on the 2,400. Well then...
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Frank, I have a feeling you will be the first to 2500 between the two of us.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley -
*grin*
If I were you, I wouldn't bet on myself.
Hope you won't get frustrated and stop posting.
I really learn a lot from you.
Okay, 10:50 PM. Today's work is done. Time to go home and go to sleep, just to stay up and go to work again. Isn't life wonderful sometimes? *sigh*
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
Can you register it once using the servername, then again using the IP, or even multiple IPs?
Once you understand the BITs, all the pieces come together
-
Yes - u can register by both machine name and IP address
-
I didn't set out to do this, but I have the same server registered by it's machine name and it's IP address. I did it initially to reach the server from the outside, but I have found it useful as well to test permissions problems.
Student of SQL and Golf, Master of Neither
Student of SQL and Golf, Master of Neither -
You can also register it by full dns name. Which might be a better solution as you want your application developers to use DNS names to connect rather than the shorter WINS name (WINS is much less reliable than DNS) so that server replacements and database moves are transparent to the applications. Just create a DNS for each application.
-
True, but keep in mind if search suffixes are properly configured on the workstation, it'll append the domain suffix when doing a DNS lookup to find the server. For example, if I have a workstation in the Active Directory domain contoso.com or I've ensured the network identity is set so that the workstation knows it's in contoso.com or in TCP/IP properties I've configured it to append the suffix contoso.com (yup, three possible ways), I can connect to sql.contoso.com by using sql, even if WINS isn't present. Caveat: the sql.contoso.com will have to be registered in DNS... but with dynamic registration, this usually isn't an issue.
K. Brian Kelley, GSEC
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
Edited by - bkelley on 12/18/2003 06:52:41 AM
K. Brian Kelley
@kbriankelley
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply