I had a similar problem, but after I ran
aspnet_regsql.exe -E -S localhost -A all
to create the sql aspnetmembership db and using a web.config like
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="norcsfs02" connectionString="Data Source=norcsfs02;Initial Catalog=applixdata;User ID=csintra;Password=clntsrvcs;Persist Security Info=True" providerName="System.Data.SqlClient" />
<add name="SqlServices" connectionString="Data Source=norcsfs02;Initial Catalog=aspnetdb;User ID=CSintra;Password=clntsrvcs;Persist Security Info=True" />
</connectionStrings>
<system.web>
<membership defaultProvider="csIntra">
<providers>
<clear />
<add connectionStringName="SQLServices" applicationName="csintra" name="csIntra"
type="System.Web.Security.SqlMembershipProvider" />
</providers>
</membership>
<roleManager enabled="true" defaultProvider="csIntra">
<providers>
<clear />
<add connectionStringName="SQLServices" applicationName="csintra" name="csIntra"
type="System.Web.Security.SqlRoleProvider" />
</providers>
</roleManager>
<profile defaultProvider="csIntra">
<providers>
<clear/>
<add name="csIntra" applicationName="csintra" type="System.Web.Profile.SqlProfileProvider" connectionStringName="SQLServices" />
</providers>
</profile>
<webParts>
<personalization>
<providers>
<clear/>
<add connectionStringName="SQLServices"
&nbs p; name="AspNetSqlPersonalizationProvider" applicationName="csintra" type="System.Web.UI.WebControls.WebParts.SqlPersonalizationProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />
</providers>
<authorization>
<deny users="*" verbs="enterSharedScope" />
<allow users="*" verbs="modifyState" />
</authorization>
</personalization>
</webParts>
<compilation debug="true"/>
<authentication mode="Windows"/>
<caching>
<sqlCacheDependency enabled="true">
<databases>
<add
name="applixdata"
connectionStringName="norcsfs02"
pollTime="600000" />
</databases>
</sqlCacheDependency>
</caching>
</system.web>
</configuration>
It worked like a charm
Edited by michael - 25 July 2005 at 3:47pm