The connection name 'LocalSqlServer' was not found in the applica

The connection name 'LocalSqlServer' was not found in the applications configuration

Pavel Shumigaj

Vote:

Hi,

I creted new project and changed configuration (changed IIS Express to IIS; local db to SQL SErver 2014).

I gets next error after I have entered domain credentials.

Error after enter credentials

I also updated EPiServer to the latest version.

Could you please help me to solve this error?

Thanks for any help

#123259

Jun 30, 2015 12:21

Mattias Olsson

Vote:

Hi, are you sure the connection string name is LocalSqlServer?

In a standard EPiServer installation I think the name of the connectionString is EPiServerDB:

<connectionStrings>
   <add name="EPiServerDB" connectionString="the connection string" providerName=System.Data.SqlClient" />
</connectionStrings>

#123260

Edited, Jun 30, 2015 12:36

Pavel Shumigaj

Vote:

Connection string name in my application is EPiServerDB.

I don't know the reason but application tryinng to use data from machine.config

#123262

Jun 30, 2015 12:47

Pavel Shumigaj

Vote:

Solution:

Add <clear /> before DefaultProfileProvider

    <profile defaultProvider="DefaultProfileProvider">      
      <providers>
        <clear />
        <add name="DefaultProfileProvider" type="System.Web.Providers.DefaultProfileProvider, System.Web.Providers, Version=2.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" connectionStringName="EPiServerDB" applicationName="/" />
      </providers>
    </profile>

Thanks

#123264

Jun 30, 2015 13:03