I am very new to nopCommerce and SQL, it might sound stupid but on page 2 of the install it asks about the SQL server, now which one do i check, the 'use server account' or 'Use integrated Windows authentication (ASP.NET account: NT AUTHORITY\NETWORK SERVICE)'
Hi, I had no problem installing v1.6 with XP and SQL2005. Last week I have decided to use better machine with Windows 7 and SQL2008 Express and now I am in a truble. Version1.9 ( or may be the new SQL2008 Express) is just driving me creasy. When I try to install the DB in step 3 (nopCommerce installation) I have the following message: "An error occured when creating database: CREATE DATABASE permission denied in database 'master'. Creating a new database nop_db"
Even if I try to create the DB manually with SQL Server Managment Studio and point to emptyDB in the installation menu in nopCommerce I have: "An error occured: Cannot open database "nop_db" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\LOCAL SERVICE'."
When I created the db (nop_db) manually I have used the following settings: name: NT AUTHORITY Login name: NT AUTHORITY/SYSTEM Default shema:db_owner database role membership: I have ticked DB_OWNER
What I am doing wrong ? Can you help? I am sorry I am not very good at SQL.
Hi, I had no problem installing v1.6 with XP and SQL2005. Last week I have decided to use better machine with Windows 7 and SQL2008 Express and now I am in a truble. Version1.9 ( or may be the new SQL2008 Express) is just driving me creasy. When I try to install the DB in step 3 (nopCommerce installation) I have the following message: "An error occured when creating database: CREATE DATABASE permission denied in database 'master'. Creating a new database nop_db"
Even if I try to create the DB manually with SQL Server Managment Studio and point to emptyDB in the installation menu in nopCommerce I have: "An error occured: Cannot open database "nop_db" requested by the login. The login failed. Login failed for user 'NT AUTHORITY\LOCAL SERVICE'."
When I created the db (nop_db) manually I have used the following settings: name: NT AUTHORITY Login name: NT AUTHORITY/SYSTEM Default shema:db_owner database role membership: I have ticked DB_OWNER
What I am doing wrong ? Can you help? I am sorry I am not very good at SQL.
Thanks in advance Vivi
You can't create database and getting that error message because you don't have permission to create database.
HI abcd_12345, Thank you for the help. Sorry for not explaining well. By 'manually creating' the db I mean using SQL Server Managment Studio. I can see it is there. However, when I am selecting 'use an existing db' (pointing to already created with SQL Server Managment Studio db) in the nopCommerce instalation the second message above appeared. Regards Thank you for the links - I will check them now
Garrie, Can you please post some steps. I still have problem accessing the DB from nopCommerce installation panel. If I have to create the DB with SQL Server Managment studio and use an empty db option in the install panel in nopCommerce, Is there any differences in the permission I have to set for SQL 2005 and SQL 2008 Express. How to set the permission for SQL 2008 Expres? Rgds Vejen
Well, finally I have this running. After spending in agony few days and with only break for few hours on a Christamas day to deliver the presents to the children. Finally on 1 Jan Father Christmas came for me. I need to go back now and provide good instructions to avoid someone else to get to this situation. Actually I was cople of times on the edge to abandon nopCommerce due to installation problems. What I will suggest is a document with proper instructions published on the main web cite. I am not SQL specialist and this was long learning curve for me. This will boost the public interest and certainly will attract more people to use nopCommerce. ( I am dowing research for good e-commerce solution (middle size e-commerce) for few months and I think nopCommerce is very good: Very well structured code, community with active forums, it is using latest development environment with features well ahaid the other e-commerce solutions, but I was nearly ready to leave due to installation issues. Regards Vejen
Thank you Garry. much appreciated. Below is my story.
These are instructions of how to install nopCommerce v1.9 on machine with Windows7 and SQL Express 2008. I assume you have .NET4 installed with VS2010 and iis enabled in windows. 1) Download version 1.9 from nopCommerce server 2) Unzip and copy the content in wwwroot\your-directory 3) Go in IIS and open the default web sites- ‘your-directory’ must be there 4) Right click on it ->Security->Select IIS_IUSERS(‘your_pc’\IIS_IUSRS)->edit the permission and give full permission ( tick all options)->OK . 5) Restart IIS 6) In IIS, Open the Application Pools. Right click on the Pool which runs the applications (the number of application running under the pool is stated in each rows next to the pool name on the right side) and change the pool to run under the .NET4 (in my case was .NET2 – default). WRITE somewhere the name of the pool. It will become handy latter. 7) Restart IIS and exit. 8) OK now you need database. But to allow the database to be assessable from the pool thread you need the name of the pool. 9) Open SQL Server Management studio-> When you open memorise the name of the server and make sure you access it using Windows Authentication method. 10) Right Click on databases and create new database. ‘my_db’ for example. 11) Now in the Explorer Windows in SQL Management Studio you will see the following :Databases ,Security, Server Objects, Replication, Management. Open Security and create Login with name : IIS APPPOOL\’your-pool’. Notice!, bellow the’Default DB’ parameter is master. This is the Security Menu under databases not under ‘your-db’. 12) Create also Login: NT AUTHORITY\SYSTEM if it is not already listed 13) Now go on Security menu under ‘your-db’ and add User name: NT AUTHORITY and select Login name IIS APPPOOL\’your-pool’. It must be listed in the drop down menu if you completed correctly 11). 14) Select ‘db_owner’ under role membership.->OK 15) With all this you are ready to start nopCommerce. Go to http://localhost/’your-directory’ and you must see the installation screen. 16) Step 1) if you have message that your APPPool can not access the directory of your web site check 4). You will not be able to install nopCommerce since the APPPOOL will not be able to do any changes in ‘your-directory’. The installation menu will allow you to go further and will say it is not an ERROR. Well, you can go to step 2 but this will be dead end since the Apppool will not be able to write the settings in ‘your-directory’ 17) In the database menu you have to select: ‘.\your-database’ (.\SQLEXPRESS in my case) 18) Connection method ‘Windows Authentication’ because it is on your local machine 19) Database -> select use empty database and type ‘your-db’ in the field 20) This should allow you to complete the installation menu with no problem. If you have database error you have to check again is you APPPool is accessing your database. ( Check the security settings! Look for user : NT AUTHORITY settings). 21) Enjoy.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.