deploy lightswitch html to web hosting error ! RRS feed

  • Question

  • Server Error in '/' Application.

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

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. 

    Exception Details: System.ArgumentException: Format of the initialization string does not conform to specification starting at index 0.

    Source Error: 
    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace: 

    [ArgumentException: Format of the initialization string does not conform to specification starting at index 0.] System.Data.Common.DbConnectionOptions.GetKeyValuePair(String connectionString, Int32 currentPosition, StringBuilder buffer, Boolean useOdbcRules, String& keyname, String& keyvalue) +6787193 System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +253 System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +134 System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +103 System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +35 System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(DbConnectionPoolKey key, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +294 System.Data.SqlClient.SqlConnection.ConnectionString_Set(DbConnectionPoolKey key) +60 System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +89 System.Data.SqlClient.SqlConnection..ctor(String connectionString, SqlCredential credential) +43 System.Web.DataAccess.SqlConnectionHolder..ctor(String connectionString) +58

    How to fix it ?

    Friday, August 15, 2014 6:11 AM


  • Hi lekhanhky,

    According to the error message above, this issue is related to your connection string, please check the steps below when you connect to SQL Server database in Connection Properties dialog box.

    1. In the Connection Properties dialog box, make sure that Microsoft SQL Server (SqlClient) appears as selected in the Data source box.

    2. In the Server name box of the Connection Properties dialog box, type the name of the SQL Server instance that you want to connect to.

    If SQL Server is running on the same machine as LightSwitch, you can type localhost into the Server name box.

    Please let me know if there is anything that I can do to help.                    

    Best regards,


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    • Marked as answer by lekhanhky Tuesday, August 19, 2014 11:26 AM
    Tuesday, August 19, 2014 6:59 AM