How can I create the ExpressMaintenance database with SQL 2008 and newer?

Answer: Express Technology Inc. software is designed for the Microsoft SQL ServerDatabase Engine.  It will work with all versions of MS SQL Server.   However, newer versions of SQL Server will not create the database from older version database files.  Therefore, you may need to download newer model files.  You can download newer model files from our website – Click Here to Download Model Data Files in zip format. 

Below are instructions for creating the database using these files.

1. Download the file and unzip into the folder where you installed ExpressMaintenance (Example: ExpressTech).

2. Run ExpressMaintenance (Maintenance.exe) from the folder.

3. After receiving errors because the database does not exist, proceed into the program.

4. Click on Administration / Databases & Connections.

5. Enter your SQL Server name.  It will likely be the computer name or computername\SQLExpress (instances being used).

6. Test connecting to your SQL Server with using Windows authentication and SQL Authentication and connecting to the “master” database.

7. Once you are able to successfully connect, complete the dialog info as shown below in the sample screen shot.

8. Click the Create Database button to create the ExpressMaintenance Database.

9. After the database is created, click the button to Create etuser account.

10. Click the buttcreDownload Connection File / Write Connection File.

11. Exit the program and run over again.  This should take you directly into ExpressMaintenance.

Creating Database using ExpressSQL

Below are instructions for creating a database using ExpressSQL:

1.     Download ExpressSQL from the following link www.ExpressSQL.com.

2.     Install ExpressSQL on your computer.

3.     Run ExpressSQL and be sure to run as Administrator.  Windows 8 is picky about permission and you must select to Run as Administrator even if you are logged in with Admin rights.

4.     Once you run ExpressSQL, register your SQL server using the sa login and password.  Your server name will be computer name or ComputerName\SQLExpress (instances being used).

5.     If you have trouble saving your SQL server registration, that means you did not run the program as Administrator.

6.     Save your SQL Server registration.

7.     Select your SQL Server on left side.

8.     Select the master database.

9.     Right click on master database and select View Connection Info.

10.  Note the folder where the Database file is located for the master database.

11.  Leave ExpressSQL for the moment.

12.  Go to the folder where you installed ExpressMaintenance.

13.  Locate the ExpressMaintenance_Data.mdf and ExpressMaintenance_Log.ldf files.

14.  Copy these two files and paste them to the folder noted above in step 10.

15.  Go back to ExpressSQL.

16.  Right click on the master database and select Create New Database.

17.  In the create dialog, select the 3rd option Both Files and enter the databse name of ExpressMaintenance.

18.  For the Data File, select the ExpressMaintenance_Data.mdf file pasted in folder in step 14 above.

19.  For the Log File, select the ExpressMaintenance_Log.ldf file pasted in folder in step 14 above.

20.  Click Proceed and Run Now to create the database.

21.  Once the database is created, if will appear on the left along with master.

22.  Left click on the ExpressMaintenance database and you will see tables, etc.

23.  Now locate the Users section in left column.

24.  Right click in the Users section and run the option to Create special etuser account.

25.  Close ExpressSQL.

26.  Run ExpressMaintenance and it should work.

27.  If it does not connect now, do a Test connection.

28.  Once connected, choose the option to Create the connection file or you can create it manually following instructions in the following link: How do workstations determine the server and database connection instructions?