Hello, my name is Eric Villarreal, technical support engineer with Dell. In this video, I'll show you how to configure and verify SQL database permissions.
First, identify the active directory user that is being used for the Desktop Authority OpsMaster Service. Open up Windows Services. Right click Properties and select a Log On.
Next, we'll open the SQL Server Management Studio Express. Connect to the instance. Expand Databases. Expand Security. Right click the Logins and select New Login. We'll find the user. Verify to select a domain. And we'll give it server roles verified to sys admin. Select User Mapping. We'll select a DA Configuration and we'll give it db_owner. And we'll do the same with DA Reporting. And select OK.
If there are any additional issues, or you still cannot access the SQL databases, contact support for additional assistance. This concludes our video.
To learn more about Desktop Authority, visit quest.com/desktop-authority.
For more video tutorials, visit quest.com/support.