dbTalk Databases Forums  

WMI for SQL aliases?

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss WMI for SQL aliases? in the microsoft.public.sqlserver.tools forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
cc
 
Posts: n/a

Default WMI for SQL aliases? - 05-27-2010 , 04:24 PM






I have a WMI script that will add SQL Server Aliases (configured via client
network utility or SQL Configuration Manager). It works perfect for machines
that have SQL client tools installed. it queries
\root\Microsoft\SqlServer\ComputerManagement10.

But for end user machines that do not have SQL tools, I do not see even
\root\Microsoft\SqlServer. Not sure how to find aliases configured with the
client network utility that ships with Windows. Aliases are created, edited
and deleted easily and in the same manner as when SQL tools are present, but
I need to query via WMI in both cases.

With SQL tools installed: query
\root\Microsoft\SqlServer\ComputerManagement10\Sql ServerAlias

Without SQL tools installed: query \?????

Any ideas?

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.