cancel
Showing results for 
Search instead for 
Did you mean: 
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 1 of 3

Changing SQL Compatibility Level for the McAfee ePO Server

Jump to solution

We recently upgraded the SQL Server from 2014 to 2017 for our ePO 5.10 server. I noticed that the compatibility level is set for SQL Server 2014 (120). Is it OK to change this level to SQL Server 2017? Will it cause any issues with the database?

1 Solution

Accepted Solutions
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 3

Re: Changing SQL Compatibility Level for the McAfee ePO Server

Jump to solution

No, it should not cause any problems, as that is a supported version of sql.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

View solution in original post

2 Replies
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 3

Re: Changing SQL Compatibility Level for the McAfee ePO Server

Jump to solution

No, it should not cause any problems, as that is a supported version of sql.

Was my reply helpful?
If this information was helpful in any way or answered your question, will you please select Accept as Solution in my reply and together we can help other members?

View solution in original post

Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 3 of 3

Re: Changing SQL Compatibility Level for the McAfee ePO Server

Jump to solution

Hello @twenden ,

Adding to @cdinet , EPO 5.10 requires sql 2012 and above, below table will give you details on the compatibility levels for every version of SQL . upgrading sql compatibility will not affect epo database , just that you have to make sure the version of EPO supports that level.

SQL Server Version             Database Engine Version        Default Compatibility Level           

SQL Server 2019                   15                                            150                                                  

SQL Server 2017                   14                                            140                                                  

SQL Server 2016                   13                                            130                                                 

SQL Server 2014                   12                                            120                                              

SQL Server 2012                   11                                            110                                              

SQL Server 2008 R2              10.5                                         100                                             

SQL Server 2008                   10                                            100                                             

SQL Server 2005                     9                                              90                                             

SQL Server 2000                     8                                              80                

Supported platforms, environments, and operating systems for ePolicy Orchestrator
Technical Articles ID: KB86693

Was my reply helpful?
If you find this post useful, Please give it a Kudos! l Also, Please don't forget to select "Accept as a solution" if this reply resolves your query!

Thanks and regards,
Yash T
You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community