1. System Requirements
Expand | ||
---|---|---|
| ||
1.1 Client Requirements
|
Expand | ||
---|---|---|
| ||
1.2 Database User
@rolename = 'SQLAgentReaderRole', @membername = 'TrustedUser' use msdb EXECUTE sp_addrolemember @rolename = 'TargetServersRole', @membername = 'TrustedUser' grant select on dbo.log_shipping_monitor_history_detail to TrustedUser grant select on dbo.log_shipping_monitor_primary to TrustedUser grant select on dbo.log_shipping_monitor_secondary to TrustedUser grant select on dbo.log_shipping_primary_databases to TrustedUser grant select on dbo.log_shipping_secondary_databases to TrustedUser grant select on dbo.log_shipping_primary_secondaries to TrustedUser grant select on dbo.log_shipping_primaries to TrustedUser grant select on dbo.log_shipping_secondary to TrustedUser grant select on dbo.log_shipping_secondaries to TrustedUser grant select on dbo.sysjobs to TrustedUser grant select on dbo.sysalerts to TrustedUser grant select on dbo.sysjobhistory to TrustedUser grant execute on dbo.sp_help_jobhistory to TrustedUser grant select on msdb.dbo.syssessions to TrustedUser grant select on msdb.dbo.sysjobactivity to TrustedUser use master grant EXECUTE on xp_servicecontrol to TrustedUser grant EXECUTE on xp_enumerrorlogs to TrustedUser grant EXECUTE on xp_readerrorlog to TrustedUser grant EXECUTE on xp_sqlagent_enum_jobs to TrustedUser grant execute on xp_regread to TrustedUser declare @dbnumber int declare @dbname sysname declare @use nvarchar(4000) declare @Quest_dblist table (row int identity,name sysname) insert into @Quest_dblist (name) select name from master.dbo.sysdatabases; set @dbnumber = @@rowcount while @dbnumber > 0 begin select @dbname =name from @Quest_dblist where row = @dbnumber set @use = N'USE ' + quotename(@dbname) + N'CREATE USER [TrustedUser] FOR LOGIN [TrustedUser]'; exec (@use) set @dbnumber = @dbnumber - 1 end ----un-comment the following line for SQL Server 2008 and above. --Grant CONTROL SERVER to TrustedUser ----un-comment the following line for SQL Server 2012 and above. -Grant ALTER ANY EVENT SESSION to TrustedUser
|
Expand | ||
---|---|---|
| ||
1.3 Permissions required during installation
|
2. Installation
Expand | ||
---|---|---|
| ||
Spotlight for SQL Server Expert
2. Select Component to install Spotlight Client or Diagnostic Server. Click Next
3. To Accept the license agreement, Click Next 4. Accept Help improve Spotlight , Click Next 5. Select specify the computer to install, Click Next 6. Select Destination Folder, Click Next 7. Select and fill data for Diagnostic Server Account , Click Next 8. The Diagnostic Server will run as a Windows Service under whatever account you give us here. 9. Enable Auto update Diagnostic Server, Click Next 10. Configure Playblack Database, enter authentication detail, Click Next 11. Spotlight needs a database (called SpotlightPlaybackDatabase by default) to store historical data, so 12. Running Create Playblack database, Click OK 13. Select destination folder to install Spotlight client , Click Next 14. Finished choosing the options for the installation of the Diagnostic Server, 15. Installation Completed, Click Finish |
3. Licensing
Expand | ||
---|---|---|
| ||
3.1 Activate Licnse Key- Spotlight for SQL ServerFrom a Spotlight Client connected to the Spotlight deployment:
|
Expand | ||||
---|---|---|---|---|
| ||||
3.2 Uninstall SpotlightFollow these steps to uninstall Spotlight Enterprise. Multiple Spotlight Clients and servers may be involved.
|
Support Chanel : Support Portal