Full error message

The 'MyAssistant' connection information provided is invalid. Verify that the information submitted is valid. SQL Error Message: Login failed for user 'MyAssistant'.

• You don't have the SQL Server Authentication Mode set to mixed SQL Server and Windows Authentication mode
• Your password doesn't match your network's complexity requirements

[BCB:4:Operating system warning:ECB] 

Change the authentication mode

Change authentication in Microsoft SQL Server Management Studio

1. Go to Start, All Programs, Microsoft SQL Server [version], SQL Server Management Studio.
2. Connect to the database engine with the Server name: [Server]\ISD.
3. In the Object Explorer, right-click on the database engine and select Properties.
4. Go to Security in the Select a page pane.
5. Verify you have SQL Server and Windows Authentication mode selected. Change it if needed.

Change authentication in the Windows Registry

As an alternative to installing Microsoft SQL Server Studio you can edit the Windows registry.

1. Stop the SQL Server (ISD) service.
2. Browse to HKLM\Software\Microsoft\Microsoft SQL Server\MSSQL10_50.ISD\MSSQLServer.
3. Change the value for LoginMode from 1 to 2.
4. Start the SQL Server (ISD) service.

Update your MyAssistant password

Check if the password meets the password policy options for complexity and enforcement requirement.

1. Go to Start, All Programs, Microsoft SQL Server [version], SQL Server Management Studio.
2. Connect to the database engine with the Server name: [Server]\ISD.
3. In the Object Explorer, expand the database engine.
4. Open Security and Logins.
5. Right-click on MyAssistant, and select Properties.
6. Click Ok.
7. Consult with your SQL and Network Administrator to update policies, if needed.

Troubleshoot SQL connectivity issues during MyAssistant setup.

Sage MyAssistant and MyCommunicator antivirus and firewall exceptions