I'm trying to work through the installation/configuration but I get this error during database creation:
``` at CMS.DataEngine.SqlInstallationHelper.ImportDefaultData(IDataConnection connection, String dataFolder, LogMessage log, String defaultErrorMessage) at CMS.DataProviderSQL.DataConnection.BulkInsert(DataTable sourceData, String targetTable, BulkInsertSettings insertSettings) at CMS.DataEngine.AbstractDataConnection.HandleError(String queryText, Exception ex)
The statement has been terminated. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Caused exception:
BulkInsert to table 'BadWords_Word' Query:
[DataConnection.HandleError]: ERROR: An error occurred: data\badwords_word ```
This is my connection string:
<connectionStrings> <add name="CMSConnectionString" connectionString="Data Source=MYPC\SQLEXPRESS;Initial Catalog=jobzgenie;Integrated Security=False;Persist Security Info=False;User ID=jobzgenie_user;Password=jobzgenie99;Connect Timeout=200;Encrypt=False;Current Language=English;" /> <add name="Entities" connectionString="metadata=res://*/DataModels.JobsJetDataModel.csdl|res://*/DataModels.JobsJetDataModel.ssdl|res://*/DataModels.JobsJetDataModel.msl;provider=System.Data.SqlClient;provider connection string="data source=MYPC\SQLEXPRESS;initial catalog=xxx;persist security info=True;user id=xxx;password=xxx;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" /> </connectionStrings>
I have increased How can I get past this?
Did you try increasing the Timeout even further?
Is anything getting written when you check the DB after? As in perhaps you haven't got the correct permissions set?
The tabeles are getting created but data not getting written to them.
I tried increasing the timeout to 600 but even that made no difference.
What permissions should be set?
Have a check to the minimal settings in the Documentation:
docs.xperience.io/.../minimal-secure-configuration
The DB creation requires the following: 'Alter, Connect, Delete, Execute, Insert, References, Select, Update'
You increased the time out in the connection string or also on the SQL server side, in the server's Remote connection's configuration?
I'm able to add records to [jobzgenie].[dbo].[BadWords_Word] with jobzgenie_user through SSMS so assume the SQL user has the correct permissions.
I give the application folders modify permissions for IUSR and IIS_IUSRS. I'm not sure what other permissions I need to set.
Juraj Ondrus, I tried updating both web.config and the SQL Server remote connection. Neither seemed to work. I currently have the SQL Server remote connection at 0(no timeout).
What version of Kentico are you installing and what is the SQL server version? I would try boosting the server priority as described here. And I would maybe try stopping any other traffic coming to the SQL server, if there is any at the same time.
Kentico Version: 10.0 Build: 10.0.6376 SQL Server Express 2014
Please, sign in to be able to submit a new answer.