SQL Connection Error

serjo l asked on July 21, 2022 05:55

I'm getting this SQL Error

The application could not connect to the database, please check the connection string in the web.config file and SQL server availability.

Original error: Instance failure.

I'm using issexpress btw. and already have connectionString.config. here it is

<connectionStrings>
  <add name="CMSConnectionString" connectionString="Data Source=.\\SQLExpress; Initial Catalog=dev-strategicweb-cms-db-dhp-dev; Integrated Security=False; Persist Security Info=False; User ID=sa; Password=password123456; Connect Timeout=240; Encrypt=False; Current Language=English;" />
  <add name="CMSOMConnectionString" connectionString="Data Source=.\\SQLExpress; Initial Catalog=dev-strategicweb-cms-om-db; Integrated Security=False; Persist Security Info=False; User ID=sa; Password=password123456; Connect Timeout=240; Encrypt=False; Current Language=English;" />
</connectionStrings>

This is the web.config

<connectionStrings configSource="connectionStrings.config" />

Image Text

Recent Answers

Brian McKeiver answered on July 23, 2022 17:03

Can you connect to the database using that exact connection string from SSMS on the machine the Kentico .NET site is running from?

Is the SQLExpress instance running in the servers.msc list of the machine that has SQLExpress installed?

0 votesVote for this answer Mark as a Correct answer