I've got a website that has a ControlPanel directory. The control panel has a web.config in it that restricts access to the controlpanel folder to only the admin role. I have a login.aspx in the root of the site, with a login control on it. Pretty much the most basic ASP.NET authentication scheme. In the root web.config I set the application name and then used the built-in admin website to ensure the database was setup for membership.

Running the built in web server, the web site runs fine. Logins work perfectly. However, once deployed I get an error. It's as if the web site is trying to find a .mdf file on the D: drive of my web host. The SQL server is separate from the web server on the host. My web.config connection strings reflect this, I comment out the local connection string, and ensure the connection string for the remote SQL server was correct.

I think I've deduced it down to the asp.net authentication/membership part of the framework... if I delete the web.config inside the controlpanel folder, I am able to access the control panel, perform admin functions, and all database calls work fine. It's only when the folder requires login that it throws an exception.

Any ideas?

TIA
 

I guess I wasn't able to word my problem description well. I basically need to know why the app is trying to load a .mdf file when logging in/accessing a role-restricted section of my website. The web.config doesn't contain any local connection strings, only the remote SQL server's connection string.

Anything jump to mind that I should check first?

ChadThiele:

I basically need to know why the app is trying to load a .mdf file when logging in/accessing a role-restricted section of my website. The web.config doesn't contain any local connection strings, only the remote SQL server's connection string.

Hi

For investigation, could you paste your web.config file?

 Yes, I will post it when I get home from work today. I'll simply edit this post to add it in. Thanks!

<configuration>
	<configSections>
		<sectionGroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
			<sectionGroup name="scripting" type="System.Web.Configuration.ScriptingSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
				<section name="scriptResourceHandler" type="System.Web.Configuration.ScriptingScriptResourceHandlerSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
				<sectionGroup name="webServices" type="System.Web.Configuration.ScriptingWebServicesSectionGroup, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35">
					<section name="jsonSerialization" type="System.Web.Configuration.ScriptingJsonSerializationSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="Everywhere"/>
					<section name="profileService" type="System.Web.Configuration.ScriptingProfileServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
					<section name="authenticationService" type="System.Web.Configuration.ScriptingAuthenticationServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
					<section name="roleService" type="System.Web.Configuration.ScriptingRoleServiceSection, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" requirePermission="false" allowDefinition="MachineToApplication"/>
				</sectionGroup>
			</sectionGroup>
		</sectionGroup>
	</configSections>
	<appSettings/>
	<connectionStrings>
		<add name="ASPNETDBConnectionString" connectionString="Data Source=SQLServerFQDN;Initial Catalog=DBName;user=UsrName;pwd=Pass;" providerName="System.Data.SqlClient"/>
	</connectionStrings>
	<system.web>
		<roleManager enabled="true" />
		<compilation debug="false">
			<assemblies>
				<add assembly="System.Core, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
				<add assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
				<add assembly="System.Data.DataSetExtensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
				<add assembly="System.Xml.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/>
				<add assembly="System.Data.Linq, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"/></assemblies>
		</compilation>
		<authentication mode="Forms"/>
		<pages>
			<controls>
				<add tagPrefix="asp" namespace="System.Web.UI" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
				<add tagPrefix="asp" namespace="System.Web.UI.WebControls" assembly="System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
			</controls>
		</pages>
		<httpHandlers>
			<remove verb="*" path="*.asmx"/>
			<add verb="*" path="*.asmx" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
			<add verb="*" path="*_AppService.axd" validate="false" type="System.Web.Script.Services.ScriptHandlerFactory, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
			<add verb="GET,HEAD" path="ScriptResource.axd" type="System.Web.Handlers.ScriptResourceHandler, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35" validate="false"/>
		</httpHandlers>
		<httpModules>
			<add name="ScriptModule" type="System.Web.Handlers.ScriptModule, System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35"/>
		</httpModules>
		<membership>
   <providers>
    <add connectionStringName="ASPNETDBConnectionString" applicationName="/"
     minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0"
     name="CustomizedProvider" type="System.Web.Security.SqlMembershipProvider" />
   </providers>
  </membership>
	</system.web>
	<system.codedom>
		<compilers>
			<compiler language="c#;cs;csharp" extension=".cs" compilerOptions="/warnaserror-" warningLevel="4" type="Microsoft.CSharp.CSharpCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
				<providerOption name="CompilerVersion" value="v3.5"/>
			</compiler>
			<compiler language="vb;vbs;visualbasic;vbscript" extension=".vb" compilerOptions="/optioninfer+" type="Microsoft.VisualBasic.VBCodeProvider, System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089">
				<providerOption name="CompilerVersion" value="v3.5"/>
			</compiler>
		</compilers>
	</system.codedom>
</configuration>

Thanks in advance... I hope it's just some dumb thing I've overlooked. I'd love to get this working soon. Really appreciate the help.
 

I have a similar problem, are you by chance getting an Error: 26?

ChadThiele:

 <connectionStrings>
<add name="ASPNETDBConnectionString" connectionString="Data Source=SQLServerFQDN;Initial Catalog=DBName;user=UsrName;pwd=Pass;" providerName="System.Data.SqlClient"/>
</connectionStrings>
<system.web>
<roleManager enabled="true" />

<membership>
   <providers>
    <add connectionStringName="ASPNETDBConnectionString" applicationName="/"
     minRequiredPasswordLength="5" minRequiredNonalphanumericCharacters="0"
     name="CustomizedProvider" type="System.Web.Security.SqlMembershipProvider" />
   </providers>
  </membership>

Hi

From your description, web app doesn't connect to a proper SQL Server database. Please specify the defaultProvider property and see if it helps.

    <roleManager enabled="true" defaultProvider="AspNetRoleProvider">

      <providers>

        <clear/>

        <add name="AspNetRoleProvider"
                connectionStringName="LocalSqlServer" *************specify connectionStringName**********
                applicationName="/formview" *************specify proper applicationName**********

                type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
      </providers>

    </roleManager>
    <membership defaultProvider="AspNetSqlMembershipProvider">


      <providers>
        <remove name="AspNetSqlMembershipProvider" />
        <add name="AspNetSqlMembershipProvider"
             type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
             connectionStringName="LocalSqlServer" *************specify connectionStringName**********
             minRequiredNonalphanumericCharacters="0"
             requiresQuestionAndAnswer="true"
             minRequiredPasswordLength="2"
             passwordFormat="Hashed"
             applicationName="/formview" *************specify proper applicationName**********
             />
      </providers>
    </membership>