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.Â