cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Performing new ePo installation on Dedicated SQL Server

Jump to solution

Dear McAfee,

Can you clarify what DB roles are requried for the Serviceaccount / Windowsaccount during a Fresh ePo (with dedicated SQL) installation?

We plan to use Win Authentication for SQL during epO installation (Not SA). 

 

In The productguide (see attached) it says that the user account need following role:  "public+dbcreator" , is this enough to start performing the installation..? 

 

Later it says "This McAfee EPO SQL useraccount is granted the database role permission db_owner" which I find confusing.. Can you clarify this plz? 

 

Br

1 Solution

Accepted Solutions
cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: Performing new ePo installation on Dedicated SQL Server

Jump to solution

You can't assign it db_owner yet because the db doesn't exist till you install epo.  The install sets db_owner rights.  The default database for the account needs to be master and as for other rights needed, please review the following KB.

https://kc.mcafee.com/corporate/index?page=content&id=KB75766

 

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

3 Replies
vivs
Reliable Contributor
Reliable Contributor
Report Inappropriate Content
Message 2 of 4

Re: Performing new ePo installation on Dedicated SQL Server

Jump to solution

Hello,

Please check the below KB article:

https://kc.mcafee.com/corporate/index?page=content&id=KB75766

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

Re: Performing new ePo installation on Dedicated SQL Server

Jump to solution
OK Thanks. Since it is a new installation we will go with dbroles "public+Dbcreator" only

Seems to be a better explenation in the KB so the role db_owner is assigned by the epo installation after it has been created I presume..

when you refer to :
"NOTE: The ePO SQL user is created with the db_owner database role permission on the ePO database."

cdinet
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 4 of 4

Re: Performing new ePo installation on Dedicated SQL Server

Jump to solution

You can't assign it db_owner yet because the db doesn't exist till you install epo.  The install sets db_owner rights.  The default database for the account needs to be master and as for other rights needed, please review the following KB.

https://kc.mcafee.com/corporate/index?page=content&id=KB75766

 

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?

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