Microsoft SQL Server 2016 (8004100E: The namespace specified could not be found)

Hello,

each SQL server version uses a different WMI namespace. The question would be if the SQL Server 2019 does work, or not.

Hi, I have tried 2014, 2016 and 2019 sensors, they all throw the same error. The actual SQL version on the server is 2016.

Hello,

for checking, please use the WMI Tester, and set the namespace to root\Microsoft\SqlServer\ComputerManagement13

Then, use the tab "Advanced" to paste this custom query:

SELECT ServiceName, DisplayName FROM SQLService WHERE SQLServiceType = 1

Do you get a result table or an error?

Hi, I just completed this test and get the exact same error as mentioned above

Hello,

in that case, the sensor cannot work, and the issue cannot be fixed through PRTG.

Please check if you can repair the WMI instances.

So I used the following command to see the actual namespaces containing *SqlServer*:

Get-WMIObject -Namespace root -ClassName *SqlServer* -list -recurse -EA 0

Turns out, the namespace we have on this server is ComputerManagement14, not 13 as mentioned above:

root\Microsoft\SqlServer\ComputerManagement14

Using that namespace in the utility, it works. So can the sensor be forced to use that namespace instead?

So it turns out it was SQL 2017 on that server, and that sensor does work.

We have a SQL 2014 Server and that sensor still doesn't work, but we the error:

"The specified class is not valid"

Hello,

for this please copy the ServiceName property, then change the namespace back to root\cimv2 and run:

SELECT Name, UserConnections, LoginsPersec, Timestamp_Perftime , Frequency_PerfTime, LogoutsPersec FROM Win32_PerfRawData_ServiceName_SqlServerGeneralStatistics

"ServiceName" has to be replaced with the actual name.

Does that work?