Asure ID 2009 – Setting up a MySQL as the Native Database

Steps to setting up a MySQL database for Asure ID 2009

1. Have your SQL database administrator create a database instance for Asure ID 2009 to use. The administrator needs to grant full read/write privileges for the security setting for this database instance.

2. The SQL database adminstrator needs to run the table creation script. Normally you will find this script in C:\Program Files\HID Global\Asure ID 2009\Scripts

3. Once the script has been run to create the tables, Asure ID 2009 can now be connected to the database.

4. Under the start menu, choose the “Data Connection Wizard”. To do this, go to your All Programs option down by your start function. Choose HID Global. Select Asure ID 2009. Then, select Data Connection Wizard.

5. Follow the attached screens to use the wizard.

Click next to continue setting up the customer database configuration for Asure 2009in your screen shot as shown below.

Data Connection Wizard

b. Next the wizard will need to confirm the type of custom database Asure ID 2009 will connect to. In this case, choose “Microsoft SQL Server” and click “Next”

Data Connection Wizard

c. Next is the general data connect window for SQL Server. Under “Server Name” the name of the SQL Server needs to be entered. Then, under “Initial Catalog” the place the name of the Database Instance that the SQL Database Administrator set up for Asure ID 2009 to use. For the “User Name and Password” use the information the SQL Database Admin set up. It can either be a specified user name
and password or it can be set up to “Use Integrated Security” which means that who ever logged on to the computer could access it. Once it is all filled out, click “Next”.

Data Connection Wizard

d. The wizard is now complete. You can click the “Test” button to test the connection to the SQL Database.

Data Connection Wizard

e. Click “Finish” to exit the wizard.

The log in for Asure 2009 now that it is connected to the SQL Database is:
User Name: admin
Password: admin

Free trial download of Asure ID 2009 ID Card Software is now available.

Additional information about Asure ID 2009 ID Card Software is available from our website or our ID card experts.

3 thoughts on “Asure ID 2009 – Setting up a MySQL as the Native Database

  1. Pingback: Asure ID 2009 - Installation Instructions | SafeCardID.com

  2. SafeCardID Team

    Hi Karan – version 2009 of Asure ID was replaced by Version 7. Users of version 2009 receive a free upgrade to version 7, which you can obtain directly from the HID Global web-site. As version 2009 is no longer support, we recommend you apply the free upgrade first. THEN you can follow this information for creating and using a SQL database, rather than the default MS Access database:

    Creating a new Native Database (Access, SQL, and Oracle)
    When Asure ID is installed, it will use an Access database. This database stores some configuration tables, as well as template and cardholder data. If using SQL Server or Oracle as the native database, A new native database will need to be created. Your system administrator or DBA will need to execute a set of scripts to create all the database objects needed for Asure ID 7. The application needs to be pointed to the new database. If the database is not found the user will have the option to generate a new database by selecting the required path. With the next startup the new database will be accessed. To install the scripts access the Scripts sub-folder wherever Asure ID is installed.

    Typically installation will be either:

    1. C:\Program Files\HID Global\Asure ID
    2. C:\Program Files (x86)\HID Global\Asure ID).

    There will be two SQL script files:

    1. AsureID_MSSQL.sql (to be used for SQL Server)
    2. AsureID_Oracle.sql (to be used for Oracle)

    Your administrative authority will need to run whichever set of scripts is applicable in the selected database.

    1. Also needed is to create a user that has SELECT, INSERT, UPDATE, DELETE and CREATE privileges.

Leave a Reply

Your email address will not be published. Required fields are marked *

eighteen − thirteen =