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.

Procedure

• ♦ 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
  ;
  

Results

Your dedicated account is configured.