an ASP.NET Open Source CMS & eCommerce platform
Search:
Last Post 8/26/2010 10:15:38 AM By lukezy. 5 replies.
8/22/2010 3:05:27 AM
TAhmad
Posts: 46
Joined: 1/12/2010
login not successful
Dear Luky,
 
I'm using dotshoppingcart v4.1.
 
We are deploying the system at hosting server and at the beggining of the CMD command installation we receive a message that says "create database permission denied in database 'master'." the CreateDB.sql file uses a user "<font color="#ff0000" size="2"><font color="#ff0000" size="2">NT AUTHORITY\NETWORK SERVICE". can I use "sa" user instead of the existing one?
 
I create the data base manually, without using CMD command, and I configured the site on IIS; but when I log in by using user: admin and password: admin I recieve the following "Your login attempt was not successful. Please try again", please advice.
 
Regards,
Tariq
8/23/2010 12:02:35 PM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: login not successful
You don't want to use "sa" due to security reason. You want to use the least privilege account. That's why we set up database to use "NT AUTHORITY\NETWORK SERVICE".
 
When you run the InstDSC.exe make sure the current logged in user has the permission to create database.
DotShoppingCart Staff
8/24/2010 3:09:46 AM
TAhmad
Posts: 46
Joined: 1/12/2010
Re: login not successful
What can I do to install InstDSC.exe without a permission interruption ?
8/25/2010 9:07:02 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: login not successful
The current logged in account who will will running InstDSC.exe must have the permission to create database. It's probably database server sysadmin. You can verify the permission by using SQL management studio and connect to the database server and then try to create a database manually.
DotShoppingCart Staff
8/26/2010 1:01:35 AM
TAhmad
Posts: 46
Joined: 1/12/2010
Re: login not successful
I can create database manually, but running InstDSC.exe will show me this message "create database permission denied in database master".
8/26/2010 10:15:38 AM
lukezy
Posts: 2109
Joined: 6/12/2007
Location:WA, US
Re: login not successful
Did you open up "Administrator" cmd window?
 
If you are running on Vista or Windows 2008 server OS, make sure you open command window (right click) run as administrator to get enough permission for the following steps.
DotShoppingCart Staff