Alter EM registered servers so they contain dns-suffix
-
I'm looking for a way to have the dns-suffix added to the registered sqlservers in EM.
We have a NĀ° of sql-clients, that will have to be altered the same way, so maybe a vbs might be usefull.
Who knows which registry-keys/values have to be altered and how ?
I guess it should be in "Software\Microsoft\Microsoft SQL Server\80\Tools\SQLEW\Registered Servers X", but how ?
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution š
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
I haven't seen any way, documented or undocumented. I'll take a look and see if I can dig up something. Renaming the key would be logical but didn't do anything.
K. Brian Kelley
@kbriankelley -
I've already tested that (change of keyname) with no luck,
but the key-value is a bunch of hex-stuff, where I think It all has to be done.
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution š
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Would creating aliases with the suffix in them not work for you?
-
You can set the aliases in the registry, they are located under HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Client\ConnectTo
You could set the keys here and display the info in EM.
-
This might help if it were only for me or if I was the onlyone to be registering servers on clients, however, that is not the case.
I would like to have everyone having visible what he/she is connecting to, unlike e.g. Oracle-tnsnames.ora , where you as system-support have to examine what settings are in use and where the settings lead to.
Ofcourse the use of sql-client-config may also misslead/confuse, but we do not promote the use of it. (nor do we promote odbc-dsn usage)
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution š
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply