Yes it is...
From: [email protected] [mailto:[email protected]] On Behalf Of Jason Sandys Sent: Wednesday, July 10, 2013 2:59 PM To: [email protected] Subject: [mssms] RE: SSRS Report Builder Preview The report server DB permissions don't matter for running a report or query. Is you SPN properly registered for the SQL Server? J From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Spengler, Jeff Sent: Wednesday, July 10, 2013 3:43 PM To: '[email protected]' Subject: [mssms] RE: SSRS Report Builder Preview Yes.. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Thompson, Joseph W (Joe) Sent: Wednesday, July 10, 2013 2:40 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: SSRS Report Builder Preview Can you run the query from SQL Mgmt Studio? Sounds like a ssrs datasource config issue.... From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jason Sandys Sent: Wednesday, July 10, 2013 3:03 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: SSRS Report Builder Preview Have you granted the folks running report builder DB-read permissions on the SQL DB? J From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Spengler, Jeff Sent: Wednesday, July 10, 2013 2:59 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: SSRS Report Builder Preview Yes..I have imported the cert to the trusted people on the local machine.. From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Jason Sandys Sent: Wednesday, July 10, 2013 1:39 PM To: [email protected]<mailto:[email protected]> Subject: [mssms] RE: SSRS Report Builder Preview Does the client trust the SQL instance? Specifically, have you added the cert (which is automatically self-generated) from the SQL Server as a trusted cert on the client? J From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Spengler, Jeff Sent: Wednesday, July 10, 2013 1:56 PM To: '[email protected]' Subject: [mssms] SSRS Report Builder Preview I am using Report Builder 3.0 to create a report on a remote workstation. When I try to 'run' the report in Report Builder, I get an error that it is unable to preview report. The permissions for user domain\user are insufficient for performing this operation. Can someone help point me in the right direction to solve this? I checked roles and user is an report admin, Thanks, ________________________________ [Idaho Power Legal Disclaimer] This transmission may contain information that is privileged, confidential and/or exempt from disclosure under applicable law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or use of the information contained herein (including any reliance thereon) is STRICTLY PROHIBITED. If you received this transmission in error, please immediately contact the sender and destroy the material in its entirety, whether in electronic or hard copy format. Thank you. ________________________________ ________________________________
