Friday, March 23, 2012
reportservertempdb
recovery purposes. ReportServerTempDB is purely a temp database, correct?
Meaning, the data in it does not need to be replicated from our production
server to our disaster recovery server, correct?
Could someone just verify this for me.
Thanks.Yes, you don't need to replicated your ReportServerTempDB
According to BOL "Backup and Restore Operations for a Reporting Services
Installation"
The only reason to backup the reportservertempdb is to avoid having to
recreate it if there is a hardware failure.
Med bouchenafa
"Jeff" <Jeff@.discussions.microsoft.com> a écrit dans le message de news:
C440E7E5-D027-4C98-9A8B-EA0C8C2B245B@.microsoft.com...
> We are working on creating a copy of our SQL server machine for disaster
> recovery purposes. ReportServerTempDB is purely a temp database, correct?
> Meaning, the data in it does not need to be replicated from our production
> server to our disaster recovery server, correct?
> Could someone just verify this for me.
> Thanks.|||Depends... are you talking disaster recovery... in which you would
re-establish services from a repository of stored data? ...or... are you
looking for fault tollerance where a more real-time fail over takes place
imediately after the falure due to disaster?
"Jeff" wrote:
> We are working on creating a copy of our SQL server machine for disaster
> recovery purposes. ReportServerTempDB is purely a temp database, correct?
> Meaning, the data in it does not need to be replicated from our production
> server to our disaster recovery server, correct?
> Could someone just verify this for me.
> Thanks.|||Ken,
We're looking a the former. We have an offsite repository of data, which we
would use to re-establish services in the event of a fire or something like
that. This isn't for real time failover.
"Ken Carter" wrote:
> Depends... are you talking disaster recovery... in which you would
> re-establish services from a repository of stored data? ...or... are you
> looking for fault tollerance where a more real-time fail over takes place
> imediately after the falure due to disaster?
> "Jeff" wrote:
> > We are working on creating a copy of our SQL server machine for disaster
> > recovery purposes. ReportServerTempDB is purely a temp database, correct?
> > Meaning, the data in it does not need to be replicated from our production
> > server to our disaster recovery server, correct?
> >
> > Could someone just verify this for me.
> >
> > Thanks.
Tuesday, March 20, 2012
Reports Services will not work with SharePoint 2003 and SQL Server 2005
We have installed SharePoint Portal Server 2003 (it is working correctly) and SQL Server 2005 (it is working correctly) on a single virtual machine.
If I enter "http://ComputerName/reports" to display the Report Manager we get the following error:
(yes, I did put in our computer name in the appropriate location)
Parser Error Message: An error occured loading a configuration file: Access to the path 'c:\inetpub\www\root\web.config' is denied.
Is this a permissions issue, a configuration issue, or something else?
Any suggestions for resolving this would be appreciated.
We have found the cause for this. It was a corrupted installation.Reports Services will not work with SharePoint 2003 and SQL Server 2005
We have installed SharePoint Portal Server 2003 (it is working correctly) and SQL Server 2005 (it is working correctly) on a single virtual machine.
If I enter "http://ComputerName/reports" to display the Report Manager we get the following error:
(yes, I did put in our computer name in the appropriate location)
Parser Error Message: An error occured loading a configuration file: Access to the path 'c:\inetpub\www\root\web.config' is denied.
Is this a permissions issue, a configuration issue, or something else?
Any suggestions for resolving this would be appreciated.
We have found the cause for this. It was a corrupted installation.Reports not working on server
I have been developing my asp.net application in c#, on my local machine. I have started working with the "reportViewer " and it works fine on my machine, but as soon as i upload it onto our server, which is windows 2000 server, IIS 5.0, it won't work.
i get the following error, MASTER1 is the name of the server.
Hope someone can help me. I presume it is an IIS thing. other non-report aspx pages are accessed fine.
Any ideas where i should be looking?
Thanks,
Munira
"An error has occurred during report processing.
Exception has been thrown by the target of an invocation.
Login failed for user 'MASTER1\ASPNET'."
well i have the same problem on w2003 & IIS 6,any idea?Reports Manager 400 Bad Request
one machine. Both with Reporting Services installed. I am running SQL
Server 2005 build 2153 for both, on Windows Server 2003 Enterprise. I have
IIS setup correctly. I went through and configured each so that everything
has a green checkmark next to it, with the exception of encryption. Now
everytime I try to bring up the reports either locally or remotely. It
brings up the page and with a 400 error. I have tried the following
server2/reports(instancename), server2.mastro.local/reports(instancename),
and 192.168.0.2/reports(instancename). Does anyone know how to get rid of
this 400 error?
Michael R. Mastro IIGot it fixed.
"Michael Mastro" <MikeRM2XXX@.worldnet.att.net> wrote in message
news:e9YR1RRUHHA.1364@.TK2MSFTNGP06.phx.gbl...
> Here is the problem I am having. I have 2 instances of SQL Server setup
> on one machine. Both with Reporting Services installed. I am running SQL
> Server 2005 build 2153 for both, on Windows Server 2003 Enterprise. I
> have IIS setup correctly. I went through and configured each so that
> everything has a green checkmark next to it, with the exception of
> encryption. Now everytime I try to bring up the reports either locally or
> remotely. It brings up the page and with a 400 error. I have tried the
> following server2/reports(instancename),
> server2.mastro.local/reports(instancename), and
> 192.168.0.2/reports(instancename). Does anyone know how to get rid of
> this 400 error?
> Michael R. Mastro II
>
Monday, March 12, 2012
Reports Home Page "Page Cannot be Found" Error
I am running SQL Server 2000 Reporting Services on a development machine
which is part of a corporate network. However, other computers in the network
cannot see the Reports Home Page.
I am fairly certain that the problem is due to the IIS settings, but don't
know what to change to fix it. I have checked that Integrated Windows
authentication is enabled. I have also added a user who is co-testing the
reports Browser permission on the folder containing the report. I understand
that I do not have to repeat this on the report itself as it inherits
permissions from the parent folder.
I have also given the the IUSR_xxxx and the ASP.Net accounts permissions to
the ReportManager folder on my computer.
What have I done wrong?
Regards,
JamesHi,
Just go to the machine where your reporting services is installed and give
access to the users. If it is domain please give your domain \username and
give "View ports"
Amarnath
"James" wrote:
> Hi,
> I am running SQL Server 2000 Reporting Services on a development machine
> which is part of a corporate network. However, other computers in the network
> cannot see the Reports Home Page.
> I am fairly certain that the problem is due to the IIS settings, but don't
> know what to change to fix it. I have checked that Integrated Windows
> authentication is enabled. I have also added a user who is co-testing the
> reports Browser permission on the folder containing the report. I understand
> that I do not have to repeat this on the report itself as it inherits
> permissions from the parent folder.
> I have also given the the IUSR_xxxx and the ASP.Net accounts permissions to
> the ReportManager folder on my computer.
> What have I done wrong?
> Regards,
> James
>|||Hi,
I found out that the error was due to Windows Firewall blocking connections
from other computers. By opening port 80, it worked immediately.
Thanks for your suggestion anyway.
James
"Amarnath" wrote:
> Hi,
> Just go to the machine where your reporting services is installed and give
> access to the users. If it is domain please give your domain \username and
> give "View ports"
> Amarnath
>
> "James" wrote:
> > Hi,
> >
> > I am running SQL Server 2000 Reporting Services on a development machine
> > which is part of a corporate network. However, other computers in the network
> > cannot see the Reports Home Page.
> >
> > I am fairly certain that the problem is due to the IIS settings, but don't
> > know what to change to fix it. I have checked that Integrated Windows
> > authentication is enabled. I have also added a user who is co-testing the
> > reports Browser permission on the folder containing the report. I understand
> > that I do not have to repeat this on the report itself as it inherits
> > permissions from the parent folder.
> >
> > I have also given the the IUSR_xxxx and the ASP.Net accounts permissions to
> > the ReportManager folder on my computer.
> >
> > What have I done wrong?
> >
> > Regards,
> >
> > James
> >
Reports deployed to Standard edition RS and SQL Server
We have successfully developed the reports on our testing machine with SQL Server 2000 Enterprise + Reporting Services 2000 Enterprise. Is there any problem if we deploy the reports to the production machine that runs SQL Server 2000 Standard and Reporting Services 2000 Standard?
Thanks in advance!
Here is some info on licensing:
http://msmvps.com/blogs/anguslogan/archive/2004/10/03/14788.aspx
The report RDL files should be the same in both environments so you should not have any problems.
cheers,
Andrew
Reports Deployed on a local machine cannot be viewd from internet
local intranet. Now we have created a asp.net page and given a link to one of
the reports by mentioning "MC230" in the URL of the link. After hosting this
page on out web site, we are able to take the reports by clicking the link in
the local intranet. But when v take the reports out side the domain we are
not getting the reports, instead it is showing Page Cannot be Displayed. As
mentioned in this group v tried changing the url in RSWebApplication.config.
still v r getting the same error.
Can any one please help us. As we are developing a corporate application it
is very urgent.The Reporting Services setup program assumes that you will be accessing the
Reports website using an address similar to http://servername/Reports. This
works fine inside your network, but it probably isn't going to work well if
you want to make the Reports website available from outside your network.
In this case you should make a change to the RSWebApplication.config file.
Find lines like
<Configuration>
<UI>
<ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
</UI>
and replace <ReportServerUrl></ReportServerUrl> parameter like
<Configuration>
<UI>
<ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
</UI>
you can write servers IP too, like http://212.212.222.222/ReportServer
After this change you may need to restart the IIS service for this change to
take effect.
"Bigil" <Bigil@.discussions.microsoft.com> wrote in message
news:37C202DC-B311-4A79-8556-97A966FBE756@.microsoft.com...
> We have deployed our reports on a local machine say "MC230" which is the
> local intranet. Now we have created a asp.net page and given a link to one
of
> the reports by mentioning "MC230" in the URL of the link. After hosting
this
> page on out web site, we are able to take the reports by clicking the link
in
> the local intranet. But when v take the reports out side the domain we are
> not getting the reports, instead it is showing Page Cannot be Displayed.
As
> mentioned in this group v tried changing the url in
RSWebApplication.config.
> still v r getting the same error.
> Can any one please help us. As we are developing a corporate application
it
> is very urgent.
>|||Hi,
Tanks for de reply, but it culd'nt solve the issue, u have asked me to give
> <UI>
> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> </UI>
right, since reporting services isnstalled on a localmachine "MC230" how
should i give the url "http://MC230/ReportServer"'? how will this b
recognized on internet
"saglamtimur" wrote:
> The Reporting Services setup program assumes that you will be accessing the
> Reports website using an address similar to http://servername/Reports. This
> works fine inside your network, but it probably isn't going to work well if
> you want to make the Reports website available from outside your network.
> In this case you should make a change to the RSWebApplication.config file.
> Find lines like
> <Configuration>
> <UI>
> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> </UI>
> and replace <ReportServerUrl></ReportServerUrl> parameter like
> <Configuration>
> <UI>
> <ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
> </UI>
> you can write servers IP too, like http://212.212.222.222/ReportServer
> After this change you may need to restart the IIS service for this change to
> take effect.
>
> "Bigil" <Bigil@.discussions.microsoft.com> wrote in message
> news:37C202DC-B311-4A79-8556-97A966FBE756@.microsoft.com...
> > We have deployed our reports on a local machine say "MC230" which is the
> > local intranet. Now we have created a asp.net page and given a link to one
> of
> > the reports by mentioning "MC230" in the URL of the link. After hosting
> this
> > page on out web site, we are able to take the reports by clicking the link
> in
> > the local intranet. But when v take the reports out side the domain we are
> > not getting the reports, instead it is showing Page Cannot be Displayed.
> As
> > mentioned in this group v tried changing the url in
> RSWebApplication.config.
> > still v r getting the same error.
> >
> > Can any one please help us. As we are developing a corporate application
> it
> > is very urgent.
> >
> >
>
>|||Talk to your IT person about mapping an internet DNS address (or public IP
address) to the report server. If that's not done, it's not possible.
Whatever the IT guy tells you is the correct address, put that in the config
file.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"Bigil" <Bigil@.discussions.microsoft.com> wrote in message
news:626225B4-BDF0-45B9-81F9-93E5573F195F@.microsoft.com...
> Hi,
> Tanks for de reply, but it culd'nt solve the issue, u have asked me to
> give
>> <UI>
>> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
>> </UI>
> right, since reporting services isnstalled on a localmachine "MC230" how
> should i give the url "http://MC230/ReportServer"'? how will this b
> recognized on internet
> "saglamtimur" wrote:
>> The Reporting Services setup program assumes that you will be accessing
>> the
>> Reports website using an address similar to http://servername/Reports.
>> This
>> works fine inside your network, but it probably isn't going to work well
>> if
>> you want to make the Reports website available from outside your network.
>> In this case you should make a change to the RSWebApplication.config
>> file.
>> Find lines like
>> <Configuration>
>> <UI>
>> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
>> </UI>
>> and replace <ReportServerUrl></ReportServerUrl> parameter like
>> <Configuration>
>> <UI>
>> <ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
>> </UI>
>> you can write servers IP too, like http://212.212.222.222/ReportServer
>> After this change you may need to restart the IIS service for this change
>> to
>> take effect.
>>
>> "Bigil" <Bigil@.discussions.microsoft.com> wrote in message
>> news:37C202DC-B311-4A79-8556-97A966FBE756@.microsoft.com...
>> > We have deployed our reports on a local machine say "MC230" which is
>> > the
>> > local intranet. Now we have created a asp.net page and given a link to
>> > one
>> of
>> > the reports by mentioning "MC230" in the URL of the link. After hosting
>> this
>> > page on out web site, we are able to take the reports by clicking the
>> > link
>> in
>> > the local intranet. But when v take the reports out side the domain we
>> > are
>> > not getting the reports, instead it is showing Page Cannot be
>> > Displayed.
>> As
>> > mentioned in this group v tried changing the url in
>> RSWebApplication.config.
>> > still v r getting the same error.
>> >
>> > Can any one please help us. As we are developing a corporate
>> > application
>> it
>> > is very urgent.
>> >
>> >
>>|||Hi,
Thanks!! it was really helpful.
This was the answer i was looking for "If that's not done, it's not possible."
Best Regards
Bigil Kuriyan
"Jeff A. Stucker" wrote:
> Talk to your IT person about mapping an internet DNS address (or public IP
> address) to the report server. If that's not done, it's not possible.
> Whatever the IT guy tells you is the correct address, put that in the config
> file.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "Bigil" <Bigil@.discussions.microsoft.com> wrote in message
> news:626225B4-BDF0-45B9-81F9-93E5573F195F@.microsoft.com...
> > Hi,
> >
> > Tanks for de reply, but it culd'nt solve the issue, u have asked me to
> > give
> >> <UI>
> >> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> >> </UI>
> > right, since reporting services isnstalled on a localmachine "MC230" how
> > should i give the url "http://MC230/ReportServer"'? how will this b
> > recognized on internet
> >
> > "saglamtimur" wrote:
> >
> >> The Reporting Services setup program assumes that you will be accessing
> >> the
> >> Reports website using an address similar to http://servername/Reports.
> >> This
> >> works fine inside your network, but it probably isn't going to work well
> >> if
> >> you want to make the Reports website available from outside your network.
> >>
> >> In this case you should make a change to the RSWebApplication.config
> >> file.
> >>
> >> Find lines like
> >>
> >> <Configuration>
> >> <UI>
> >> <ReportServerUrl>http://servername/ReportServer</ReportServerUrl>
> >> </UI>
> >>
> >> and replace <ReportServerUrl></ReportServerUrl> parameter like
> >>
> >> <Configuration>
> >> <UI>
> >>
> >> <ReportServerUrl>http://www.MyRSServer.com/ReportServer</ReportServerUrl>
> >> </UI>
> >>
> >> you can write servers IP too, like http://212.212.222.222/ReportServer
> >>
> >> After this change you may need to restart the IIS service for this change
> >> to
> >> take effect.
> >>
> >>
> >> "Bigil" <Bigil@.discussions.microsoft.com> wrote in message
> >> news:37C202DC-B311-4A79-8556-97A966FBE756@.microsoft.com...
> >> > We have deployed our reports on a local machine say "MC230" which is
> >> > the
> >> > local intranet. Now we have created a asp.net page and given a link to
> >> > one
> >> of
> >> > the reports by mentioning "MC230" in the URL of the link. After hosting
> >> this
> >> > page on out web site, we are able to take the reports by clicking the
> >> > link
> >> in
> >> > the local intranet. But when v take the reports out side the domain we
> >> > are
> >> > not getting the reports, instead it is showing Page Cannot be
> >> > Displayed.
> >> As
> >> > mentioned in this group v tried changing the url in
> >> RSWebApplication.config.
> >> > still v r getting the same error.
> >> >
> >> > Can any one please help us. As we are developing a corporate
> >> > application
> >> it
> >> > is very urgent.
> >> >
> >> >
> >>
> >>
> >>
>
>
Reports broke from remote
Recently this one report errors as below when running on any machine except
the actual server hosting the
reporting services.
a.. An error has occurred during report processing.
a.. Cannot create a connection to data source 'databasename.
a.. For more information about this error navigate to the report
server on the local server machine, or enable remote errors
They did recently change the name of the machine hosting the datasource, but
it shows up OK
in RS config manager.
Anything else I could look at?
Regards
CTCheck out the credentials for the report datasource. I always use shared
datasources but perhaps this report uses a report specific datasource that
has a problem.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MSNewsGroup" <Cal@.obded.org> wrote in message
news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
> Hello
> Recently this one report errors as below when running on any machine
> except the actual server hosting the
> reporting services.
> a.. An error has occurred during report processing.
> a.. Cannot create a connection to data source 'databasename.
> a.. For more information about this error navigate to the report
> server on the local server machine, or enable remote errors
> They did recently change the name of the machine hosting the datasource,
> but it shows up OK
> in RS config manager.
> Anything else I could look at?
> Regards
> CT
>|||Could that be if it works on the machine hosting RS?
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:e3Ywj7s0HHA.464@.TK2MSFTNGP02.phx.gbl...
> Check out the credentials for the report datasource. I always use shared
> datasources but perhaps this report uses a report specific datasource that
> has a problem.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "MSNewsGroup" <Cal@.obded.org> wrote in message
> news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> Recently this one report errors as below when running on any machine
>> except the actual server hosting the
>> reporting services.
>> a.. An error has occurred during report processing.
>> a.. Cannot create a connection to data source 'databasename.
>> a.. For more information about this error navigate to the report
>> server on the local server machine, or enable remote errors
>> They did recently change the name of the machine hosting the datasource,
>> but it shows up OK
>> in RS config manager.
>> Anything else I could look at?
>> Regards
>> CT
>|||It depends on how the credentials are configured. Check and see if it is
using a shared datasource or report datasource. If report datasource compare
how its credentials are setup compared to a report datasource/shared
datasource that works.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"MSNewsGroup" <Cal@.obded.org> wrote in message
news:%23ag1lpt0HHA.4824@.TK2MSFTNGP02.phx.gbl...
> Could that be if it works on the machine hosting RS?
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:e3Ywj7s0HHA.464@.TK2MSFTNGP02.phx.gbl...
>> Check out the credentials for the report datasource. I always use shared
>> datasources but perhaps this report uses a report specific datasource
>> that has a problem.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "MSNewsGroup" <Cal@.obded.org> wrote in message
>> news:eYZ0uws0HHA.3848@.TK2MSFTNGP03.phx.gbl...
>> Hello
>> Recently this one report errors as below when running on any machine
>> except the actual server hosting the
>> reporting services.
>> a.. An error has occurred during report processing.
>> a.. Cannot create a connection to data source 'databasename.
>> a.. For more information about this error navigate to the report
>> server on the local server machine, or enable remote errors
>> They did recently change the name of the machine hosting the datasource,
>> but it shows up OK
>> in RS config manager.
>> Anything else I could look at?
>> Regards
>> CT
>>
>
Wednesday, March 7, 2012
ReportingServicesCompression.dll error
not a local administrator on the machine running reporting services. If the
user is a local administrator, the report will run. The user that is not a
local administrator is able to run the report after the local administrator
user has run the report.
It appears a local administrator has to get a dll loaded first before a
non-local administrator can run the report.
The error received is:
An unexpected error occurred in Report Processing. (rsInternalError) Get
Online Help Unable to load DLL (ReportingServicesCompression.dll).
The log file for reporting services contains the following:
w3wp!processing!d94!11/05/2004-08:56:02:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing., ;
Info:
Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An
unexpected error occurred in Report Processing. -->
System.DllNotFoundException: Unable to load DLL
(ReportingServicesCompression.dll).
at
Microsoft.ReportingServices.Diagnostics.CompressUtil.inflateInit_(z_stream
strm, String version, Int32 stream_size)
at Microsoft.ReportingServices.Diagnostics.CompressUtil.UnCompress(Byte[]
input, Int32 outputBufferLength, Byte[]& output)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.Uncompress(Byte[]
compressedBuffer, Int32 uncompressedBufferLength, Byte[]& uncompressedBuffer)
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.ReadAndUncompressBuffer()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream.FillBuffer()
at
Microsoft.ReportingServices.Library.BufferedCompressedReadStream..ctor(Stream
store)
at
Microsoft.ReportingServices.Library.SnapshotChunkStreamFactory.CreateReadStream(Guid
snapshotDataID, Boolean isPermanentSnapshot, String chunkName, Int32
chunkType, String& mimeType)
at
Microsoft.ReportingServices.Library.ReportSnapshot.GetReportChunk(String
name, ReportChunkTypes type, String& mimeType)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext
reportContext, GetReportChunk getCompiledDefinitionCallback,
SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection
dataSources, Boolean checkIfUsable, ServerDataSourceSettings
serverDatasourceSettings)
Please advise.Hi,
Thanks for your post.
From your descriptions, I understood that you will have to view the report
by local administartor first to load DLL file, otherwise it will be error.
Have I understood you? Correct me if I was wrong.
It seems to be a permission issue and please make sure that non-local
administrator user was content manager ("New Role Assignment" in Report
Manager's Properties). Try to initial view the report with the non-local
administrator again and let me now whether it works this time.
If it doesn't work, please show me the detailed descriptions about your
sceanrio, such as remote access or local access, how do you change the user
to view the reports.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||We have an IIS Server running Reporting Services (machine "RS") with the
report published to it.
User "A" is a domain user on the network and logs onto computer "Computer A"
on the local intranet. User "A" does not have administrative priviledges on
machine "RS". User "A" is a Content Manager.
User "B" is a domain user on the network and logs onto "Computer B" on the
local intranet. User "B" has administrative priviledges on machine "RS"
User "A" runs the report on "Computer A" and the error is received.
User "B" runs the report on "Computer B" and it runs fine. User "A" on
"Computer A" can now run the report also.
The report uses a shared data source. The security on the shared data
source is
"Credentials stored securely in the Report Server" - "User as Windows
credentials when connecting to the data source" - "Impersonate the
authenticated user after a connection has been made to the data source". The
user specified is a domain user who is an administrator on "Computer RS"
""Michael Cheng [MSFT]"" wrote:
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you will have to view the report
> by local administartor first to load DLL file, otherwise it will be error.
> Have I understood you? Correct me if I was wrong.
> It seems to be a permission issue and please make sure that non-local
> administrator user was content manager ("New Role Assignment" in Report
> Manager's Properties). Try to initial view the report with the non-local
> administrator again and let me now whether it works this time.
> If it doesn't work, please show me the detailed descriptions about your
> sceanrio, such as remote access or local access, how do you change the user
> to view the reports.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>
>|||Hi,
I am looking into this issue, I will update you as soon as possible when I
find anything valueable.
Thank you for your patience and corporation.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi,
What kind of Reporting Server you are using now? Is it Reporting
ServicesSP1 (8.0.878)? Go to the report server virtual directory and see
what version number it says.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi,
I am currently standing by for an update from you and would like to know
how things are going there. Should you have any questions or concerns on
the recent questions/ information I've posted, please don't hesitate to let
me know directly. It's my pleasure to be of assistance
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Reportingservice2005 is not defined, Please how to webreference it
I have rs2005 on my machine, how can i do the webreference to Reportingservice2005.asmx
Dim rs As New ReportingService2005
I am getting an error when i am using the above dim statement, it says reportingservice2005 is not defined.
Please help thank you very much.
Where are you calling the web service from?
If it's from a VS solution (Web or forms) then you need to add the web reference there so it can create the proxy file.
|||To add a Web Reference in Visual Studio follow the steps listed on MSDN:
http://msdn2.microsoft.com/en-us/library/d9w023sx.aspx
The Url of the ReportingService2005.asmx will be in the ReportServer virtual directory, which is installed by default at http://<servername>/reportserver/reportingservice2005.asmx. If the ReportServer Url was changed you can find it by using the Reporting Services Configuration app.
HTH, Jason Tremper
|||Hello Jason,
I am using VS 2003 with RS 2005, and trying to webreference Reportingservice2005, but i don't find it
i do find just reportservice.asmx instead,
I used the reportingservice.asmx and it does work without anyproblem, but the report does'nt get displayed at all am i doing something wrong:
here is my code:
Dim rs As New ReportingService
Dim LogonCredentials As System.Net.NetworkCredential
Dim Items As CatalogItem
LogonCredentials = New System.Net.NetworkCredential("username", "password", "mydomainname")
rs.Credentials = LogonCredentials
'rs.Credentials = System.Net.CredentialCache.DefaultCredentials
rs.PreAuthenticate = True
' Render arguments
Dim result As Byte() = Nothing
Dim reportPath As String = "/PCSnetReports/StatusReport"
Dim format As String = "MHTML"
Dim historyID As String = Nothing
Dim devInfo As String = "<DeviceInfo><Toolbar>False</Toolbar></DeviceInfo>"
' Prepare report parameter.
Dim parameters(1) As ParameterValue
parameters(0) = New ParameterValue
parameters(0).Name = "eStatus"
parameters(0).Value = "All"
parameters(1) = New ParameterValue
parameters(1).Name = "UserName"
parameters(1).Value = "johnsmith" ' June
Dim credentials As DataSourceCredentials() = Nothing
Dim showHideToggle As String = Nothing
Dim encoding As String
Dim mimeType As String
Dim warnings As Warning() = Nothing
Dim reportHistoryParameters As ParameterValue() = Nothing
Dim streamIDs As String() = Nothing
Dim sh As New SessionHeader
rs.SessionHeaderValue = sh
Try
result = rs.Render(reportPath, format, historyID, devInfo, parameters, _
credentials, showHideToggle, encoding, mimeType, reportHistoryParameters, warnings, streamIDs)
sh.SessionId = rs.SessionHeaderValue.SessionId
Console.WriteLine("SessionID after call to Render: {0}", rs.SessionHeaderValue.SessionId)
Console.WriteLine("Execution date and time: {0}", rs.SessionHeaderValue.ExecutionDateTime)
Console.WriteLine("Is new execution: {0}", rs.SessionHeaderValue.IsNewExecution)
Catch e1 As SoapException
Console.WriteLine(e1.Detail.OuterXml)
End Try
' Write the contents of the report to an MHTML file.
Try
Dim stream As FileStream = File.Create("report.mhtml", result.Length)
Console.WriteLine("File created.")
stream.Write(result, 0, result.Length)
Console.WriteLine("Result written to the file.")
stream.Close()
Catch e2 As Exception
Console.WriteLine(e2.Message)
End Try
Monday, February 20, 2012
Reporting Services, Sharepoint and MOM on Windows Server 2003
I have just installed the SQL Server 2000 Reporting Services on the Windows
Server 2003 (non-DC).
My machine already has MOM 2005 Evaluation and the Sharepoint services
installed. I followed and did all the necessary changes written out in the
setup documentation in order for RS to live with Sharepoint.
Installation of RS with all the default options went fine, however neither
http://localhost/ReportServer nor http://localhost/Reports runs normally.
1) The ReportServer only gives me the lines:
localhost/ReportServer - /
----
----
Microsoft SQL Server Reporting Services Version 8.00.743.00
2) And the Report Manager gives me:
Server Error in '/Reports' Application.
----
Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\global.asax" is denied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Exception Details: System.UnauthorizedAccessException: Access to the path
"C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\global.asax" is denied.
ASP.NET is not authorized to access the requested resource. Consider
granting access rights to the resource to the ASP.NET request identity.
ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5 or
Network Service on IIS 6) that is used if the application is not
impersonating. If the application is impersonating via <identity
impersonate="true"/>, the identity will be the anonymous user (typically
IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET write access to a file, right-click the file in Explorer,
choose "Properties" and select the Security tab. Click "Add" to add the
appropriate user or group. Highlight the ASP.NET account, and check the
boxes for the desired access.
Source Error:
An unhandled exception was generated during the execution of the current web
request. Information regarding the origin and location of the exception can
be identified using the exception stack trace below.
Stack Trace:
[UnauthorizedAccessException: Access to the path "C:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportManager\global.asax" is denied.]
System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize, Boolean useAsync, String msgPath, Boolean
bFromProxy) +888
System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access,
FileShare share, Int32 bufferSize) +44
System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean
detectEncodingFromByteOrderMarks, Int32 bufferSize) +79
System.Web.UI.Util.ReaderFromFile(String filename, HttpContext context,
String configPath) +443
System.Web.UI.TemplateParser.ParseFile(String filename, String
virtualPath) +62
System.Web.UI.TemplateParser.Parse() +200
System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation() +74
System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean
fCreateIfNotFound) +189
System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath() +125
System.Web.UI.TemplateParser.GetParserCacheItem() +87
System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String
inputFile, HttpContext context, ApplicationFileParser& parser) +171
System.Web.HttpApplicationFactory.CompileApplication(HttpContext context)
+43
System.Web.HttpApplicationFactory.Init(HttpContext context) +485
System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
context) +170
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414
----
Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET
Version:1.1.4322.2032
What's wrong?
MantvydasSeems to have solved it myself. I just messed with the Application Pools
most probably.
I have put the Reports Virtual Directory to MSSharePointAppPool and
everything came to normal.
Mantvydas
"Mantvis" <mantvydas at delfi dot lt> wrote in message
news:u7cewq7rEHA.4004@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I have just installed the SQL Server 2000 Reporting Services on the
> Windows Server 2003 (non-DC).
> My machine already has MOM 2005 Evaluation and the Sharepoint services
> installed. I followed and did all the necessary changes written out in the
> setup documentation in order for RS to live with Sharepoint.
> Installation of RS with all the default options went fine, however neither
> http://localhost/ReportServer nor http://localhost/Reports runs normally.
> 1) The ReportServer only gives me the lines:
> localhost/ReportServer - /
> ----
> ----
> Microsoft SQL Server Reporting Services Version 8.00.743.00
> 2) And the Report Manager gives me:
> Server Error in '/Reports' Application.
> ----
> Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\global.asax" is denied.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Exception Details: System.UnauthorizedAccessException: Access to the path
> "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\global.asax" is denied.
> ASP.NET is not authorized to access the requested resource. Consider
> granting access rights to the resource to the ASP.NET request identity.
> ASP.NET has a base process identity (typically {MACHINE}\ASPNET on IIS 5
> or Network Service on IIS 6) that is used if the application is not
> impersonating. If the application is impersonating via <identity
> impersonate="true"/>, the identity will be the anonymous user (typically
> IUSR_MACHINENAME) or the authenticated request user.
> To grant ASP.NET write access to a file, right-click the file in Explorer,
> choose "Properties" and select the Security tab. Click "Add" to add the
> appropriate user or group. Highlight the ASP.NET account, and check the
> boxes for the desired access.
> Source Error:
> An unhandled exception was generated during the execution of the current
> web request. Information regarding the origin and location of the
> exception can be identified using the exception stack trace below.
> Stack Trace:
>
> [UnauthorizedAccessException: Access to the path "C:\Program
> Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\global.asax" is denied.]
> System.IO.__Error.WinIOError(Int32 errorCode, String str) +393
> System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
> access, FileShare share, Int32 bufferSize, Boolean useAsync, String
> msgPath, Boolean bFromProxy) +888
> System.IO.FileStream..ctor(String path, FileMode mode, FileAccess
> access, FileShare share, Int32 bufferSize) +44
> System.IO.StreamReader..ctor(String path, Encoding encoding, Boolean
> detectEncodingFromByteOrderMarks, Int32 bufferSize) +79
> System.Web.UI.Util.ReaderFromFile(String filename, HttpContext context,
> String configPath) +443
> System.Web.UI.TemplateParser.ParseFile(String filename, String
> virtualPath) +62
> System.Web.UI.TemplateParser.Parse() +200
> System.Web.UI.TemplateParser.GetParserCacheItemThroughCompilation() +74
> System.Web.UI.TemplateParser.GetParserCacheItemInternal(Boolean
> fCreateIfNotFound) +189
> System.Web.UI.TemplateParser.GetParserCacheItemWithNewConfigPath() +125
> System.Web.UI.TemplateParser.GetParserCacheItem() +87
> System.Web.UI.ApplicationFileParser.GetCompiledApplicationType(String
> inputFile, HttpContext context, ApplicationFileParser& parser) +171
> System.Web.HttpApplicationFactory.CompileApplication(HttpContext
> context) +43
> System.Web.HttpApplicationFactory.Init(HttpContext context) +485
> System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext
> context) +170
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +414
>
>
> ----
> Version Information: Microsoft .NET Framework Version:1.1.4322.2032;
> ASP.NET Version:1.1.4322.2032
> What's wrong?
> Mantvydas
>