I am unable to complete the Symantec EndPoint Protection Configuration Wizard due to errors:
Here are the configurations for the the last three wizard screens before the errors appear:
Database Type: Microsoft SQL Server
Create a new database
Database Server: ServerName\InstanceName
SQL Server Port: 1433
Database Name: sem5
Authentication: Windows Authentication
User: sem
Password: ***************
Confirm Password: ***************
SQL Client Folder: C:\Program Files\Microsoft SQL Server\100\Tools\Binn
Database data folder:
If I click the the Default button next to the Database data folder field, this error appears:
Failed to connect to database
If I specify a data folder C:\Program Files\Microsoft SQL Server\MSSQL10_50.InstanceName\MSSQL\DATA then this error appears:
Error 11501: Unable to create the database for Symantec Enpoint Protection Manager. Please click here for more information.
I've already searched the support site and forums for resolution to these error messages. No previous posts applied or resolved the issues.
The Installation documentation (if you can call it that) equivocates on if the "user" account should already exist. I tried installing under two scenarios: account exist and account not exist. Under the account exist scenario, the sem account had local admin rights and was also a login account with sysadmin rights in the SQL Serve Management Studio.
Server Notes:
- Windows 2008 R2 with SQL 2008 R2 Installed
- Symantec_Endpoint_Protection_11.0.6_MP2_Trialware_Xplat_EN
- Workgroup (not part of a domain)
- Using Remote Desktop to connect to server (since it is in another state)
- Windows Firewall Enabled (corporate policy)
- Configured Windows Firewall to Allow SQL Exception (see http://support.microsoft.com/kb/968872 )
- Configured SQL to enable TCP/IP for InstanceName on port 1433