sqlserver probe: no error for invalid DB instance

book

Article ID: 132028

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

If an invalid SQL instance name is specified in the 'Server name' field in the sqlserver probe connection setup, the connection test reports that the connection is OK, while it should actually fail.

For example:

--> sqlservername\invalid_instance_name,1433
CONNECTION: OK

(If the port number is not provided, it will fail)

Environment

Release:
Component: UIMSQS

Resolution

The issue is not on the probe but is with Microsoft SQL server itself. The sqlserver probe uses the sqlserver related API's to connecto to the server. The MSSQL allows the connection even if the instance name is not correct. 

This can be proved by using MS SQL Server Management Studio and opening a connection to the same database with a wrong instance:

in MS SQL Management Studio:
Connect to DB instance:
--> sqlservername\invalid_instance_name,1433
CONNECTION: OK