Follow the upgrade guide, turned off IIS, change database to single user mode and tried running the migratesgn610_sng700.sql script, but hit with this error.
Msg 924, Level 14, State 1, Line 15
Database 'SafeGuard' is already open and can only have one user at a time.
Updating Policy Setting BitLockerFallbackLogonMode
Msg 208, Level 16, State 1, Line 5
Invalid object name 'SGN_POLICY_SETTINGS'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'SGN_POLICY_SETTINGS'.
(1 row(s) affected)
Create OneDrive Cloud Storage Definition
Msg 208, Level 16, State 1, Line 11
Invalid object name 'CLOUD_STORAGE_DEFINITION'.
Create OneDrive for Business Cloud Storage Definition
Msg 208, Level 16, State 1, Line 11
Invalid object name 'CLOUD_STORAGE_DEFINITION'.
Table versioning maintenance
Msg 208, Level 16, State 1, Line 14
Invalid object name 'dbo.TABLE_INFO'.
Msg 208, Level 16, State 1, Line 1
Invalid object name 'dbo.SEC_OFFICER'.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFFICER" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_ROLES" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_CERT" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_TAB_ACCESS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_IN_GROUP" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_SGD" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_POL" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SCHEDULE_TASKS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.KEY_ENTRY" because it does not exist or you do not have permissions.
Msg 3701, Level 11, State 5, Line 1
Cannot drop the table 'dbo.SEC_OFFICER', because it does not exist or you do not have permission.
Caution: Changing any part of an object name could break scripts and stored procedures.
Msg 4902, Level 16, State 1, Line 2
Cannot find the object "dbo.KEY_ENTRY" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.KEY_ENTRY" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SCHEDULE_TASKS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SCHEDULE_TASKS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_POL" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_POL" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_SGD" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_SGD" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_IN_GROUP" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_IN_GROUP" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_TAB_ACCESS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_TAB_ACCESS" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_CERT" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_CERT" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_ROLES" because it does not exist or you do not have permissions.
Msg 4902, Level 16, State 1, Line 1
Cannot find the object "dbo.SEC_OFF_ROLES" because it does not exist or you do not have permissions.
(1 row(s) affected)
The database update failed.
How do i get past this error?
This thread was automatically locked due to age.
