/
How to Grant access to DB owner ET

How to Grant access to DB owner ET

Description of Issue

Instance doesn't have access to the Database

Context
  • SQL server
  • ExecuTime
  • ET
  • DB
  • Database
Cause

Instance needs access to DB owner.

Resolution
  1. Log into a SQL DB
  2. Click Security tab 
  3. Click Logins tab
  4. Right click Instance 
  5. Click Properties 
  6. Click User mapping
  7. Find instance in the table and check the box for that instance
  8. Type in dbo in the Default Schema tab
  9. Check dbo_owner box
  10. Click OK
Additional Information

To check if it worked go back in the instance logins tab and the instance should have access. 





Related content

The Database Is Not Accessible
The Database Is Not Accessible
More like this
A network-related or instance-specific error occurred while establishing a connection to SQL Server
A network-related or instance-specific error occurred while establishing a connection to SQL Server
More like this
Error clicking View database columns - Your permissions do not allow you to access this option
Error clicking View database columns - Your permissions do not allow you to access this option
More like this
System details hidden due to insufficient permissions error on database tab of Diagnostic Utility
System details hidden due to insufficient permissions error on database tab of Diagnostic Utility
More like this
Cannot open database DatabaseName requested by the login The login failed
Cannot open database DatabaseName requested by the login The login failed
More like this
Database Stuck In Restoring Status
Database Stuck In Restoring Status
More like this