How to create Profile,Membership and Role provider with SQL2000/2005

[RedHair]

How to create Profile,Membership and Role provider with SQL2000/2005
thanks.

 

[Guest]

Red,
aspnet_regsql

I can do that with SQL Sever 2003 so maybe it will work for you. Your
implementation may be different depending on how you currently connect to the
database. This example uses a sql server userid. Create the database used
by the asp.net application providers. From the vs2005 command prompt run
aspnet_regsql and follow the wizzard steps.

Tell the asp.net application where the tables are. "LocalSqlServer" you
override that in the web.config with something like the following pointing to
the catalog where you created the tables.

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=kogdws;Initial
Catalog=webmstsql2;Persist Security Info=True;User
ID=redhaird;Password=redhaird" />
</connectionStrings>

Good Luck
DWS

 

[RedHair]

Thanks, I'll try this tip.

Red,
aspnet_regsql

I can do that with SQL Sever 2003 so maybe it will work for you. Your
implementation may be different depending on how you currently connect to
the
database. This example uses a sql server userid. Create the database
used
by the asp.net application providers. From the vs2005 command prompt run
aspnet_regsql and follow the wizzard steps.

Tell the asp.net application where the tables are. "LocalSqlServer" you
override that in the web.config with something like the following pointing
to
the catalog where you created the tables.

<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=kogdws;Initial
Catalog=webmstsql2;Persist Security Info=True;User
ID=redhaird;Password=redhaird" />
</connectionStrings>

Good Luck
DWS