But really SQLDIAG I do, and I am not lying!! I have helped multiple users of SQLDIAG (not SQL Nexus) trace down the root cause of this issue. SQLDIAG is a tool that is used to collect data which can be imported into a SQL Server database with the help of SQL Nexus. The error that you get in the ##SQLDIAG.LOG file when you try collecting data using the configuration files downloaded from the SQL Nexus website is:
2011/04/05 22:54:32.27 SQLDIAG Failed to open Software\Microsoft\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER key . Function result: 2. Message: The system cannot find the file specified. 2011/04/05 22:54:32.27 SQLDIAG There are no instances of version 10 on this computer 2011/04/05 22:54:32.27 SQLDIAG . Function result: 87. Message: The parameter is incorrect.
The above error is most commonly due to the use of the SQLDIAG configuration file which was configured to capture data from SQL Server 2008 instances. So if you are using the same configuration file to capture data from SQL Server 2008 R2 instances, then you need to make a small change to the .xml configuration file. The XML file will have an XML tag with the name “Instance”.
<Instance name="<instance name>" windowsauth="true" ssver="10.5" user=""> OR <Instance name="<instance name>" windowsauth="true" ssver="*" user="">
If you want to collect data only from a SQL Server 2008 R2 instance, then you can change the ssver value from 10 to 10.5 (first example above). If you intend to collect data from more than one instance from two different releases of SQL Server (eg. SQL Server 2008 and SQL Server 2008 R2), then you need to change the ssver value to *.
The <instance name> place holder is for the SQL Server instance. The instance name provided depends on the data collection scenario:
Name = * - If you want to collect data from all instances
Name = Instance Name – If you want to collect data only from a specific stand-alone instance SQL Server named instance
Name = MSSQLSERVER – If you want to collect data from a default stand-alone SQL Server instance.
There are other reasons due to which this issue occurs:
Happy data collection! J
Amit Banerjee SQL Server Escalation Services Twitter: @banerjeeamit