Last post Nov 04, 2008 08:41 AM by berndt
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!!!!!
Oct 04, 2008 07:13 AM|jeremyh|LINK
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 ?)
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.
Oct 24, 2008 12:13 PM|Deucallion|LINK
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!
Nov 03, 2008 11:29 AM|berndt|LINK
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.
Nov 03, 2008 12:03 PM|jeremyh|LINK
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 @
Nov 04, 2008 08:41 AM|berndt|LINK
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.
connectionString="Data Source=the hostsIPHere;Initial
Catalog=aspnetdb_01;Persist Security Info=True;User ID=aspnetdb_01_admin;Password=PutYourPaswordHere;User Instance=False"
connectionString="Data Source=the hostsIPHere;Initial Catalog=personal_01;Persist Security Info=True;User ID=personal_01_admin;Password=PutYourPaswordHere;User
Now everything works fine