AuditWizard - Getting Started - Review Requirements

From Layton Support
(Difference between revisions)
Jump to: navigation, search
m (Minor text additions)
m (Minor text changes)
Line 60: Line 60:
 
On installation, a SQL Compact database is created on the application server. This is intended for only trial and testing purposes, and when going live, it is strongly recommended that it be migrated to SQL Server.
 
On installation, a SQL Compact database is created on the application server. This is intended for only trial and testing purposes, and when going live, it is strongly recommended that it be migrated to SQL Server.
  
To connect to a SQL Server Express or full SQL Server database, run the '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration|Change Database Wizard]]'''.
+
To migrate to a SQL Server Express or full SQL Server database, run the '''[[AuditWizard - Using AuditWizard - Administration - General - Database Maintenance - Change Database Wizard - SQL Migration|Change Database Wizard]]'''.
  
 
===SQL Server===
 
===SQL Server===

Revision as of 02:18, 7 January 2020

Btn back up.png Back to Contents

Contents

Servers

The live application requires at least an application and a SQL Server. These can be on the same or different servers. The system requirements for the application server are dependent on the number of PCs to be audited. The configuration defined below is the recommended minimum.

On installation, a SQL Compact database is created on the application server. This is intended for only trial and testing purposes, and when going live, it is strongly recommended that it be migrated to SQL Server.

AuditWizard Application Server

Hardware Requirements

Requirement Description
Minimum processor Intel Core i3 or higher. This is not a recommended live server configuration for large-scale deployments (1000 clients or more). In this case, Intel Xeon.
Minimum RAM 2GB
Hard-drive space 70–100 MB for the program installation. Allow at least 500 MB for growth in the folder structure. This is for attachments and other files related to the application. On installation, a SQL Compact database is created. This is intended for trial and testing purposes, and when going live, it is recommended that it be migrated to SQL Server. If not, the hard-drive space requirements will exceed 500 MB.

Software Requirements

Server OS

It is not recommended that AuditWizard be installed on a computer running a workstation version of Windows. A service is used to do background tasks, and this requires that the computer be running constantly. Additionally, there may be issues with the number of computer connections to the computer. For this, we recommend that it be installed on a server-class Windows version. If using the AuditAgent, a Server OS must be used.

Requirement Description
Operating System (Trial/Testing) Minimum Windows XP. This is only recommended for trial and testing.
Operating System (Live) Windows 32- and 64-bit Windows 2008, 2012 or 2016 operating systems.

Ports

These are default ports and are the supported ones. Use different ports under your own advisement.

Port Description

SQL Server

SQL Compact

On installation, a SQL Compact database is created on the application server. This is intended for only trial and testing purposes, and when going live, it is strongly recommended that it be migrated to SQL Server.

To migrate to a SQL Server Express or full SQL Server database, run the Change Database Wizard.

SQL Server

Either the enterprise (full) version of SQL Server or the free Express version can be used. SQL Server does not need to be installed on the same server as Layton ServiceDesk.

  • Microsoft SQL Server 2005 or later
  • Microsoft SQL Server 2005 Express or later.

If you don't have any version of SQL Server installed, you may download the free SQL Server 2017 Express from Microsoft.

You can use either, depending on your hardware configuration. You should choose a WT ("With Tools") version to get Microsoft SQL Server Management Studio. Management Studio offers features such as database backup and recovery options.

SQL Server Browser Service

If Layton ServiceDesk is to be installed on a server that is separate from the one hosting the SQL database, the SQL Server Browser Service must be enabled, or Layton ServiceDesk will not be able to see the SQL Server.

Ports

These are default ports and are the supported ones. Use different ports under your own advisement.

Port Description
1433 SQL Server

Windows Account

A Windows account should be added in Management Studio in SERVER ➤ Security ➤ Logins. This should be used to access SQL Server during installations and upgrades.

In Properties, default settings can be specified, but make sure it has the public and sysadmin roles in the Server Roles tab and it has permission to connect and login in the Status tab.

The Audited PC

Operating System

Virtually any PC can be audited provided the operating system is one of the following:

  • Windows XP, Vista, 7, 8 and 10
  • Windows Server 2000, 2003, 2008, 2012, 2016, 2019
  • Both 32 and 64 Bit Operating Systems

Firewall

Deployment of the Agent will be difficult if individual client computers have a firewall installed. We recommend that you either don't use a client-level firewall or use the Scanner method instead.

Audit-Data Storage

By default, AuditWizard installs a SQL Server Compact version. This allows the user to get up and running without needing to install and configure SQL Server, making it easy to get started and when evaluating the application. The SQL Server Compact database can be used as is, but it is recommended that a SQL Server be used for databases above 10 assets. Hosting the database on a full version of SQL Server (not Express) gives the benefit of automated backup, so this is an important reason to migrate.

To connect to a SQL Server Express or full SQL Server database, run the Change Database Wizard.

The following SQL Server versions are supported:

  • SQL Server 2000 (including MSDE)
  • SQL Server 2005 (including SQL Express 2005)
  • SQL Server 2008 (including SQL Express 2008)
  • SQL Server 2008 R2 (including SQL Express 2008 R2)
  • SQL Server 2012 (including SQL Express 2012)
  • SQL Server 2014 (including SQL Express 2014)
  • SQL Server 2016 (including SQL Express 2016)
  • SQL Server 2017 (including SQL Express 2017)

The amount of hard disk space required for your audit data is dependent upon the number of PCs audited and the amount of data uploaded. Typical database size for 100 uploaded computers is approximately 1.5Mb.

SQL Server Browser Service

If AuditWizard is to be installed on a server that is separate from the one hosting the SQL database, the SQL Server Browser Service must be enabled, or AuditWizard will not be able to see your SQL Server.

Next article in this series: Pre-Installation Btn forward.png

Btn back up.png Back to Contents

Personal tools
Namespaces

Variants
Actions
Main Page
Online User Guides
General Support
Release Notes
Toolbox