473,385 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Move asp.net profile/membership tables to sql server

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
2 5887

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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: VB Programmer | last post by:
I am using personalization/profile to store info for the user that is not contained in the aspnet_Users or aspnet_Membership tables. This info includes, firstname, lastname, and phonenumber. ...
8
by: VB Programmer | last post by:
I would appreciate your assistance on this ASP.NET 2.0 site.... This is the wierd problem: While accessing the built in .NET functions for 'profiling' or 'membership' an error is generated (see...
2
by: RedHair | last post by:
How to create Profile,Membership and Role provider with SQL2000/2005 thanks.
2
by: jdp | last post by:
I've created a custom login control with values that are not used in the Membership table. I created these other fields through the <profiletag in the web config. I'm able to get a new member...
2
by: JoeFusion | last post by:
Hi folks, I am trying to use the new User Profile functionality in ASP.Net 2, and on initial impression, it looked simple enough to use. But I seem to be getting in a bit of a mess as to what...
2
by: Peter Afonin | last post by:
Hello, I'm using CreateUserWizard control in ASP.NET 2.0. I'm storing the data in SQL Server 2005. The first and last steps run smoothly without any problems. But I added one middle step to...
2
by: Annie | last post by:
Hello guys, I have set the MEMBERSHIP, ROLEMANAGER and PROFILE in my config file as below. I just want to use my own sql server 2000 table instead of MSDB.
1
by: kpg* | last post by:
Hi all, Trying to use the ASP.NET 2.0 membeship API to manage users and user profiles, and of course, to provide role based security to my web app. I have several attributes I want to users,...
4
by: Scott M. | last post by:
When profile data is stored in ASP .NET, where is the user data persisted? For how long is it persisted: is it session persisted or permanent (like a cookie)?
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.