When upgrading from Shavlik Protect 9.1 to 9.2, the database upgrade fails with a SQL install script error "A data conversion error has been detected during the database upgrade process. Cannot find the object 'APEventsDeleteHistorical' because it does not exist or you do not have permission."
The upgrade from 9.1 to 9.2 requires database user "dbo" to own the Reporting, Services, and Virtual schemas.
- Open SQL Server Management Studio**
- Navigate to Databases > Protect*** > Security > Users
- Once you have expanded the Users container right click on "dbo" and choose properties.
- Under "Select a Page" choose "Owned Schemas", add the Owned Schema's listed below and press OK
SQL Management Studio is a tool used to manage permissions and setting for SQL database. For more information and download links please see the following article:
"Protect" is the default database name. If you have renamed your database to something other than "Protect" please choose the database your Shavlik install is connected to.
Shavlik Protect 9.1.x
Shavlik Protect 9.2.x