none
MAP Toolkit 7.0 inventory of SQL Server RRS feed

  • Question

  • Hello,

    I have a problem regarding the SQL inventory. There is only the first database inventoried with all of the requested details. We have some SQL-Servers (2005 and 2008) with more then 20 DB´s on every and there is only the first DB inventory completed with all information regarding users, ....

    I have tried to inventory a new installed SQL 2008 (master, model, msdb and tempdb) and I only got the informations regarding the master db.

    Why we dont get the information of all db´s?

    best regards,

    Karsten


    • Edited by kaludwig Friday, September 21, 2012 10:50 AM
    Friday, September 21, 2012 10:37 AM

Answers

All replies

  • Is your account in the sysadmins group on each of the SQL Servers? By default a login to SQL Server doesn't have access to any of the user databases.

    Tuesday, September 25, 2012 2:15 AM
  • Yes, that was the problem.

    Thanks,

    Karsten

    • Marked as answer by kaludwig Tuesday, September 25, 2012 7:36 AM
    Tuesday, September 25, 2012 7:34 AM