Forms Authentication Using SQL Server 2000 Database

W

WhiskeyRomeo

I have looked at this example and it uses the webconfig file as the external
datasource. So that was totally unhelpful.

http://www.aspnettutorials.com/tutorials/validation/authentication-aspnet2-vb.aspx

I have a 1.1 Login form that implements forms authentication that obviously
will not convert to VS 2005. It uses a sqlcommand to verify the username and
password and if validated retrieves certain information about the user via a
datareader.

Does anyone have a real world example using SQLServer 2000 or 2005?

WR
 
W

WhiskeyRomeo

WhiskeyRomeo said:
I have looked at this example and it uses the webconfig file as the external
datasource. So that was totally unhelpful.

http://www.aspnettutorials.com/tutorials/validation/authentication-aspnet2-vb.aspx

I have a 1.1 Login form that implements forms authentication that obviously
will not convert to VS 2005. It uses a sqlcommand to verify the username and
password and if validated retrieves certain information about the user via a
datareader.

Does anyone have a real world example using SQLServer 2000 or 2005?

WR

I wanted to add I uses roles and here is my webconfig file settings for the
1.1 application:

<authentication mode="Forms">
<!-- old setting was Windows -->
<forms name="UPAuth" loginUrl="login.aspx" slidingExpiration="true"
protection="All" timeout="20" path="/">
<credentials passwordFormat="Clear">
</credentials>
</forms>
</authentication>
<location path="Admin">
<system.web>
<authorization>
<!-- Order and case are important below -->
<allow roles="Admin" />
<deny roles="Photog,Super,Public" />
<deny users="?" />
</authorization>
</system.web>
</location>
<location path="Super">
<system.web>
<authorization>
<!-- Order and case are important below -->
<allow roles="Super,Admin" />
<deny roles="Photog,Public" />
<deny users="?" />
</authorization>
</system.web>
</location>
<location path="Reports">
<system.web>
<authorization>
<!-- Order and case are important below -->
<allow roles="Super,Admin,Photog" />
<deny roles="Public" />
<deny users="?" />
</authorization>
</system.web>
</location>
<location path="Public">
<system.web>
<authorization>
<!-- Order and case are important below -->
<allow roles="Super,Admin,Public" />
<deny roles="Photog" />
<deny users="?" />
</authorization>
</system.web>
</location>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top