|
Question: How do workstations
determine the server and database connection?
Answer: ExpressMaintenance and
ExpressRequest have always used an ini file to obtain SQL Server and
database information for connecting to the SQL Server.
Previous Versions
In versions previous to 6.2.1.1,
ExpressMaintenance used a file by the name of Connection.ini. The
file must reside in the folder with Maintenance.exe and must contain the
following:
[LastConnection]
Server=ActualSQLServerName
Database=ExpressMaintenance
Current Version
Starting with version 6.2.1.1,
ExpressMaintenance uses a file by the name of ExpressMaintenance.ini.
The update attempts to create the ini file for you but is often unable
due to of security protection on servers. The
ExpressMaintenance.ini file must reside in the folder with Maintenance.exe and must contain
the following:
[Connection Info]
SQLServer=ActualSQLServerName
SQLDatabase=ExpressMaintenance
The ini file is best edited using the
Notepad text editor.
Notice the space in “Connection Info”.
Also, make sure this file is in the
folder with Maintenance.exe.
Give users read / write permission to
ExperessMaintenance.ini.
Remove Connection.ini once you have
ExpressMaintenance.ini setup.
Test first at the server and make sure
everything works correctly. Next, make sure the workstation
shortcuts point to the same Maintenance.exe in the same folder where you
do your testing at the server.
The file can contain another line to
prevent the use of Windows login. For details on using or disabling the
Windows login - click here.
The same applies to ExpressRequest.
There must be an ExpressRequest.ini file with the same contents.
In the current version,
ExpressMaintenance & ExpressRequest only use the two ini files and no
other ini files are required. No ini files are used on the
workstations. |
