Hello everyone...I have created an ASP.NET app using VWD 2005 and I've created a custom access database and I've installed all membership objects on that using aspnet_regsql...and I've also configured the Web.config file as shown bellow.
My database name is westside.mdf...Now the problem is when I open ASP.NET administration tool and try to see if my providers in the advanced section, are working fine..Its always giving me an error that cannot create connection to the database...And also when I'm clicking on the total site management its saying no providers created...Why is this happening and also I've seen some examples where providers can be configured through the Administration tool->Providers tab section but in my case there is no option or link for creating a provider there..How can I overcome this problem...Please help...
This is my Web.config :
<configuration>
<appSettings/>
<!--
**********************
Database configuration
**********************
-->
<connectionStrings>
<add name="WestsideConnectionString" connectionString="Server=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|Westside.mdf;Database=Westside;Trusted_Connection=Yes;User Instance=True"/>
</connectionStrings>
<system.web>
<compilation debug="false" />
<!--
*******************
Form Authentication
*******************
-->
<authentication mode="Forms" >
<forms name=".WESTSIDEAUTH" loginUrl="~/Login.aspx" defaultUrl="~/Default.aspx"/>
</authentication>
<!--
****************
Profile Provider
****************
-->
<profile>
<providers>
<add name="WestsideSqlProfileProvider" connectionStringName="WestsideConnectionString" applicationName="/" type="System.Web.Profile.SqlProfileProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"/>
</providers>
</profile>
<!--
*******************
Membership Provider
*******************
-->
<membership defaultProvider="WestsideSqlProvider" userIsOnlineTimeWindow="15">
<providers>
<clear/>
<add name="WestsideSqlProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="WestsideConnectionString" applicationName="/" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="false" requiresUniqueEmail="false" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="7" minRequiredNonalphanumericCharacters="1"/>
</providers>
</membership>
<!--
************
Role Manager
************
-->
<roleManager defaultProvider="WestsideRoleSqlProvider" enabled="true" cacheRolesInCookie="true">
<providers>
<clear/>
<add name="WestsideRoleSqlProvider" type="System.Web.Security.SqlRoleProvider" connectionStringName="WestsideConnectionString" applicationName="/"/>
</providers>
</roleManager>
<pages theme="Default"/>
</system.web>
</configuration>