Trying to setup NopCommerce 3.1 on GoDaddy and getting error message Setup failed: An error occurred while creating the database: CREATE DATABASE permission denied in database 'master'.
I realize this is probably a host issue which is why I called them and spent over a hour on the phone which ended with them telling me that I wouldn't be able to create the database through the wizard. I have found online some scripts to create the 2.0 database but I fear there may be many changes to the database and as such that may cause problems. Is there anyway to get the database scripts so I can create the 3.1 database or do I need to try to start this fight with GoDaddy all over again.
Richard
NopCommerce 3.1 and GoDaddy
- 1390
- 11685
- 8/10/2012
- United States
It is a permissions issue that you can't get around...they will not allow you to set IUSR/Modify permissions on the web.config file in the site root, so it doesn't complete installation... or if you don't create an empty SQL server database first, you'll see the same error you posted. IUSR cannot be configured to have permissions to create a new SQL server database so you have to go into the database admin area at godaddy and manually create an empty SQL server database to use.
I got 3.10 working on godaddy economy hosting by doing the following:
Create a new directory in your godaddy site and move all the nopcommerce files into it, then set it with very loose permissions on it and all of it's children . Then, after you visit it in a browser and install it, it will work. But after completion of installation, you need to move the entire contents of the directory back to the root and adjust the folder permissions accordingly.
Oh..and FYI...most installation errors you see at godaddy during install occur AFTER the database has already been created/written to...so, since the economy plan at godaddy only allows 1 SQL server database, you'll have to go delete the database you(or the script initially tried and failed) created from the godaddy SQL server database admin area, and create it again..as an empty database. Then input it's connectionstring info into the nopcommerce installation screen and choose to use existing database..that way it doesn't have to "create"..it just "inserts into"...I chose to use sample data because it gives examples to my client.
You just have to understand that the nopcommerce installation cannot work correctly because of godaddy's internal configs, but you can work around it. The installation cannot write to the web.config in the root of a site like it needs to, and it cannot create a database like it needs to...but the installation script will correctly create all the tables and queries if you install it into an empty/structure-less database...and you can successfully run the installation script from a subfolder on your site with relaxed permissions.
I got 3.10 working on godaddy economy hosting by doing the following:
Create a new directory in your godaddy site and move all the nopcommerce files into it, then set it with very loose permissions on it and all of it's children . Then, after you visit it in a browser and install it, it will work. But after completion of installation, you need to move the entire contents of the directory back to the root and adjust the folder permissions accordingly.
Oh..and FYI...most installation errors you see at godaddy during install occur AFTER the database has already been created/written to...so, since the economy plan at godaddy only allows 1 SQL server database, you'll have to go delete the database you(or the script initially tried and failed) created from the godaddy SQL server database admin area, and create it again..as an empty database. Then input it's connectionstring info into the nopcommerce installation screen and choose to use existing database..that way it doesn't have to "create"..it just "inserts into"...I chose to use sample data because it gives examples to my client.
You just have to understand that the nopcommerce installation cannot work correctly because of godaddy's internal configs, but you can work around it. The installation cannot write to the web.config in the root of a site like it needs to, and it cannot create a database like it needs to...but the installation script will correctly create all the tables and queries if you install it into an empty/structure-less database...and you can successfully run the installation script from a subfolder on your site with relaxed permissions.
MVP
- 11320
- 100942
- 5/22/2011
- United States
(It's been a while since I worked with GoDaddy, but ...)
You can create multiple web sites. Check their plans - E.g. Deluxe has unlimited web sites, but only 2 SQL Server DBs. Each nopC site requries own DB.
The instructions above look accurate - due to folder permission issues on their hosting, you need to initially create the site in a sub folder and move it
You can create multiple web sites. Check their plans - E.g. Deluxe has unlimited web sites, but only 2 SQL Server DBs. Each nopC site requries own DB.
The instructions above look accurate - due to folder permission issues on their hosting, you need to initially create the site in a sub folder and move it