Configuring the SolutionPack with an unprivileged account

Create a account with specific grants required by the Microsoft SQL SolutionPack collector.
The collector must connect to each instance of MS-SQL Server and perform SQL queries. You can use either an administrator equivalent system account or create a dedicated system account for the collector. If you want a dedicated system account, please ask the DBA administrator to create a
watch4net
account with specific grants for the collector.
  1. Follow this example to create a
    watch4net
    account.
    The default database must be used as the
    [master]
    database in this procedure.
    USE [master] GO CREATE LOGIN [watch4net] WITH PASSWORD=N'
    <securepassword>
    ', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF GO EXECUTE master.sys.sp_MSforeachdb 'USE [?]; CREATE USER watch4net FOR LOGIN watch4net GO GRANT VIEW SERVER STATE TO watch4net GO GRANT VIEW ANY DEFINITION TO watch4net GO ;
Your dedicated account is configured.