By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,978 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,978 IT Pros & Developers. It's quick & easy.

Move asp.net profile/membership tables to sql server

P: n/a
Hello,

I have a problem that I need some help on.

I am creating a website that utilizes the builtin membership functionality
in Asp.net 2.0. By default, the "AspNetSqlProvider" is used and the
membership data is stored in "AspNetDB.mdf". However, instead of using this
mdf file, I would like to store the membership data in Sql Server, using the
"SqlMembershipProvider". I have already run the "regsql.exe" file, but I'm
not sure of what I need to do next. Do I delete the AspNetDB.mdf data file
that is in my web project? Do I need to manually specify the membership
provider in the web.config file? Any suggestions would certainly be
appreciated.

Thanks.

May 18 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a

Check here:

http://weblogs.asp.net/scottgu/archi...25/423703.aspx

and

http://www.aspcode.net/articles/l_en...ticle_279.aspx
You'll find most of your answers there.

My last name is Holliday too.

That's crazy!
http://sholliday.spaces.live.com/blog/

"Brandon Holliday" <br******@nospam.transech.comwrote in message
news:DA**********************************@microsof t.com...
Hello,

I have a problem that I need some help on.

I am creating a website that utilizes the builtin membership functionality
in Asp.net 2.0. By default, the "AspNetSqlProvider" is used and the
membership data is stored in "AspNetDB.mdf". However, instead of using
this
mdf file, I would like to store the membership data in Sql Server, using
the
"SqlMembershipProvider". I have already run the "regsql.exe" file, but
I'm
not sure of what I need to do next. Do I delete the AspNetDB.mdf data
file
that is in my web project? Do I need to manually specify the membership
provider in the web.config file? Any suggestions would certainly be
appreciated.

Thanks.

May 18 '07 #2

P: n/a
Hey Sloan,

Thanks for the quick reply. I took a look at Scott Gu's blog, and it helped
me.

And it's not everyday you find a Holliday. That's crazy!

Thanks again.
"sloan" <sl***@ipass.netwrote in message
news:Ov**************@TK2MSFTNGP04.phx.gbl...
>
Check here:

http://weblogs.asp.net/scottgu/archi...25/423703.aspx

and

http://www.aspcode.net/articles/l_en...ticle_279.aspx
You'll find most of your answers there.

My last name is Holliday too.

That's crazy!
http://sholliday.spaces.live.com/blog/

"Brandon Holliday" <br******@nospam.transech.comwrote in message
news:DA**********************************@microsof t.com...
>Hello,

I have a problem that I need some help on.

I am creating a website that utilizes the builtin membership
functionality
in Asp.net 2.0. By default, the "AspNetSqlProvider" is used and the
membership data is stored in "AspNetDB.mdf". However, instead of using
this
>mdf file, I would like to store the membership data in Sql Server, using
the
>"SqlMembershipProvider". I have already run the "regsql.exe" file, but
I'm
>not sure of what I need to do next. Do I delete the AspNetDB.mdf data
file
>that is in my web project? Do I need to manually specify the membership
provider in the web.config file? Any suggestions would certainly be
appreciated.

Thanks.

May 18 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.