MSSQL ODBC check unable to login
Hi,
I am trying to setup a rule to check the availability of a MSSQL database. The SQL database is set to use domain credentials. I tried to define the rule to use the domain admin id and password (modified the template to use the uid/pwd). However, I get the Unable to login error.
Any suggestions?
Your help is very much appreciated
I am trying to setup a rule to check the availability of a MSSQL database. The SQL database is set to use domain credentials. I tried to define the rule to use the domain admin id and password (modified the template to use the uid/pwd). However, I get the Unable to login error.
Any suggestions?
Your help is very much appreciated
This discussion has been closed.
Comments
If Windows authentication is on, then passing on the username/password in the ODBC SQL string will not work since it uses the Windows connectivity for authentication.
Best is also to enable username/password logon to the SQL server for the computer running ServersCheck.
Could not start the ServersCheck Monitoring Service service on Local Computer
Error 193:0Xc1
Please help
Event Type: Error
Event Source: Service Control Manager
Event Category: None
Event ID: 7000
Date: 7/8/2005
Time: 10:56:04 AM
User: N/A
Computer: ROCKCHECK
Description:
The ServersCheck Monitoring Service service failed to start due to the following error:
ServersCheck Monitoring Service is not a valid Win32 application.
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Thanks for the help.