Ravendra's Blog

January 29, 2010

SSRS not able execute dataset

Filed under: SSRS,TFS — Ravendra Mishra @ 3:53 pm
Tags: , , ,

Recently I have created few reports for Team foundation server. Dataset for these reports were calling stroed procedures and functions. These reports worked well in dev envionrment but not in prod. I have asked deployment team to run stored procedures on TFS warehouse database. Later I found that its because the SSRS service account was not able to execute these reports so for all the stored procedures and functions I provided execute/ select permission for service account and it worked.

Execute permission for stored procedures and Scalar functions

grant exec on dbo.prc_Report_GetCurrentIteration to TfsWarehouseDataReader

grant exec on dbo.prc_Report_ProjectBurnUp to TfsWarehouseDataReader

Select permission for Table valued function

grant select on dbo.GetIterationDates to TfsWarehouseDataReader

grant select on dbo.SplitString to TfsWarehouseDataReader


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

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 )

Google+ photo

You are commenting using your Google+ 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 )


Connecting to %s

Create a free website or blog at WordPress.com.

%d bloggers like this: