3.1 Configuring SQL Server 2005 or 2008

If you are using Microsoft SQL Server 2005 or Microsoft SQL Server 2008, you need to configure your SQL server to support ZENworks Endpoint Security Management. The graphics in the following procedure show SQL Server 2005, but the configuration steps are the same for SQL Server 2008.

  1. Make sure you have Microsoft SQL Server Management Studio.

    Management Studio is included with the Standard and Enterprise editions. If you are using the Express edition, you can download Management Studio Express from the Microsoft Download Center.

  2. Launch Management Studio (Start menu > All Programs > Microsoft SQL Server 2005 (or 2008) > SQL Server Management Studio).

  3. Right-click your SQL server (TC2K3 in the above graphic), then click Properties.

  4. Select Security, then make sure that Server Authentication is set to SQL Server and Windows Authentication mode.

  5. Click OK, then exit Management Studio.

  6. Launch SQL Server Configuration Manager (Start menu > All Programs > Microsoft SQL Server 2005 (or 2008) > Configuration Tools > SQL Server Configuration Manager).

  7. Expand the SQL Server Network Configuration section, select Protocols for MSSQLSERVER (where MSSQLSERVER is your server), then make sure that TCP/IP is enabled as shown below.

  8. Expand the SQL Native Client Configuration section, select Client Protocols, then make sure that TCP/IP is enabled as shown below.

  9. Exit SQL Server Configuration Manager.