|
Question: Can
ExpressMaintenance use the Windows Login account or does it 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 check the Windows login account
and if it matches an account in the ExpressMaintenance user accounts it
will proceed to automatically login that user without prompting for a
login. 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 is a user uses multiple login accounts in
ExpressMaintenance for example to access different sites or databases.
Therefore the automatic feature can be turned off.
To turn off the use
of automatic use of the Windows login simply edit the ExpressMaintenance.ini file which resides in the folder with
ExpressMaintenance.ini. To turn the feature off, simply add the
line "UseWindowsLogin=No". 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 authentication to
the SQL Server and only allows SQL authentication.
[Connection Info]
SQLServer=MyServerName
SQLDatabase=ExpressMaintenance
UseWindowsLogin=No
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.
The ExpressMaintenance.ini file example below prohibits the use of SQL login authentication to the
SQL Server and only allows Windows authentication.
[Connection Info]
SQLServer=MyServerName
SQLDatabase=ExpressMaintenance
UseWindowsLogin=Only
The
ExpressMaintenance.ini file example below allows for both Windows and
SQL authentication.
[Connection Info]
SQLServer=MyServerName
SQLDatabase=ExpressMaintenance |
