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.
  • Note: See the Kaseya Knowledge Base for more information.