A new LS Commerce SQL Database is created during the LS Commerce Service Setup.
The setup creates the SQL Server login LSCommerceUser with password LSCommerceUser, and grants this user data reader and data writer privileges in the LSCommerce database.
If you have a problem logging in with this LSCommerceUser, 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 LSCommerceUser.
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\LSCommerce\LSCommerceService\AppSettings.config
Note: In production, you can change this connection string to use Windows Authentication or any other SQL Server login/password.
For LS Commerce Service setup with LS Central SQL access
LSCommerceUser must also have read access to LS Central Database as LS Commerce will access LS Central database to pull some data from it.
Note: In a testing and demo environment, you can give the LSCommerceUser sysadmin access to bypass all restrictions. Do not do this in a production environment.