Added new SQL Server, Host is added but no SQL Engine shown
DamianLBF
Posts: 1 New member
Existing install of SQL Monitor which was monitoring 2 servers.
I removed a server and added a new server in for monitoring.
After some host configuration the 'add host' test successfully advised it could connect but it doesn't show the SQL server- only that WMI was connected ok.
On adding the server, the host is show but it doesn't populate the SQL instance.
The log makes no comment about connecting to SQL.
The 'configuration' I had to perform on the host all surrounded adding the various permissions needed to query WMI and some odd issue surrounding querying SQL cluster which needed fixes from this page.
I removed a server and added a new server in for monitoring.
After some host configuration the 'add host' test successfully advised it could connect but it doesn't show the SQL server- only that WMI was connected ok.
On adding the server, the host is show but it doesn't populate the SQL instance.
The log makes no comment about connecting to SQL.
The 'configuration' I had to perform on the host all surrounded adding the various permissions needed to query WMI and some odd issue surrounding querying SQL cluster which needed fixes from this page.
Tagged:
Best Answer
-
Jessica R Posts: 1,319 Rose Gold 4Hi and thanks for your post!
Just confirming that you tried modifying the HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Policies\System key as mentioned in that forum post (outlined on https://docs.microsoft.com/en-GB/troubleshoot/windows-server/windows-security/user-account-control-and-remote-restriction)?
If so, can I please check what SQL Server version is this? And if you do this WMI query on the machines from wbemtest does it return an entry for the SQL Server service, or fail with an error?SELECT * FROM Win32_Service WHERE Name = 'MSSQLSERVER' OR Name LIKE 'MSSQL$%'