What are the required configurations for installing the Symantec Endpoint Protection Manager with SQL Server 2005?
The following is a checklist and general outline of configurations to make as they are encountered during a typical Symantec Endpoint Protection Manager (SEPM) and SQL 2005 server installation process.
Checklist of installation steps:
These steps are provided as a convenience. They may or may not reflect the current procedures from Microsoft for installing IIS and the SQL components. For current instructions, please contact Microsoft.
Step 1: Install Internet Information Services:
Installing IIS on Windows Server 2003 Operating Systems:
Step 2: Installing SQL Client Components
Note: If the SQL Server is on a separate server, then you must install the SQL Server 2005 Client components on the SEPM server. If the SQL server is on the same system as SEPM, skip this step.
Installing the SQL Server 2005 Client components
Configuring the SQL Server 2005 Client components
Step 3: Installing SQL 2005 Server:
Configure SQL Server 2005:
Update SQL Server 2005 for SQL Server 2005 Service Pack 2
Download SQL Server 2005 Service Pack 2 from this location:
During the installation, in the Authentication window choose 'SQL Authentication'. Use the test available to verify that you have entered the sa password correctly by clicking on the button Test.
Installing Symantec Endpoint Protection Manager
Installing IIS on Windows Server 2008 Operating Systems:
NOTE: Some Administrators find it useful to install the Tracing component under Health and Diagnostics to track IIS errors. There is more information about this feature in the following article from Microsoft TechNet:
IIS 7.0: Configuring Tracing for Failed Requests in IIS 7.0