Showing posts with label manager. Show all posts
Showing posts with label manager. Show all posts

Monday, March 26, 2012

ReportServerUrl element is not a valid configuration file element

Hi,

I get the error specified in the subject

"ReportServerUrl element is not a valid configuration file element"

ini the report manager if I replace

<ReportServerUrl></ReportServerUrl>

tags in RSWebApplication.cofig file with

<ReportServerUrl>http://<computername>/ReportServer</ReportServerUrl>

Any ideas why I should get that?. If the element was not valid, it should not have worked even earlier?

Thanks.

Have you also set ReportServerVirtualDirectory ?
Take a look at: http://msdn2.microsoft.com/en-us/library/ms155878.aspx

ReportServerURL and ReportServerVirtualDirectory are mutually exclusive. If you specify ReportServerURL, you must delete the entry for ReportServerVirtualDirectory

Friday, March 23, 2012

Reportserver front end

Hi,
I am new to MS reporting services and after installing Reporting
services and having had a look at it briefly the Report Manager
(http://localhost/Reports/Pages/Folder.aspx) has a pretty decent front
end, but the Report Server (http://localhost/reportserver/) from where
users select reports has pretty dismal front end. Am I missing the
point or is this for us to develop' Please help! I dont want to
develop a front end if this has already be done or I have missed the
user front end altogether. My users wont want to see "<ds>
DataSource1" for example.
Thanks.Hi David:
The Report Manager (/Reports/) is the front end for SSRS. Send the
users to the Report Manager unless you do build a custom front end.
The report server (/reportserver/) doesn't really present much of a UI
unless you send the user to the report server with commands in the
query string (this is known as URL access).
For example:
http://localhost/reportserver?/SampleReports/Sales+Order+Detail&rs:Command=Render&rc:Zoom=110
When the report server sees this incoming URL it knows to render the
report for the user, and the rendering engine knows to zoom the report
to 110%. There is also a web service exposed by the web server if you
want programattic access to all the features of SSRS.
--
Scott
http://www.OdeToCode.com/blogs/scott/
On 18 Oct 2004 14:42:44 -0700, davidagnew37@.hotmail.com (David) wrote:
>Hi,
>I am new to MS reporting services and after installing Reporting
>services and having had a look at it briefly the Report Manager
>(http://localhost/Reports/Pages/Folder.aspx) has a pretty decent front
>end, but the Report Server (http://localhost/reportserver/) from where
>users select reports has pretty dismal front end. Am I missing the
>point or is this for us to develop' Please help! I dont want to
>develop a front end if this has already be done or I have missed the
>user front end altogether. My users wont want to see "<ds>
>DataSource1" for example.
>Thanks.

Wednesday, March 21, 2012

ReportServer component is not showing during installaion

when i try to install Sql Server 2000 reporting services setup on XP then it shows me client components only.Report Server and report manager component is not showing.Due to this i am unable to run the report project using report server.It gives a messege "No Reprot Server was found at http://localhost/ReprotServer".How can i installed report server.

Can you check if IIS is installed? The below link might give you some more info.

http://www.microsoft.com/technet/prodtechnol/sql/2000/deploy/rsdepgd.mspx

Thanks,
Sharmila

|||Thanks Sharmila....

Reports work, Reports Manager not

I've done a number of RS installs, this one is on a new 2003 server. I have
VS.NET on the computer and can develop and deploy successfully.
I can view the report from VS.NET preview or using IE, typing
http://localhost/ReportServer?/yada/yada
However if I want to run Reports Manager, typing http://localhost/Reports
then I get an error,
Access denied to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\ReportManager\BIN'. Failed to start monitoring file changes.
I've changed permissions on the folder and the ReportServer service is now
started with the Admin account, no success yet.It is fixed now. This is what I did in case it can help someone in the
future.
Un-install Reporting Services.
Use Enterprise Manager to delete the 2 Reporting Services databases, the
un-install did not.
Delete the C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services
directory and sub-directories.
Install again.
"Chris Botha" <chris_s_botha@.AThotmail.com> wrote in message
news:#5EIp0$HFHA.2564@.tk2msftngp13.phx.gbl...
> I've done a number of RS installs, this one is on a new 2003 server. I
have
> VS.NET on the computer and can develop and deploy successfully.
> I can view the report from VS.NET preview or using IE, typing
> http://localhost/ReportServer?/yada/yada
> However if I want to run Reports Manager, typing http://localhost/Reports
> then I get an error,
> Access denied to 'C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\ReportManager\BIN'. Failed to start monitoring file changes.
> I've changed permissions on the folder and the ReportServer service is now
> started with the Admin account, no success yet.
>

Tuesday, March 20, 2012

Reports Manager does not list or manage reports...

I recently installed RS and have deployed several reports but none show up under the reports manager. Only the top toolbar folder shows home.
Setup:
ReportServer: local administrator
ReportServer Database: SQL User auth.
Windows 2003
SQL 2000
Any Ideas?Sounds like you are accessing the server with an account that does not have
permissions. Did you assign any security roles?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"jhines" <jhines@.discussions.microsoft.com> wrote in message
news:991D3C55-3022-4F3C-B7A8-2395D243ADDC@.microsoft.com...
>I recently installed RS and have deployed several reports but none show up
>under the reports manager. Only the top toolbar folder shows home.
> Setup:
> ReportServer: local administrator
> ReportServer Database: SQL User auth.
> Windows 2003
> SQL 2000
> Any Ideas?|||Permissions?
"jhines" <jhines@.discussions.microsoft.com> wrote in message
news:991D3C55-3022-4F3C-B7A8-2395D243ADDC@.microsoft.com...
> I recently installed RS and have deployed several reports but none show up
under the reports manager. Only the top toolbar folder shows home.
> Setup:
> ReportServer: local administrator
> ReportServer Database: SQL User auth.
> Windows 2003
> SQL 2000
> Any Ideas?

Reports Manager 400 Bad Request

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 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
>

Reports in Report Manager-drilldown

When runing a report in Report Manager I can click on an item and SQL Server provides the logic to drill down into the underlying tables. I can find no button to go back. The only way I've found to go back is to click a different tab at the top of the screen (History or something) then click View again and you get the original report. In designer there's a back button. Is there not such a button when running a saved report?

Thanks.

Never mind....D'OH

Monday, March 12, 2012

Reports (Manager) website errors with 404 and 500

Deploying reports works, Running ReportServer URL yields deployed reports
directory and reports can be run. The Reports Manager website does not run.
The redirect to http://Server/Reports/Pages/Folder.aspx shows and a Red X
Error header followed by The request failed with HTTP status 404: Not Found.
The log shows:
w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: The request failed with HTTP status
404: Not Found.
w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 404: Not Found.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at
Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname)
at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level)
at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args)
at System.EventHandler.Invoke(Object sender, EventArgs e)
at System.Web.UI.Control.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain()
w3wp!ui!7e8!6/3/2005-09:11:48:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)...
--
Keith Powers, MCDBAReport Manager can be run from Inside IIS Manager.
--
Keith Powers, MCDBA
"Keith Powers" wrote:
> Deploying reports works, Running ReportServer URL yields deployed reports
> directory and reports can be run. The Reports Manager website does not run.
> The redirect to http://Server/Reports/Pages/Folder.aspx shows and a Red X
> Error header followed by The request failed with HTTP status 404: Not Found.
> The log shows:
> w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: The request failed with HTTP status
> 404: Not Found.
> w3wp!ui!7e8!6/3/2005-09:11:46:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 404: Not Found.
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at
> Microsoft.SqlServer.ReportingServices.ReportingService.ListSecureMethods()
> at Microsoft.SqlServer.ReportingServices.RSConnection.GetSecureMethods()
> at Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname)
> at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level)
> at Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args)
> at System.EventHandler.Invoke(Object sender, EventArgs e)
> at System.Web.UI.Control.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain()
> w3wp!ui!7e8!6/3/2005-09:11:48:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)...
> --
> Keith Powers, MCDBA

Friday, March 9, 2012

ReportManager over SSL

Anyone else having problems or have solved problems, running Report Manager
over SSL?Hi,
I do have an issue with SSL and reportmanager, the reportserver interface is
fine, but reportmanager at /Reports gives
"The underlying connection was closed: Could not establish trust..." message
Am using a self-issued cert, but reportserver is OK, been through lots,
still no joy...
Chris
"Kevin Antel" <kevina@.cqlcorp.com> wrote in message
news:%23fzPiL%23MGHA.3728@.tk2msftngp13.phx.gbl...
> Anyone else having problems or have solved problems, running Report
> Manager over SSL?
>

ReportManager ok button doesn't work

ReportManager ok button doesn't work, I access the reoport manager
http://213.63.184.203/reports apperantly everything is ok. But when try to
create a new role the ok button doesn't wok. What can be wrong?
Thanks in advance
Maria JoãoI am having exactly the same problem.
When you click Ok, nothing happens. I have checked that active scripting is
on.
Is there anything that I should do?
We have only started experiencing this problem after installing sp2.
Paul
"Maria João Lima" wrote:
> ReportManager ok button doesn't work, I access the reoport manager
> http://213.63.184.203/reports apperantly everything is ok. But when try to
> create a new role the ok button doesn't wok. What can be wrong?
>
> Thanks in advance
> Maria João
>
>|||Usually this has to do with having anonoymous access enabled for the
website.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:B11EA9F5-40BE-4F98-A737-54CB793EC548@.microsoft.com...
>I am having exactly the same problem.
> When you click Ok, nothing happens. I have checked that active scripting
> is
> on.
> Is there anything that I should do?
> We have only started experiencing this problem after installing sp2.
> Paul
> "Maria João Lima" wrote:
>> ReportManager ok button doesn't work, I access the reoport manager
>> http://213.63.184.203/reports apperantly everything is ok. But when try
>> to
>> create a new role the ok button doesn't wok. What can be wrong?
>>
>> Thanks in advance
>> Maria João
>>|||Anonoymous access is disabled in IIS
Cheers
Paul
"Bruce L-C [MVP]" wrote:
> Usually this has to do with having anonoymous access enabled for the
> website.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:B11EA9F5-40BE-4F98-A737-54CB793EC548@.microsoft.com...
> >I am having exactly the same problem.
> >
> > When you click Ok, nothing happens. I have checked that active scripting
> > is
> > on.
> > Is there anything that I should do?
> >
> > We have only started experiencing this problem after installing sp2.
> >
> > Paul
> >
> > "Maria João Lima" wrote:
> >
> >> ReportManager ok button doesn't work, I access the reoport manager
> >> http://213.63.184.203/reports apperantly everything is ok. But when try
> >> to
> >> create a new role the ok button doesn't wok. What can be wrong?
> >>
> >>
> >>
> >> Thanks in advance
> >>
> >> Maria João
> >>
> >>
> >>
>
>|||Are you an administrator of the machine where RS is installed? You need to
be in the administrators group (at least initially, until you create a role
for this).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:B2DEFD3F-79BC-4B26-AD76-09AA5B180F30@.microsoft.com...
> Anonoymous access is disabled in IIS
> Cheers
> Paul
> "Bruce L-C [MVP]" wrote:
>> Usually this has to do with having anonoymous access enabled for the
>> website.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Paul" <Paul@.discussions.microsoft.com> wrote in message
>> news:B11EA9F5-40BE-4F98-A737-54CB793EC548@.microsoft.com...
>> >I am having exactly the same problem.
>> >
>> > When you click Ok, nothing happens. I have checked that active
>> > scripting
>> > is
>> > on.
>> > Is there anything that I should do?
>> >
>> > We have only started experiencing this problem after installing sp2.
>> >
>> > Paul
>> >
>> > "Maria João Lima" wrote:
>> >
>> >> ReportManager ok button doesn't work, I access the reoport manager
>> >> http://213.63.184.203/reports apperantly everything is ok. But when
>> >> try
>> >> to
>> >> create a new role the ok button doesn't wok. What can be wrong?
>> >>
>> >>
>> >>
>> >> Thanks in advance
>> >>
>> >> Maria João
>> >>
>> >>
>> >>
>>|||I was logged in as admin. We think we have found a fix now.
When browsing reports on the server it comes up with an error message
suggesting reregistering iis
C:\WINNT\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis -c
"Bruce L-C [MVP]" wrote:
> Are you an administrator of the machine where RS is installed? You need to
> be in the administrators group (at least initially, until you create a role
> for this).
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> news:B2DEFD3F-79BC-4B26-AD76-09AA5B180F30@.microsoft.com...
> > Anonoymous access is disabled in IIS
> >
> > Cheers
> > Paul
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> Usually this has to do with having anonoymous access enabled for the
> >> website.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >> "Paul" <Paul@.discussions.microsoft.com> wrote in message
> >> news:B11EA9F5-40BE-4F98-A737-54CB793EC548@.microsoft.com...
> >> >I am having exactly the same problem.
> >> >
> >> > When you click Ok, nothing happens. I have checked that active
> >> > scripting
> >> > is
> >> > on.
> >> > Is there anything that I should do?
> >> >
> >> > We have only started experiencing this problem after installing sp2.
> >> >
> >> > Paul
> >> >
> >> > "Maria João Lima" wrote:
> >> >
> >> >> ReportManager ok button doesn't work, I access the reoport manager
> >> >> http://213.63.184.203/reports apperantly everything is ok. But when
> >> >> try
> >> >> to
> >> >> create a new role the ok button doesn't wok. What can be wrong?
> >> >>
> >> >>
> >> >>
> >> >> Thanks in advance
> >> >>
> >> >> Maria João
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>

ReportManager and domain name change

Hi,
The fully qualified domain name of the reporting services server has changed
and that caused the Report Manager to stop working. Iâ'm using SQL 2000
Reporting Services on Windows Server 2003 .
I tracked the issue down to /Reports/Pages/Report.aspx page where that page
calls the actual report in a IFRAME and the IFRAME is calling the report with
the old domain name.
I found a configuration setting <UrlRoot> in the C:\Program Files\Microsoft
SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config config
file that used the old domain name. However, even changing that property to a
new domain name had no effect (tired touching web.configs, bouncing the
website).
Any suggestions greatly appreciated.
Thanks,
AlexFrom an issue I had with something similar on my CRM system here are some
notes passed on to me that I think might help you. I was changing mine from
a fullqualified domain name to a domain.local name but these would still
apply for you as well:
These instructions assume you are using SQL 2000 SP4.
First, on the server where SRS is installed, open the two files
rswebapplication.config at C:\Program Files\Microsoft SQL
Server\MSSQL\Reporting Services\ReportManager and rsreportserver.config at
C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer
with notepad and search for https://fqdn.yourdomain.com. Once you find this
replace it with https://YourNetBiosServerName.domain.local and save and
close the files.
On the same server, open the registry and modify the following registry
values at HKLM | SOFTWARE | Microsoft | Microsoft SQL Server | 80 |
Reporting Services to replace https://fqdn.yourdomain.com/ReportServer with
https://YourNetBiosServerName.domain.local/ReportServer.
RSVirtualDir - should be
https://YourNetBiosServerName.domain.local/ReportServer
WAVirtualDir - should be https://YourNetBiosServerName.domain.local/Reports
Gary
"alex" <alex@.discussions.microsoft.com> wrote in message
news:2E0195F3-5F67-4196-A119-9CDFC08656DA@.microsoft.com...
> Hi,
> The fully qualified domain name of the reporting services server has
> changed
> and that caused the Report Manager to stop working. I'm using SQL 2000
> Reporting Services on Windows Server 2003 .
> I tracked the issue down to /Reports/Pages/Report.aspx page where that
> page
> calls the actual report in a IFRAME and the IFRAME is calling the report
> with
> the old domain name.
> I found a configuration setting <UrlRoot> in the C:\Program
> Files\Microsoft
> SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config
> config
> file that used the old domain name. However, even changing that property
> to a
> new domain name had no effect (tired touching web.configs, bouncing the
> website).
> Any suggestions greatly appreciated.
> Thanks,
> Alex
>

Wednesday, March 7, 2012

ReportIoError 2 - any ideas?

Problem:
--
The following SQL is scheduled to run via Enterprise
manager. It has been successfully running for months.
BACKUP LOG [Proclaim] TO DISK = N'D:\mssql7
\backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMAT
Friday night the job failed with the log reporting:
BackupMedium::ReportIOError: write failure on backup
device 'D:\mssql7\backup\Proclaim_backup.bak'.
Operating system error 2 (error not found).
To add to the problem, the log file is now full and there
is limitted space in this D: on the server.
Configuration:
--
Operating System: Windows 2000 Server sp3
Full recovery mode.
SQL Server 2000 sp 3 (upgraded from SQL 7 12 months ago)
Hardward Raid (1) on C: (and 500MB free)
Hardware Raid (5) on D: (and 5Gb free)
Hardware Raid (1) on E: (and 6Gb free)
.mdf file = 4491MB allocated (autogrow)
.log file = 2101MB allocated (at limit)
.bak file = 4110MB
Attempted Action so far:
--
* Invoking log backup from Enterprise manager:
- to same location -> failed with same error
- to E:\ -> failed with ReportIoError 112
* Retried above after deleting existing file
D:\mssql7\backup\Proclaim_backup.bak' - no change
* Retried above after changing to bulk recovery mode.
- to same location -> failed with same error
- to E: -> successful, but log file still the same size
I've read Knowledge base article 325334; but since the
striping is hardware based on all available drives - see
no means of utilising this information.
Any suggestions would be greatly appreciated.I don't know where D:\ and E:\ are, but have you tried backing up to a
different machine?
--
http://www.aspfaq.com/
(Reverse address to reply.)
"Kim" <anonymous@.discussions.microsoft.com> wrote in message
news:2631501c46229$3f11d150$a401280a@.phx.gbl...
> Problem:
> --
> The following SQL is scheduled to run via Enterprise
> manager. It has been successfully running for months.
> BACKUP LOG [Proclaim] TO DISK = N'D:\mssql7
> \backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
> NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMAT
> Friday night the job failed with the log reporting:
> BackupMedium::ReportIOError: write failure on backup
> device 'D:\mssql7\backup\Proclaim_backup.bak'.
> Operating system error 2 (error not found).
>
> To add to the problem, the log file is now full and there
> is limitted space in this D: on the server.
>
> Configuration:
> --
> Operating System: Windows 2000 Server sp3
> Full recovery mode.
> SQL Server 2000 sp 3 (upgraded from SQL 7 12 months ago)
> Hardward Raid (1) on C: (and 500MB free)
> Hardware Raid (5) on D: (and 5Gb free)
> Hardware Raid (1) on E: (and 6Gb free)
> .mdf file = 4491MB allocated (autogrow)
> .log file = 2101MB allocated (at limit)
> .bak file = 4110MB
>
> Attempted Action so far:
> --
> * Invoking log backup from Enterprise manager:
> - to same location -> failed with same error
> - to E:\ -> failed with ReportIoError 112
> * Retried above after deleting existing file
> D:\mssql7\backup\Proclaim_backup.bak' - no change
> * Retried above after changing to bulk recovery mode.
> - to same location -> failed with same error
> - to E: -> successful, but log file still the same size
>
> I've read Knowledge base article 325334; but since the
> striping is hardware based on all available drives - see
> no means of utilising this information.
>
> Any suggestions would be greatly appreciated.|||Sounds you are out of disk space on D drive. Take the
backup of transaction log and shrink the .ldf. Don't you
take frequent transaction log backups?. If you are
concerned only about FULL and DIFFERENTIAL backups , you
can set the Database to SIMPLE recovery, so the log will
be truncated automatically.
INF: Shrinking the Transaction Log in SQL Server 2000 with
DBCC SHRINKFILE
http://support.microsoft.com/default.aspx?scid=kb;EN-
US;272318
Also look for some other pointers which tells, why the log
file grows rapidly.
Finally I think u may need to buy some Hard disks.
HTH
--
Regards
~Thirumal~
www.thirumal.com
>--Original Message--
>I don't know where D:\ and E:\ are, but have you tried
backing up to a
>different machine?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Kim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2631501c46229$3f11d150$a401280a@.phx.gbl...
>> Problem:
>> --
>> The following SQL is scheduled to run via Enterprise
>> manager. It has been successfully running for months.
>> BACKUP LOG [Proclaim] TO DISK = N'D:\mssql7
>> \backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
>> NAME = N'Proclaim backup', SKIP , STATS = 10,
NOFORMAT
>> Friday night the job failed with the log reporting:
>> BackupMedium::ReportIOError: write failure on backup
>> device 'D:\mssql7\backup\Proclaim_backup.bak'.
>> Operating system error 2 (error not found).
>>
>> To add to the problem, the log file is now full and
there
>> is limitted space in this D: on the server.
>>
>> Configuration:
>> --
>> Operating System: Windows 2000 Server sp3
>> Full recovery mode.
>> SQL Server 2000 sp 3 (upgraded from SQL 7 12 months ago)
>> Hardward Raid (1) on C: (and 500MB free)
>> Hardware Raid (5) on D: (and 5Gb free)
>> Hardware Raid (1) on E: (and 6Gb free)
>> .mdf file = 4491MB allocated (autogrow)
>> .log file = 2101MB allocated (at limit)
>> .bak file = 4110MB
>>
>> Attempted Action so far:
>> --
>> * Invoking log backup from Enterprise manager:
>> - to same location -> failed with same error
>> - to E:\ -> failed with ReportIoError 112
>> * Retried above after deleting existing file
>> D:\mssql7\backup\Proclaim_backup.bak' - no change
>> * Retried above after changing to bulk recovery mode.
>> - to same location -> failed with same error
>> - to E: -> successful, but log file still the same size
>>
>> I've read Knowledge base article 325334; but since the
>> striping is hardware based on all available drives - see
>> no means of utilising this information.
>>
>> Any suggestions would be greatly appreciated.
>
>.
>|||I've only ever backed up to the local PC. I use the
Enterprise Manager GUI to generate the SQL as a scheduled
job - then modify the schedule as required. The GUI will
not list mapped network drives - so I'd assumed that it
wasn't possible to back up to an external machine.
In any case, Our only other Windows 2000 server has
exactly the same RAID settings.
I have got around the immediate problem by:
* increasing the ldf file by 500MB
* backing up the transaction log to the E: (which has Raid
1).
* using DBCC SHRINKFILE to reduce the ldf file size.
* Deleting the file 'D:\mssql7\backup\Proclaim_backup.bak'
* Rerunning the backups through Enterprise Manager.
I still don't really understand what ReportIoError 2
means. I can only assume that it is related somehow to
the striping because of Q325334.
As a consequence I've no idea whether the problem will
continue and in what timeframe. (I work in an IT
department of 3, and we support a number of disparate
platforms. My colleagues know even less about SQL Server
than I do - so I want to avoid this situation recurring in
my absence).
Thanks for your assistance.
Kim.
>--Original Message--
>I don't know where D:\ and E:\ are, but have you tried
backing up to a
>different machine?
>--
>http://www.aspfaq.com/
>(Reverse address to reply.)
>
>
>"Kim" <anonymous@.discussions.microsoft.com> wrote in
message
>news:2631501c46229$3f11d150$a401280a@.phx.gbl...
>> Problem:
>> --
>> The following SQL is scheduled to run via Enterprise
>> manager. It has been successfully running for months.
>> BACKUP LOG [Proclaim] TO DISK = N'D:\mssql7
>> \backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
>> NAME = N'Proclaim backup', SKIP , STATS = 10,
NOFORMAT
>> Friday night the job failed with the log reporting:
>> BackupMedium::ReportIOError: write failure on backup
>> device 'D:\mssql7\backup\Proclaim_backup.bak'.
>> Operating system error 2 (error not found).
>>
>> To add to the problem, the log file is now full and
there
>> is limitted space in this D: on the server.
>>
>> Configuration:
>> --
>> Operating System: Windows 2000 Server sp3
>> Full recovery mode.
>> SQL Server 2000 sp 3 (upgraded from SQL 7 12 months ago)
>> Hardward Raid (1) on C: (and 500MB free)
>> Hardware Raid (5) on D: (and 5Gb free)
>> Hardware Raid (1) on E: (and 6Gb free)
>> .mdf file = 4491MB allocated (autogrow)
>> .log file = 2101MB allocated (at limit)
>> .bak file = 4110MB
>>
>> Attempted Action so far:
>> --
>> * Invoking log backup from Enterprise manager:
>> - to same location -> failed with same error
>> - to E:\ -> failed with ReportIoError 112
>> * Retried above after deleting existing file
>> D:\mssql7\backup\Proclaim_backup.bak' - no change
>> * Retried above after changing to bulk recovery mode.
>> - to same location -> failed with same error
>> - to E: -> successful, but log file still the same size
>>
>> I've read Knowledge base article 325334; but since the
>> striping is hardware based on all available drives - see
>> no means of utilising this information.
>>
>> Any suggestions would be greatly appreciated.
>
>.
>|||Context
--
The first of the failed log backups was run after a series
of indexes on the database were rebuilt.
Recovery mode is changed to "bulk-logged" before rebuiding
indexes. This is followed by the log backup and then
recovery mode is changed back to "full".
Additional Error Messages in SQL Server Log
---
BackupMedium::ReportIoError: write failure on backup
device 'D:\mssql7\backup\Proclaim_backup.bak'. Operating
system error 2(error not found).
Internal I/O request 0x2E45D1A8: Op: Write, pBuffer:
0x3BE50000, Size: 65536, Position: 4293497344, UMS:
Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFE99200,
OffsetHigh: 0x0, m_buf: 0x3BE50000, m_len: 65536,
m_actualBytes: 0, m_errcode: 2, BackupFile: D:\mssql7
\backup\Proclaim_backup.bak
BACKUP failed to complete the command BACKUP LOG
[Proclaim] TO DISK = N'D:\mssql7
\backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMAT|||Thanks for the suggestions. It's hard to think of all the
relevant info to post when asking the question.
* The job that should back up the transaction log is the
job that failed. Attempts to back up the transaction log
via other means (as listed) also failed.
* We have limited space on all 3 drives. On both D: and
E: there is the equivalent of the existing database size
free however (figures in original post).
* The transaction log is backed up 6 times during a
working day, and once each weekend.
* Recovery mode is "full" except for when one scheduled
script is run each weekend. It rebuilds indices so before
it is run recovery mode is changed to "bulk logged". The
log backup following this task was the first to fail.
>--Original Message--
>Sounds you are out of disk space on D drive. Take the
>backup of transaction log and shrink the .ldf. Don't you
>take frequent transaction log backups?. If you are
>concerned only about FULL and DIFFERENTIAL backups , you
>can set the Database to SIMPLE recovery, so the log will
>be truncated automatically.
>INF: Shrinking the Transaction Log in SQL Server 2000
with
>DBCC SHRINKFILE
>http://support.microsoft.com/default.aspx?scid=kb;EN-
>US;272318
>Also look for some other pointers which tells, why the
log
>file grows rapidly.
>Finally I think u may need to buy some Hard disks.
>HTH
>--
>Regards
>~Thirumal~
>www.thirumal.com
>>--Original Message--
>>I don't know where D:\ and E:\ are, but have you tried
>backing up to a
>>different machine?
>>--
>>http://www.aspfaq.com/
>>(Reverse address to reply.)
>>
>>
>>"Kim" <anonymous@.discussions.microsoft.com> wrote in
>message
>>news:2631501c46229$3f11d150$a401280a@.phx.gbl...
>> Problem:
>> --
>> The following SQL is scheduled to run via Enterprise
>> manager. It has been successfully running for months.
>> BACKUP LOG [Proclaim] TO DISK = N'D:\mssql7
>> \backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
>> NAME = N'Proclaim backup', SKIP , STATS = 10,
>NOFORMAT
>> Friday night the job failed with the log reporting:
>> BackupMedium::ReportIOError: write failure on backup
>> device 'D:\mssql7\backup\Proclaim_backup.bak'.
>> Operating system error 2 (error not found).
>>
>> To add to the problem, the log file is now full and
>there
>> is limitted space in this D: on the server.
>>
>> Configuration:
>> --
>> Operating System: Windows 2000 Server sp3
>> Full recovery mode.
>> SQL Server 2000 sp 3 (upgraded from SQL 7 12 months
ago)
>> Hardward Raid (1) on C: (and 500MB free)
>> Hardware Raid (5) on D: (and 5Gb free)
>> Hardware Raid (1) on E: (and 6Gb free)
>> .mdf file = 4491MB allocated (autogrow)
>> .log file = 2101MB allocated (at limit)
>> .bak file = 4110MB
>>
>> Attempted Action so far:
>> --
>> * Invoking log backup from Enterprise manager:
>> - to same location -> failed with same error
>> - to E:\ -> failed with ReportIoError 112
>> * Retried above after deleting existing file
>> D:\mssql7\backup\Proclaim_backup.bak' - no change
>> * Retried above after changing to bulk recovery mode.
>> - to same location -> failed with same error
>> - to E: -> successful, but log file still the same size
>>
>> I've read Knowledge base article 325334; but since the
>> striping is hardware based on all available drives -
see
>> no means of utilising this information.
>>
>> Any suggestions would be greatly appreciated.
>>
>>.
>.
>|||Hi Kim,
When ever you perform a recovery model change, it is always suggested to do
a full database backup and
then goahead with Transaction log backup.
This I/O issue can araises due to free space in hard disk, permissions on
the disk.
Thanks
Hari
MCDBA
"Kim" <anonymous@.discussions.microsoft.com> wrote in message
news:25bce01c46248$42024970$a601280a@.phx.gbl...
> Context
> --
> The first of the failed log backups was run after a series
> of indexes on the database were rebuilt.
> Recovery mode is changed to "bulk-logged" before rebuiding
> indexes. This is followed by the log backup and then
> recovery mode is changed back to "full".
>
> Additional Error Messages in SQL Server Log
> ---
> BackupMedium::ReportIoError: write failure on backup
> device 'D:\mssql7\backup\Proclaim_backup.bak'. Operating
> system error 2(error not found).
> Internal I/O request 0x2E45D1A8: Op: Write, pBuffer:
> 0x3BE50000, Size: 65536, Position: 4293497344, UMS:
> Internal: 0x103, InternalHigh: 0x0, Offset: 0xFFE99200,
> OffsetHigh: 0x0, m_buf: 0x3BE50000, m_len: 65536,
> m_actualBytes: 0, m_errcode: 2, BackupFile: D:\mssql7
> \backup\Proclaim_backup.bak
> BACKUP failed to complete the command BACKUP LOG
> [Proclaim] TO DISK = N'D:\mssql7
> \backup\Proclaim_backup.bak' WITH NOINIT , NOUNLOAD ,
> NAME = N'Proclaim backup', SKIP , STATS = 10, NOFORMAT|||Thanks for the suggestion.
I'll add a full backup to the scheduled job before and
after the recovery mode change and see if the issue
persists.

ReportingServic process memory consumption

Hi in my task manager i notice that ReportingServic process has been building
up in memory consumption. Is this supposed to happen?Running reports in SQL 2k and in the future Yukon require that the entire
data set be instantiated in memory... In my opinion this is a shortcoming of
the product, since you can (and maybe will) get out of memory errors, and
IIS will reset the task.
The data must be in memory so that grouping and sorting in the report can
occur... In future versions I expect that MS will add some functionality to
allow the "plan" to become smarter to use a firehose cursor under conditions
which require no grouping or sorting outside of the database query.
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"Marvin" <Marvin@.discussions.microsoft.com> wrote in message
news:AA003D3E-0B3F-4F59-9B9E-0F1C9645B115@.microsoft.com...
> Hi in my task manager i notice that ReportingServic process has been
> building
> up in memory consumption. Is this supposed to happen?|||So the dataset stays in memory? Is there a way to release it after a certain
amount of time?
"Wayne Snyder" wrote:
> Running reports in SQL 2k and in the future Yukon require that the entire
> data set be instantiated in memory... In my opinion this is a shortcoming of
> the product, since you can (and maybe will) get out of memory errors, and
> IIS will reset the task.
> The data must be in memory so that grouping and sorting in the report can
> occur... In future versions I expect that MS will add some functionality to
> allow the "plan" to become smarter to use a firehose cursor under conditions
> which require no grouping or sorting outside of the database query.
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> (Please respond only to the newsgroup.)
> I support the Professional Association for SQL Server ( PASS) and it's
> community of SQL Professionals.
> "Marvin" <Marvin@.discussions.microsoft.com> wrote in message
> news:AA003D3E-0B3F-4F59-9B9E-0F1C9645B115@.microsoft.com...
> > Hi in my task manager i notice that ReportingServic process has been
> > building
> > up in memory consumption. Is this supposed to happen?
>
>

Monday, February 20, 2012

Reporting Services: Role Assignment without using Report Manager

Hello,

I'm having some problems using the Report Manager, but I *really* need
to make a role assignment now. Can't wait to have the problem with
Report Manager solved.
So, I would like to make this role assignment directly in the
ReportServer database, using the SP SetPolicy or some other SP.

I'm looking for the equivalent of making the "New Role Assignment" and
then
Group or user name: Everyone
Role "Browser" checked
OK

Can anyone tell me exactly how to do this?

Thanks in advance,

Filipe Henriques

PS: By the way, the problem I've got using the Report Manager is that
always appear "The request failed with HTTP status 404: Not Found.",
although I can see perfectly the Report Server page.
Does anyone knows what's the problem?"Filipe Henriques" <filipehenriquespt@.hotmail.com> wrote in message
news:f545f620.0410080044.7ca7b54e@.posting.google.c om...
> Hello,
> I'm having some problems using the Report Manager, but I *really* need
> to make a role assignment now. Can't wait to have the problem with
> Report Manager solved.
> So, I would like to make this role assignment directly in the
> ReportServer database, using the SP SetPolicy or some other SP.
> I'm looking for the equivalent of making the "New Role Assignment" and
> then
> Group or user name: Everyone
> Role "Browser" checked
> OK
> Can anyone tell me exactly how to do this?
> Thanks in advance,
> Filipe Henriques
>
> PS: By the way, the problem I've got using the Report Manager is that
> always appear "The request failed with HTTP status 404: Not Found.",
> although I can see perfectly the Report Server page.
> Does anyone knows what's the problem?

You might want to try posting this in
microsoft.public.sqlserver.reportingsvcs.

Simon|||>
> You might want to try posting this in
> microsoft.public.sqlserver.reportingsvcs.
> Simon

Already did.
No luck yet.|||Ok, I found this link:

http://blogs.msdn.com/bryanke/archi...3/17/91736.aspx

for "Sample Script for Setting Item-level Security in Reporting Services".

It's all I need.

Reporting Services: Report Manager does not load (server error)

Hello Everyone,

I have installed SQL Server 2005 with Reporting Services on Windows Server 2003. I can run through reporting services configuration and completed all the required steps to initialize it. I can access the reports through //localhost/reportserver and I can also access the reports through Microsoft CRM. But I cannot access the Report Manager (//localhost/reports). I get this Error:

Server Error in '/Reports' Application.

Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

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.IO.FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.

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.


Assembly Load Trace: The following information can be helpful to determine why the assembly 'ReportingServicesWebServer' could not be loaded.

WRN: Assembly binding logging is turned OFF. To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1. Note: There is some performance penalty associated with assembly bind failure logging. To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].


Stack Trace:

[FileNotFoundException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Evidence assemblySecurity, Assembly locationHint, StackCrawlMark& stackMark, Boolean throwOnFileNotFound, Boolean forIntrospection) +0 System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +211 System.Reflection.Assembly.InternalLoad(String assemblyString, Evidence assemblySecurity, StackCrawlMark& stackMark, Boolean forIntrospection) +141 System.Reflection.Assembly.Load(String assemblyString) +25 System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +32 [ConfigurationErrorsException: Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.Configuration.CompilationSection.LoadAssemblyHelper(String assemblyName, Boolean starDirective) +596 System.Web.Configuration.CompilationSection.LoadAssembly(AssemblyInfo ai) +70 System.Web.Compilation.BuildManager.GetReferencedAssemblies(CompilationSection compConfig) +177 System.Web.Compilation.BuildProvidersCompiler..ctor(VirtualPath configPath, Boolean supportLocalization, String outputAssemblyName) +180 System.Web.Compilation.ApplicationBuildProvider.GetGlobalAsaxBuildResult(Boolean isPrecompiledApp) +3561465 System.Web.Compilation.BuildManager.CompileGlobalAsax() +51 System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +462 [HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.Compilation.BuildManager.ReportTopLevelCompilationException() +57 System.Web.Compilation.BuildManager.EnsureTopLevelFilesCompiled() +612 System.Web.Hosting.HostingEnvironment.Initialize(ApplicationManager appManager, IApplicationHost appHost, IConfigMapPathFactory configMapPathFactory, HostingEnvironmentParameters hostingParameters) +521 [HttpException (0x80004005): Could not load file or assembly 'ReportingServicesWebServer' or one of its dependencies. The system cannot find the file specified.] System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3540923 System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +69 System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +275


Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

Any ideas? I have done some searching, but could not find any viable solutions. Please Help Smile

Regards,

Ray

It sounds like this is a fairly complex problem:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1259637&SiteID=1

Have you tried reinstalling report manager?

Reporting Services won't start (SQL Server 2005 Express)

Hi,
I have IIS and SQL Server 2005 Express + Reporting Services.
When you try to configure the virtual directory for RS the manager crashes,
but the directory is created anyway.
However I can't start the reporting service, I get the following exception:
System.ServiceProcess.TimeoutException: Time out has expired and the
operation has not been completed.
at
System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus
desiredStatus, TimeSpan timeout)
at
ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
I've seen this on the net a few times, but never a solution.Ok I found the problem and solution.
First of all, make sure IIS is running.
Then make sure ASP.NET 2.0 is enabled and set as the default .NET Runtime
(right click on your website --> properties)
Check the users on your system and see if you can find the ASPNET user,
if not, reinstall the .NET 2.0 redist (after you make sure IIS is running),
because
if finds IIS this time, it'll create the ASPNET user and RS will be able to
start.
"TimothyP" wrote:
> Hi,
> I have IIS and SQL Server 2005 Express + Reporting Services.
> When you try to configure the virtual directory for RS the manager crashes,
> but the directory is created anyway.
> However I can't start the reporting service, I get the following exception:
> System.ServiceProcess.TimeoutException: Time out has expired and the
> operation has not been completed.
> at
> System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus
> desiredStatus, TimeSpan timeout)
> at
> ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)
> I've seen this on the net a few times, but never a solution.
>