ASP.net Web Forms Application login using external DB

Question

I'am creating a dynamic web form aplication. It stores the users data in another database (external server) I know that there is aspnet_regsql.exe but i have no idea how to implement it on external server. (i also can't loose data from existing database) How can i force default login system to check if my database have valid credentials in my Password and UserName columns ?

Thanks in advance.

Win · Accepted Answer · 2013-11-26 15:08:36Z

2

Membership using aspnet_regsql.exe has been obsoleted.

There are new ones -

Universal Providers will be the closest if you want to use the legacy Membership.

It stores the users data in another database (external server) I know that there is aspnet_regsql.exe but i have no idea how to implement it on external server.

Yes, you can store the Membership's tables in another database. If so, you will need to have separate connection string for the Membership.

<membership defaultProvider="DefaultMembershipProvider">
  <providers>
  <clear/>
    <add name="DefaultMembershipProvider" connectionStringName="MyConnection" ... />
  </providers>
</membership>
<roleManager enabled="true" cacheRolesInCookie="false" 
  defaultProvider="DefaultRoleProvider">
  <providers>
  <clear/>
  <add name="DefaultRoleProvider" connectionStringName="MyConnection" ... />
  </providers>
</roleManager>

answered Nov 26, 2013 at 15:08

Win

62.4k13 gold badges106 silver badges190 bronze badges

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

3 Comments

molu2008 Over a year ago

Hi thanks for comprehensive answer. I afraid that i do not explain well goal that i want to achieve. Thing is that i have to authorize users which are authenticate by user login and password (that i store in external DB) I can achive that in any possible way. After a day of looking for answers and learning ASP.NET (i'm new in this technology) i figure out that maybe easier will be to override Login.Authenticate Event like here:[link] msdn.microsoft.com/en-us/library/…

molu2008 Over a year ago

What do you think ? does it make any sense ?

Win Over a year ago

I suggest you to use Membership Provider. If you do not use Membership Provider and just use Login.Authenticate to authenticate a user, you will need to 1) create Authentication Ticket by yourself, 2) create IPricipal object by yourself on each request. It is a lot of works if you are new to FormAuthentication.

Collectives™ on Stack Overflow

ASP.net Web Forms Application login using external DB

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related