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,

To discover MSSQL Catalogs/Database you need to fulfill the following prerequisites.

Microsoft SQL Server discovery

Like, install SMO, CLR in MIDServer and Remote registry in the SQL server. To pull instance version in SQL 2014 you need to have sysadmin level access.

Regards,

Vivek

[VPN]

Hi Vivek,

After installing SMO,CLR and powershell it is giving below warning and not able to discover Databases.

Regards,

Vikas

[Dave Smith1]

... because of:

Did you confirm those credentials worked first?

[VPN]

Yes Dave the same credentials worked for   same host and other host.

Regards

Vikas