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
- Log into a SQL DB
- Click Security tabÂ
- Click Logins tab
- Right click InstanceÂ
- Click PropertiesÂ
- Click User mapping
- Find instance in the table and check the box for that instance
- Type in dbo in the Default Schema tab
- Check dbo_owner box
- Click OK
Additional Information
To check if it worked go back in the instance logins tab and the instance should have access.Â