Script to create an ASP.NET Membership provider User

asp.net tsql asp.net-membership membership-provider
PositiveGuy picture PositiveGuy · Feb 9, 2012 · Viewed 14.4k times · Source

I created a bunch of insert scripts to add a new user to the aspnet_Membership and aspnet_User table. I can't auth, says it can't find my user.

Has anyone tried to create a new membership user via T-SQL inserts? I have to do it this way because our create user code in C#/ASP.NET does not work at the moment.

Answer

Vinicius picture Vinicius · Oct 8, 2013

From MSDN:

declare @now datetime
set @now= GETDATE()
exec aspnet_Membership_CreateUser 'MyAppName','admin1','pass@word1', '','[email protected]','','',1,@now,@now,0,0,null

http://msdn.microsoft.com/en-us/library/gg252020(v=office.14).aspx

Related questions

Generate ASP.Net Membership password hash in pure T-SQL

I'm attempting to create a pure t-sql representation of the default SHA-1 password hashing in the ASP.Net Membership system. Ideally, what I would get would be this: UserName Password GeneratedPassword cbehrens 34098kw4D+FKJ== 34098kw4D+FKJ== Note: that's …

Read More
Change the selected value of a drop-down list with jQuery

I have a drop-down list with known values. What I'm trying to do is set the drop down list to a particular value that I know exists using jQuery. Using regular JavaScript, I would do something like: ddl = document.getElementById("…

Read More
How to get the URL of the current page in C#

Can anyone help out me in getting the URL of the current working page of ASP.NET in C#?

Read More