How do I change my asp.net membership database from express to standard sql?

Question

I am building an ASP.NET 3.5 (C#) application and I plan to use the membership and roles security.

I want to set this up on my SQL Server 2008 standard edition and not the default express setting.

How would I go about this?

Answer 1

You can install membership database with this command aspnet_regsql.exe at *C:\Windows\Microsoft.NET\Framework\v2.0.50727* (adjust to your path)

You can find more details here

Answer 2

It doesn't matter wich database server version you are using for the ASP.NET security membership/role module, apart from being SQL Server.

To set up manually this security on a server you have to run these scripts:

c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\InstallCommon.sql

c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\InstallMembership.sql

c:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\InstallRoles.sql

and configure web.config accordingly (see http://msdn.microsoft.com/en-us/library/6e9y4s5t.aspx).

You may run this scripts using the same database where you have your data, or you can create a new database to store user membership or role related data and run them there.