iMonnit Enterprise - Enabling Mixed Mode Authentication on a SQL Server

iMonnit Enterprise requires your SQL Server to operate with Mixed Mode Authentication. You can adjust this in your SQL Server with the following steps.
Note: As SQL Server is a software supported by another company (Microsoft), any issues you encounter following these steps should be referred to the party that supports your SQL Server installation.

  • Launch SSMS (SQL Server Management Studio)
  • Log into your server
  • Right click the SQL Server in the Object Explorer (this is usually the top level item)
  • Select Properties
    SQL Server Properties
    View Full Size
  • Select Security
  • In the Server Authentication section, select the radial for “SQL Server and Windows Authentication Mode”
  • Select OK
    Mixed Mode Authentication
    View Full Size

If your server does not automatically restart, select the SQL Server in the Object Explorer, and select Restart. Upon restarting, your server will support both Windows and SQL Authentication.


Call today for live expert advice & save 10% on your first order!


Or enter your phone number or email and we'll contact you.