August 27, 2014 at 6:35 am
I use SSDT 2012 and when in Report Manager I cannot view any of the reports which I uploaded.
I get what appears in ReportManager1.png
When I click on the "Dashboard" report, I get what appears in ReportManager2.png
I can view the reports in Report Designer.
Also it is worth noting that in Report Manager when I am logged in with a non-Admin user, each click (ex folder selection and other activities) take about 10 seconds each to complete.
It appears that the reports are Deployed from SSDT to Report Manager, since I can view the report names and Shared Data Source in Report Manager. When I click on a report I still get what appears in ReportManager1.png.
Any ideas would be greatly appreciated.
Thanks,
John
August 27, 2014 at 6:45 am
Yes, you need to define the data source for this report from report's Properties, after you have uploaded it.
August 27, 2014 at 7:16 am
Thanks for the reply.
The data source is defined in the properties of the report when viewed in Report Manager.
Any other ideas?
August 27, 2014 at 7:37 am
it says something about login failed for user ... I wander if this is a local user id or is defined properly.
so I would search around this user id and authentication .
August 27, 2014 at 8:03 am
It is a local user id. Everything is happening on a single pc right now. Will look into the authentication.
August 27, 2014 at 8:06 am
You do not have access to the resource the Data Source is trying to connect to.
Check the data source properties on the server and make sure the credentials they are using are set correctly.
Do you have SSRS running on the same Windows server instance as the SSRS database? If not you could experience issues related to the third pass of pass-through windows authentication.
In these cases, for the data source to work correctly, you have to store the credentials to access the data in the data source on the server. Sometimes you even have to us SQL Login stored in the data source settings on the server.
Good Luck!
August 27, 2014 at 8:11 am
JohnPapa (8/27/2014)
It is a local user id. Everything is happening on a single pc right now. Will look into the authentication.
Then check and change the Datasource on the SSRS server using Report Manager.
Give is a SQL Login and password, or Window user name and password to use.
Not all environments can support Intigrated or pass through windows authentication and that is what is failing here.
The Data source settings in your Visual Studios project have nothing to do with the data source settings on the server.
August 27, 2014 at 8:36 am
Many thanks Old Hand. It seems that we are getting warmer.
I get what appears on RM6.png
Any suggestions for changes.
John
August 27, 2014 at 8:42 am
JohnPapa (8/27/2014)
Many thanks Old Hand. It seems that we are getting warmer.I get what appears on RM6.png
Any suggestions for changes.
John
The name is PhyData DBA, not Old Hand. Just as your name is not Grasshoper.
As I mentioned in my post you need to update the Data Source on the SSRS server to have the correct entries to store the credentials needed to access your data on the server. There are many options and you have not given me any information that would help me guide you.
Reading the SSRS books online about this at http://TechNet.Microsoft.com is going to be the best for you. I recommend searching on SSRS DataSource settings Authentication.
August 27, 2014 at 8:51 am
Thanks PHYData DBA,
Will look into your suggestion. I've spent a couple of days on this issue, which must be easier than it seems.
What data can I provide to help you help me?
The report data can be found at
https://dl.dropboxusercontent.com/u/13473531/Junk/Files.zip
Thanks,
John
August 27, 2014 at 9:02 am
One possibly relevant piece of info is that with the specific login john-pc\Administrator, I cannot get the combobox options when I click on the combobox selector in Report Manager.
For the above, I log in as john-pc\john and run Report Manager and SSDT as Admin.
When I log in as User Administrator then I have access to the combobox options.
Do I need to change something in user Administrator?
John
August 27, 2014 at 9:05 am
JohnPapa (8/27/2014)
One possibly relevant piece of info is that with the specific login john-pc\Administrator, I cannot get the combobox options when I click on the combobox selector in Report Manager.For the above, I log in as john-pc\john and run Report Manager and SSDT as Admin.
When I log in as User Administrator then I have access to the combobox options.
Do I need to change something in user Administrator?
John
What you might need to change are your SSRS configuration settings.
Again, these setting are dependant on your environment and your use. You should go to TechNet and check out the Books Online and set-up guides. They are very useful.
August 27, 2014 at 9:37 am
JohnPapa (8/27/2014)
Thanks PHYData DBA,Will look into your suggestion. I've spent a couple of days on this issue, which must be easier than it seems.
What data can I provide to help you help me?
The report data can be found at
https://dl.dropboxusercontent.com/u/13473531/Junk/Files.zip
Thanks,
John
John, I think you are getting to what your issues are now.
After reading your last post (made after this one) you are now looking at how your Server is running the report and using the data source.
This has nothing to do with your report or it's code in SDT 2012.
It is about how reports need to access data because of your SSRS settings and configuration.
My recommendations: Create and use Windows Accounts as the Service and Execution accounts. Make sure to read the SSRS set-up guide for how to create these accounts correctly. Make sure to ready the SSRS set-up guide for you version/edition of SQL Server. It's important that your SSRS server is configured correctly. Even the Dropdown control settings are changed by this.
August 27, 2014 at 9:49 am
Many thanks. Will review later on.
BTW, is there a way to thank people on this forum?
August 27, 2014 at 9:51 am
JohnPapa (8/27/2014)
Many thanks. Will review later on.BTW, is there a way to thank people on this forum?
There is, and you just did it. 😀
BTW - Here is a direct link to some great information:
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply