CM4D can use Windows and/or SQL Authentication when connecting to a SQL Server database, depending on your network policies. Outlined below is a procedure that creates a SQL login account to be used for SQL Server Authentication.
1. Right-click on Security > Logins.
2. Select New Login... from the context menu.
a. Enter a Login name (e.g., cm4duser)
b. Select SQL Server authentication.
c. Enter a secure Password.
d. Confirm password.
e. Clear the Enforce password expiration check box.
f. For the Default database, select your new Site database (or CM4D database if you are not using a Site).
g. Select User Mapping.
h. Check the boxes next to your CM4D Site database, CM4D database(s) and the Results database.
i. For each of your databases, set the Database role membership to 'public' and 'db_owner'.
j. Click OK.
Use the login (cm4duser) you just created when connecting to any databases used by CM4D that require SQL Authentication.