Using SQL 2005 with ZENworks Endpoint Security Management Server

  • 3466284
  • 15-Oct-2007
  • 27-Apr-2012

Environment

Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Standard Edition
Microsoft SQL 2005
Microsoft Windows 2000 Advanced Server
Microsoft Windows 2000 Server

Situation

How do I configure my SQL 2005 to work with ZENworks Endpoint Security Management Server?

Resolution

  1. You need to use Microsoft SQL Server Management Studio Express to manage your databases. This can be found at https://www.microsoft.com/downloads/details.aspx?familyid=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
  2. Right click on your Local Database and select properties
  3. Select the Security option - Make sure that Server Authentication is set for SQL Server and Windows Authentication mode
  4. Close out the Studion Express and now launch the SQL Server Configuration Manager (found in program files\Microsoft SQL Server 2005\Configuration Tools\SQL Server\Configuration Manager
  5. Under SQL Server 2005 Network Configuration - Select Protocols for MSSQLSERVER
  6. Make sure TCP/IP is enabled
  7. Select SQL Native Client Configuration - Select Client Protocols and make sure that TCP/IP is enabled
  8. Close out the Configuration Manager
  9. Open the SQL Server 2005 Surface Area Configuration (found in program files\Microsoft SQL Server 2005\Configuration Tools\SQL Server Surface Area Configuration)
  10. Click on the Surface Area Configuration for Services and Connections
  11. Select Remote Connections under the Database Engine - Make sure that local and remote connections are checked and using TCP/IP only or using both TCP/IP and named pipes is selected
  12. Click Apply and the OK Button
  13. Click on Surface Area Configuration for Features
  14. Under the Database Engine select xp_cmdshell and make sure that xp_cmdshell is checked. This setting allows for remote connections made through OSQL using a command prompt. Click Apply and then click the OK button. Close out the Server 2005 Surface Area Configuration
  15. Open the Microsoft SQL Server Management Studio
  16. Expand out Databases and System databases
  17. Right click on the model database and select properties
  18. Click files in the left hand pane and make sure the intial size is 2MB
  19. If the intial size is 3MB or more do the following:
  20. Right click on the model database and select Tasks\Shrink\Database
  21. Leave all the default settings on the dialog box and click the OK button

Additional Information

ZENworks Endpoint Security Management Server is not compatible with SQL 2005 express