Sukumar Raju's Blog

MCP

Sponsors

Tags

News

SharePoint SharePoint

More reading these days Patterns and practicces


Interesting to work with ASP.NET Membership provider

Suggested Reading C# Book


patterns & practices Application Architecture Guide 2.0


MVP Blog Badge.

Grab this badge here!


Installing ASP.NET Membership services database in SQL Server Express 2008

In this article i have briefly discussed ASP.Net SQL Server Membership database installation on SQL Server 2008 Express.

Environment: Visual Studio 2008; SQL Server 2008

Step 1:

  1. Run aspnet_regsql.exe utility from C:\windows\Microsoft.NET\Framework\v2.0.50727 folder on your machine. Selecting or double clicking the aspnet_regsql.exe utility opens the wizard as below.

1

Selecting Next button on above window opens next window where you can either configure SQL Server for Application services or remove Application services information from an existing database.

Step 2:

Select configure SQL Server for application services radio button to install new database and select Next button.

2

Step 3

Enter your SQL Express server name as <your Machine name \SQL Express> as shown below. Note that you can change the application services database name to your desired name (aspnetdb by default).

Note that i named the database to ASPNETServices

3

Step 4:

Select Next button and confirm that your settings are correct to go further with installation (shown in below image) and select Next button.

4 

   Step 5

Selecting Next button on above window takes you to confirmation window as below after successful installation of your application services database for ASP.NET.

5 

Step 6

You will see installed ASPNET Services database ready to use within your ASP.NET application

6

Reference:

http://www.asp.net/learn/security/tutorial-04-vb.aspx

http://www.asp.net/learn/security-videos/video-388.aspx

Posted: Oct 02 2009, 04:30 PM by sukumarraju | with 20 comment(s)
Filed under:

Comments

charles rhamazany said:

I know now how to generate my security tables in a DB other than ASPNETDB. Thanks Raju. Great post.  

# December 8, 2009 5:45 AM

nestea said:

Thnx! Works great.

# December 28, 2009 3:46 PM

Praveen said:

Thanks Buddy.

It worked for me!!!

# January 13, 2010 5:15 PM

peter hamilton-scott said:

Works a charm. Thanks.

# January 14, 2010 8:36 AM

Sukumar Raju's Blog said:

In my article Install ASP.NET Application Services database step by step guide is provided to install

# January 17, 2010 4:01 PM

sanjibsinha said:

Very helpful. Nice work.

# July 16, 2010 7:42 AM

Jorge said:

Thanks you man

i was looking for a guide like this

# August 12, 2010 1:12 AM

morke said:

Thanks, short and to the point

# September 14, 2010 2:41 PM

progammer said:

my friend like what you say but i get error setup failed

exception:

unable to connect to sql server database

can you tell me what's answer

# September 15, 2010 10:03 AM

sukumarraju said:

Hi programmer,

AS the exception says 'there is problem with your SQL Server connection string'.

Make sure that you can connect to SQL Server using SQL Server Management by choosing SQL Server authentication using the same USERNAME and PASSWORD that are used in Web.config connectionStrings section.

Make sure that the same User account has permission on Membership databse.

# September 17, 2010 9:21 AM

Instalando ASP.NET Membership no SqlServer | 1/2 Bit said:

Pingback from  Instalando ASP.NET Membership no SqlServer | 1/2 Bit

# October 13, 2010 1:51 PM

Michael said:

Thanks for the post, works great

# October 20, 2010 11:13 PM

Getting started ASP.Net MVC 2 , Razor , Fluent Nhibernate and ASP.Net Membership, Open Id – Day 1 | DevTalk said:

Pingback from  Getting started ASP.Net MVC 2 , Razor , Fluent Nhibernate and ASP.Net Membership, Open Id &ndash; Day 1 | DevTalk

# October 21, 2010 4:35 PM

Hitesh nirmal said:

Thanks, short and to the point

# December 2, 2010 1:13 AM

Installing ASP.NET Membership services database in SQL Server 2008 | BLTSoftware Solutions said:

Pingback from  Installing ASP.NET Membership services database in SQL Server 2008 | BLTSoftware Solutions

# July 28, 2011 1:15 PM

Danny said:

Hello.

Can I use this to connect to SQL Server standard (NOT Express)? I don't want to use the .mdf file, but rather use an existing SQL Server database. Is that possible?

# February 15, 2012 3:06 PM

sukumarraju said:

Hello Danny,

Yes it is feasible to install ASP.NET Membership database in SQL Server standard existing database.

Thanks for pointing that issue, I update this article with that info.

# March 5, 2012 5:28 PM

SSen said:

Thanks Raju for the useful post. Worked great!

# April 25, 2012 11:29 AM

Web.config allow location access for specific user | PHP Developer Resource said:

Pingback from  Web.config allow location access for specific user | PHP Developer Resource

# May 23, 2012 6:09 PM

asp.net mvc3 with a extern sql server, how? | PHP Developer Resource said:

Pingback from  asp.net mvc3 with a extern sql server, how? | PHP Developer Resource

# May 23, 2012 7:13 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)