Discovery of MSSQL Database Instances

[syddent]

I am new to discovery. Below looks like a credential issue, but I am wondering if I do not have the right problem.

I have run discovery in my environment. I find the host machine and the software that is running on that host machine. I find MSSQL Server running on the machine. However discovery does not find the instances on the MSSQL Server.

The following message shows up in the ECC queue

<?xml version="1.0" encoding="UTF-8"?><results probe_time="13108" result_code="0"><result><error>Authentication failure with the local MID server service credential.</error><error>Failed to access target system.   Please check credentials and firewall settings on the target system to ensure accessibility: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))</error></result><parameters>

If this is a credential issue, does someone have a hint on what needs to be present besides a Username and password?

Thanks

Sydney Dent

[doug_schulze]

What you are probably seeing is that yoru MSSQL process classifier is probably using a pattern now.  I've seen in these patterns that we just set the 'name', you might check that..

This is what mine looks like

[bharath10]

Thanks for the repsonse.

pattern set same way. (but no hostname and no IP address captures in cmdb_ci_db_instance_list)

but not sure why nothing is capture for MSSQL DB whereas we can see 'instance name@hostname' info for MS FTSQL DB.

event for 'MongoDB' observed that for some instance its getting hostname value, but not others.

R's

Bharat

[Ashish Verma4]

Hi syddent,

Please check your credential in servicenow instance from Test Credential.

Once credential is working fine, Please check with Firewall team, since as per the error it looks like firewall is blocking some port to reach the target server.

Please hit like if this resolve your queries.

Thanks,

Ashish