Skip to Content
0
Former Member
Oct 22, 2014 at 11:46 AM

Necessary Windows security on SQL Server for BPC System Admin ID

27 Views

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