Notes for deploying to SQL Server 2008

Topics: User Forum
Feb 5, 2011 at 12:55 AM
Edited Feb 5, 2011 at 12:56 AM

I am deploying the app to a SQL Server 2008 instance. One of the issues that tripped me up initially is that the web.config in the RTM release does not include a section for the profile provider. The net effect is that when trying to manage a user profile, the app will try to create the aspnet.mdf database in App_Data, which is not what I wanted. I wanted all profiles to reside in my production database. The way I fixed the issue was to modify the Profile section in the web.config. I added the <providers> section. It now looks like this:


    <profile defaultProvider="AspNetSqlProfileProvider">
        <clear />
        <add name="AspNetSqlProfileProvider" 
             description="SqlProfileProvider for TheBeerHouse" />
				<add name="Subscription" type="String"/>
				<add name="Language" type="String"/>
				<add name="ShoppingCart" type="TheBeerHouse.Models.ShoppingCart" serializeAs="Binary" allowAnonymous="true"/>
				<group name="PersonalInformation">
					<add name="FirstName" type="String"/>
					<add name="LastName" type="String"/>
					<add name="Gender" type="String"/>
					<add name="BirthDate" type="DateTime"/>
					<add name="Occupation" type="String"/>
					<add name="Website" type="String"/>
				<group name="ContactInformation">
					<add name="Street" type="String"/>
					<add name="City" type="String"/>
					<add name="State" type="String"/>
					<add name="ZipCode" type="String"/>
					<add name="Country" type="String"/>


I hope this helps anybody who runs into cryptic errors when editing profiles.

Nov 29, 2012 at 10:02 PM

the error message is here




you are still GREAT, write the whole section for that


I resolve the beginner  connection string section == http://  -- (also mine


then  forum, poll (only 1 computer 1 vote), member profile change, cartfor SHOP, all these does not work


beside , load of MESSAGE on how to write web.config  -- it said could not find schema information for element  .....


not sure how to resolve though, but you written a huge paragraph, I just don't know where to put it in my webconfig, should we put it behind the  connection string


we knew it is some form of profile or  some special user (with certain role) that can re-use  the   REGISTERED members


but still don't know how to resolve that 




there are other cool site software such as  GENEXUS evolution2 -- but also a big learning curve to make it just barely work