Authentication problem after moving site

[MalCarne]

I've been working on a site that uses .net authentication and roles. Everything is working fine on my dev box, but when moving it up to a staging server, I get the following error at loginrovider: SQL Network Interfaces, error: 26 -Error Locating Server/Instance Specified

I know that this lies in my web.config, but I'm out of ideas as to what the correct settings would be. Here's the relavant piece of the web.config:

<authorization>
			<allow users="?"/>
		</authorization>
		<roleManager enabled="true">
			<providers>
				<remove name="AspNetSqlRoleProvider"/>
				<add connectionStringName="LocalSqlServer" applicationName="stratton" name="AspNetSqlRoleProvider" type="System.Web.Security.SqlRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
				<remove name="AspNetWindowsTokenRoleProvider"/>
				<add applicationName="slg" name="AspNetWindowsTokenRoleProvider" type="System.Web.Security.WindowsTokenRoleProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
			</providers>
		</roleManager>
		<authentication mode="Forms">
			<forms loginUrl="clients/login.aspx"/>
		</authentication>

Any insight that can be provided is appreciated. Thanks in advance.

 

[adamroof]

connectionStringName="LocalSqlServer"

- whats your connection here?

 

[MalCarne]

This is where I get a bit lost. I've uploaded the db in the app_data directory, which I mistakenly thought would use the same connection.

 

[MalCarne]

I guess the question at hand is how to reference the aspnetdb.mdf as the authentication data source.