SQL Server Performance

Caching Error

Discussion in 'SQL Server 2005 Reporting Services' started by sha_shivani, Apr 23, 2007.

  1. sha_shivani New Member

    Whenever i try to Cache a temporary copy of the report i get this error

    "Credentials used to run this report are not stored"

    How to i solve this problem.Pls help!!
  2. satya Moderator

    I believe this is in Reporting services, to avoid this go to the properties of your report, then click on 'Data Sources' on the left. In here, select 'Credentials stored securely in the report server' and supply a username and password that ensure that account has relevant rights on server.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page