AuditWizard - Getting Started - Review Requirements
(Added section "SQL Server Browser Service") |
m (Added link to "Change Database Wizard") |
||
| Line 20: | Line 20: | ||
AuditWizard v8 now is 100% SQL based. By default, AuditWizard installs a SQL Server Compact version automatically. 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. | AuditWizard v8 now is 100% SQL based. By default, AuditWizard installs a SQL Server Compact version automatically. 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, | + | 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]]'''. |
The following SQL Server versions are supported: | The following SQL Server versions are supported: | ||
| Line 32: | Line 32: | ||
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. | 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= | =SQL Server Browser Service= | ||
If AuditWizard is to be installed on a server that is separate from the one hosting the SQL database, the '''[https://technet.microsoft.com/en-us/library/ms181087(v=sql.105).aspx SQL Server Browser Service]''' must be enabled, or AuditWizard will not be able to see your SQL Server. | If AuditWizard is to be installed on a server that is separate from the one hosting the SQL database, the '''[https://technet.microsoft.com/en-us/library/ms181087(v=sql.105).aspx SQL Server Browser Service]''' must be enabled, or AuditWizard will not be able to see your SQL Server. | ||
<p align="right">[[AuditWizard™ - Getting Started - Pre-Installation |<u>Next article in this series: ''Pre-Installation''</u>]] [[File:Btn forward.png|link=AuditWizard™ - Getting Started - Pre-Installation]]</p> | <p align="right">[[AuditWizard™ - Getting Started - Pre-Installation |<u>Next article in this series: ''Pre-Installation''</u>]] [[File:Btn forward.png|link=AuditWizard™ - Getting Started - Pre-Installation]]</p> | ||
<p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p> | <p align="right">[[File:btn_back_up.png|link=User Guide for AuditWizard]] [[User Guide for AuditWizard|<u>Back to Contents</u>]]</p> | ||
Revision as of 04:57, 18 September 2015
Contents |
The System
The system requirements are dependent on the number of PCs to be uploaded. The configuration defined below is the recommended minimum.
- IBM PC or compatible, 2.0Ghz
- 2 Gb RAM
- 500 Mb hard drive space for system data
- MS Windows 2000 Server or later. If using the AuditAgent, a Server OS must be used.
- Display adapter capable of a minimum resolution of 800×600
The Audited PC
Virtually any PC can be audited provided the operating system is one of the following:
- Windows XP, Vista, 7 and 8
- Windows Server 2000, 2003, 2008, 2012
- Both 32 and 64 Bit Operating Systems
Audit-Data Storage
AuditWizard v8 now is 100% SQL based. By default, AuditWizard installs a SQL Server Compact version automatically. 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)
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.
