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.
installation failed wrong password
- 2
- 20
- 3/22/2013
- United States
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.
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.
- 2
- 20
- 3/22/2013
- United States
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.
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.
