1

I am using Sitecore 8.2 Update 7 Web Apps and created an empty Web App. Following these instructions to deploy the Publishing Service, everything has worked except for the schema upgrade: http://www.ehabelgindy.com/run-sitecore-publishing-as-azure-cloud-service/

I am using the 64-bit version of Sitecore Publishing Service 2.2.1 rev. 180807-x64

Sitecore.Framework.Publishing.Host.exe schema upgrade -f
[21:42:06 INF] Schema Upgrade
[21:42:13 ERR] There was an error querying Schema Sitecore.Framework.Publishing.Common.Sql.Schema for azuresqlserver-sql.database.windows.net,1433\azure-master-db
[21:42:13 ERR] There was an error querying Schema Sitecore.Framework.Publishing.Common.Sql.Schema for azuresqlserver-sql.database.windows.net,1433\azure-core-db
[21:42:13 ERR] There was an error querying Schema Sitecore.Framework.Publishing.Common.Sql.Schema for azuresqlserver-web-sql.database.windows.net,1433\azure-web-db
[21:42:13 ERR] One or more errors occurred.
Command not found. Type help for a list of available commands.
  • 1
    I have tried following this blog post instead using 2.2.1 without any issues coreysmith.co/… – Vincent Lui Sep 18 '19 at 23:34
  • Great post. I just contacted Sitecore Support and they had me use the SQL Admin Account... which worked to update the schema. Unsure if I need to switch it back to the regular database contained user accounts (Azure SQL) or update the permission level for the user accounts. – Kode Sep 19 '19 at 0:53
  • 1
    It must be a user with full dbo access unfortunately. I'd just leave it, and ensure that there's adequate ip whitelist in place. – Vincent Lui Sep 19 '19 at 10:12
  • Support got back and said that for updating schema to use an account with full DBO but that it should work with the regular connectionStrings once the schema is updated by the DBO account – Kode Sep 19 '19 at 14:00
  • Did that work? If so, can you please add an answer with what you did to solve the issue? – Dan Sinclair Sep 24 '19 at 11:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.