Home Forums Reporting Services Reporting Services Select premission was denied on Object RE: Select premission was denied on Object

  • October 15, 2010 at 1:20 pm

    #1237832

    Are you certain that whatever login you are using in your dataset has the appropriate permissions (Select) to read data from your TVF? Make certain it's not in the db_DenyDatareader role. Have you tried to connect using SSMS and executing the query from the same set of credentials that you are using in your report?

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]