cancel
Showing results for 
Search instead for 
Did you mean: 

Is it possible to remove the DBO user as the owner of the McAfee ePolicy Orchestrator 4.5 database?

Jump to solution

Hi,

We have the McAfee ePolicy Orchestrator 4.5 installed on a MS Server 2003 R2 SP2 - Standard Edition, and the database lays on the same server, in a Microsoft SQL Express 9.0.1399 database.

The system works fine, but since the database lays on a MS SQL Express database, we cannot create a backup job as in a "normal" MS SQL database, because of the missing SQL Agent.

I would like to create an automatic database backup on the SQL Express database anyway (as I have done on all our other SQL Express database servers), and this is done as described in "http://en.kioskea.net/faq/3701-automatic-backup-of-a-database-in-sql-express-2005".

As a part of this automation, I need to create a Active Directory service account, that have the permissions on the SQL Express database to perform a backup, so I need to map the service account user to the "ePO4_AEPO01" database, but when I try this, I get the error:

Rename failed for User 'dbo'. (Microsoft.SqlServer.Express.Smo).

Additional information:

An exception occured while executing a Transact-SQL statement or batch.

(Microsoft.SqlServer.Express.ConnectionInfo)

Cannot alter the user 'dbo'. (Microsoft SQL Server, Error: 15150).

(I have attached an image of the error).

To complete this process, it is necessary to remove the DBO user as owner on the database, and this role transferred to our dedicated service account, so it can have the permissions to be "mapped" to the login on the "ePO4_AEPO01" database, with the permission-role "db_backupoperator".

Can you help me with figuring out if I can do this, or will this operation affect the functionality of the McAfee system?

Kind regards,

Carl-Marius

1 Solution

Accepted Solutions

Is it possible to remove the DBO user as the owner of the McAfee ePolicy Orchestrator 4.5 database?

Jump to solution

you should create another user which to be used for the epo connection with db.

3 Replies

Is it possible to remove the DBO user as the owner of the McAfee ePolicy Orchestrator 4.5 database?

Jump to solution

you should create another user which to be used for the epo connection with db.

Is it possible to remove the DBO user as the owner of the McAfee ePolicy Orchestrator 4.5 database?

Jump to solution

Hi alexander_h,

I am not sure I can follow you on this one...

Do you mean that I should create a new SQL user and assign the owner role to this user? (If yes; are you sure that this will not affect the functionality of the system?)

I have created a new active directory user to run the backup process, but it is in the permission assignment to this user that I get the error, so I am not sure in which user-context you are talking about, when you say I should create a new user.

Kind regards,

Carl-Marius

Re: Is it possible to remove the DBO user as the owner of the McAfee ePolicy Orchestrator 4.5 database?

Jump to solution

Hi,

It works if I create a new AD-user in the SQL database and maps the roles to this user.

Why it does not work with the AD-user account that was used to install the McAfee system, I cannot understand.

But it works with a new user .

Kind regards,

Carl-Marius