|
Note:
This Tech Bulletin only applies to installing on the server computer or
a standalone computer running the database engine and application.
A separate Tech Bulletin cover setup of
client workstations.
Question: When I run the
program, I get the error, "unable to connect etuser with sql
database: ExpressMaintenance" or "unable to connect to server".
Answer:
The Microsoft Database Engine (MSDE) provides an extremely
reliable and powerful database engine for ExpressMaintenance. No
user of any of our applications has ever lost data or even found it
necessary to rebuild an index or data file. The MSDE is that
solid. However, the
MSDE does add two steps to the installation process.
Installing the MSDE
The
first step is that you must install the MSDE. On most computers,
that is a pretty simple step though it does take a few minutes.
Check our list of supported
operating systems to insure your version of Windows is supported. When
installing the MSDE, allow the installation time to complete.
Starting the MSDE
The
second step is to start the MSDE. This step is often overlooked
especially by users of Windows 98. You must run the SQL Service
Manager. On Windows NT and later, the Service Manager automatically
starts upon installation. On Windows 95 & 98, you must run the
Service Manager. In both cases, you must start the SQL Server from
within the Service Manager.
You
must start the database engine the first time. With SQL /
MSDE2000, the Service Manager can be found under Start / Programs /
Startup. With the SQL / MSDE7 you will find the Service Manager
under Start / Programs / MSDE. When the
Service Manager window appears, check the Auto Start option in the lower
left corner. Next, click the green Start button to start the SQL
database server. It will not be necessary to repeat this step as
the SQL server will start automatically in the future.
Database
Recognition
After you start the
database engine, try running ExpressMaintenance by double clicking on the
desktop shortcut. In most cases, the program will run properly or
prompt to create the database for the first time. For details on
setting up the database for the first time, see the
SQL Installation tech
bulletin.
In the unlikely
event the program still fails to recognize the SQL server, you have a
problem with the computer data access components which is part of
windows. You should then try connecting via the Windows ODBC
Manager. Please see the Tech Bulletin at the following link for
details:
http://www.expresstechnology.com/TechBulletins/Environments.htm
Administrator Privileges
Note that the
first time you run ExpressMaintenance, you must have Administrator
Privileges as it must create the startup database. Please make
sure you login to your system as Administrator the first time you run
ExpressMaintenance in order to create the database.
|
