The Desktop/Laptop Option (DLO) agent displays an Alert: Unable to configure the Desktop Agent on computer <hostname> for user <username>. Error: EXECUTE permission denied on object 'sp_shadow_get_user_sid', database 'master',...
Article ID: 100022280
Updated On:
Description
Error Message
While DLO Agent tries to launch, it throws the below message:
V-139-32772-3631, Failed to load configuration settings
or
V-139-32772-3593, Failed to load configuration settings
Cause
This usually happens after an upgrade of DLO server and for some reason, permissions are not updated properly.
Resolution
Grant explicit "Execute" permission for "Public" using SQL Management Studio. This is necessary for the extended stored procedure called dbo.sp_shadow_get_user_sid
Procedure for modifying the permissions:
1.Stop the DLO services in this order:
- Veritas DLO administration service
- Veritas DLO maintenance service
2. Connect to the SQL server through SQL Server Management Studio using the DLO service account.
3. Expand the Databases tree > System Databases > Master > Programmability > Extended Stored Procedures.
4. Look for the extended stored procedure called dbo.sp_shadow_get_user_sid. Right-click on it and select Properties (refer to Figure 1):
Figure 1:
5. Select Permissions > Add > Browse > Public.
6. Grant explicit Execute permission for Public as shown below:
Figure 2:
7. Save the changes and exit.
8. Restart the SQL Server (DLO) service.
9. Start the DLO services in this order:
- Veritas DLO Maintenance service
- Veritas DLO Administration service
Note: It is best to check the permissions on all 18 stored procedures in the list and grant the "Execute" permission to the "Public" if missing.
Applies To
All versions of DLO
DLO Administration, Maintenance and SQL DB server on Windows 2012+
Issue/Introduction
The Desktop and Laptop Option (DLO) Agent displays an alert: Failed to load configuration settings.
Was this article helpful?
Yes
No
Powered by
