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 ofPublic
- Securable grants forConnect SQL,View any definitions, andView server state