Questions tagged [sqlmembershipprovider]

The `SqlMembershipProvider` class is used by the `Membership` and `MembershipUser` classes to provide membership services for an ASP.NET application using a SQL Server database.

The SqlMembershipProvider class is used by the Membership and MembershipUser classes to provide membership services for an ASP.NET application using a SQL Server database.

System.Object
. System.Configuration.Provider.ProviderBase
. . System.Web.Security.MembershipProvider
. . . System.Web.Security.SqlMembershipProvider

Namespace: System.Web.Security
Assembly: System.Web (in System.Web.dll)

To manually create the database, run the Aspnet_regsql.exe executable found in the %systemroot%\Microsoft.NET\Framework\ versionNumber folder and specify the -A m option (for example aspnet_regsql.exe -A m). The database created is called Aspnetdb. Alternatively, run Aspnet_regsql.exe to pull up the GUI configuration mode and choose to configure all ASP.NET Features.

http://msdn.microsoft.com/en-us/library/system.web.security.sqlmembershipprovider(v=vs.110).aspx

201 questions
0
votes
1 answer

SqlMembershipProvider initialize method not being called

I have done a custom implementation of MembershipProvider but for some reason the initialize method is not being invoked and thus my provider is not setting up properly from the config parameters, who invokes it in the first place and how do i get…
Addi
  • 291
  • 1
  • 6
  • 13
0
votes
2 answers

What methods from SqlMembershipProvider set IsApproved to false?

I have come across a problem where one of my user's IsApproved flag has magically been set to false and I'm wondering how this may have happened. The user is not locked out due to failed password attempts (not sure if this would set IsApproved to…
0
votes
2 answers

Orphaned entries in aspnetdb

After calling method _membershipProvider.DeleteUser(user.UserName, false); where where the second parameter (false) is deleteAllRelatedData, orphaned entries are left in the database (aspnet_Users table and probably more). What is the best practice…
spender
  • 117,338
  • 33
  • 229
  • 351
0
votes
1 answer

Mapping Asp.net cookies to users

If one has access to both the Asp.net membership DB (the standard SqlMembershipProvider db, generated with aspnet_regsql.exe), and the respective asp.net client's cookies, is it possible to correlate the two to identify the user from the…
spender
  • 117,338
  • 33
  • 229
  • 351
0
votes
2 answers

Encrypted passwords in asp.net SQLMembershipProvider and Umbraco membership provider

Security Noob here. I am trying to move from asp.net membership to Umbraco membership. But using passwordFormat="Encrypted" seems to encrypt differently between the Umbraco membership provider and Microsoft's SQL membership provider. If I register…
Ian Grainger
  • 5,148
  • 3
  • 46
  • 72
0
votes
1 answer

Configure SqlMembershipProvider without password

I need to use the SqlMembershipProvider without password to new users. How can I do that? Thanks!
Rodrigo Juarez
  • 1,745
  • 1
  • 23
  • 38
0
votes
2 answers

How do I select user information with multiple databases using ASP & VB.NET?

Okay here it goes . . . I have a web application I am developing in Microsoft Visual Web Developer using ASP, VB.net, etc. that will allow "Sellers" to post ads for "Buyers" to view. When the Buyer searches for a product, each result needs to…
0
votes
2 answers

How can I log/trap exceptions thrown by the ASP.NET SqlMembershipProvider?

I have a .NET 4 WebAPI app that's using the ASP.NET SqlMembershipProvider. When it works, it works fine - but if there's any problems connecting to the membership database, I just get a silent failure and the browser shows an HTTP 500 server…
Dylan Beattie
  • 53,688
  • 35
  • 128
  • 197
0
votes
3 answers

How to migrate from custom Membership Provider to SqlMembershipProvider?

I'm currently using a very basic custom implementation of MembershipProvider in an ASP.NET web application. As my requirements for membership increase, it seems to make a lot of sense to use an existing, full featured, and well tested implementation…
jrummell
  • 42,637
  • 17
  • 112
  • 171
0
votes
2 answers

Displaying Member info including Roles using Sql Membership Provider

I wish to create a summary table of all users with the database tables setup according to SqlMembershipProvider schema. So far, I have:
Tony
  • 1,839
  • 10
  • 27
  • 48
0
votes
1 answer

Pass values to overriden CreateUser method of SqlMemebership Provider in MVC

I am working with ASP.NET Membership Providers. I am using SqlMembership Provider, I have overriden the CreateUser class as shown below. As you can see I have a SportDetails fields which contains many values, this I want to use in the CreateUser…
0
votes
1 answer

MVC4 application can not see any membership section

Just installed VS 2012(Ultimate) and created a MVC4 application. When I looked into web.config, I can not find any membership, role or profile providers sections. Curious to know where they are set. Thanks.
Naresh
  • 2,667
  • 13
  • 44
  • 69
0
votes
1 answer

Call custom MembershipProvider without casting Membership.Provider

Is there a way to call the custom MembershipProvider I have implemented in code without having to cast the Membership class to my custom provider every time? For example, I setup my web.config like so:
0
votes
1 answer

Membership Provider producing unexpected SQL Error

I am getting the following error when calling Membership.GetUser() on a specific page (first page on the site to do so as we implement proper security controls) System.Data.SqlClient.SqlException (0x80131904): Login failed for user 'IIS APPPOOL\UAT…
Roger Willcocks
  • 1,649
  • 13
  • 27
0
votes
1 answer

Successfully extend custom SQL Datatables with aspnet_Membership tables

I have an application which I created using MVC3 and Custom SQL Database with 3 tables: mm_Table1, mm_Table2, mm_Jobs I built out the MVC app with a JobsController and have the respective Views folder with Create.cshtml, Delete.cshtml,…
J0NNY ZER0
  • 707
  • 2
  • 13
  • 32
1 2 3
13
14