Hello!
I was getting this error with mssql.vbs on a particular host and I found a work-around:
[DBNETLIB][ConnectionOpen(Connect()).]SQL Server does not exist or access denied.
This Windows 2008 host has many IP addresses and the MS-SQL server (also 2008) is clustered. ("%COMPUTERNAME%") does not match clustered IP.
I was able to get it working by setting hostname and CONN.Properties(“Data Source”).Value in mssql.vbs. I had to comment most of the If/Else stanza regarding “MSSQLSERVER” like this:
'hostname = WScript.CreateObject(“WScript.Shell”).ExpandEnvironmentStrings("%COMPUTERNAME%")
hostname = “192.168.1.45”
’ In case of instance name “MSSQLSERVER” always use (local) as connect string
’ If instName = “MSSQLSERVER” Then
’ CONN.Properties(“Data Source”).Value = “(local)”
CONN.Properties(“Data Source”).Value = hostname
’ Else
’ CONN.Properties(“Data Source”).Value = hostname & “” & instName
’ End If
I’m running OMD 1.20 with Check_MK 1.2.4p5. I have mostly been using WATO.
Hope this helps!
-pat