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
1
vote
1 answer

ASP.NET SqlMembershipProvider: Unique but not required email?

Is there a way to configure ASP.NET SqlMembershipProvider such that Email is optional but when provided must be unique? I only found the requiredUniqueEmail attribute (web.config) which makes Email mandatory. Do I have to leave this out and…
davehauser
  • 5,844
  • 4
  • 30
  • 45
1
vote
1 answer

Add Password Requirements to Membership Provider

Do I need to make a Custom Membership Provider or is there another way? I have a project using ASP.NET Forms Authentication and the Microsoft SQL Membership Provider. The website is DONE. I use this provider everywhere. (Register, Login, Forgot…
1
vote
1 answer

Sql Membership for ASP.NET, Learning Resources

I am quite a beginner to ASP.NET. Recently, I started to learn ASP.NET WebForm. I created a web application where I needed to implement the login and registration form. Could you tell me about the best resources (book, video, tutorial, etc...) to…
Usman
  • 13
  • 2
1
vote
0 answers

How to implement window with ask for username and password in Sql Membership provider

I use tutorial from here to create SQL Membership Provider. But I don't know how to implement functionality, that when user open my Silverlight application appear window where he must put correct user name and password and when he click login button…
netmajor
  • 6,507
  • 14
  • 68
  • 100
1
vote
1 answer

Using SqlMembershipProvider when ActiveDirectoryProvider fails to log a user in

I have a requirement to allow access to an app with users being authenticated by AD. Sadly, not all of the users who can access the app will have been authenticated this way so I need to provide a mechanism whereby if a user arrives as the site…
1
vote
1 answer

Can I use the authorization rule (web.config) with Identity

I am migrating an old application that use the SqlMemberShipProvider and have a lot of authorization rules. e.g.
amd
  • 20,637
  • 6
  • 49
  • 67
1
vote
2 answers

Load list of roles for each user in MVC5 razor

I am trying to display a row of each user and their roles in the ASP.net MVC application. Users and their roles are stored in ASP.net membership provider table. Using the code below I can display each user and the role they are assigned, but my…
snowflakes74
  • 1,307
  • 1
  • 20
  • 43
1
vote
0 answers

ASP.NET SQLMembership Provider not logging in

My web app uses the sql memebership provider. Running it locally all is well, deploying to a dev server it works fine too in firefox, but in IE8 something unexpected is happening. Once a user logs in they're supposed to be redirected to home.aspx.…
user23048345
  • 3,033
  • 7
  • 31
  • 31
1
vote
1 answer

Partial connection to SQL Server 2014 Express

Firstly, this is not a repeat of the same old: provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified. Here's the scenario. I'm using ASP.NET membership with a SQLMembershipProvider. This used to work fine, however…
1
vote
0 answers

Export Sql membership data to asp.net identity 2.0

I am updating my MVC application to use asp.net identity, is there any way to import current users information from Sql-Membership Provider.
hncl
  • 2,295
  • 7
  • 63
  • 129
1
vote
0 answers

Using OAuthWebSecurity for external login and SqlMembershipProvider for internal login

In my MVC4 project I have defined connection string to database and have defined it as SqlMembershipProvider, it works fine for local account (Login and register). but in external (facebook) login and in ExternalLoginCallback method I got this error…
Aryan Firouzian
  • 1,940
  • 5
  • 27
  • 41
1
vote
1 answer

Asp.net Forms Authentication Cookie Issue

I am running into a weird issue when publishing to a staging server in Azure. Within this deployment I have a single web application using SQL membership. When I attempt to log in via my login page I am redirected back to the login page. This is a…
Brownman98
  • 1,053
  • 1
  • 7
  • 17
1
vote
1 answer

How to migrate memberships from SqlAzureMembershipProvider to Azure Active Directory

I have an existing application with a few thousand users using SqlAzureMembershipProvider for authentication. I am interested in creating an Azure Active Directory for the application and migrating the existing membership profiles into it. Is it…
1
vote
0 answers

Managing App Users/Groups in a iPhone App

I'm looking at managing user groups in an iPhone App. The App is connected to a WebServer. I'm therefore looking at using ASP.net Membership Provider to store/manage User Info. (We may just make a simple custom table to manager end users). I have…
1
vote
1 answer

Allow space in SqlMembershipProvider password

Are spaces not allowed in the default password format for SqlMembershipProvider, or have I done something else wrong? If they aren't allowed, why is that?
annelie
  • 2,569
  • 6
  • 25
  • 39