We are in the process to upgrade to BBSA 8.0 SP11 from BBSA 8.0 SP3. As I understand it, firstly we would need to apply SP6, then SP10 and lastly SP11. According to SP6 Technical Bulletin, as the bladelogic database type is SQL, the "install_hotfix_update_sqlserver_script.bat" file should be executed with "<BLADELOGIC_Username>" and "<BLADELOGIC_Password>", as well as the database name, as input parameters. Does anyone know the permissions that the "username" to provide should have over the bladelogic database in order for the script to run smoothly and if Windows Authentication is allowed (I assume that SQL authentication is the default authentication mode)?
The bladlogic user should have been setup with db_owner perms at the start and the default DB being the BL core DB. This should be fine.
For windows auth - that is best answered by your DBA