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 need to run aspnet_regsql. That will popup the wizard to configure your new database.

Answer 2

1. Take the MDF and LDF files created by Express Edition (usually in App_Data) and Attach them to your SQL Server 2008 Instance.
2. Setup security for the new database (i.e. add a user to the database that will access the database. Make sure to give the appropriate permissions to the user)
3. Change the connection string in your web.config to point to the new database

Edit: My answer assumes that you're already using your database and just want to migrate it from SQL Express to SQL Standard edition.

Answer 3

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 4

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.

Answer 5

What if I'm using MySQL database and not SQL server? What do I need to run then??