title: Permission error when trying to connect SSRS on amazon EC2 to amazon RDS MSSQL
body: <p>I am trying to deploy SSRS on amazon EC2 instance and connect it to report DB on RDS. Since amazon RDS doesn't support SSRS, my other option is to open dedicated EC2 instance with MSSQL server on it.</p>
  
  <p>I've tried creating the ReportDB from SSRS configuration utility - getting configuration exception: "User does not have permission to perform this action.". It's most probably caused by insufficient SQL permissions. Amazon doesn't grant you with sa user, only processadmin and setupadmin server roles are granted. In databases you create you gain dbowner.</p>
  
  <p>Also, I've created ReportDB separately and transferred it to the RDS, connected the SSRS to it and when it finally recognized it as a proper ReportDB, I received the same exception.</p>
  
  <p>Any thoughts?</p>