Im still struggling to get past the db error(26). I have done the following...
-Made changes to site (text ect.)
-Ran the publish db wizard and created the two .sql scripts
-logged into my server 2003 box and created a new database websiteDB
-Ran the two aformentioned db scripts
-Copied the website into my server's wwwroot folder
Any ideas? If anyone has gotten this to work could you please share how you did it, and maybe a template of your connection strings section in web.config. Obviously ommitting the specifics haha. Thanks!!!!!
Regards
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
I successfully installed this kit through my host at Discountasp.net and can probably help you as well. Can you please post what errors you're receiving and what your environment looks like (i.e. is it a local IIS or a hosted server).
Discountasp does not support sql express database so you would need to upsize/move your sql express database to their hosted sql 2005 or 2008 database
and then you will need to update the connectionString within your web.config to point to the hosted sql database.
However, you can use the SQL 2005 Attach tool in control panel to attach a SQL Express database to our SQL 2005 database with discountasp.
Regards
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
I solved the problem. I renamed the aspnetdb.mdf to aspnetdb_01.mdf and the personal.mdf to personal_01.
Then I atached them in SQL server Management studio Express and made a backup on the local machine of each file and FTPed the backup files to the server.
I created 2 new empty databases with Plesk on the server, aspnetdb_01.mdf and personal_01.mdf on the server.
The the supportpersonal for the server helped me to read in the backup of these two files and atach them with the following connectionstings in the web.config file.
None
0 Points
23 Posts
Did you successfully deploy the Starter kit on your own server?
Oct 02, 2008 10:36 AM|drabbag|LINK
Im still struggling to get past the db error(26). I have done the following...
-Made changes to site (text ect.)
-Ran the publish db wizard and created the two .sql scripts
-logged into my server 2003 box and created a new database websiteDB
-Ran the two aformentioned db scripts
-Copied the website into my server's wwwroot folder
Any ideas? If anyone has gotten this to work could you please share how you did it, and maybe a template of your connection strings section in web.config. Obviously ommitting the specifics haha. Thanks!!!!!
Chris
Contributor
5190 Points
1469 Posts
Re: Did you successfully deploy the Starter kit on your own server?
Oct 04, 2008 07:13 AM|jeremyh|LINK
Hello Chris,
You do not tell us how you are hosting this site, hosting company or a local server?
I would check out if the default iis user has access to the database (Is this sql express or sql 2005 ?)
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=395
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=287
And for the connectionstring take a look at http://www.connectionstrings.com/ or I have a commented
connectionstring at http://www.jasminedesign.com/webconfig.aspx that will show you the settings that you need.
Let us know how you get on.
Hope it helps, good luck.
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
None
0 Points
2 Posts
Re: Did you successfully deploy the Starter kit on your own server?
Oct 24, 2008 12:13 PM|Deucallion|LINK
Hi Chris,
I successfully installed this kit through my host at Discountasp.net and can probably help you as well. Can you please post what errors you're receiving and what your environment looks like (i.e. is it a local IIS or a hosted server).
Thanks and good luck!
Deuce
Member
3 Points
15 Posts
Re: Did you successfully deploy the Starter kit on your own server?
Nov 03, 2008 11:29 AM|berndt|LINK
Hi Deuce
Can you tell me about your successfull installation at Discountasp.net?
Does the ASPNETDB.MDF work as is, or did you rename that file?
My ISP tells med that I must use a different filename for ASPNETDB.MDF for every Personell site.
tell me please how you installed the site.
regards Berndt
Contributor
5190 Points
1469 Posts
Re: Did you successfully deploy the Starter kit on your own server?
Nov 03, 2008 12:03 PM|jeremyh|LINK
Hello Berndt,
Discountasp does not support sql express database so you would need to upsize/move your sql express database to their hosted sql 2005 or 2008 database
and then you will need to update the connectionString within your web.config to point to the hosted sql database.
However, you can use the SQL 2005 Attach tool in control panel to attach a SQL Express database to our SQL 2005 database with discountasp.
Hope it helps, lots more info @ http://kb.discountasp.net/default.aspx
Good luck
Jeremy
If this has helped Please: Don't forget to click "Mark as Answer" on the post that helped you.
That way future readers will know which post solved your issue.
Member
3 Points
15 Posts
Re: Did you successfully deploy the Starter kit on your own server?
Nov 04, 2008 08:41 AM|berndt|LINK
Hello again
Thanks for your help.
I solved the problem. I renamed the aspnetdb.mdf to aspnetdb_01.mdf and the personal.mdf to personal_01.
Then I atached them in SQL server Management studio Express and made a backup on the local machine of each file and FTPed the backup files to the server.
I created 2 new empty databases with Plesk on the server, aspnetdb_01.mdf and personal_01.mdf on the server.
The the supportpersonal for the server helped me to read in the backup of these two files and atach them with the following connectionstings in the web.config file.
<connectionStrings>
<remove name="LocalSqlServer" />
<add name="LocalSqlServer" connectionString="Data Source=the hostsIPHere;Initial Catalog=aspnetdb_01;Persist Security Info=True;User ID=aspnetdb_01_admin;Password=PutYourPaswordHere;User Instance=False"
providerName="System.Data.SqlClient" />
<add name="Personal" connectionString="Data Source=the hostsIPHere;Initial Catalog=personal_01;Persist Security Info=True;User ID=personal_01_admin;Password=PutYourPaswordHere;User Instance=False"
providerName="System.Data.SqlClient" />
</connectionStrings>
Now everything works fine
regards Berndt