Home › Forums › Support › Enterprise Discovery

Database Catalog Discovery

Tue, 03/02/2010 - 07:05 — rmann56

Does anyone have details on how to configure security in SQL to allow Discovery to discover MSSQL catalogs?

http://wiki.service-now.com/index.php?title=Database_Catalogs

Thank you.

‹ Importing IP Ranges Having issue while customizing Consolidators for a computer in network ›
Fri, 03/12/2010 - 12:24 — doug.schulze

I've learned of one customer whos domain admin account they are using to discover their systems by default allows it to have SQL sysadmin access... which is resulting in successful catalog discoveries.

Tue, 03/02/2010 - 10:56 — rmann56

Dan

Thanks for the info. What I'm trying to find what type of SQL security you used to allow the Midserver server to collect the catalog info. Did you have to add the midserver service account to a DBusers group in SQL? How did you give the service account access to query the database instance. Thanks.

Rick

Tue, 03/02/2010 - 10:11 — dan.sherwin

Actually, I was just informed that we use a script that makes dmo calls to the DB.. Not wmi queries..

Tue, 03/02/2010 - 09:06 — dan.sherwin

Hi,

We're pulling SQL Catalogs today with the most recent release, but we're using WMI as our source.

-Dan

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.