installation failed wrong password

Posted: March 22, 2013 at 1:50 PM Quote #92390
Hello

I tried to install microsoft web developer with their web platform installer.  It downloaded nopcommerce but I got a message that it didn't install it.  Prior to that I got a message that I had the wrong password for user sa.  I don't know who sa is.  I think the error was for some sql program it was installing.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: March 22, 2013 at 3:18 PM Quote #92399
Hi gamalpha,
When someone tries to connect with SQL Server he first needs to prove that his account is authorized to connect. This process is called "Authentication". Once authentication is done, SQL Server allows that account to conduct business according to his "Server Role", i.e. the permission associated with that account.

SQL Server accepts two types of authentications: (1) Windows Authentication and (2) SQL Server Authentication.

For "SQL Server Authentication" you have two options: (1) Either the SQL Server Administrator creates an account/login in SQL Server and assigns certain "Server Roles/permissions" to that account. (2) or if there is no such account then you can use SQL Server's built-in account "SA" or "sa". The account name "sa" is short for "System Administrator" and it has built-in Server Role/permissions of "sysadmin".

If you do not know the password for the account/user "sa" then please contact your server administrator for the password.

If you need any further assistance, please let this community know.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: March 22, 2013 at 4:31 PM Quote #92401
I was installing everything on my laptop.  There is no system administrator other than me.  Do I have to set up sql server with passwords?  I'm a beginner and never have used sql server.
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: March 22, 2013 at 4:32 PM Quote #92402
Did the problem with sql server create the problem with nopcommerce?
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: March 28, 2013 at 11:43 AM Quote #92846
nopCommerce gives you the following two options for creating database:

1. Use built-in data storage (SQL Server Compact)  
2. Use SQL Server (or SQL Express) database [Recommended]

It appears that you are selecting the second option but either SQL Server is not installed on your machine or you are not providing the correct "SA" password.

I would suggest you to select the first option to let nopCommerce install its built-in Compact SQL Server. I hope it will resolve the issue.
This post/answer is useful
1
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: March 28, 2013 at 12:30 PM Quote #92850
The first option wasn't listed

1. Use built-in data storage (SQL Server Compact)
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Posted: June 13, 2018 at 7:41 PM Quote #205711
i have the same problem, i don't have option 1. Use built-in data storage (SQL Server Compact) to be selected
This post/answer is useful
0
This post/answer is not useful

Please login or register
to vote for this post.

(click on this box to dismiss)
Premium support services
  • Dedicated premium support services provided by core developers are intended for persons who run mission critical websites, work on projects with tight deadlines, or want to get dedicated support.
Professional services
  • Want to open a new store? Want to take your store to the next level? Need a custom extension? We can customize nopCommerce to fit your store perfectly. Request a quote to get started.
eCommerce CONFERENCE 2018
Learn more