ASP.NET Security Integration with a different datasource

Question

0.00/5 (No votes)

See more:

Hallo everybody,

Is it possible to log users into an ASP.Net application while the credentials are kept at a different datasoource like MSSQLServer?
For example, I wish to compare username and password against a database table, or I want to keep those who are authorized to specific webpages on a database.

Note: I want to keep the ASP.NET configuration, in other words, I want to take all the advantages of ASP.NET security configuration.

Please tell me, if I am not clear.

Thanks

Posted 24-Feb-11 3:14am

Yonathan1111

Add a Solution

2 solutions

Solution 1

Yes you can do it. Make a table in database and store the username and corresponding password.

When needed, verify against it and get back the needed data.

Example:

EmployeeID    Username    Password
     1        someuname   somepassword

Actually, you should encrypt the password and then keep it in DB. (out here I have written in clear text for sample)

Posted 24-Feb-11 3:40am

Sandeep Mewara

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Dylan Morley · Accepted Answer · 2011-02-24T03:42:00

Most definitely, have a look at created aspnetdb Creating the Application Services Database for SQL Server[^]

Using this database, you can store applications \ users \ roles etc for different applications.

You just use the SQLRoleProvider for this

How To: Use Role Manager[^]

The good thing about this is you can define your own providers if you want - these can go off to whatever datastore you want

Create Custom RoleProvider[^]

However, the aspnetdb provides all of the schema you need to make full use of the membership providers, I've used this successfully for many applications.