This can take a long time to finish due to the large number of databases.
Important: By default, the public role is assigned to the new login ID. Here is a brief explanation of these options: LOCAL - Specifies that the cursor can be available only in the batch in which the cursor was created, and will be de-allocated once the batch terminates.
Results A user is created with the default public role and the permissions that you assigned, and is displayed in the Logins list. Solution You have a few different options, in SQL Server Management Studioyou can tick each checkbox for all databases from the user mapping interface in the login properties to grant the access.
In the Confirm Password field, retype the password that you entered in the Password field. Select SQL Server authentication.
Click Add, enter the windows user name with which the agent is installed and configured, and then click OK. What to do next Configure the agent. Allow read access to the user by selecting the check box.
Granting permission to the Perflib registry key for collecting data for few data sets To collect data for few date sets, you need to grant users read access to the Perflib registry key.
This parameter is required if username is provided.