KB-10067: The Database Owner does not have External Access Assembly Permission in SQL
Auditing and Monitoring Service
,
Show Properties
Hide Properties
|
4/1/2018 2:59 AM |
|
4/1/2018 2:59 AM |
|
4/1/2018 2:59 AM |
|
Article Audience |
|
Products |
Auditing and Monitoring Service
|
Operating Systems |
Windows
|
Service |
Centrify Infrastructure Services
|
|
|
|
|
000010067 |
|
While rotating the Audit SQL database an error occurred stating the owner doesn't have External Assembly permission to the database. |
|
Problem:
While doing an Audit SQL database rotation,the following error came up when opening the Collector on the Audit Manager:
"Invalid database. The database owner does not have External Access Assembly permission on the SQL Server"
Resolution:
Change the SQL database owner to 'sa' and set trustworthy to ON.