Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.
Credentials used to run this report are not stored

In Reporting Services there is a feature to Cache a temporary copy of the report that can be used to paste elsewhere.

If the proper username has not been granted on Report Manager the user will get error "Credentials used to run this report are not stored". To avoid the issue on the Report Manager choose properties of the report, click on Data Sources by selecting 'Credentials Stored security in the Report Server', enter valid user name and password that has relevant privileges on the server with atleast Power User rights.

Rest is your...

Posted: Monday, April 23, 2007 7:31 AM by SQL Master

Comments

No Comments

Anonymous comments are disabled