How to set up role/membership objects in SQL Server database for ASP.net?

Question

I usually create role/membership database using command:

aspnet_regsql.exe -S (local) -E -A all

but my current web hosting company only allows to create database using phpMyLittleadmin.

How can I manually create database for asp.net role/membership?

How about of creating the role/membership locally and then just executes all the script tables? Isn't the better solution but it will work :) — profanis
– profanis, Commented Jun 16, 2012 at 10:48
Could you please tell me how to generate table creation scripts in MSSQL and execute the script tables in phpMyLittleadmin? — SiHyung Lee
– SiHyung Lee, Commented Jun 16, 2012 at 10:55

marc_s · Accepted Answer · 2012-06-16 14:49:21Z

1

In the directory where your aspnet_regsql utility lives (dependent on the .NET framework version you use - probably something like C:\Windows\Microsoft.NET\Framework\v4.0.30319), there's a list of Install*.sql script files that will create the necessary tables for the ASP.NET membership and roles system.

InstallCommon.sql
InstallMembership.sql
InstallPersistSqlState.sql
InstallPersonalization.sql
InstallProfile.SQL
InstallRoles.sql
InstallSqlState.sql
InstallSqlStateTemplate.sql
InstallWebEventSqlProvider.sql

So basically you only need to figure out which script files exactly you need, and which sequence to run them in - and then just ship those (or upload those) to your site and then execute it there.

There's also the same files for uninstalling the tables and the other database objects from your database (called Uninstall*.sql).

answered Jun 16, 2012 at 14:49

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to set up role/membership objects in SQL Server database for ASP.net?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related