Office 365 script to upgrade from 5.9 to 6.0 fails:
== ERROR == Configuring application 'Office365_5'... Trying to detect SQL Server connection string from existing configuration... Deploying the database... Exception calling "Execute" with "1" argument(s): "DacInstance with the specified instance_id does not exist." At C:\Users\Administrator\Desktop\MicrosoftOffice365-6.0-1070.app\O365-Web\PS\sqlinstall.ps1:85 char:17 + $Deploy.Execute <<<< ((Join-Path $ScriptPath "Deployment\DB.dacpac")) + CategoryInfo : NotSpecified: (:) , ParentContainsErrorRecordException + FullyQualifiedErrorId : DotNetMethodException
The user that upgrade script is using to access the database node specified in parameters of script does not have sysadmin role, as required in upgrade procedure
- Access the host with the database,
- Open MS SQL management studio,
- Connect to localhost,
- Expand Security > Logins
- Double-click the user (likely having 'o365' in name)
- Go to Server roles,
- Add 'sysadmin' role.
- Re-run the script.