Using a new / separate database for forms authentication

Question

Does anyone have a view on whether to use a new separate database for forms authentication users, or is it ok to mix it with your application database?

I could see separation being useful if multiple applications/databases were sharing user authentication, but in my case I have one website/database, and intended to just add the tables/views/sps created by aspnet_regsql.exe to my current application database.

Any views/opinions welcomed. Thank you.

gwt · Accepted Answer · 2012-08-18 08:58:14Z

0

You can mix that db with your database BUT you should not make any changes to the default database tables if you want to use asp.net built in classes that use that database , It means you can only add your tables to that database !

answered Aug 18, 2012 at 8:58

gwt

2,4334 gold badges40 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 11:56:15Z

0

That is OK to have a single Database from which the Forms are to be authenticated. Since the SQL server is a very secure one there will be no problem in having a single database.

But If you want to setup Your custom database for Authentication then Refer the following Links

Using Forms Authentication with a customer database

forms authentication with sql server 2008 database questions

edited May 23, 2017 at 11:56

CommunityBot

11 silver badge

answered Aug 18, 2012 at 8:59

Krishna Thota

7,11617 gold badges58 silver badges79 bronze badges

Collectives™ on Stack Overflow

Using a new / separate database for forms authentication

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related