Page 2 on installastion problem

Hi,


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)'

Thanks.

Garrie

Hi Garrie ,

If you are installing nopCommerce on your server then you have to enter credentials (username and password) to access server.

If you are trying to install nopCommerce on your local machine then you have to select "Windows Authentication"

Here are the steps to install nopCommerce on your local machine: http://www.strivingprogrammers.com/boards/t/136/how-to-install-and-confirgure-nopcommerce-to-run-on-local-machine-.aspx

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

Vejen wrote:

You can't create database and getting that error message because you don't have permission to create database.

Take a look at these threads:

https://www.nopcommerce.com/boards/t/806/installation-error-database-permission.aspx

https://www.nopcommerce.com/boards/t/2183/cant-setup-database-sql-on-sql-server-2008.aspx

https://www.nopcommerce.com/boards/t/7579/sql-error.aspx

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

Hi,

Thank you very much for the reply, that has done the trick and is now up and running.

Garrie

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

Hi,

The steps i done for my install as mine is a local server which has IIS6 running,

screen 1 asks to install nopC or upgrade, install.

screen 2 asks for your login credentialson to your server then you have to enter (username and password) to access the remote server

or

If you are installing nopCommerce on your local machine then you select "Windows Authentication" (which i did)

screen 3 asks about database and i selected the bottom one where nop creates the db for you.

and that was it all setup and i am now just intergrating the checkouts and going through the admin section getting to know it.

hope this helps

Garrie.

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.