Cannot discover MS-SQL databases

[bdeblis]

We just recently upgraded from ServiceNow Express to Enterprise, but still use Express Discovery. Noticed that discovery does not find the MS-SQL databases, it finds the MSSQL servers, but not databases. I have followed instructions to add items to the midserver, but still does not work. Anybody have any advice?

[DaveHertel]

To discovery MS SQL catalogs, instances, etc. you have to configure the MID server + add SQL credentials, to enable full discovery / exploration of SQL DBs.   Check out the Discovery setup for SQL docs .   A summary of the items you need to set up on the MID server to discovery SQL objects:

• .Net (v3.5 & 4, or 4.5)
• Powershell
• Common Language Runtime 
• MS SQL Management library

Does this help? Hope so..

[Peter Segrera]

Your link does not work

[John Shores1]

First, make sure you have the credentials you need:

https://docs.servicenow.com/bundle/kingston-it-operations-management/page/product/discovery/referenc...

Then, make sure you have the SQL Management tools and CLR types installed on the MID servers you plan to use to discover your SQL servers:

https://docs.servicenow.com/bundle/istanbul-it-operations-management/page/product/discovery/referenc...

If this doesn't get you what you need, you may have to look to access issues at the network or firewall level.

Good luck!

[Rahman4]

Hi,

I have the exact same issue. I can discover the installed SQL Server 2008 database but the instances are not discovered. The only thing I am not sure is if database instances are discoverable over local network with Workgroup? I have followed all the other requirements including .Net runtime, Service account, adding the user to database roles.

Any comments will be appreciated.

TA