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? |