Format of the initialization string does not confo

Question

I have an ASP.Net MVC application which runs fine on my local development machine. But when deployed to IIS7 gives the following error when trying to log in:

Format of the initialization string does not conform to specification starting at index 0

Most people who post this error resolve it by changing their connection string in some way. However my connection string on the local and deployed application are the same. The connection string is like this:

<add name="ApplicationServices" connectionString="Data Source=*server*\*instance*;Initial Catalog=*database*;Integrated Security=True;"
      providerName="System.Data.SqlClient" />

What is causing this error in my case?

Answer 1

I has the same issue, when I use command: "Update-Database" in Package Manager Console.

To Fix, make sure set startup project to the project which you want to do update.

E.g. I got Db project and Web project, make sure set startup project on Db project, when run "Update-Database", otherwise, it will try to search inside Web project.

Answer 2

The permissions on the SQL server were not correctly set up. I have now resolved this by properly setting up the server permissions.

Answer 3

Format of the initialization string does not conform to specification starting at index 0

Web.config :

<connectionStrings>
    <add name="TestDataConnectionString" connectionString="Data Source=.\SQLExpress;Initial Catalog=TestData;User ID=satest;Password=satest"
     />
  </connectionStrings>

In aspx.cs Page the code must be written in the below format :

SqlConnection con = new
SqlConnection(ConfigurationManager.ConnectionStrings["TestDataConnectionString"].ToString());

Answer 4

Check to make sure the credentials are correct for the connection string in Web.config. Mine was missing the password for the account with permissions to the database.

Answer 5

In my case I accidentally wrote "password:" instead of "password=" in my conn string

Answer 6

I encountered the same error. In my case it was the config transform not working properly. There is an issue with config transforms when it comes to connection strings. Some reference:

• MSBuild web.config transforms not working by drneel
• Replaceable token issue with config ConnectionString transforms by Francis

Also one can write the code in the aspx.cs page as

using (IDbConnection dbConnection =
       new SqlConnection(ConfigurationManager.ConnectionStrings["db"].ConnectionString))
       {
           // TODO: Write SQL Stored Procedures or SQL Statements using Dapper
       }

For those who would like to find out more about Dapper.

Hope this helps.