STEP 1:  [sqlmode.vbs]

Download sqlmode.vbs from the link below to change which authentication mode you are currently using.

http://www.smartmax.com/download/Tools/MailMax%205.5/SQLMode.vbs

Since you are currently using NT Authentication, you need to run "sqlmode mixed" to switch to SQL Authentication. Once you have done this, you need to go to Step 2.


Examples of usage:

IMPORTANT! This file MUST be run from a command prompt.

Parameter Options: 1)status 2)mixed (3)nt

NOTE: "Mixed Mode" is another name for SQL Authentication

sqlmode status
This displays what authentication mode you are currently using.
Result: "Current Authentication Status: "X" Authentication Mode

sqlmode mixed
This changes your type of authentication to Mixed Mode.
Result: "Successfully changed to Mixed Mode Authentication (Previously set to "X" Authentication Mode)

sqlmode nt
This changes your type of authentication to NT Mode.
Result: "Successfully changed to NT Mode Authentication (Previously set to "X" Authentication Mode)

IMPORTANT: You will need restart the MSSQL$MAILMAX5 Service for the change to take place.

NOTE: If you would like script responses to appear in the console instead of pop up windows, please use the cscript command.

Example: cscript sqlmode.vbs nt

STEP 2:  [sqluser.vbs]
Once you have your authentication set to Mixed Mode (SQL Authentication), you need to setup a SQL username and password to login. Download sqluser.vbs from the link below.

http://www.smartmax.com/download/Tools/MailMax%205.5/SQLUser.vbs


Examples of usage:

IMPORTANT! This file MUST be run from a command prompt.

Parameter Options: 1)add 2)remove 3)changepass

sqluser add (ex. sqluser add useraccount password)
Result: "Successfully added user "mike" with password of "mynewpassword" to SQL Server.

sqluser remove (ex. sqluser remove useraccount)
Result: "Successfully removed user "mike" from the SQL Server.

sqluser changepass (ex. sqluser changepass useraccount oldpassword newpassword)
Result: "Successfully changed password for user 'mike' from 'password' to 'newpassword' in the SQL Server.

---------------------------------------
NOTE: If you would like script responses to appear in the console instead of pop up windows, please use the cscript command.

Example: cscript sqluser.vbs remove mike

Once you have created your SQL username and password, go to your Services Control Panel and RESTART the MSSQL$MAILMAX5 Service.

Finally, you will need to edit config.aspx and enter the information in the SQL Authentication fields.
-------------------------------
An alternative to using SQL Authentication is using Windows Authentication. Simply open the MailMax Admin Tool and go to Edit/Local Settings/the Database Tab and make sure 'Use SQL Authentication' is NOT checked. Then edit config.aspx to use NT Authentication.