Hi Melanie,
Yes, you've posted properly. Welcome to the community :)
There are a few reasons why this would occur:
1) The servername in the domain table is something other than the machine name (such as an alias). Ensure that the servername field in the domain table is populated with the actual machine name.
2) The E8 user account is getting locked out. In SQL Server Management Studio, right click on the E8 user and open Properties. On the General tab, ensure that the "Enfor Password Policy" option is Unchecked. On the status tab, ensure that the login is not disabled.
3) Another option that is similar to the steps in the original reply is the following:
a) Make sure all users are logged out of SL
b) Log in to SQL Management Studio and expand the 'Logins' folder in the Object Explorer pane. Please find the E8F575915A2E4897A517779C0DD7CE login and right-click on it and delete it.
c) Expand on any databases that are experiencing the error and expand on the Security folder. Expand Users, and if any E8 user exists right click and delete it.
d) Ensure you have a good backup of your databases and run the following statement against the system database:
delete from Domain where Description = 'report user password'
e) Open up SL's Database Maintenance screen, enter in the SQL server name, and connect using the SQL sa login/password.
f) In the Update Databases tab, select your SL app and system db's, then select the 'Synchronize All Ownership and Security' scenario.
g) Click on the Update Database button.
h) Once the process has completed, see if the issues still exist.
Hopefully one of these suggestions will work for you!
