1.3* – Does Express Maintenance use the Windows Login account or require its own login account to the SQL Server?

Article sections

    Enable or Disable the Windows login feature

    Answer:

    User Accounts are setup in Express Maintenance under Administration / User Accounts.  In that screen the administrator can assign None, Read Only, Write and Full levels of permission to different areas of the program per user account.

    By default, Express Maintenance when executed will not use the Windows login account.  However, you can change this behavior and cause Express Maintenance to use the Windows login account.  In this case, if the Windows login account matches an account in the Express Maintenance user accounts it will proceed to automatically login that user without prompting for a login or password.  This is convenient and prevents the user from having to re-login to Express Maintenance when their permissions are handled by the Windows operating system.

    However, this feature can present a problem if several users are using the same computer and the same Windows login account on that computer.  It can also present a problem if a user uses multiple login accounts in Express Maintenance for example to access different sites or databases.  Therefore the automatic feature should be turned on or off as desired.

    To turn on or off the use of automatic Windows login simply edit the ExpressMaintenance.ini file which resides in the folder with Maintenance.exe.  To turn the feature off, simply add the line “UseWindowsLogin=No”.  to turn it on, simply add the link “UseWindowsLogin=Yes”.  In the example below Windows login account will NOT be used to login to Express Maintenance.

    The ExpressMaintenance.ini file example below prohibits the use of Windows login for Express Maintenance and requires that each user login through the application.

    [Connection Info]
    SQLServer=MyServerName
    SQLDatabase=ExpressMaintenance
    UseWindowsLogin=No

    The ExpressMaintenance.ini file example below allows the use of Windows login for Express Maintenance and will not prompt for a login if a matching user is found in Express Maintenance.

    [Connection Info]
    SQLServer=MyServerName
    SQLDatabase=ExpressMaintenance
    UseWindowsLogin=Yes

    On the other hand, some customers prefer to only allow the use of Windows login and do not want Express Maintenance to attempt to login via regular SQL authentication or prompt users for a login to the application.

    The ExpressMaintenance.ini file example below prohibits the use of SQL login authentication and Express Maintenance login and therefore only allows Windows authentication.

    [Connection Info]
    SQLServer=MyServerName
    SQLDatabase=ExpressMaintenance
    UseWindowsLogin=Only