I'm trying to configure SSRS 2008 R2. In the configuration wizard -> Databases Step just when it is about to create the below two Databases, It throws insufficient access to create Database error (Sorry I dont have the exact error message)
1) ReportServer
2) ReportServer_TempDB
As a DBA, I'm not supposed to grant "sysadmin". Therefore please let me know the necessarry roles I should assign to configure the SSRS.
Thanks,
Kavin