Welcome to dbForumz.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

WMI for SQL aliases?

 
   Database Forums (Home) -> Tools RSS
Next:  2008R2 Views with ORDER BY clause  
Author Message
cc

External


Since: Apr 02, 2006
Posts: 2



(Msg. 1) Posted: Thu May 27, 2010 2:24 pm
Post subject: WMI for SQL aliases?
Archived from groups: microsoft>public>sqlserver>tools (more info?)

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\SqlServerAlias

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

Any ideas?

 >> Stay informed about: WMI for SQL aliases? 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
BCP Problem - Please Help !! - When I try to bcp out data from a table with text columns, the following error prompted : Starting copy... SQLState = S1001, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver]Memory allocation failure Most grateful if anyone can provide help...

Connectivity to Informix Database - I am evaluating MS SQL Server Reporting Services and during the process, I encountered issues pertaining to connectivity with Informix Database. I want to design a report by retrieving data from Informix database. I have a code that generates the .RD...

High Compilations counter but few cache insert events in p.. - I've been testing a system and it shows a high compilation rate (280/sec out of about 315 batch requests/sec) on SQL Server/perf counters, but when I trace it in profiler there are very few cache insert events (like one every few seconds). There are ...

Profiler - Trace SQL Server assignment problem - My development machine was built using an image from someone else's computer (thinking it would save me time). When I start a new trace, I can intially select (local) as the Trace SQL Server but it reverts to the instance name that the image was take...

Windows XP Problem: SQL Profiler hangs when trace is pause.. - I've recently installed Windows XP on my laptop, and ever since, when I use SQL Profiler, I can't pause or stop a trace, or exit with a running trace. Any of these activities causes profiler to hang and stop responding. In short, once I've started a..
   Database Forums (Home) -> Tools All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]