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
2
votes
2 answers

Is a .Net membership database portable, or are accounts somehow bound to the originating Web site or server?

I have an ASP.Net Web site using .Net Membership with a SQL Server provider, so the users and roles are stored in the SQL tables created by Aspnet_regsql.exe. Is this architecture totally self-contained and portable, or are users in it somehow bound…
2
votes
0 answers

Is it possible to use SqlMembershipProvider AND ActiveDirectoryMembershipProvider at the same time

Good afternoon. My first post with an MVC 4 authentication question. For my current project, I have a requirement to allow logins against multiple user stores. Administrators need to be validated against an Active Directory store and regular users…
ceci
  • 429
  • 1
  • 7
  • 22
2
votes
1 answer

Using an existing SqlMembershipProvider database with an ASP.NET MVC app

I have been looking for direction on how to use an existing membership db with a new mvc app. Everything I've found is in regard to creating a new membership db. I would expect to simply point the new app to the existing db somewhere, but I haven't…
tintyethan
  • 1,772
  • 3
  • 20
  • 44
2
votes
1 answer

Allow asp.net sqlmembership users to create "subusers"

I've tried searching this for days and can't seem to find an adequate answer so I'll ask here. I'm building an asp.net Membership website. What I want to do is: Allow a user to create an account - say UserA I then want to allow UserA to create "sub…
GenXisT
  • 298
  • 4
  • 10
2
votes
1 answer

CreateUserWizard not use tables created by aspnet_regsql

How can I configure my CreateUserWizard and Login controls to use the aspnet_regsql tables? I'm using SQL Membership. I added aspnet_regsql to my project, database and configured in web.config file. When I created a new user, the CreateUserWizard…
gvd
  • 1,482
  • 6
  • 32
  • 58
2
votes
1 answer

Check Password on SqlMembershipProvider bypassing IsApproved?

In the application I am working on, users are created by are not approved until they activate their account. The IsApproved flag is set to false until they have activated. When they submit their activation, we want to check that their password is…
danpalmer
  • 2,163
  • 4
  • 24
  • 41
2
votes
2 answers

How do add/integrate SqlMembershipProvider in existing MVC 3 project?

On creating a new MVC project, Visual Studio take cares of SqlMembershipProvider if it is a non-empty project. Visual Studio creates a Database and all necessary Tables. But, I have an existing MVC 3 project and I would like to add/integrate…
Parimal Raj
  • 20,189
  • 9
  • 73
  • 110
2
votes
3 answers

SqlMembershipProvider not able to login with frames or iframes only in Internet Explorer

I am using SqlMembershipProvider with asp.net and it works fine until I try to use iframes or frames. When I login without them, I have no issues but if I wrap our website from our customer's site, and try to login, it just flashes and comes back to…
ErocM
  • 4,505
  • 24
  • 94
  • 161
2
votes
1 answer

Membership.CreateUser issue

There is an issue reported here ASP.NET Membership Issues With Registration which summarizes a situation I am experiencing. I'm not sure I understand the claimed solution. Simply put, after invoking this line: MembershipUser user =…
Jason Kealey
  • 7,988
  • 11
  • 42
  • 55
2
votes
3 answers

Extending ASP.NET Membership Provider, PK == FK == OK?

I'm using the SQLMembershipProvider and want to add a load more info about the users. It the best way to do this to create a new DB and make an entry for each new user as they are created? If so, is there any reason not to use the…
Mr. Flibble
  • 26,564
  • 23
  • 69
  • 100
2
votes
1 answer

Configure ASP.NET SQL Membership Provider from Web Role setting

I have a Web Role that is using the ASP.NET SQL Membership provider. Currently the configuration is in the Web.Config file. I would like to configure the connection string as a Web Role setting instead of having it in the Web.Config. The main reason…
1
vote
1 answer

Why are commas not allowed in a username when using the SqlMembershipProvider?

Although NOT documented as a part of the CreateUser method on MSDN, the SqlMembershipProvider throws an ArgumentException if you try to do anything with a username containing a comma (including trying to create a user). Commas in passwords appear to…
1
vote
1 answer

ASP.NET Web Forms Custom Membership provider error

In my ASP.NET Web Forms app, I'm trying to create my own SQLMembershipProvider class, to override the ConnectionString at runtime. But I am getting a configuration error: "The type 'ExtendRegv1.MyMembershipProvider' is ambiguous" I have created the…
1
vote
1 answer

ASP.NET SQL Server Registration Tool Not Finding Any Databases

I am trying to use the ASP.NET SQL Server Registration Tool to setup my database for Membership Roles and ASP.NET Users however it cannot find any database when I clearly have one. I am using SQL Express, does that play any role?
Darren
  • 10,631
  • 8
  • 42
  • 64
1
vote
1 answer

Develop a .net custom membership provider for facebook

I have an mvc website that is using the asp.net membership database. I am wanting to enhance the website to allow users to use their facebook details to log into my site. I use the database for membership and role management, I have a number of…
Diver Dan
  • 9,953
  • 22
  • 95
  • 166