A new Commerce SQL Database is created during the Commerce Service Setup.
The setup creates the SQL Server login CommerceUser with password CommerceUser, and grants this user data reader and data writer privileges in the Commerce database.
If you have a problem logging in with this CommerceUser, you can configure the SQL Server with SQL Server Authentication disabled. The setup will display a warning, but allow the setup to continue. If the SQL Server and Windows Authentication mode option is not enabled, you cannot use the CommerceUser.
To enable this option:
- Open the SQL Management Studio.
- Open the Server Properties.
- Restart, see images below:
The SQL Server connection string is stored in: C:\LS Retail\Commerce\CommerceService\AppSettings.config
Note: In production, you can change this connection string to use Windows Authentication or any other SQL Server login/password.
For Commerce Service setup with LS Central SQL access
CommerceUser must also have read access to LS Central Database as Commerce will access LS Central database to pull some data from it.
Note: In a testing and demo environment, you can give the CommerceUser sysadmin access to bypass all restrictions. Do not do this in a production environment.