Even though the event viewer is showing an error, the synchronization is still running as long as scheduled synchronization is set up.

The error is related to the configuration of the SQL server. If you are using mixed mode authentication, you can detach and reattach the database to remove the error from the event viewer.