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
- 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
- Right click on your Local Database and select properties
- Select the Security option - Make sure that Server Authentication is set for SQL Server and Windows Authentication mode
- 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
- Under SQL Server 2005 Network Configuration - Select Protocols for MSSQLSERVER
- Make sure TCP/IP is enabled
- Select SQL Native Client Configuration - Select Client Protocols and make sure that TCP/IP is enabled
- Close out the Configuration Manager
- Open the SQL Server 2005 Surface Area Configuration (found in program files\Microsoft SQL Server 2005\Configuration Tools\SQL Server Surface Area Configuration)
- Click on the Surface Area Configuration for Services and Connections
- 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
- Click Apply and the OK Button
- Click on Surface Area Configuration for Features
- 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
- Open the Microsoft SQL Server Management Studio
- Expand out Databases and System databases
- Right click on the model database and select properties
- Click files in the left hand pane and make sure the intial size is 2MB
- If the intial size is 3MB or more do the following:
- Right click on the model database and select Tasks\Shrink\Database
- 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