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.
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