Home > SSRS Expert > SSRS – Setting up a SQL account for data source

SSRS – Setting up a SQL account for data source

Goal

Need to set up a SQL account for data source on the report server.

Solution

Select “Credential stored securely in the report server”. The credential EAM_ETL_Reader needs to be created first.

image

This should create a SQL account EAM_ETL_Reader.

CREATE USER    [EAM_ETL_Reader]
FOR LOGIN    [Password]
WITH DEFAULT_SCHEMA=[dbo]

image

The only role we need is db_datareader. This should be enough for reading from tables and views.

image

If we need this account to execute stored procedures, we will need to grant Execute right to the account for the stored procedure.

image

Categories: SSRS Expert
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: