Frequently Asked Questions (FAQ)

What SQL Server Permissions are required for BI Documenter?

The following Server Permissions will need to be granted to BI Documenter users: 

  • db_datareader and db_datawriter access to the BI Documenter Metabase
  • db_datareader access to any SQL Server Database you intend on documenting
  • db_ssisoperator (in 2008/R2) or db_dtsoperator (in 2005) access to the msdb System Database for every SQL Server Instance that includes deployed SSIS Packages you intend on documenting
  • System User Roles as well as the Browser Role to the Web Service Directory and Publisher Role to any report folder you intend on documenting inside of the Reporting Services Server

Some of our clients