Experts:
Ok - here is the latest challenge... I've created a SQLExpress Database using the cool aspnet_regsql tool. That creates all the tables needed for authentication. After that I setup web.config with a LocalSqlServer connection... next I used the web configuration tool to select AspNetSqlProvider as my authentication provider DB... I setup a user in the DB, Allow my admin group and deny ? (unauth) users... everything is great so far... Run the app, my logon comes up, I type in user / pwd and FormsAuthentication.Authen
My guess it is some sort of permissions issue, but "Authenticate" only returns T/F... no feedback.
Here is some of my setup... nothing complicated... I'm just testing before I convert my app to SQL from Access:
--------------------------
Web.Config:
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=.\SQLEXPRESS;Attach
providerName="System.Data.
</connectionStrings>
--------------------------
Code on Login:
Protected Sub Login1_Authenticate(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.
If FormsAuthentication.Authen
FormsAuthentication.Redire
End If
End Sub
--------------------------
OH - using VS2005, language=vb, SQLExpress latest ver.
Thanks for your help in advance!
Stan
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Here ya go:
<authentication mode="Forms" >
<forms name="icsAuth" loginUrl="login.aspx">
</forms>
</authentication>
and
<authorization>
<deny users="?" />
<allow roles="SiteAdministrators"
</authorization>
Notes: The user I'm testing with is in the "SiteAdministrators" group... just in case I pulled out that "Allow roles" line alll together and tested... no luck...
OK - Sometimes it pays to take a break, throw the football with your daughter (yes daughter), eat dinner, and then try again. I've figured it out... well, actually I found some other poor guy who was going crazy, asked for help and found it. For the future reference of someone who may be clueless like me here is the simple solution: You can't do it. Yep, you can't use FormsAuthentication.Authen
If Membership.ValidateUser(Lo
FormsAuthentication.Redire
End If
Here are the articles I stumbled upon:
http://forums.asp.net/thre
more details
http://msdn2.microsoft.com
Hope it helps someone else.
Solar Flare - Thanks for taking time to help me. Have a blessed night.
Stan.
Business Accounts
Answer for Membership
by: Solar_FlarePosted on 2006-09-20 at 14:25:06ID: 17564640
can you please post the authentication etc part of your web.config file that sets the authentication & membership etc that tells your forms authentication to use your database?