User privilege requirements for SolutionPack for Microsoft SQL

The Microsoft SQL Server can be discovered with SQL Authentication or Windows Authentication.

Microsoft SQL authentication

SQL authentication works for users having either SYSADMIN privileges or an unprivileged account.

Note: An unprivileged account can be created and used to discover the Microsoft SQL Server. Configuring the SolutionPack with an unprivileged account

Windows authentication

A Windows user account must be imported into the Microsoft SQL Server with settings similar to these:

• Server role of Public
• Securable grants for Connect SQL, View any definitions, and View server state