UAAR DataLog: Enterprise Database Setup Instructions


Create the Database


Using standard Microsoft SQL Server tools create the database to store UAAR DataLog sales.


Run the Database Creation Tool


The application DB-Update.exe (see: https://agwarefiles.com/maven/) is a tool we use to create and/or update the database. Download and save the db-update.zip file in a folder of your choice on your machine.

In a command window, type db-update and hit the “Enter” key, you will be prompted to enter a server name (the name of your SQL Server), and a database name:



When successfully running the tool in the command window you should see some output that looks like this:



If an error occurs during the database creation or update, the issue will be displayed in the command window.


Logins


Add SQL Server Logins for the users or groups that need access. The DataLog can assign users to the Database and Database Roles but it does not create the Server Logins. SQL Server Enterprise Manager or a similar tool must be used to create Server Logins for the appropriate domain users or groups.


Ensure that the first user that will be doing setup has access to the Database. The first user that will be adding other users to the database need to have access to the database and be a member of the UAAR_SysAdmin database role. Administrators are members of both the database and the database role by default. If a different user will be completing the setup, that user must have a Server Login, Database Login, and be a member of the UAAR_SysAdmin role. That can be setup using SQL Server Enterprise Manager.

See more about the roles definitions on the Security Info page.


Install SQL Server Driver (Clients)


Make sure the SQL Server driver is installed on the users machines.

For more info on this, see the SQL Server Driver page.


Install and Configure DataLog


Download the DataLog MSI install from http://www.uaar.net/downloads and run it. This can be on a client or administrators computer. It does not need to be run on the server.


Set the Database Connection String in DataLog


After running the install and starting DataLog, the Server and Database Name need to be entered.

  • Under the menu Edit -> Configuration
  • Then “System Configuration” Tab

Click on the “Edit” or “Advanced” button




Edit” is a simple way to select the connection authentication type, server and database name, while “Advanced” provides a bit more flexibility by allowing you set the actual connection string:



Test Your Connection


After having set the connection string (server and database name), ensure that the connection can be established by clicking on the “Test Database” button



If successful, you should get the following prompt



Also, after restarting the program, you can see/check the status bar to see if the program is connected to the server.


What’s Left


Now that we have database connectivity, all we need is to do is add users to the Database Roles, set up an Access Group and a Ruleset.