MSSQL Databases doscovery

[VPN]

Hi All,

We Ran discovery on windows servers which has MSSQL DB's on it.

We are able to discover DB instance but not MSSQL DB's, got read access to DB's.

Could anyone please let me know how to discover MSSQL DB's and where to check exactly.

Regards

Vikas

[VivekSattanatha]

Hi Vikas,

The Credentials might work to discover your host but did you check the credentials worked to discover Database? Try login to any database with the credential you used for discovery. if that didn't work then ask your DB team to include your discovery credentials to the database instances that you are going to discover. In MSSQL there is a different kind of roles in there. Initially, you can ask them to provide a public role for your discovery credential that will discover your database.

Regards,

Vivek

[VPN]

Hi,

I am able to login MSSQL instance with my windows credentials that I use for Discovery and open the Database.

I am using a Service account XYZ, And to login to MSSQL server i used same XYZ account as Windows authentication it is working.

.

Regards,

Vikas

[VPN]

Hi Vivek & Dave,

Able to discover DB's and showing under MSFT SQL Catalogs

But they are still few warnings after discovery.

Plz see below..

Regards,

Vikas

[VivekSattanatha · Accepted solution]

Hi Vikas,

I am not sure about these warnings. Someone tried to explain it in here

List of discovery errors/warnings and resolution

As long as you get all the information I guess you can ignore those warnings.

Regards,

Vivek

[VPN]

Thanks Vivek,

When i do Oracle i see these warnings and Oracle Schema are not getting discovered.

Regards

Vikas,