I am trying to move a simple ASP.Net web application from my local machine to a remote server. I am using .net 2.0. On the local machine, Membership (usernames, roles and rules) are all stored in the ASPNETDB.MDF database. I want to move this to the remote server and use the SQL Server with a name of HRSMSQLSharePoint

The existing authorization portion of the web.config for the local version is given below.

Code:
  </authorization>
  <roleManager enabled="true" />


<membership defaultProvider="MyMembershipProvider" userIsOnlineTimeWindow="30">
	<providers>
		<clear/>

		<add name="MyMembershipProvider"
  connectionStringName="LocalSqlServer"
  applicationName="MyApplication"
  enablePasswordRetrieval="false"
  enablePasswordReset="false"
  requiresQuestionAndAnswer="false"
  requiresUniqueEmail="true"
  passwordFormat="Clear"
  maxInvalidPasswordAttempts="5"
  passwordAttemptWindow="10"
  minRequiredPasswordLength="3"
  minRequiredNonalphanumericCharacters="0"
  type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"
  />
	</providers>
</membership>
		
  <authentication mode="Forms" />
I can't seem to get the membership to you the remote server. Any help would be greatly appreciated.