Checking the server authentication mode

For Earnie IQ to operate correctly, the authentication mode of the SQL Server must be “Mixed Mode”. This is normally set during SQL Server installation but may be changed later.

To check the authentication mode:

  1. Open Enterprise Manager or SQL Server Management Studio.

  2. Expand the SQL Server group containing the Earnie IQ SQL Server.

  3. Right click on the Earnie IQ SQL Server and select Properties.

  4. In the Properties dialog, open the Security tab.

  5. Under Authentication, ensure that SQL Server and Windows is selected.

    Setting Service Startup Accounts

    The following instructions may vary depending on which version of Windows is in use.

    To set the start-up properties for the two services:

    From the Services console (usually found in Control Panel | Administrative Tools), locate the MS SQL Server service. The name of the service will be MSSQLSERVER on SQL Server 2000 or SQL Server on SQL Server 2005, 2008 or 2012 for default instances or MSSQL$<Instance Name> on SQL Server 2000 or SQL Server (<Instance Name>) on SQL Server 2005/2008 for non-default instances.

  6. Right-click on the service and select ‘Properties’

  7. Select the ‘Log On’ tab as shown

  8. Ensure that This account is selected then enter the account details for the account to be used. If the service is already using an account you should ensure that the account is appropriate for requirements.

  9. Return to the General tab and ensure that the Startup type is set to Automatic

  10. Click ‘OK’

    Repeat Steps 1 to 6 for the SQL Server agent service (SQLAGENT on SQL Server 2000 or SQL Server Agent on SQL Server 2005/2008)

    Note: If the instance of SQL Server is not the default instance then the services will be MSSQL$<Instance Name> and SQLAGENT$<Instance Name> on SQL Server 2000 and SQL Server (<Instance Name>) and SQL Server Agent (<Instance Name>) on SQL Server 2005/2008/2012.