Video Screencast Help

SEP on SQL Server 2008 Service Pack 1

Created: 17 Mar 2010 • Updated: 21 May 2010 | 9 comments
This issue has been solved. See solution.

Hi

during the last days we tried to install the SEP database on a remote server with Windows Authentication. On the remote server a Windows 2008 R2 + SQL Server 2008 64-Bit Service Pack 1 is installed. SQL Service Pack 1 is required to get SQL Server up and running on Windows 2008 R2.

After a quick review  of the system requirements SQL Server 2008 is supported. We fought a couple of days and we were not abel to get it running. We tried mixed mode and everything worked fine but due to security reason wa have to use Windows Authentication. We opend a call and got a reply from Symantec that SQL Server 2008 is supported but Windows 2008 Server Pack 1 not as specified in the system requirements.

Ok I have to accept this reply but I still interested in the reason. What has been changed in SQL Servive Pack 1 which can cause SEP not installing. Is there anybody who can shed some light in this area or maybe a timeline when Service Pack 1 will be supported.

Thanks in advance
Joachim

Comments 9 CommentsJump to latest comment

P_K_'s picture

SEP RU6 would be realeased in some time next Quater. Lets hope it supports SQL 2008 SP1

MCT MCSE-2012 Symantec Technical Specialist (SCTS)

SOLUTION
VinodhRaj K's picture

Symantec Endpoint Protection cannot query the SQL server through Windows authentication.

P_K_'s picture

I Vinodh I am not sure where are you quotting from but SEP RU5 has support for SQL server. 2008

MCT MCSE-2012 Symantec Technical Specialist (SCTS)

VinodhRaj K's picture

Sorry for that and I just edited my comment. Thank you.

P_K_'s picture

SEP RU5 supports following  http://www.symantec.com/business/products/sysreq.jsp?pcid=2241&pvid=endpt_prot_1

32-bit systems:

  • Microsoft SQL Server 2000 with Service Pack 4 or later.
  • Microsoft SQL Server 2005 with Service Pack 2.
  • Microsoft SQL Server 2008.
  •  
64-bit systems:
  • Microsoft SQL Server 2000 with Service Pack 3 or later
  • Microsoft SQL Server 2005 with Service Pack 2
  • Microsoft SQL Server 2008    

Please refer the Release notes
http://service1.symantec.com/SUPPORT/ent-security.nsf/docid/2007121216360648

Symantec Endpoint Protection Manager can now be used with Microsoft SQL Server 2008.

Also refer to https://www-secure.symantec.com/connect/articles/new-features-ru5-mr5

            

MCT MCSE-2012 Symantec Technical Specialist (SCTS)

ShadowsPapa's picture
IT would seem that the OP understands that part, but is asking about SP1. He's asking why does it not support SP1, and what, if anything can be done about it.
Folks like them, and us, are NOT going to downgrade from SP1 just to run SEP when everything else in the world does run on the very latest.
So I can see his quandry - they have a SQL server, they have the latest releases, and they have SP1, which is good security practice and necessary if they want any help from Microsoft - yet SEP won't work on it........
He's asking why.......... as per this quote..

>>We opend a call and got a reply from Symantec that SQL Server 2008 is supported but Windows 2008 Server Pack 1 not as specified in the system requirements.

Ok I have to accept this reply but I still interested in the reason. What has been changed in SQL Servive Pack 1 which can cause SEP not installing.<<

Of course, the reason is probably the login method and not the service pack level.........

 

AravindKM's picture

Have a look in this article
 

How To change the Authentication method from SQL to Windows when configuring SEPM database.

Please don't forget to mark your thread solved with whatever answer helped you : ) Thanks & Regards Aravind

jhans's picture

Thanks ShadowsPapa for clarification. I know it's not working with sp1 but I have to use sp1 on a windows 2008 R2.

I'll wait for some additional comments. I can't see any technical reason for supporting SQL 2008 without but not with service pack.

I'm curious. That's all.

Cheers

SaltyProject's picture

We're having problems with SEPMs configured on SQL Server 2008 SP1 as well.   I'm not sure I fully understand what the issues with SP1 are.   As others have requested,  I would like a more in depth explanation.