-
Perform
the following steps on the computer that contains the MSDE database
server to create a new database. The following example uses
ExpressMaintenance.
-
Make
sure you are on the computer (server) with the MSDE and the application.
-
Download and install the latest release of ExpressUtility from our
website at:
http://www.expresstechnology.com/DownloadTrial.htm
-
After installing, run ExpressUtility at the server computer.
-
Click on File / Register New Server to
Setup the server using the user name of "sa" and the
password of "welcome" (blank) or the proper password as set by your
company.
-
Connect to the server by clicking on the server name.
-
Connect to the ExpressMaintenance database by clicking on the
database name.
-
In the Data Connection tab, click the "Create New Database" button
(upper center cylinder looking graphic) and follow steps of the
wizard.
-
You will be prompted for the new database name.
-
You will be prompted for the source model database files which can
be found in the ExpressTech folder.
The files are "ExpressMaintenance_Data.MDF" and "ExpressMaintenance_Log.LDF".
-
You will be prompted for the destination folder where the SQL
database will reside. This is usually the folder of
"\Program Files\MSSQL\Data" or \MSSQL7\Data" but may be different on your computer
depending on where SQL was installed.
-
Click Next and Finish to have the database created.
-
You must now click on the
server name to refresh the list of available databases.
-
Click on the newly created database.
-
Next, click on the Explore Data tab and then the SQL Users tab.
-
Click on the Reset etuser SQL Account button (yellow sign with
explanation mark) to create / reset the etuser login account which
is used by ExpressMaintenance.
-
Next, you will need to create a new shortcut to run
ExpressMaintenance and connect to the new database. You should
do this at the server first, test and then on the workstations.
-
Create
a shortcut to the application on the desktop.
-
Right
click on the new shortcut and rename it as desired.
-
Right
click on the new shortcut and select properties.
-
Locate
the field for the Target program.
-
The
Target field will likely appear as: "C:\ExpressTech\Maintenance.exe".
-
At
the end, add two more parameters separated by a space and quotation
marks. These two parameters represent the Server Name and the
New Database Name. For example: "C:\ExpressTech\Maintenance.exe"
"ServerName or IP" "ExpressMaintenance2"
-
Make
sure each parameter is separated by a space and has quotes around
it.
-
Click
Ok to save the new parameters for the shortcut.
-
Run
the new shortcut and the application should run connecting to the
new database. If not, make sure you have the server and
database parameters correct. If you can connect in
ExpressUtility, you should be able to connect with
ExpressMaintenance.
-
A new serial number will be
generated and you will need to email that to
support@ExpressTechnology
to obtain a new registration code.
