If you add a SQL Server using Windows authentication, DLM Dashboard connects to the server with its Windows services account. By default, this is the machine account (the name of the machine that DLM Dashboard is installed on, with a $ sign on the end, eg MY-MACHINE$). This account isn't likely to have the necessary permissions on SQL Server.

To give DLM Dashboard access to SQL Server, you can change the account that DLM Dashboard uses.

Permissions

See Creating a login with the correct permissions for a script to create a login with these permissions.

The permissions that this account needs are:

• on all databases you want to monitor:

• VIEW ANY DEFINITION


• SELECT ON sys.sql_expression_dependencies

• on master:
  • VIEW ANY DEFINITION
    
  • EXECUTE ON dbo.RG_SQLLighthouse_ReadEvents
• on the database RedGate:
  
  • SELECT ON SQLLighthouse.DDL_Events

If you have encrypted objects, the account needs the sysadmin role.

Change the account

To change the account:

1. From the Start menu, open services.msc
2. In the Services list, right-click DLM Dashboard Monitoring Service and select Properties.
   1. In the Properties window, go to the Log On tab.
   2. Select This account and enter the credentials for the user account you want to use. 
   3. Click OK. 
   4. Right-click the service again and select Restart.
3. In the Services list, right-click DLM Dashboard Web Server and select Properties.
   1. In the Properties window, go to the Log On tab.
   2. Select This account and enter the credentials for the user account you want to use. 
   3. Click OK. 
   4. Right-click the service again and select Restart.