I have designed a small intranet site which contains some report viewer reports.
Everything works fine when testing locally on my laptop however once I publish it to my internal IIS server the pages with reports on don't load the reports.
They don't throw an error up or anything and I have tried installing the following files from research I did on the internet.
ReportViewer.msi
SQLSysClrTypes.msi
The environment is IIS 7, Server 2008, I also have placed the following files in the bin folder of the website
It sounds like a security issue.
When you are testing from your local machine, you are using your login details..which has the required access.
After you publich it, you are probably using the Network Services account which might not have the required authority.
Check your application pool's user account (you can also change it to your login ..just to test whether this is the issue) and make sure the
account has access to the report server (if it is server reports) and access to the required database to run the queries (or stored procedures) for the report's dataset
Marked as answer by ChrisJNewb on Nov 22, 2012 09:11 AM
Thanks for the advice I checked the application pool via the Advanced Settings and it was set to Network Service, I changed this to the domain administrator username and password which is also setup on the SQL Server Reporting Services but I still get the
same outcome.
I recycled the Application Pool I changed and also restarted the website in question but still no joy.
Is there a way to check log files? I checked the Application log in Event Viewer but couldn't see any entries for IIS.
I would suggest addding the Network Service account as SSRS user and also grant access to the specific folder on SSRS where the report is located. Remember to change the App Pool back to the Network Service account.
If that doesn't work....hopefully someone else has some ideas.
Tried adding the Network Service and I am still getting the same result.
I tried browsing to the website hosted on the server from my laptop and ran the Visual Studio debug on the page it comes up with the following if this helps?
Uncaught ReferenceError: Type is not defined Reserved.ReportViewerWebControl.axd:1
Uncaught TypeError: Cannot call method '_initialize' of undefined ABSLive.aspx:75
Uncaught TypeError: Cannot call method 'add_init' of undefined ABSLive.aspx:191
The worrying thing is I don't have a bundles folder within the website directory on either local or web host.
There is a bundle.config file which contains the following but no mention of any of the bundles it is looking for. I am using Visual Studio 2012 and I am very new to it. I assumed the publish web site option would copy all the needed content to a directory
on the web host however this seems not to be the case.
I think I am getting confused here I may start a new thread in a different section first as it seems I may have some underlying issues. Thanks for your help on this matter it is greatly appreciated.
I can't understand why using Visual Studio 2012 straight out of the box and created a default Web Forms ASP website generates the following errors without altering anything.
Just to let you know I fixed the errors and then it occurred it was a security issue so I have marked that as the answer, thanks for your help on this matter it is very much appreciatted
ChrisJNewb
Member
2 Points
16 Posts
ReportViewer no longer working once publishing to web host
Nov 21, 2012 07:59 AM|LINK
Hi
I have designed a small intranet site which contains some report viewer reports.
Everything works fine when testing locally on my laptop however once I publish it to my internal IIS server the pages with reports on don't load the reports.
They don't throw an error up or anything and I have tried installing the following files from research I did on the internet.
ReportViewer.msi
SQLSysClrTypes.msi
The environment is IIS 7, Server 2008, I also have placed the following files in the bin folder of the website
Microsoft.ReportViewer.Common.dll
Microsoft.ReportViewer.WebForms.dll
Microsoft.ReportViewer.WinForms.dll
Any help appreciated.
Cheers
Basquiat
Contributor
2386 Points
649 Posts
Re: ReportViewer no longer working once publishing to web host
Nov 21, 2012 08:16 AM|LINK
Hi
It sounds like a security issue.
When you are testing from your local machine, you are using your login details..which has the required access.
After you publich it, you are probably using the Network Services account which might not have the required authority.
Check your application pool's user account (you can also change it to your login ..just to test whether this is the issue) and make sure the
account has access to the report server (if it is server reports) and access to the required database to run the queries (or stored procedures) for the report's dataset
ChrisJNewb
Member
2 Points
16 Posts
Re: ReportViewer no longer working once publishing to web host
Nov 21, 2012 09:02 AM|LINK
Hi Basquiat
Thanks for the advice I checked the application pool via the Advanced Settings and it was set to Network Service, I changed this to the domain administrator username and password which is also setup on the SQL Server Reporting Services but I still get the same outcome.
I recycled the Application Pool I changed and also restarted the website in question but still no joy.
Is there a way to check log files? I checked the Application log in Event Viewer but couldn't see any entries for IIS.
Cheers
Chris
Basquiat
Contributor
2386 Points
649 Posts
Re: ReportViewer no longer working once publishing to web host
Nov 21, 2012 09:26 AM|LINK
I am not sure about your log file question.
I would suggest addding the Network Service account as SSRS user and also grant access to the specific folder on SSRS where the report is located. Remember to change the App Pool back to the Network Service account.
If that doesn't work....hopefully someone else has some ideas.
ChrisJNewb
Member
2 Points
16 Posts
Re: ReportViewer no longer working once publishing to web host
Nov 21, 2012 09:50 AM|LINK
Tried adding the Network Service and I am still getting the same result.
I tried browsing to the website hosted on the server from my laptop and ran the Visual Studio debug on the page it comes up with the following if this helps?
SCRIPT5009: 'Type' is undefined
Reserved.ReportViewerWebControl.axd?OpType=Resource&Version=11.0.1443.3&Name=ViewerScript, line 1 character 1
SCRIPT5007: Unable to get value of the property '_initialize': object is null or undefined
ABSLive.aspx, line 75 character 1
SCRIPT5007: Unable to get value of the property 'add_init': object is null or undefined
Does this help?
ABSLive.aspx, line 187 character 1
Basquiat
Contributor
2386 Points
649 Posts
Re: ReportViewer no longer working once publishing to web host
Nov 21, 2012 10:25 AM|LINK
Are you using IE?
If so, try it in another browser.
ChrisJNewb
Member
2 Points
16 Posts
Re: ReportViewer no longer working once publishing to web host
Nov 21, 2012 10:35 AM|LINK
Tried it in Google Chrome and got the same result the debug also comes up with the following
Failed to load resource: the server responded with a status of 404 (Not Found) http://barr-main-001:12345/bundles/modernizr?v=jmdBhqkI3eMaPZJduAyIYBj7MpXrGd2ZqmHAOSNeYcg1
Failed to load resource: the server responded with a status of 404 (Not Found) http://barr-main-001:12345/bundles/MsAjaxJs?v=J4joXQqg80Lks57qbGfUAfRLic3bXKGafmR6wE4CFtc1
Failed to load resource: the server responded with a status of 404 (Not Found) http://barr-main-001:12345/bundles/WebFormsJs?v=q9E9g87bUDaS624mcBuZsBaM8xn2E5zd-f4FCdIk2cA1
Uncaught ReferenceError: Type is not defined Reserved.ReportViewerWebControl.axd:1
Uncaught TypeError: Cannot call method '_initialize' of undefined ABSLive.aspx:75
Uncaught TypeError: Cannot call method 'add_init' of undefined ABSLive.aspx:191
The worrying thing is I don't have a bundles folder within the website directory on either local or web host.
There is a bundle.config file which contains the following but no mention of any of the bundles it is looking for. I am using Visual Studio 2012 and I am very new to it. I assumed the publish web site option would copy all the needed content to a directory on the web host however this seems not to be the case.
<?xml version="1.0" encoding="utf-8" ?>
<bundles version="1.0">
<styleBundle path="~/Content/css">
<include path="~/Content/Site.css" />
</styleBundle>
<styleBundle path="~/Content/themes/base/css">
<include path="~/Content/themes/base/jquery.ui.core.css" />
<include path="~/Content/themes/base/jquery.ui.resizable.css" />
<include path="~/Content/themes/base/jquery.ui.selectable.css" />
<include path="~/Content/themes/base/jquery.ui.accordion.css" />
<include path="~/Content/themes/base/jquery.ui.autocomplete.css" />
<include path="~/Content/themes/base/jquery.ui.button.css" />
<include path="~/Content/themes/base/jquery.ui.dialog.css" />
<include path="~/Content/themes/base/jquery.ui.slider.css" />
<include path="~/Content/themes/base/jquery.ui.tabs.css" />
<include path="~/Content/themes/base/jquery.ui.datepicker.css" />
<include path="~/Content/themes/base/jquery.ui.progressbar.css" />
<include path="~/Content/themes/base/jquery.ui.theme.css" />
</styleBundle>
</bundles>
Basquiat
Contributor
2386 Points
649 Posts
Re: ReportViewer no longer working once publishing to web host
Nov 21, 2012 10:47 AM|LINK
That seems like a jquery file (or file path) problem.
Check the following posts:
http://forums.asp.net/t/1746623.aspx/1
http://forum.jquery.com/topic/script5009-jquery-is-undefined-13-3-2012-1
http://www.blakepell.com/Blog/?p=405
ChrisJNewb
Member
2 Points
16 Posts
Re: ReportViewer no longer working once publishing to web host
Nov 21, 2012 01:30 PM|LINK
I think I am getting confused here I may start a new thread in a different section first as it seems I may have some underlying issues. Thanks for your help on this matter it is greatly appreciated.
I can't understand why using Visual Studio 2012 straight out of the box and created a default Web Forms ASP website generates the following errors without altering anything.
GET http://barr-main-001:789/bundles/modernizr?v=jmdBhqkI3eMaPZJduAyIYBj7MpXrGd2ZqmHAOSNeYcg1 404 (Not Found)
GET http://barr-main-001:789/bundles/MsAjaxJs?v=J4joXQqg80Lks57qbGfUAfRLic3bXKGafmR6wE4CFtc1 404 (Not Found)
GET http://barr-main-001:789/bundles/WebFormsJs?v=q9E9g87bUDaS624mcBuZsBaM8xn2E5zd-f4FCdIk2cA1 404 (Not Found)
GET http://barr-main-001:789/Content/css?v=f5ydPh92LWsttS1MEc8JZmFtAgT6RUaer_jy37xBkQs1 404 (Not Found)
The above errors are fdrom Google Chrome diagnostics.
Cheers
Chris
ChrisJNewb
Member
2 Points
16 Posts
Re: ReportViewer no longer working once publishing to web host
Nov 22, 2012 09:12 AM|LINK
Just to let you know I fixed the errors and then it occurred it was a security issue so I have marked that as the answer, thanks for your help on this matter it is very much appreciatted
Cheers
Chris