SSRS – Setting up a SQL account for data source
Need to set up a SQL account for data source on the report server.
Select “Credential stored securely in the report server”. The credential EAM_ETL_Reader needs to be created first.
This should create a SQL account EAM_ETL_Reader.
CREATE USER [EAM_ETL_Reader]
FOR LOGIN [Password]
The only role we need is db_datareader. This should be enough for reading from tables and views.
If we need this account to execute stored procedures, we will need to grant Execute right to the account for the stored procedure.