Search Engine: Elastic

Article ID: 127354, created on Nov 6, 2015, last review on Nov 6, 2015

  • Applies to:
  • Operations Automation 6.0


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\\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


  1. Access the host with the database,
  2. Open MS SQL management studio,
  3. Connect to localhost,
  4. Expand Security > Logins
  5. Double-click the user (likely having 'o365' in name)
  6. Go to Server roles,
  7. Add 'sysadmin' role.
  8. Re-run the script.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 956c448bddc7e1f3585373687602379f 6f1456866eed87488c0f02b298a741c0

Email subscription for changes to this article
Save as PDF