SQL: Other SQL Server Requirements

Fully Patched

Ensure that SQL Server operating system has the latest Service Packs and is fully patched beforehand.

Authentication

Make sure SQL server is set to Mixed Mode Authentication and not Windows Authentication.

Running SQL Server on a Separate System

If your SQL Server is on a separate system:

• You may have to open TCP Port 1433 and UDP Port 1434. Other ports may be required for non-default instances of SQL Server.
• Ensure the following services use Network Service logons.
  • SQL Server Service
  • SQL Server Browser
• Ensure the SQL Server system and Kaseya Server system are synchronized to within a couple of minutes of each other. A time service is recommended.

Using Microsoft SQL 2005 64 Bit

As documented in the System Requirements, you can install the Kaseya Server on various 64 Bit versions of Windows and SQL. Running MS Windows 64-bit (XP, 7, Server), SQL Server 2005 64-bit (and the Kaseya Server) all on a single Windows machine is not recommend due to a Microsoft issue related to MS Reporting Services. The issue is described in the Microsoft article How to: Install 32-bit Reporting Services on a 64-bit Computer.

There is no issue if you are running SQL Server 2005 64-bit on a separate machine from the Kaseya Server.