Does ExpressMaintenance use the Windows Login account or require it’s own login account to the SQL Server?

Answer: User Accounts are setup in ExpressMaintenance 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, ExpressMaintenance when executed will not use the Windows login account.  However, you can change this behavior and cause ExpressMaintenance to use the Windows login account.  In this case, if the Windows login account matches an account in the ExpressMaintenance 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 ExpressMaintenance 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 ExpressMaintenance 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 ExpressMaintenance.

The ExpressMaintenance.ini file example below prohibits the use of Windows login for ExpressMaintenance and requres 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 ExpressMaintenance and will not prompt for a login if a matching user is found in ExpressMaintenance.

[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 ExpressMaintenance 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 ExpressMaintenance login and therefore only allows Windows authentication.

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