OK, Never thought development would drive me to tears, but this girl has had it!</o> </o> </o> I have been trying to troubleshoot an ASP.NET login issue <u1ersonName u2:st="on"><st1ersonName w:st="on">for</u1ersonName> the past 5 days and I am desperate <u1ersonName u2:st="on"><st1ersonName w:st="on">for</u1ersonName> assistance. I have posted on the database <st1ersonName w:st="on">forumn and contacted support and I am no closer to fixing this than I was on Monday.</o> </o> My website is yellowbrickroadtech.com </o> </o> I built the site using Visual web developer express. I have since installed SQL 2005 developer edition and Visual Studio 2005.</o> </o> I am using a SLQ 2005 server at my host site discountasp</o> </o> When I create usesrs roles etc, they show up in remote datebase at discount asp. So everything there appears to be working. My only purpose <u1ersonName u2:st="on"><st1ersonName w:st="on">for</u1ersonName> the database is to have users authenticate to access a secured folder and files.</o> </o> When my users who have valid accounts created login I get ?</o> Your login attempt was not successful. Please try again.</o> This of course tells me <u1ersonName u2:st="on"><st1ersonName w:st="on">for</u1ersonName> some reason the the database is not being queried. I have seen post on the asp.net site of others with this issue, but again no resolution. I need to get this fixed ASAP. PLEASE someone has to know what is going on.</o> </o> Below is my web.config </o> </o> </o> </o> <configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"></o> </o> <connectionStrings></o> <remove name="LocalSqlServer" /></o> <add name="LocalSqlServer" connectionString="Data Source=tcp:sql2k505.discountasp.net;Integrated Security=false;Initial Catalog=SQL2005_294046_ybr;User ID=SQL2005_294046_ybr_user;Password=(my password is here)" providerName="System.Data.SqlClient"/></o> </connectionStrings></o> </o> </o> </o> <system.web></o> <authentication mode="Forms"></o> <<u1ersonName u2:st="on"><st1ersonName w:st="on">for</u1ersonName>ms loginUrl="login.aspx" protection="Validation" timeout="300" /></o> </authentication></o> </o> <roleManager enabled="true" /> </o> <compilation debug="true" strict="false" explicit="true"></o> <assemblies></o> <add assembly="System.Design, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></o> <add assembly="System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></o> <add assembly="System, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B77A5C561934E089"/></o> <add assembly="System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=B03F5F7F11D50A3A"/></o> </assemblies></o> </compilation></o> <pages></o> <namespaces></o> <clear/></o> <add namespace="System"/></o> <add namespace="System.Collections"/></o> <add namespace="System.Collections.Specialized"/></o> <add namespace="System.Configuration"/></o> <add namespace="System.Text"/></o> <add namespace="System.Text.RegularExpressions"/></o> <add namespace="System.Web"/></o> <add namespace="System.Web.Caching"/></o> <add namespace="System.Web.SessionState"/></o> <add namespace="System.Web.Security"/></o> <add namespace="System.Web.Profile"/></o> <add namespace="System.Web.UI"/></o> <add namespace="System.Web.UI.WebControls"/></o> <add namespace="System.Web.UI.WebControls.WebParts"/></o> <add namespace="System.Web.UI.HtmlControls"/></o> </namespaces></o> </pages></o> </system.web></o> </o> </o> <appSettings/> </o> <system.net></o> <mailSettings></o> <smtp from=""></o> <network host="localhost" password="(my password is here)" userName="yellowbric1" /></o> </smtp></o> </mailSettings></o> </system.net></o> </configuration></o> </o>
Add the following to your web.config <system.web> <membership defaultProvider='MySqlMembershipProvider'> <providers> <add connectionStringName='LocalSqlServer' name='MySqlMembershipProvider' type='System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' /> </providers> </membership> </system.web> Vikram DiscountASP.NET www.DiscountASP.NET