MSSQL Server Monitoring Wizard Configuration

[wipro-cloud-services]

When i try to monitor DB with MSSQL Server Monitoring Wizard Configuration wizard, Status shows "Warning" and Status Information as "(null)". Please advice on the below queries.

Address - IP address of server ?
Instance - Hostname of server or IP address ?
Username and Password - SQL or Windows authentication credentials ?

Can you please advice.

[nscott]

Address - Yes, IP address of the server
Instance - If you don't know what this is, leave it blank. This is how the MSSQL hands off to different databases running on the same server. If you call the database something like MSSQLSERVER\TECH_SUPPORT. TECH_SUPPORT would be your instance name.
Username and Password - It must be SQL authentication.

[wipro-cloud-services]

I have tried, but same error. Updated details below.

Server IP: 10.194.131.193
Hostname: ZEW-V-0AC283C1

And configured details as below:

Address: 10.194.131.193
Instance: LEFT BLANC first time an used ZEW-V-0AC283C1 in second time. Same error.
Port: 1433
Username: ZEW-V-0AC283C1\sa and only sa second time.
Password: Entered password.

Please let me know if anything is missed above.
I have opened up all the ports in the server and also installed "NSCP-0.4.0.183-x64" package

[slansing]

Is ZEW-V-0AC283C1 your database name or the name of the instance? This is as equally important as the other parts because the checks need to be directed at a specific instance if you are running multiple databases.

[wipro-cloud-services]

ZEW-V-0AC283C1 is the instance name, Database name can be taken as "TEST"..

[nscott]

You're going to have to try running this on the command line and see the error the its giving:

Drop to the command line and run the following commands:

Code: Select all

cd /usr/local/nagios/libexec
./check_mssql_database.py -H 10.194.131.193 -I 'ZEW-V-0AC283C1' -U <username> -P <password> --table=TEST

What does that return?

[wipro-cloud-services]

Apologies for delay. "CRITICAL:Unable to access SQL Server." returns from command:
./check_mssql_database.py -H 10.194.25.52 -I 'ZUE-V-0AC21934' -U test123 -P test123 --table=TEST

I have started testing with different server, so IP and hostname have changed now. Please let me know.
SQL login test123 has full access to all the DB's.

Please check and advice.

[scottwilkerson]

I noticed in your post above you labeled as hostname. The -I is not for hostname it is for Instances, and if you aren't using instances you should leave that off.

Try

Code: Select all

./check_mssql_database.py -H 10.194.25.52 -U test123 -P test123 --table=TEST

[wipro-cloud-services]

Team,
Now we are able to monitor Database. Thank you for the support provided.

[slansing]

Closing thread and marking as resolved, thanks for letting us know!