SQL Express platform

Get SQL-like efficiency at a fraction of the price by using Treasury Software on the SQL Express platform.

Treasury Software SQL Express products consist of two InstallShield files, approximately 170 MB in size combined.

• Client InstallShield (installs Treasury Software)

• Server InstallShield (installs the SQL Express database engine).

Select one of the workstations to act as the server, and run the server install file to install Microsoft SQL Server Express database software. This software is distributed without charge.

Then the client software is installed on each workstation that needs access to the Treasury Software product, including the server. During the workstation configuration, the user will point to the server using a three step Wizard-based setup.

The SQL Express version enables users to share data in a true multi-user environment. While the data is protected by SQL Server security and access is limited to the workstations, there is no ability to apply role-level permissions/restrictions within the workstations with access.

The Server

The workstation designated as the the server should be backed up regularly. Depending on the workload and the number of records processed, the user at the server workstation may be impacted and experience delays when others are processing records.

If the impact of processing is too great on the user at the server workstation, we recommend migrating to the full SQL Server platform. Note: As part of the sensitivity of this issue, SQL Express platforms are limited to 5 users.

When to migrate from SQL Express to full SQL Server

Security
SQL Express differs significantly from SQL Server in its capabilities to manage users.

SQL Server Database Administrators are familiar with SQL Server Management Studio, which grants and restricts access on a database-by-database basis. Users are assigned to Roles - and are assigned permissions. However, the full SQL Server security model does not exist within SQL Express.

In SQL Express, there is only one user id (sa) and once logged in, every user is treated the same - and has full administrator rights. Operationally, this is not an issue - however, segregating databases between users can no longer be guaranteed by SQL (there is no back-end security).
While Treasury Software provides a front-end security model, this is not the same as a back-end security model. For maximum protection and security - you should have both a front-end and back-end security model in place.

Data Access
Need to run reports from the SQL databases? You can perform this if the SQL Express Server is located on the same computer as the process (ie. Crystal Reports, etc..) requesting data - and you are the owner/administrator.

Need help testing - or want to perform maintenance? Install SQL Server Management Studio Express on the same computer hosting SQL Express for full control. Download (item #7) from https://www.treasurysoftware.com/Support/support-downloads.aspx

Note: For security reasons, we are unable to distribute the sa password. If data access is a requirement and you are unsuccessful above, please migrate to full SQL Server. Please contact Treasury Software licensing (additional fees may apply) and then migrate your data using the step-by-step checklist (#6):
https://www.treasurysoftware.com/Support/support2-Install-Center.aspx