Necessary Windows security on SQL Server for BPC System Admin ID

[Former Member]

Hi,

I work with an environment where BPC 10 MS (and SSIS) is installed on one server, and SQL Server 2012 plus SSAS is installed on a corporate SQL server.

1. Is it necessary for the System Admin ID to be member of the (Windows) Administrators group on the SQL Server on a permanent basis?

2. Or is it sufficient for the System Admin ID to have SQL sysadmin rights on the SQL Server?

Optionally, it would be acceptable for the System Admin ID to be local admin (member of the administrators group) of the SQL Server for the installation process.

Best regards,

Thomas

[Former Member]

Thomas,

BPC admin account should be a sysadmin on SQL Server and have admin rights on SSAS due to processing of dims... you may get away with lesser privileges, but you'd have issues if you use BPC backup/restore tool. DBO should be enough if you backup/restore BPC AppSets yourself.

In addition to that, it should have rights to a BPC share/folders. Personally, I dont' see a reason for it to be a local admin, but I've never tested that. If you have a test environment you can easily test - you'd see issues right away if any.

regards,

Akim

[Former Member]

Thank you very much for your reply.

Kind regards,

Thomas