Applicative Credentials for MSSQL

[KhasimKhanP]

Hi folks,

I'm trying to discover MS SQL installed in Windows Machine.

I've defined applicative credentials and win credentials but's throwing the error.

Credentials being used:

User name: sa

[KhasimKhanP]

Hlo @Selva Arun ,

I didn't find any record in the MS SQL instance table.

[Selva Arun]

Oh, okay, let me check more and get back to you.

Regards,

Selva Arun

[AjinA]

ChatGPT said:

It looks like the issue is mainly with the SQL authentication and network setup rather than the discovery tool itself. Make sure you are using the exact SQL instance name (for example, MACHINE\SQLEXPRESS) in your configuration. Also, open SQL Server Configuration Manager and enable TCP/IP under SQL Server Network Configuration → Protocols for SQLEXPRESS. For easier discovery, set a static port (like 1433) instead of dynamic ports and allow it through the Windows Firewall. In SQL Server Management Studio, confirm that the server is running in Mixed Mode Authentication so that the sa login works, and test those credentials manually from another machine. If the manual connection fails, the credentials or SQL configuration itself need to be fixed first. The probe error you’re seeing usually points to invalid or inaccessible credentials.

[SK Chand Basha]

Hi @KhasimKhanP 

I would suggest use Command Validation tool

There is a plugin Pattern Enhancements, from that you can validate the all the pattern commands with respective credentials and mid server.

See if respective MSSql pattern commands are passed or not!