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

  • Thread starter Thread starter RedHair
  • Start date Start date
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
 
Thanks, I'll try this tip.

DWS said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASP.net membership/role/profile question - is it possible? 1
Creating a custom ASPNET provider Database 2
Passing UserGUID to the Custom Role Provider 1
Membership, Profile, Roles, ... 1
Mulitple membership providers but one role provider 1
Membership 2
.NET 3.5 - Membership, Profile and Roles 1
Membership Provider: how to create initial user acct. after deploy 6

Back
Top