Zurück
-
Titel
SQL Error (2146232060) The Execute permission was denied on the Object 'udt_GUID_List_Type' database "ChangeAuditor", schema 'dbo',command: dbo.sup_AlertQuery_ReadActiveQueries -
Beschreibung
The Coordiantor logs shows the following error messages:
- Error uploading stats
- Error running bulk update AuditEvent_STS_SiteID:
SQL Error (2146232060) The Execute permission was denied on the Object 'udt_GUID_List_Type' , database "ChangeAuditor", schema 'dbo',command: dbo.sup_AlertQuery_ReadActiveQueries
- Attempting to reconnect to the database
- Database error: data could not be read
- Task Altert Processsor WMO Task has not completed successfully due to error: Database error: data could not be read
-
Ursache
The DBO permissions are removed from the account used by Change Auditor to connect to the database. -
Lösung
Add DBO permissions for the account used by Change Auditor to connect to the Change Auditor database.