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

WPF does not respect SQL Connection and Membership Provider in App.config

I have a WPF form that I am trying to use with a SQL Membership Provider we have setup. My App.Config looks like this:
Dan
  • 1
0
votes
1 answer

Create a checkboxlist of user roles MVC5 razor

I am trying to show a checkbox list of application roles in a view. I am not sure how to populate view with all the roles that I pull from the aspnet_roles table. If I use the code below I get null reference exception because ApplicationRoles is…
snowflakes74
  • 1,307
  • 1
  • 20
  • 43
0
votes
0 answers

Use ASP.Net Membership Provider in MVC (instead of SimpleMembership)

I have already implemented an MVC4 project using SimpleMembership. However for certain reasons, i need to integrate the older ASP.NET Membership provider in the project to replace the SimpleMembership provider. Is this possible? If so, how can it…
ZiggY
  • 111
  • 1
  • 9
0
votes
0 answers

Can't add existing SQL Membership Provider to MVC 5

I'm transfering an existing ASP.net forms site to MVC 5 and I can't get the user authentication to work. I can't understand what it is that I'm missing. What I've added the database and the connection string and made sure they work. I then pasted…
Peter
  • 3
  • 4
0
votes
1 answer

how to apply Roles and Membership classes' methods on user defined SQL tables

I have been using ASP.NET Roles/Membership classes and associated methods in ASP.NET Website application. Where I have configured ASP.NET membership database. With this database, I am able to use all those methods associated with Membership and…
0
votes
2 answers

Membership Roles.GetUsersInRole not working for me

Dim usersInRole As String() = Roles.GetUsersInRole("HR_Base_Role") Dim Myusers As New MembershipUserCollection For Each UserName As String In usersInRole Myusers.Add(Membership.GetUser(UserName)) Next ComboBox2.DataSource = Myusers The code…
StackTrace
  • 9,190
  • 36
  • 114
  • 202
0
votes
1 answer

Cannot login with new password after resetting using SqlMembership Provider

After resetting the password using SqlMembership provider.I am unable to login with the new password. Below is the line of code used to reset the password for dbo.aspnet_Membership table. Password is encrypted . Everytime I reset the password a new…
0
votes
1 answer

Hot to fetch UserId from aspnet_Users table while using Windows authentication

I am using windows authentication in my application if(User.IsInRole("Supervisor")) { //do something } which is working as expected. Now i want to fetch a UserId of the logged in user from aspnet_Users table . I tried using Membership.GetUser ,…
0
votes
2 answers

ASP.NET Login Control rejects users who exist

I'm having some trouble with the ASP.NET 2.0 Login Control. I've setup a database with the aspI.net regsql tool. I've checked the application name. It is set to "/". The application can access the SQL Server. In fact, when I go to retrieve the…
rsteckly
  • 1,952
  • 3
  • 23
  • 35
0
votes
2 answers

ASP MySQLRoleProvider tie roles to users

I would like to use the mysql role provider for aspnet. I have setup a custom table for the users using the attribute userTableName="user". Now the problem is that when I assign users to roles, MYSQLRolesprovider creates an entry in a table…
Sello Mkantjwa
  • 1,798
  • 1
  • 20
  • 36
0
votes
1 answer

Using SQL and AD membership providers together in ASP.NET 4.5

I have an application that is used by both internal employees and outside clients. I would like internal users to be authenticated against Active Directory, while clients use the Universal Providers membership provider. I'm vaguely familiar with…
0
votes
1 answer

SqlMembershipProvider where IIS and SQL are on different machines?

We're moving one of my websites to production. Because of a firewall and the website and database being on different machines, the website can't connect directly to the SQL server. We've set it up so we're running all of the database access…
user291525
0
votes
1 answer

ASP.net Membership Provider Website Administrator Tool

I have created the necessary tables (aspnet_User,....) in Sql server Management Studio 2005 in my Database named "AuctionSite". So instead of making one in App_Data folder ,i want my website to point the database (AuctionSite) MembershipProvider,…
user274364
  • 1,797
  • 2
  • 20
  • 27
0
votes
1 answer

ASP.NET web application project ProfileBase.Create(userName) method always returns profile of current user

I am using this article to implement ASP.NET SQLMembership Profile Provider in my ASP.NET 4.0 Web Application project (NOT website project). I am using Forms authentication. On my admin page I need to display the profile info of all the users. But…
nam
  • 21,967
  • 37
  • 158
  • 332
0
votes
2 answers

MVC Application is looking for credentials in the wrong database

I have an aspnetservicesdb database that is used for storing user profiles. I have deployed a new asp.net mvc application. The application uses a local sqlexpress database in the appdata directory for membership/profile purposes. I do not want the…