Adaptive Server connection failed (severity 9) - check_mssql

[benzen78]

Hi,

I've been running an old monitoring db that stores certain results from some check done with powershell on an old server 2003 and old SQL Express and decided it was way over due an update so I have a new Server 2019 with SQL 2019 Express but I'm having issues connecting to the new DB through NagiosXi.

Everything is as the old server would have been setup but I get the following error:

CRITICAL: Could not connect to dblib:host=172.22.40.46:1433;dbname=Monitor as sqluser (Exception: SQLSTATE[01002] Adaptive Server connection failed (severity 9)).

I have run :

nmap 172.22.40.46 -p 1433

and this returns:

Host is up
Port Status Service
1433 open ms-sql-s

My sql user is a sql user (not windows domain) and does have connection and read access to the db.

I'm now a little stuck as seem to have hit a brick wall with anything else I try.. Any advice?

[benzen78]

No worries, after hours on this I find the issue... really simple one too.

Just didn't have the Server authentication set to allow SQL Server and Windows Authentication mode so it was only allowing connections through Windows Authentication!

[jbrunkow]

I'm glad you were able to find out what it was! Thankyou for posting the solution here.

Is it okay if we mark this topic as resolved and lock it for editing?

[benzen78]

Hi,

Yes please mark it as resolved, I was trying to find a way of doing that myself but couldn't find the option.

Many Thanks,

Ben

[scottwilkerson]

Hi,

Yes please mark it as resolved, I was trying to find a way of doing that myself but couldn't find the option.

Many Thanks,

Ben

Great!

Locking thread