Can't create new site or page or anything.

Sam Sumpter asked on October 14, 2015 20:11

We have an old site that was created in Kentico version 5. Now it's old and the CEO wants it to be responsive. I have tried to retro fit the old site to look better on mobile devices but I can't figure out how to do it in Kentico 8.2 I just keep tanking the portal engine. So I thought I would try to create a new site next to the old one and then deploy it in place of the old one. But every attempt to make a buddy site just errors no matter what I do...

ERROR: Error importing 'Page types' objects (Image gallery) Message:

CREATE TABLE CONTENT_ImageGallery ([ImageGalleryID] int NOT NULL IDENTITY (1,1)); ALTER TABLE CONTENT_ImageGallery ADD CONSTRAINT PK_CONTENT_ImageGallery PRIMARY KEY CLUSTERED ([ImageGalleryID]);

Caused exception: CREATE TABLE permission denied in database 'CaptionCall_DPLYWeb2'.

Exception type: System.Exception Stack Trace: at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex) at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) at CMS.DataEngine.AbstractTableManager.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType) at CMS.DataEngine.TableManager.CreateTableByDefinition(String tableName, String definition, String& columns) at CMS.FormEngine.ImportSpecialActions.UpdateDatabase(DataClassInfo dci) at CMS.FormEngine.ImportSpecialActions.ProcessMainObject_Before(Object sender, ImportEventArgs e) at CMS.Base.AbstractHandler.CallEventHandler[TArgs](EventHandler1 h, TArgs e) at CMS.Base.AbstractHandler.Raise[TArgs](String partName, List1 list, TArgs e, Boolean important) at CMS.Base.AdvancedHandler2.RaiseBefore(TArgs e) at CMS.Base.AdvancedHandler2.RaiseBefore(TArgs e) at CMS.Base.AdvancedHandler2.StartEvent(TArgs e, Boolean allowEvent) at CMS.CMSImportExport.ImportProvider.ProcessMainObject(SiteImportSettings settings, GeneralizedInfo infoObj, GeneralizedInfo parentObject, TranslationHelper th, ImportParameters parameters) at CMS.CMSImportExport.ImportProvider.UpdateObject(SiteImportSettings settings, GeneralizedInfo infoObj, Boolean siteObject, DataSet data, TranslationHelper th, Boolean updateChildren, ProcessObjectEnum process, List1 importedParentIds, List1 postProcessList, List1 importedObjects, GeneralizedInfo parentObject, Boolean postProcessing) at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet data, String objectType, Boolean siteObject, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, List`1 importedParentIds)

Message: CREATE TABLE permission denied in database 'CaptionCall_DPLYWeb2'.

Exception type: System.Data.SqlClient.SqlException Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)

ERROR: Error during import process Message:

CREATE TABLE CONTENT_ImageGallery ([ImageGalleryID] int NOT NULL IDENTITY (1,1)); ALTER TABLE CONTENT_ImageGallery ADD CONSTRAINT PK_CONTENT_ImageGallery PRIMARY KEY CLUSTERED ([ImageGalleryID]);

Caused exception: CREATE TABLE permission denied in database 'CaptionCall_DPLYWeb2'.

Exception type: System.Exception Stack Trace: at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex) at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction) at CMS.DataEngine.AbstractTableManager.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType) at CMS.DataEngine.TableManager.CreateTableByDefinition(String tableName, String definition, String& columns) at CMS.FormEngine.ImportSpecialActions.UpdateDatabase(DataClassInfo dci) at CMS.FormEngine.ImportSpecialActions.ProcessMainObject_Before(Object sender, ImportEventArgs e) at CMS.Base.AbstractHandler.CallEventHandler[TArgs](EventHandler1 h, TArgs e) at CMS.Base.AbstractHandler.Raise[TArgs](String partName, List1 list, TArgs e, Boolean important) at CMS.Base.AdvancedHandler2.RaiseBefore(TArgs e) at CMS.Base.AdvancedHandler2.RaiseBefore(TArgs e) at CMS.Base.AdvancedHandler2.StartEvent(TArgs e, Boolean allowEvent) at CMS.CMSImportExport.ImportProvider.ProcessMainObject(SiteImportSettings settings, GeneralizedInfo infoObj, GeneralizedInfo parentObject, TranslationHelper th, ImportParameters parameters) at CMS.CMSImportExport.ImportProvider.UpdateObject(SiteImportSettings settings, GeneralizedInfo infoObj, Boolean siteObject, DataSet data, TranslationHelper th, Boolean updateChildren, ProcessObjectEnum process, List1 importedParentIds, List1 postProcessList, List1 importedObjects, GeneralizedInfo parentObject, Boolean postProcessing) at CMS.CMSImportExport.ImportProvider.ImportObjects(SiteImportSettings settings, DataSet data, String objectType, Boolean siteObject, TranslationHelper th, Boolean importChild, ProcessObjectEnum processType, List1 importedParentIds) at CMS.CMSImportExport.ImportProvider.ImportObjectType(SiteImportSettings settings, String objectType, Boolean siteObject, TranslationHelper th, ProcessObjectEnum processType, List1 importedParentIds) at CMS.CMSImportExport.ImportProvider.ImportObjectsData(SiteImportSettings settings)

Message: CREATE TABLE permission denied in database 'CaptionCall_DPLYWeb2'.

Exception type: System.Data.SqlClient.SqlException Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at CMS.DataEngine.AbstractDataConnection.ExecuteQuery(String queryText, QueryDataParameters queryParams, QueryTypeEnum queryType, Boolean requiresTransaction)

thoughts anyone?

Recent Answers


Brenden Kehren answered on October 14, 2015 20:33

The errors are related permissions on the database. So you need to make sure the user creating the database when creating the database. Then after the database is created you can remove that create and delete permission for the database.

0 votesVote for this answer Mark as a Correct answer

Sam Sumpter answered on October 14, 2015 20:49

Thanks for posting back so quickly Brenden. Are you talking about the server permissions or the Kentico permissions? Because I have been given god-like permissions on our server where the website resides. I can do anything I want in there. But when I involve Kentico I get errors all the time. For example: deleting a JPG from a media library. Tells me I can't. When I try to move a page from one position to another in the Pages tree. Errors with verbiage about permissions. Sorry if I sound frustrated, but its because I am. I am new to Kentico so I am pretty sure its just me on the crappy side of the learning curve but if I could just do a couple things I need to get done it would really be encouraging. I have built a lot of websites in CMS's like WordPress and ZenCart among others with much success. But I can't even successfully get some CSS or JS libraries added to a place where I can use them. I just get really weird error prompts and blank spaces where my code is supposed to be displaying stuff. I took the three day training course with Rei and it was good info but had no practical help for the mess I have been handed. This is not the place for such a long post is it? Is there some way I can get some real help?

0 votesVote for this answer Mark as a Correct answer

David te Kloese answered on October 14, 2015 21:54

Hi,

you could always ask Kentico directly (send an email to support@kentico.com).

But as Brendan mentioned I guess its mainly security settings in your SQL server.

Try following these configurations:

https://docs.kentico.com/display/K8/Minimal+secure+configuration

Greets,

David

0 votesVote for this answer Mark as a Correct answer

Brenden Kehren answered on October 14, 2015 22:05 (last edited on October 15, 2015 14:02)

Sam, the permissions I talk of are related to the user connecting to the database. So if you're using the "Network Services" account to run the app pool on the website you will need to grant that user database create permissions within SQL Server. If you specify a SQL username and password, that SQL user will need to have permissions.

1 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.