During Installation of AppFabric for monitoring store, I am receiving SQL permissions errors. I gave the service account
db_creator permissions but now its asking for "Execute sp_add_category on msdb" which I believe is to create jobs.
Does anyone the full list of SQL Server permissions required for installing/configuring AppFabric monitoring store ? (I am using a dedicated SQL Server running 2008 R2 STD edition). Giving the service account sysadmin permissions is easy way out !!!
Any info is really appreciated.
KK