howsit guys i have my own customised starter kit hosted at www.classifieds4u.co.za however its giving issues. Firstly I had to create the database in my hosting control panel and restore my classifiedsdb.mdf to that database, I altered the connection string,
however it stilll gives issues and for the life of me i cant figure out why. Secondly, what does the aspnet.mdf database get used for and howdo i connect to it? is it a issue with my site not reading anything in my App_data folder? the database is a sql
server 2005 database that I made and restored to, the hosting company says it restored the backup just fine. Please help me this is the last few steps then my site is working. here is my web.config file info:
The ASPNETDB is missing, and that holds the actual members data.
I recomend using two MSSQL databases, the actual connection string should be provided by your host provider.
But this should get you on the right track.
Note the first database is the classifieds database, and the second is the members database.
i have both databases up, and i ran a query on both to create the tables and store procedures. so it displays my site, www.classifieds4u.co.za
however when i try create a new user it takes me to a error page, is tehre something i must still do with the app_data folder or its contents? all i done so far was upload my site from my local machine, create 2 databases on my hosting plans servers, ran
a query on those to create the tables and store procedures, then i changed the connection string to what it is below...is there anything else? like how does it know that the site-config.xml file is in the app_data folder, could that be the issue with trying
to create a new user?
Really you should post the error when that's your issue.
My sample connection string was with godaddy.
So you're will be different.
They may not even use some of the data such as "initial category"
When you create a database on Godaddy, they make it easy.
(Pre-loaded with everything needed for the members database.)
I did have to load one myself once that had an error that I don't remember right off the bat.
But it had something to do with not recognizing what version was running.
I went to your site and I see the error.
requires a database schema compatible with schema version '1'
There is a table named "aspnet_schemaversions"
You can either look on your local version for what to put in but this is basically it.
common 1 1
health monitoring 1 1
membership 1 1
personalization 1 1
profile 1 1
role manager 1 1
Good Luck
Web:www.Detelli.com Please remember to mark the post as answer that solves your issue.
This will be greatly benificial for other users.
po10cy
Member
4 Points
17 Posts
database and connection question
Sep 08, 2009 08:59 AM|LINK
howsit guys i have my own customised starter kit hosted at www.classifieds4u.co.za however its giving issues. Firstly I had to create the database in my hosting control panel and restore my classifiedsdb.mdf to that database, I altered the connection string, however it stilll gives issues and for the life of me i cant figure out why. Secondly, what does the aspnet.mdf database get used for and howdo i connect to it? is it a issue with my site not reading anything in my App_data folder? the database is a sql server 2005 database that I made and restored to, the hosting company says it restored the backup just fine. Please help me this is the last few steps then my site is working. here is my web.config file info:
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<location path="Admin">
<system.web>
<authorization>
<allow roles="Administrators"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
<location path="PostAd.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<location path="EditPhotos.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<location path="MyAds.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<location path="MyProfile.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<system.web>
<customErrors defaultRedirect="Error.aspx" mode="Off"/>
<pages styleSheetTheme="Blue"/>
<authentication mode="Forms" />
<membership>
<providers>
<clear/>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
</providers>
</membership>
<profile enabled="true">
<properties>
<add name="FirstName" type="System.String"/>
<add name="LastName" type="System.String"/>
<add name="MemberId" defaultValue="0" type="System.Int32"/>
<group name="Core"/>
</properties>
</profile>
<roleManager enabled="true"/>
<compilation debug="false"/>
<siteMap defaultProvider="RoleEnabled_AspNetXmlSiteMapProvider" enabled="true">
<providers>
<clear/>
<add name="RoleEnabled_AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>
</providers>
</siteMap>
</system.web>
<connectionStrings>
<add name="classifiedsdb" connectionString="Data Source=196.220.41.171; Database=classifiedsdb.mdf; UID=MYUSERNAME; PWD=MYPASSWORD; Integrated Security=SSPI;" />
</connectionStrings>
<system.net>
<mailSettings>
<smtp>
<network
host="yourSMTPhostname"
port="25"
defaultCredentials="true"
userName="enterUserNameHereIfRequired"
password="enterPasswordIfRequired"
/>
</smtp>
</mailSettings>
</system.net>
</configuration>
<div></div><div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><?xml version="1.0"?></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="Admin"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <allow roles="Administrators"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="*"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="PostAd.aspx"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="?"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="EditPhotos.aspx"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="?"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="MyAds.aspx"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="?"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="MyProfile.aspx"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="?"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <customErrors defaultRedirect="Error.aspx" mode="Off"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <pages styleSheetTheme="Blue"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authentication mode="Forms" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <membership></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <providers></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <clear/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </providers></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </membership></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <profile enabled="true"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <properties></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="FirstName" type="System.String"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="LastName" type="System.String"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="MemberId" defaultValue="0" type="System.Int32"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <group name="Core"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </properties></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </profile></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <roleManager enabled="true"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <compilation debug="false"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <siteMap defaultProvider="RoleEnabled_AspNetXmlSiteMapProvider" enabled="true"></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <providers></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <clear/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="RoleEnabled_AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </providers></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </siteMap></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <connectionStrings></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="classifiedsdb" connectionString="Data Source=196.220.41.171; Database=classifiedsdb.mdf; UID=alr03; PWD=cheeky3653; Integrated Security=SSPI;" /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </connectionStrings></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.net></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <mailSettings></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <smtp></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <network</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> host="yourSMTPhostname"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> port="25"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> defaultCredentials="true"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> userName="enterUserNameHereIfRequired"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> password="enterPasswordIfRequired"</div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> /></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </smtp></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </mailSettings></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.net></div> <div style="position: absolute; left: -10000px; top: 0px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></configuration></div> <div></div>
oidldb
Contributor
2181 Points
419 Posts
Re: database and connection question
Sep 08, 2009 10:08 AM|LINK
Hi,
In your connection string you should use datasource=localhost because the file is stored in the App_Data folder in your website.
Dani
P.S. Please mark as answer if this helps.
po10cy
Member
4 Points
17 Posts
Re: database and connection question
Sep 08, 2009 10:40 AM|LINK
tried that but it wont work, my database is sitting with my hosting company on their servers, not locally on my pc.
darkknight18...
Contributor
2674 Points
1040 Posts
Re: database and connection question
Sep 09, 2009 01:57 AM|LINK
The ASPNETDB is missing, and that holds the actual members data.
I recomend using two MSSQL databases, the actual connection string should be provided by your host provider.
But this should get you on the right track.
Note the first database is the classifieds database, and the second is the members database.
<connectionStrings> <add name="classifiedsConnection" connectionString="Data Source=****************; Initial Catalog=ClassifiedsDB; User ID=****UserId****; Password='*****Password*******';"/> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=*********************; Initial Catalog=MembersDB; User ID=******UserId******; Password='****Password****';"/> </connectionStrings>Good Luck
-Daniel
Please remember to mark the post as answer that solves your issue.
This will be greatly benificial for other users.
po10cy
Member
4 Points
17 Posts
Re: database and connection question
Sep 09, 2009 02:48 PM|LINK
thanks for that help.
i have both databases up, and i ran a query on both to create the tables and store procedures. so it displays my site, www.classifieds4u.co.za
however when i try create a new user it takes me to a error page, is tehre something i must still do with the app_data folder or its contents? all i done so far was upload my site from my local machine, create 2 databases on my hosting plans servers, ran a query on those to create the tables and store procedures, then i changed the connection string to what it is below...is there anything else? like how does it know that the site-config.xml file is in the app_data folder, could that be the issue with trying to create a new user?
here is my web.config file:
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<location path="Admin">
<system.web>
<authorization>
<allow roles="Administrators"/>
<deny users="*"/>
</authorization>
</system.web>
</location>
<location path="PostAd.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<location path="EditPhotos.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<location path="MyAds.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<location path="MyProfile.aspx">
<system.web>
<authorization>
<deny users="?"/>
</authorization>
</system.web>
</location>
<system.web>
<customErrors defaultRedirect="Error.aspx" mode="Off"/>
<pages styleSheetTheme="Blue"/>
<authentication mode="Forms" />
<membership>
<providers>
<clear/>
<add name="AspNetSqlMembershipProvider" type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" passwordStrengthRegularExpression=""/>
</providers>
</membership>
<profile enabled="true">
<properties>
<add name="FirstName" type="System.String"/>
<add name="LastName" type="System.String"/>
<add name="MemberId" defaultValue="0" type="System.Int32"/>
<group name="Core"/>
</properties>
</profile>
<roleManager enabled="true"/>
<compilation debug="false"/>
<siteMap defaultProvider="RoleEnabled_AspNetXmlSiteMapProvider" enabled="true">
<providers>
<clear/>
<add name="RoleEnabled_AspNetXmlSiteMapProvider" type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/>
</providers>
</siteMap>
</system.web>
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="classifiedsConnection" connectionString="Data Source=**DATASOURCE**;
Initial Catalog=classifiedsdb;
User ID=**USERID**;
Password=**PASS**;"/>
<add name="LocalSqlServer" connectionString="Data Source=**DATASOURCE**;
Initial Catalog=aspnetdb;
User ID=**USERID**;
Password=**PASS**;"/>
</connectionStrings>
<system.net>
<mailSettings>
<smtp>
<network
host="yourSMTPhostname"
port="25"
defaultCredentials="true"
userName="enterUserNameHereIfRequired"
password="enterPasswordIfRequired"
/>
</smtp>
</mailSettings>
</system.net>
</configuration>
<div></div>
<div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><?xml version="1.0"?></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="Admin"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <allow roles="Administrators"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="*"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="PostAd.aspx"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="?"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="EditPhotos.aspx"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="?"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="MyAds.aspx"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="?"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <location path="MyProfile.aspx"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <deny users="?"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </authorization></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </location></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <customErrors defaultRedirect="Error.aspx" mode="Off"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <pages styleSheetTheme="Blue"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <authentication mode="Forms" /></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <membership></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <providers></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <clear/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="AspNetSqlMembershipProvider" </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">type="System.Web.Security.SqlMembershipProvider, System.Web, Version=2.0.0.0, Culture=neutral, </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">PublicKeyToken=b03f5f7f11d50a3a" connectionStringName="LocalSqlServer" enablePasswordRetrieval="false" </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">enablePasswordReset="true" requiresQuestionAndAnswer="true" applicationName="/" </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">requiresUniqueEmail="true" passwordFormat="Hashed" maxInvalidPasswordAttempts="5" </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">minRequiredPasswordLength="6" minRequiredNonalphanumericCharacters="0" passwordAttemptWindow="10" </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">passwordStrengthRegularExpression=""/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </providers></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </membership></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <profile enabled="true"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <properties></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="FirstName" type="System.String"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="LastName" type="System.String"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="MemberId" defaultValue="0" type="System.Int32"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <group name="Core"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </properties></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </profile></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <roleManager enabled="true"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <compilation debug="false"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <siteMap defaultProvider="RoleEnabled_AspNetXmlSiteMapProvider" enabled="true"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <providers></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <clear/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="RoleEnabled_AspNetXmlSiteMapProvider" </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">type="System.Web.XmlSiteMapProvider, System.Web, Version=2.0.3600.0, Culture=neutral, </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste">PublicKeyToken=b03f5f7f11d50a3a" siteMapFile="web.sitemap" securityTrimmingEnabled="true"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </providers></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </siteMap></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.web></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <connectionStrings></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><remove name="LocalSqlServer"/></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <add name="classifiedsConnection" connectionString="Data Source=sql6.glodns.net,1444; </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Initial Catalog=classifiedsdb; </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> User ID=2alr03; </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Password=cheeky3653;"/> </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"><add name="LocalSqlServer" connectionString="Data Source=sql6.glodns.net,1444; </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Initial Catalog=aspnetdb; </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> User ID=alr03; </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> Password=cheeky3653;"/> </div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </connectionStrings></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <system.net></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <mailSettings></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <smtp></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> <network</div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> host="yourSMTPhostname"</div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> port="25"</div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> defaultCredentials="true"</div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> userName="enterUserNameHereIfRequired"</div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> password="enterPasswordIfRequired"</div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> /></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </smtp></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </mailSettings></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"> </system.net></div> <div style="position: absolute; left: -10000px; top: 55px; width: 1px; height: 1px; overflow-x: hidden; overflow-y: hidden;" id="_mcePaste"></configuration></div> <div></div>darkknight18...
Contributor
2674 Points
1040 Posts
Re: database and connection question
Sep 10, 2009 01:36 AM|LINK
Really you should post the error when that's your issue.
My sample connection string was with godaddy.
So you're will be different.
They may not even use some of the data such as "initial category"
When you create a database on Godaddy, they make it easy.
(Pre-loaded with everything needed for the members database.)
I did have to load one myself once that had an error that I don't remember right off the bat.
But it had something to do with not recognizing what version was running.
I went to your site and I see the error.
requires a database schema compatible with schema version '1'
There is a table named "aspnet_schemaversions"
You can either look on your local version for what to put in but this is basically it.
common 1 1
health monitoring 1 1
membership 1 1
personalization 1 1
profile 1 1
role manager 1 1
Good Luck
Please remember to mark the post as answer that solves your issue.
This will be greatly benificial for other users.