MS SQL Wizard

[Flava]

Domain authentication is not working at all, sql authentication works fine. Any other suggestions.

[yancy]

Can you try using mixed mode authentication on the MSSQL server instead of a windows user account.

[sav2880]

Can you try using mixed mode authentication on the MSSQL server instead of a windows user account.

I'm experiencing a similar issue and want to get a clarification here. I'm attempting to use a domain account to login, but have mixed mode authentication turned on ... are you saying in this case you'd like us to try a non-domain login with mixed mode turned on?

[sav2880]

A little more to add to my own travails on this:

I took a look at the command for my particular attempt, it reads as this:

$USER1$/check_mssql_server.py $ARG1$

However, the SQL Wizard that I installed with 2011R1.9 (and upgraded subsequently to 2011R2.2) splits up the command between an $ARG1$ and a $ARG2$ section. If I do a copy/paste of the command and ARG1 at the command line, it brings up:

>

(Yeah, just that) ... so it makes sense that Nagios would interpret that as a null feedback. However, if I copy/paste the command AND $ARG1$ and $ARG2$, I once again get the CRITICAL:Unable to access SQL Server issue. That brings it back so something else I've read, that you have to give the domain account specific permissions. Can someone from Nagios verify what kind of permissions are required for an account to be able to get in and get these settings out of the server and/or database?

One additional tidbit from this sense ... the account I am using (we'll call it DOMAIN\SQLSERVICE) is a domain admin, which becomes a local admin via Local Users & Groups, and then becomes a overall sysadmin due to the inclusion of BUILTIN\Administrators in the sysadmin SQL security group. So, it's part of SQL Server through this nesting of permissions, maybe it has to be much more explicit than that. I did also find a thread on Experts Exchange about this, it's attached as a PDF.

Thanks!

[scottwilkerson]

As far as I am aware you will need to use SQL Server Authentication to use these plugins.

[Flava]

Is there a way around the SQL authentication? it is not practicle for configuring large number of servers. The plugin is usefull but poorly implemented, this should really be fixed as patch.

[scottwilkerson]

Unfortunately at this time I am unaware of any plugins that can accomplish this with Windows authentication