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