This is what I have done.

1. Created the Classifieds database on remote sql in my intranet

2. Created the Membership database on remote sql in my intranet

Modified web.config to account for remote hosting of databases. My complete web.config is below at bottom:

The problem is that I can access the site fine but if you try to register on the site after you click finish when registering you get the error below
I'm not sure why it's saying empty when I have created a connection string called "LocalSqlServer"

Server Error in '/' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: The attribute 'connectionStringName' is missing or empty.

Source Error:

Line 52: 			<providers>
Line 53: 				<clear/>
Line 54: 				<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringname="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
Line 55: 			</providers>
Line 56: 		</membership>

I assume something is wrong in my config file but cannot figure it out.

<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
 <connectionStrings>
  <add name="classifiedsConnection" connectionString="Data Source=servername\serverinstance;Initial Catalog=Classifieds;Integrated Security=True;User ID=domain\username;password=password;"/> 
  <remove name="LocalSqlServer"/>
  <add name="LocalSqlServer" connectionString="Data Source=servername\serverinstance;database=membership;user id=domain\user;password=password"/>
 </connectionStrings>
 <location path="Admin">
  <system.web>
   <authorization>
    <allow roles="Administrators"/>
    <deny users="*"/>
   </authorization>
  </system.web>
 </location>
 <location path="PostAd.aspx">
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location>
 <location path="EditPhotos.aspx">
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location>
 <location path="MyAds.aspx">
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location>
 <location path="MyProfile.aspx">
  <system.web>
   <authorization>
    <deny users="?"/>
   </authorization>
  </system.web>
 </location>
 <system.web>
  <authorization>
   <allow roles="Administrators" />
  </authorization>
  <customErrors defaultRedirect="Error.aspx" mode="RemoteOnly"/>
  <pages styleSheetTheme="Red"/>
  <authentication mode="Forms"/>
  <membership>
   <providers>
    <clear/>
    <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringname="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
   </providers>
  </membership>
  <profile enabled="true">
   <properties>
    <add name="FirstName" type="System.String"/>
    <add name="LastName" type="System.String"/>
    <add name="MemberId" defaultValue="0" type="System.Int32"/>
    <group name="Core"/>
   </properties>
  </profile>
  <roleManager enabled="true"/>
  <siteMap defaultProvider="RoleEnabled_AspNetXmlSiteMapProvider" enabled="true">
   <providers>
    <clear/>
    <add name="RoleEnabled_AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>
   </providers>
  </siteMap>
 </system.web>
 
 <system.net>
  <mailSettings>
   <smtp>
    <network host="yourSMTPhostname" port="25" defaultCredentials="true" userName="enterUserNameHereIfRequired" password="enterPasswordIfRequired"/>
    /&gt;
   </smtp>
  </mailSettings>
 </system.net>
</configuration>