Posts

Showing posts from June, 2020

CREATE TABLE permission denied in database Core/Master/Web upon executing Sitecore.Framework.Publishing.Host.exe schema upgrade --force

Image
If you are setting up a Sitecore Publishing Service, sooner or later you would most likely need to execute the script: Sitecore.Framework.Publishing.Host.exe schema upgrade --force There is a chance that the following issue would occur when you run that script. C:\inetpub\wwwroot\alextestPublishingService42>Sitecore.Framework.Publishing.Host.exe schema upgrade --force [23:48:16 INF] Schema Upgrade [23:48:16 INF] Upgrading all databases to version [ 2 ] [23:48:16 ERR] One or more errors occurred. System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: CREATE TABLE permission denied in database 'XP0.930_Core' .    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) ... omitted ... at Sitecore