Select this option if the SQL Server instance hosts a secondary replica of an Availability Group and for this secondary replica ApplicationIntent=ReadOnly.
The connection will fail if the account permissions are insufficient to allow Spotlight to collect the data it needs.
Monitor deadlock sql server 2012 how to#
If this is not feasible in your environment, see How to grant SQL Server account permissions to a trusted user. It could be a SQL Server login (such as ‘sa’). Typically the account will be a member of the sysadmin server role. Ensure the database user has sufficient account permissions to retrieve performance data from the SQL Server instance and host by WMI. When using Windows authentication to connect to a SQL Server, and that SQL server is in a different domain to the Spotlight Diagnostic Server, the domain the SQL Server is in must trust the domain the Spotlight Diagnostic Server is in.Īlternatively, fill in the Database User and Password fields. Ensure this account is trusted by the SQL Server. Select Windows Authentication (using Diagnostic Server credentials) to use the Windows user configured to run the Spotlight Diagnostic Server. Specify the authentication for Spotlight to use to connect to the SQL Server instance. If the SQL Server instance is hosted on a Windows server and UDP port 1434 is closed then the port number must be included in the address used to connect Spotlight to the SQL Server instance.
0 kommentar(er)
