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).
An exception occured while executing a Transact-SQL statement or batch.
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?
Solved! Go to Solution.
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.
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 .