After I install SP1 of SP2 for reporting services, I get the following
error:
The version of the report server database is either in a format that is
not
valid, or it cannot be read. The found version is 'C.0.6.54'. The
expected
version is 'C.0.6.43'. To continue, update the version of the report
server
database and verify access rights. (rsInvalidReportServerDatabase)
I am currently running RS enteprise edition with SQL server 2000
Standard edition.
When I used to have RS std. edition with SQL server 2000 std.edition,
I've applied both service packs and didn't get the error.
Can you help me with this problem?
Thanks,If you already installed SP2, you can not install SP1 afterwards and
you do not need to.
Service Packs are cumulative - they contain everything from prior
service packs.
bevarg wrote:
> After I install SP1 of SP2 for reporting services, I get the following
> error:
> The version of the report server database is either in a format that is
> not
> valid, or it cannot be read. The found version is 'C.0.6.54'. The
> expected
> version is 'C.0.6.43'. To continue, update the version of the report
> server
> database and verify access rights. (rsInvalidReportServerDatabase)
> I am currently running RS enteprise edition with SQL server 2000
> Standard edition.
> When I used to have RS std. edition with SQL server 2000 std.edition,
> I've applied both service packs and didn't get the error.
> Can you help me with this problem?
> Thanks,
Showing posts with label services. Show all posts
Showing posts with label services. Show all posts
Friday, March 30, 2012
HELP!!! Printer Delivery Extension not Printing Landscape
Hello All,
I'm using SQL Server 2005 Reporting Services, and I'm trying to have subscriptions print. To try this, I built, installed, and configured the printer delivery extension sample provided by Microsoft.
Everything appeared to be working fine. That is, I can schedule a report to print automatically using the printer delivery extension. However, the problem is that the reports always print portrait.
We have a number of reports--some are portrait and some are landscape. So, obviously, I need the landscape reports to print lanscape.
I've even tried "hard-coding" the page width and page height parameters in the printer delivery extension to try to force it to print landscape, but it still always prints portrait.
Would any one know how to have reports that are delivered to a printer actually print in the way they are created (i.e., print landscape if the report is set up as a landscape report)?
Do I have to use the IMAGE format? Could I use PDF? If so, how?
Thanks!
Hi,
there is a likewise issue if you use linked reports in RS - the linked report does not contain the original page settings.
It probably could be that you would have to set the page settings programmatically like described by Brian Welcker for the linked reports:
http://www.fits-consulting.de/blog/PermaLink,guid,e3f1cf4a-f9d6-44d8-86e5-84a59531f87c.aspx
hth...
cheers,
Markus
Thanks for the info. Markus. Unfortunately, setting the page settings programmatically didn't help. All reports and linked reports always print portrait, not landscape.
Therefore, would any one have any ideas on how to use the printer delivery extension and make scheduled reports be delivered automatically to a printer and acutally print in landscape?
Please see me original post and let me know if more info. is needed to answer my questions.
Thanks!
HELP!! i deleted services!
i have installed vs 2005 and sql server enterprise edition on an xp pro sp2 machine.but i could not connect to the mssqlexpress default database that it came with.in a moment of madness i deleted the mssqlserver services (3 of them).how do i reinstall them? i thought uninstalling the products and reinstalling them would help but it did not.
please help!
cheers 
HTH, jens Suessmeyer.
http://www.sqlserver2005.de|||
yes it it is possible, the only thing is that you do not have access to all the functionality.i have solved the prob by uninstalling and installing the work edition.
thanks
|||Sorry to correct you, but installing SQL Server services won′t be available for enterprise edition, only the client tools.Jens Suessmeyer.
http://www.sqlserver2005.de
Help!! i deleted mssqlserver services
i
have installed vs 2005 and sql server enterprise edition on an xp pro
sp2 machine.but i could not connect to the mssqlexpress default
database that it came with.in a moment of madness i deleted the
mssqlserver services (3 of them).how do i reinstall them? i thought
uninstalling the products and reinstalling them would help but it did
not.
please help!
cheers
Help! Where can we download the REAL Reporting Server Software?
Hi,
We downloaded Reporting Services software earlier this year and have been developing reports.
Now we are ready to start integration testing and I can not access the Report Manager on my development machine.
I get the message: Evaluation License Expired.
We have valid MS SQL 2000 licenses and thus my understanding is that we are entitled to download the developer and Standard editions of Report Services. Unfortunately, the only version provided to us at the time of our installation was the "eval" version.
Does anyone know where we can obtain Report Services Software that will not time-out on us?
More importantly, how can we upgrade our existing installations so that our report definitions and other meta-data are not lost?
We've done quite a bit of work in creating numerous reports and we would have a very difficult time recreating our existing reports.
Best Regards, Jane
PS - We do not have an MSDN subscription.
YOu should check the licensing forSQL Reporting Services it is a separate product.|||Thanks for your note. Yes, I understand SQL Reporting Services is a separate product. However, it is a free
separate product if you have a valid MS SQL Server 2000 license. This is exactly our problem, because of our retail
MS SQL 2000 licenses we should be able to upgrade to retail standard and developer editions of Reporting
Services but I have not been able find a site from which to download this software [without a subscription to MSDN].
I am also working with Microsoft and will post the solution to this dilemma when it has been resolved.
|||I understand what you mean now.Check herefor more instructions on how to obtain your copy. Look under: Existing SQL Server 2000 Customers.
Wednesday, March 28, 2012
HELP! SUBREPORTS!!
Hi All, I really need some help with subreporting in SQLRS. I have wasted 2 full days trying to get a simple subreport working in Reporting Services and am on the brink of going back to Active Reports if RS continues to be so confusing!
I have a main report and for each line I need a subreport linked on an OrderID parameter. I have followed every single RS books online How-to (as vague as some of them are) and still no luck. This is what I have done
I have created main report and a subreport.
I have placed the subreport on the main report and in its properties have added a parameter â'OrderIdâ' linked to the OrderId field from the main report. No complaints from RS so far.
In the subreport, I click on the â'â?¦â' to edit the DataSet and add a parameter OrderId here whos value is Parameters!OrderId.Value
Surely now when I run the report, the main report will pass its OrderId through to the sub report and I will get a subreport for each line?
All I get is all my main reports lines and then one subreport listing everything in the table?
If anyone can, please could you explain how exactly the parameters are meant to be set up as the online documentation assumes one has been using RS for 50 years or more!
Many thanks in advance
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.This is a very rough guess, but it sounds like you need to do some sort of
grouping (on OrderID perhaps) on each main report line item...
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uoqz3rnaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Hi All, I really need some help with subreporting in SQLRS. I have wasted
2 full days trying to get a simple subreport working in Reporting Services
and am on the brink of going back to Active Reports if RS continues to be so
confusing!
> I have a main report and for each line I need a subreport linked on an
OrderID parameter. I have followed every single RS books online How-to (as
vague as some of them are) and still no luck. This is what I have done
> I have created main report and a subreport.
> I have placed the subreport on the main report and in its properties have
added a parameter â?~OrderIdâ?T linked to the OrderId field from the main
report. No complaints from RS so far.
> In the subreport, I click on the â?oâ?¦â' to edit the DataSet and add a
parameter OrderId here whos value is Parameters!OrderId.Value
> Surely now when I run the report, the main report will pass its OrderId
through to the sub report and I will get a subreport for each line?
> All I get is all my main reports lines and then one subreport listing
everything in the table?
> If anyone can, please could you explain how exactly the parameters are
meant to be set up as the online documentation assumes one has been using RS
for 50 years or more!
> Many thanks in advance
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.|||Break this down. First, work on the two reports separately until you get
what you want. Create the subreport as a stand alone report. This report
should have a report parameter and a query parameter. You should be able to
fully test your subreport stand alone. Then put the subreport into the mail
report. Do a right mouse click onto the subreport and then you can set the
parameter to the value of the orderid field.
Bruce L-C
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uoqz3rnaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Hi All, I really need some help with subreporting in SQLRS. I have wasted
2 full days trying to get a simple subreport working in Reporting Services
and am on the brink of going back to Active Reports if RS continues to be so
confusing!
> I have a main report and for each line I need a subreport linked on an
OrderID parameter. I have followed every single RS books online How-to (as
vague as some of them are) and still no luck. This is what I have done
> I have created main report and a subreport.
> I have placed the subreport on the main report and in its properties have
added a parameter â?~OrderIdâ?T linked to the OrderId field from the main
report. No complaints from RS so far.
> In the subreport, I click on the â?oâ?¦â' to edit the DataSet and add a
parameter OrderId here whos value is Parameters!OrderId.Value
> Surely now when I run the report, the main report will pass its OrderId
through to the sub report and I will get a subreport for each line?
> All I get is all my main reports lines and then one subreport listing
everything in the table?
> If anyone can, please could you explain how exactly the parameters are
meant to be set up as the online documentation assumes one has been using RS
for 50 years or more!
> Many thanks in advance
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
I have a main report and for each line I need a subreport linked on an OrderID parameter. I have followed every single RS books online How-to (as vague as some of them are) and still no luck. This is what I have done
I have created main report and a subreport.
I have placed the subreport on the main report and in its properties have added a parameter â'OrderIdâ' linked to the OrderId field from the main report. No complaints from RS so far.
In the subreport, I click on the â'â?¦â' to edit the DataSet and add a parameter OrderId here whos value is Parameters!OrderId.Value
Surely now when I run the report, the main report will pass its OrderId through to the sub report and I will get a subreport for each line?
All I get is all my main reports lines and then one subreport listing everything in the table?
If anyone can, please could you explain how exactly the parameters are meant to be set up as the online documentation assumes one has been using RS for 50 years or more!
Many thanks in advance
--
Posted using Wimdows.net NntpNews Component -
Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine supports Post Alerts, Ratings, and Searching.This is a very rough guess, but it sounds like you need to do some sort of
grouping (on OrderID perhaps) on each main report line item...
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uoqz3rnaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Hi All, I really need some help with subreporting in SQLRS. I have wasted
2 full days trying to get a simple subreport working in Reporting Services
and am on the brink of going back to Active Reports if RS continues to be so
confusing!
> I have a main report and for each line I need a subreport linked on an
OrderID parameter. I have followed every single RS books online How-to (as
vague as some of them are) and still no luck. This is what I have done
> I have created main report and a subreport.
> I have placed the subreport on the main report and in its properties have
added a parameter â?~OrderIdâ?T linked to the OrderId field from the main
report. No complaints from RS so far.
> In the subreport, I click on the â?oâ?¦â' to edit the DataSet and add a
parameter OrderId here whos value is Parameters!OrderId.Value
> Surely now when I run the report, the main report will pass its OrderId
through to the sub report and I will get a subreport for each line?
> All I get is all my main reports lines and then one subreport listing
everything in the table?
> If anyone can, please could you explain how exactly the parameters are
meant to be set up as the online documentation assumes one has been using RS
for 50 years or more!
> Many thanks in advance
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.|||Break this down. First, work on the two reports separately until you get
what you want. Create the subreport as a stand alone report. This report
should have a report parameter and a query parameter. You should be able to
fully test your subreport stand alone. Then put the subreport into the mail
report. Do a right mouse click onto the subreport and then you can set the
parameter to the value of the orderid field.
Bruce L-C
"SqlJunkies User" <User@.-NOSPAM-SqlJunkies.com> wrote in message
news:uoqz3rnaEHA.2340@.TK2MSFTNGP09.phx.gbl...
> Hi All, I really need some help with subreporting in SQLRS. I have wasted
2 full days trying to get a simple subreport working in Reporting Services
and am on the brink of going back to Active Reports if RS continues to be so
confusing!
> I have a main report and for each line I need a subreport linked on an
OrderID parameter. I have followed every single RS books online How-to (as
vague as some of them are) and still no luck. This is what I have done
> I have created main report and a subreport.
> I have placed the subreport on the main report and in its properties have
added a parameter â?~OrderIdâ?T linked to the OrderId field from the main
report. No complaints from RS so far.
> In the subreport, I click on the â?oâ?¦â' to edit the DataSet and add a
parameter OrderId here whos value is Parameters!OrderId.Value
> Surely now when I run the report, the main report will pass its OrderId
through to the sub report and I will get a subreport for each line?
> All I get is all my main reports lines and then one subreport listing
everything in the table?
> If anyone can, please could you explain how exactly the parameters are
meant to be set up as the online documentation assumes one has been using RS
for 50 years or more!
> Many thanks in advance
>
> --
> Posted using Wimdows.net NntpNews Component -
> Post Made from http://www.SqlJunkies.com/newsgroups Our newsgroup engine
supports Post Alerts, Ratings, and Searching.
Monday, March 26, 2012
Help! SQL Server services and Agent Service Keep restarting
There are no indications as to why. Every 8 minutes or so the event log
records:
Event Type:Information
Event Source:Service Control Manager
Event Category:None
Event ID:7035
Date:5/29/2007
Time:10:15:49 AM
User:MEMOPROD\cluster
Computer:MEMOSQL1
Description:
The SQL Server Agent (MSSQLSERVER) service was successfully sent a stop
control.
THEN...
Event Type:Error
Event Source:ClusSvc
Event Category:Failover Mgr
Event ID:1069
Date:5/29/2007
Time:10:15:49 AM
User:N/A
Computer:MEMOSQL1
Description:
Cluster resource 'SQL Server' in Resource Group 'Disks' failed.
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7034
Date:5/29/2007
Time:10:16:50 AM
User:N/A
Computer:MEMOSQL1
Description:
The SQL Server Agent (MSSQLSERVER) service terminated unexpectedly. It has
done this 5 time(s).
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7011
Date:5/29/2007
Time:10:17:46 AM
User:N/A
Computer:MEMOSQL1
Description:
Timeout (30000 milliseconds) waiting for a transaction response from the
MSSQLSERVER service.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Any Ideas?
Hello Paul is there anything in the cluster log?
John Vandervliet
"Paul Riker" wrote:
> There are no indications as to why. Every 8 minutes or so the event log
> records:
> Event Type:Information
> Event Source:Service Control Manager
> Event Category:None
> Event ID:7035
> Date:5/29/2007
> Time:10:15:49 AM
> User:MEMOPROD\cluster
> Computer:MEMOSQL1
> Description:
> The SQL Server Agent (MSSQLSERVER) service was successfully sent a stop
> control.
> THEN...
>
> Event Type:Error
> Event Source:ClusSvc
> Event Category:Failover Mgr
> Event ID:1069
> Date:5/29/2007
> Time:10:15:49 AM
> User:N/A
> Computer:MEMOSQL1
> Description:
> Cluster resource 'SQL Server' in Resource Group 'Disks' failed.
> Event Type:Error
> Event Source:Service Control Manager
> Event Category:None
> Event ID:7034
> Date:5/29/2007
> Time:10:16:50 AM
> User:N/A
> Computer:MEMOSQL1
> Description:
> The SQL Server Agent (MSSQLSERVER) service terminated unexpectedly. It has
> done this 5 time(s).
> Event Type:Error
> Event Source:Service Control Manager
> Event Category:None
> Event ID:7011
> Date:5/29/2007
> Time:10:17:46 AM
> User:N/A
> Computer:MEMOSQL1
> Description:
> Timeout (30000 milliseconds) waiting for a transaction response from the
> MSSQLSERVER service.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> Any Ideas?
records:
Event Type:Information
Event Source:Service Control Manager
Event Category:None
Event ID:7035
Date:5/29/2007
Time:10:15:49 AM
User:MEMOPROD\cluster
Computer:MEMOSQL1
Description:
The SQL Server Agent (MSSQLSERVER) service was successfully sent a stop
control.
THEN...
Event Type:Error
Event Source:ClusSvc
Event Category:Failover Mgr
Event ID:1069
Date:5/29/2007
Time:10:15:49 AM
User:N/A
Computer:MEMOSQL1
Description:
Cluster resource 'SQL Server' in Resource Group 'Disks' failed.
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7034
Date:5/29/2007
Time:10:16:50 AM
User:N/A
Computer:MEMOSQL1
Description:
The SQL Server Agent (MSSQLSERVER) service terminated unexpectedly. It has
done this 5 time(s).
Event Type:Error
Event Source:Service Control Manager
Event Category:None
Event ID:7011
Date:5/29/2007
Time:10:17:46 AM
User:N/A
Computer:MEMOSQL1
Description:
Timeout (30000 milliseconds) waiting for a transaction response from the
MSSQLSERVER service.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Any Ideas?
Hello Paul is there anything in the cluster log?
John Vandervliet
"Paul Riker" wrote:
> There are no indications as to why. Every 8 minutes or so the event log
> records:
> Event Type:Information
> Event Source:Service Control Manager
> Event Category:None
> Event ID:7035
> Date:5/29/2007
> Time:10:15:49 AM
> User:MEMOPROD\cluster
> Computer:MEMOSQL1
> Description:
> The SQL Server Agent (MSSQLSERVER) service was successfully sent a stop
> control.
> THEN...
>
> Event Type:Error
> Event Source:ClusSvc
> Event Category:Failover Mgr
> Event ID:1069
> Date:5/29/2007
> Time:10:15:49 AM
> User:N/A
> Computer:MEMOSQL1
> Description:
> Cluster resource 'SQL Server' in Resource Group 'Disks' failed.
> Event Type:Error
> Event Source:Service Control Manager
> Event Category:None
> Event ID:7034
> Date:5/29/2007
> Time:10:16:50 AM
> User:N/A
> Computer:MEMOSQL1
> Description:
> The SQL Server Agent (MSSQLSERVER) service terminated unexpectedly. It has
> done this 5 time(s).
> Event Type:Error
> Event Source:Service Control Manager
> Event Category:None
> Event ID:7011
> Date:5/29/2007
> Time:10:17:46 AM
> User:N/A
> Computer:MEMOSQL1
> Description:
> Timeout (30000 milliseconds) waiting for a transaction response from the
> MSSQLSERVER service.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
>
> Any Ideas?
Help! RS REPORT Manager is not lanching!
Hi all,
I have been working on Reporting Services for a while I build and deploy
reports. Just today I tried to go on htt://myserver/reports >> and I get
the following error:
<Error Message Starts
Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message: -- <html> <head>
<title>Server Unavailable </title> </head> <body> <h1><font
face=Verdana color=#ff3300>Server Application Unavailable </font></h1>
<p> <font face=Verdana> The web application you are attempting
to access on this web server is currently unavailable. Please hit the
"Refresh" button in your web browser to retry your request. </p> <p>
<b>Administrator Note: </b> An error message detailing the cause of this
specific request failure can be found in the application event log of the
web server. Please review this log entry to discover what caused this
error to occur. </p> </body> </html> --.
Home
<Error Message End>
When I type http://myserver/reportserver >> I get the default page with a
list of my reports and can lauch one.
I WOULD REALLY APPRECIATE ANYONE'S INPUT ON WHY MY REPORT MANAGER IS NOT
LANCHING EVEN THOUGH REPORTSERVER IS WORKING FINE?
THANK YOU IN ADVANCE
--
Message posted via http://www.sqlmonster.comCan you get to http://<server>/ReportServer/ReportService.asmx ? This is
the web service URL.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"James Woo via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c5d39b721ee04a35b1cfe8a5b7e8031b@.SQLMonster.com...
> Hi all,
> I have been working on Reporting Services for a while I build and deploy
> reports. Just today I tried to go on htt://myserver/reports >> and I get
> the following error:
> <Error Message Starts
> Client found response content type of 'text/html', but expected
> 'text/xml'.
> The request failed with the error message: -- <html> <head>
> <title>Server Unavailable </title> </head> <body> <h1><font
> face=Verdana color=#ff3300>Server Application Unavailable </font></h1>
> <p> <font face=Verdana> The web application you are attempting
> to access on this web server is currently unavailable. Please hit
> the
> "Refresh" button in your web browser to retry your request. </p> <p>
> <b>Administrator Note: </b> An error message detailing the cause of this
> specific request failure can be found in the application event log of the
> web server. Please review this log entry to discover what caused this
> error to occur. </p> </body> </html> --.
> Home
> <Error Message End>
> When I type http://myserver/reportserver >> I get the default page with a
> list of my reports and can lauch one.
> I WOULD REALLY APPRECIATE ANYONE'S INPUT ON WHY MY REPORT MANAGER IS NOT
> LANCHING EVEN THOUGH REPORTSERVER IS WORKING FINE?
> THANK YOU IN ADVANCE
> --
> Message posted via http://www.sqlmonster.com|||I got the following error when I ran
http://myserver/ReportServer/ReportService.asmx ?
<<<<
Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser
to retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web
server. Please review this log entry to discover what caused this error to
occur
However when I ran any of my reports that were deployed to the reports
server sucj as:
http://vsvradaher/ReportServer?%2fMDXSamples%
2fMDX_Expression&rs:Command=Render
I had no problem rendering the reports.
Also, I stopped and started the RS service in the Windows
AdministrativeTools, with no avail.
This is nuts. It just happened suddenly.
I really want to avaoid uninstalling and reinstalling RS.
I am tempted to say it is a Reporting Services - IIS issue.
What are the recommended configurations for that?
Thanks again in advance.
--
Message posted via http://www.sqlmonster.com|||Well,
1- The "DafaultAppPool" under "Application Pools" in IIS, where "Reports"
and "ReportServer" Applications reside, had in its ("DafaultAppPool")
properties "Performance" TAB had the "Idle timeout" checked. I unchecked
"Idle timeout", Even though I started my services again ( for Report server
under Control panel, that did not restart the report server applications.
2- Also, In IIS, under "Default Web Site" I CHECKED permissions on the
"reportserver" BIn directory to:
READ - Directory Browsing - and to execute permissions:Script and
Executables.
I am not sure that whatever I did here, is kosher for IIS / RS security,
and If it is , I have no clue how these permissions were off.
I would appreciate it if anyone can guide me to the propper preset
permissions of IIS - Reporting Services.
--
Message posted via http://www.sqlmonster.com
I have been working on Reporting Services for a while I build and deploy
reports. Just today I tried to go on htt://myserver/reports >> and I get
the following error:
<Error Message Starts
Client found response content type of 'text/html', but expected 'text/xml'.
The request failed with the error message: -- <html> <head>
<title>Server Unavailable </title> </head> <body> <h1><font
face=Verdana color=#ff3300>Server Application Unavailable </font></h1>
<p> <font face=Verdana> The web application you are attempting
to access on this web server is currently unavailable. Please hit the
"Refresh" button in your web browser to retry your request. </p> <p>
<b>Administrator Note: </b> An error message detailing the cause of this
specific request failure can be found in the application event log of the
web server. Please review this log entry to discover what caused this
error to occur. </p> </body> </html> --.
Home
<Error Message End>
When I type http://myserver/reportserver >> I get the default page with a
list of my reports and can lauch one.
I WOULD REALLY APPRECIATE ANYONE'S INPUT ON WHY MY REPORT MANAGER IS NOT
LANCHING EVEN THOUGH REPORTSERVER IS WORKING FINE?
THANK YOU IN ADVANCE
--
Message posted via http://www.sqlmonster.comCan you get to http://<server>/ReportServer/ReportService.asmx ? This is
the web service URL.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"James Woo via SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:c5d39b721ee04a35b1cfe8a5b7e8031b@.SQLMonster.com...
> Hi all,
> I have been working on Reporting Services for a while I build and deploy
> reports. Just today I tried to go on htt://myserver/reports >> and I get
> the following error:
> <Error Message Starts
> Client found response content type of 'text/html', but expected
> 'text/xml'.
> The request failed with the error message: -- <html> <head>
> <title>Server Unavailable </title> </head> <body> <h1><font
> face=Verdana color=#ff3300>Server Application Unavailable </font></h1>
> <p> <font face=Verdana> The web application you are attempting
> to access on this web server is currently unavailable. Please hit
> the
> "Refresh" button in your web browser to retry your request. </p> <p>
> <b>Administrator Note: </b> An error message detailing the cause of this
> specific request failure can be found in the application event log of the
> web server. Please review this log entry to discover what caused this
> error to occur. </p> </body> </html> --.
> Home
> <Error Message End>
> When I type http://myserver/reportserver >> I get the default page with a
> list of my reports and can lauch one.
> I WOULD REALLY APPRECIATE ANYONE'S INPUT ON WHY MY REPORT MANAGER IS NOT
> LANCHING EVEN THOUGH REPORTSERVER IS WORKING FINE?
> THANK YOU IN ADVANCE
> --
> Message posted via http://www.sqlmonster.com|||I got the following error when I ran
http://myserver/ReportServer/ReportService.asmx ?
<<<<
Server Application Unavailable
The web application you are attempting to access on this web server is
currently unavailable. Please hit the "Refresh" button in your web browser
to retry your request.
Administrator Note: An error message detailing the cause of this specific
request failure can be found in the application event log of the web
server. Please review this log entry to discover what caused this error to
occur
However when I ran any of my reports that were deployed to the reports
server sucj as:
http://vsvradaher/ReportServer?%2fMDXSamples%
2fMDX_Expression&rs:Command=Render
I had no problem rendering the reports.
Also, I stopped and started the RS service in the Windows
AdministrativeTools, with no avail.
This is nuts. It just happened suddenly.
I really want to avaoid uninstalling and reinstalling RS.
I am tempted to say it is a Reporting Services - IIS issue.
What are the recommended configurations for that?
Thanks again in advance.
--
Message posted via http://www.sqlmonster.com|||Well,
1- The "DafaultAppPool" under "Application Pools" in IIS, where "Reports"
and "ReportServer" Applications reside, had in its ("DafaultAppPool")
properties "Performance" TAB had the "Idle timeout" checked. I unchecked
"Idle timeout", Even though I started my services again ( for Report server
under Control panel, that did not restart the report server applications.
2- Also, In IIS, under "Default Web Site" I CHECKED permissions on the
"reportserver" BIn directory to:
READ - Directory Browsing - and to execute permissions:Script and
Executables.
I am not sure that whatever I did here, is kosher for IIS / RS security,
and If it is , I have no clue how these permissions were off.
I would appreciate it if anyone can guide me to the propper preset
permissions of IIS - Reporting Services.
--
Message posted via http://www.sqlmonster.com
Friday, March 23, 2012
HELP! Report Parameters not working.
I bought a book, seems good, on Reporting Services. Since I am new to this
all, I am on the uphill learning curve. I have a dataset I created and added
parameters. After trying to run the report with the new parameters, I always
get the same error, "The report parameter â'SystemNameâ' has a DefaultValue or
a ValidValue that depends on the report parameter â'SystemNameâ'. Forward
dependencies are not valid." I have read other posts where a solution
provider says that the dataset is not being populated before getting to the
parameter. How do I force the dataset to be populated first? In all the
examples I worked with, I never saw where I had to do something specific
after creating the dataset to initiate the parameter.
Also, after creating a dataset I am able to see the fields without issues.
If I drag/drop one of those fields on my form, I
get:"=First(Fields!FieldName.Value)". In all the examples in the book, I
don't get First(Fields!blah.blah). It is always without parathesis in the
book. I know I am not doing something correctly. Can someone please help me
out.
Thanks much,To address a couple of things:
1) on the parameters:
Are you specifying the source of the parameter is a datasource? I'm
assuming yes, other wise it is simply input by the user and you wouldn't have
problems. In this case, make sure that the datasource you are using actually
returns data. Under the Data tab, open up the datasource for you parameter.
Click on Refresh, and then click the "!" icon to see what data you get. Does
this populate your datasource? Does this give you data to provide for your
parameters in the report?
2) The First(Fields!blah.Value) come out because you probably are just
dragging a field onto the report, and not putting it into a data region (such
as a table or list). The First() thing is saying "give me the first value
returned for this dataset." The reason being, otherwise it doesn't know how
to display the data (i.e. which piece of data do you want to display).
If you create a table, then drag a field to the "details" row of the table,
you should not see the First() thing come up. This is because a table (in
the report) automatically displays a new row for each new row of data
returned in the dataset.
Hope this helps!
"cmcdavid" wrote:
> I bought a book, seems good, on Reporting Services. Since I am new to this
> all, I am on the uphill learning curve. I have a dataset I created and added
> parameters. After trying to run the report with the new parameters, I always
> get the same error, "The report parameter â'SystemNameâ' has a DefaultValue or
> a ValidValue that depends on the report parameter â'SystemNameâ'. Forward
> dependencies are not valid." I have read other posts where a solution
> provider says that the dataset is not being populated before getting to the
> parameter. How do I force the dataset to be populated first? In all the
> examples I worked with, I never saw where I had to do something specific
> after creating the dataset to initiate the parameter.
> Also, after creating a dataset I am able to see the fields without issues.
> If I drag/drop one of those fields on my form, I
> get:"=First(Fields!FieldName.Value)". In all the examples in the book, I
> don't get First(Fields!blah.blah). It is always without parathesis in the
> book. I know I am not doing something correctly. Can someone please help me
> out.
> Thanks much,
>|||David,
Yes, I am wanting the parameter to be filled with a drop-down box on the
report. Yes, I have run this and get back a result. When assigning a field
a parameter, when I run it, it pops up a dialogue box asking for the
parameters. After supplying it with the intial values, it returns what I
want. After running in the report, it doesn't work as I preview it.
Chris
"david boardman" wrote:
> To address a couple of things:
> 1) on the parameters:
> Are you specifying the source of the parameter is a datasource? I'm
> assuming yes, other wise it is simply input by the user and you wouldn't have
> problems. In this case, make sure that the datasource you are using actually
> returns data. Under the Data tab, open up the datasource for you parameter.
> Click on Refresh, and then click the "!" icon to see what data you get. Does
> this populate your datasource? Does this give you data to provide for your
> parameters in the report?
> 2) The First(Fields!blah.Value) come out because you probably are just
> dragging a field onto the report, and not putting it into a data region (such
> as a table or list). The First() thing is saying "give me the first value
> returned for this dataset." The reason being, otherwise it doesn't know how
> to display the data (i.e. which piece of data do you want to display).
> If you create a table, then drag a field to the "details" row of the table,
> you should not see the First() thing come up. This is because a table (in
> the report) automatically displays a new row for each new row of data
> returned in the dataset.
> Hope this helps!
> "cmcdavid" wrote:
> > I bought a book, seems good, on Reporting Services. Since I am new to this
> > all, I am on the uphill learning curve. I have a dataset I created and added
> > parameters. After trying to run the report with the new parameters, I always
> > get the same error, "The report parameter â'SystemNameâ' has a DefaultValue or
> > a ValidValue that depends on the report parameter â'SystemNameâ'. Forward
> > dependencies are not valid." I have read other posts where a solution
> > provider says that the dataset is not being populated before getting to the
> > parameter. How do I force the dataset to be populated first? In all the
> > examples I worked with, I never saw where I had to do something specific
> > after creating the dataset to initiate the parameter.
> >
> > Also, after creating a dataset I am able to see the fields without issues.
> > If I drag/drop one of those fields on my form, I
> > get:"=First(Fields!FieldName.Value)". In all the examples in the book, I
> > don't get First(Fields!blah.blah). It is always without parathesis in the
> > book. I know I am not doing something correctly. Can someone please help me
> > out.
> >
> > Thanks much,
> >
> >
all, I am on the uphill learning curve. I have a dataset I created and added
parameters. After trying to run the report with the new parameters, I always
get the same error, "The report parameter â'SystemNameâ' has a DefaultValue or
a ValidValue that depends on the report parameter â'SystemNameâ'. Forward
dependencies are not valid." I have read other posts where a solution
provider says that the dataset is not being populated before getting to the
parameter. How do I force the dataset to be populated first? In all the
examples I worked with, I never saw where I had to do something specific
after creating the dataset to initiate the parameter.
Also, after creating a dataset I am able to see the fields without issues.
If I drag/drop one of those fields on my form, I
get:"=First(Fields!FieldName.Value)". In all the examples in the book, I
don't get First(Fields!blah.blah). It is always without parathesis in the
book. I know I am not doing something correctly. Can someone please help me
out.
Thanks much,To address a couple of things:
1) on the parameters:
Are you specifying the source of the parameter is a datasource? I'm
assuming yes, other wise it is simply input by the user and you wouldn't have
problems. In this case, make sure that the datasource you are using actually
returns data. Under the Data tab, open up the datasource for you parameter.
Click on Refresh, and then click the "!" icon to see what data you get. Does
this populate your datasource? Does this give you data to provide for your
parameters in the report?
2) The First(Fields!blah.Value) come out because you probably are just
dragging a field onto the report, and not putting it into a data region (such
as a table or list). The First() thing is saying "give me the first value
returned for this dataset." The reason being, otherwise it doesn't know how
to display the data (i.e. which piece of data do you want to display).
If you create a table, then drag a field to the "details" row of the table,
you should not see the First() thing come up. This is because a table (in
the report) automatically displays a new row for each new row of data
returned in the dataset.
Hope this helps!
"cmcdavid" wrote:
> I bought a book, seems good, on Reporting Services. Since I am new to this
> all, I am on the uphill learning curve. I have a dataset I created and added
> parameters. After trying to run the report with the new parameters, I always
> get the same error, "The report parameter â'SystemNameâ' has a DefaultValue or
> a ValidValue that depends on the report parameter â'SystemNameâ'. Forward
> dependencies are not valid." I have read other posts where a solution
> provider says that the dataset is not being populated before getting to the
> parameter. How do I force the dataset to be populated first? In all the
> examples I worked with, I never saw where I had to do something specific
> after creating the dataset to initiate the parameter.
> Also, after creating a dataset I am able to see the fields without issues.
> If I drag/drop one of those fields on my form, I
> get:"=First(Fields!FieldName.Value)". In all the examples in the book, I
> don't get First(Fields!blah.blah). It is always without parathesis in the
> book. I know I am not doing something correctly. Can someone please help me
> out.
> Thanks much,
>|||David,
Yes, I am wanting the parameter to be filled with a drop-down box on the
report. Yes, I have run this and get back a result. When assigning a field
a parameter, when I run it, it pops up a dialogue box asking for the
parameters. After supplying it with the intial values, it returns what I
want. After running in the report, it doesn't work as I preview it.
Chris
"david boardman" wrote:
> To address a couple of things:
> 1) on the parameters:
> Are you specifying the source of the parameter is a datasource? I'm
> assuming yes, other wise it is simply input by the user and you wouldn't have
> problems. In this case, make sure that the datasource you are using actually
> returns data. Under the Data tab, open up the datasource for you parameter.
> Click on Refresh, and then click the "!" icon to see what data you get. Does
> this populate your datasource? Does this give you data to provide for your
> parameters in the report?
> 2) The First(Fields!blah.Value) come out because you probably are just
> dragging a field onto the report, and not putting it into a data region (such
> as a table or list). The First() thing is saying "give me the first value
> returned for this dataset." The reason being, otherwise it doesn't know how
> to display the data (i.e. which piece of data do you want to display).
> If you create a table, then drag a field to the "details" row of the table,
> you should not see the First() thing come up. This is because a table (in
> the report) automatically displays a new row for each new row of data
> returned in the dataset.
> Hope this helps!
> "cmcdavid" wrote:
> > I bought a book, seems good, on Reporting Services. Since I am new to this
> > all, I am on the uphill learning curve. I have a dataset I created and added
> > parameters. After trying to run the report with the new parameters, I always
> > get the same error, "The report parameter â'SystemNameâ' has a DefaultValue or
> > a ValidValue that depends on the report parameter â'SystemNameâ'. Forward
> > dependencies are not valid." I have read other posts where a solution
> > provider says that the dataset is not being populated before getting to the
> > parameter. How do I force the dataset to be populated first? In all the
> > examples I worked with, I never saw where I had to do something specific
> > after creating the dataset to initiate the parameter.
> >
> > Also, after creating a dataset I am able to see the fields without issues.
> > If I drag/drop one of those fields on my form, I
> > get:"=First(Fields!FieldName.Value)". In all the examples in the book, I
> > don't get First(Fields!blah.blah). It is always without parathesis in the
> > book. I know I am not doing something correctly. Can someone please help me
> > out.
> >
> > Thanks much,
> >
> >
HELP! Report Manager Error: HTTP status 400: Bad Request
Hello,
I have been struggling with installing SQL Server 2005 Reporting services
for several days now, so I figured that Iâ'd post my experience on this
TechNet to see if anyone has any suggestions. Basically, the Server Manager
always returns â'The request failed with HTTP status 400: Bad Request.â' Iâ've
read similar posts on TechNet, as well as other newsgroups about this issue,
and I will note where I have tried a solution below. Details about the
server this reporting services is being installed on is in NOTE 6, at the end
of this message.
When installing SQL Server 2005 Developer Edition (came with my Visual
Studio 2005) on this server (for development/testing purposes), I choose to
install both the SQL Server Database Engine as well as Reporting Services.
As a test, I use the domain admin account, and install the new 2005 version
as a named instance: â'DEVELOPMENTâ'. When the installation proceeds to the
section to install Reporting Services, the install fails, with a note:
â'Failed on Reporting Services setup:
The setup has encountered an unexpected error while setting reporting
service and share point exclusion path.â'
Sharepoint doesnâ't appear to have anything to do with this (see NOTE 1).
After Reporting Services fails to install, I have to click â'Cancelâ', then
re-install Reporting Services from Add/Remove Programs->SQL Server
2005->Change. During the reinstall, the option to "Install but do not
configure the server" was preselected/disabled, so I had no option to install
and configure. A â'Detailsâ?¦â' button next to this revealed a message, NOTE 2.
This re-install appears to be successful. Since I didnâ't have the option to
install AND configure, I then open Reporting Services Configuration, and
connect to <server>, instance DEVELOPMENT.
In Reporting Services Config, I proceed to install the Report Server and
Report Manager Virtual Directories, give the Web Service the app pool of
DefaultAppPool, and proceed to Database Setup. Since this is a new install
and doesnâ't have a Reports database, I click â'Newâ?¦â' to create the Reports db
on server <server>\DEVELOPMENT using â'Service Credentialsâ'. At this point,
all â'Tasksâ' in the left pane of the Reports Services Config are check marks
except for â'Encryptionâ', which has a !, but I understand this is optional.
Now for IIS:
In IIS, I see both the Reports and ReportServer virtual directories under
Default Web Site, which currently listens on IP: 192.168.16.2, port 80 and
443 (SSL). In prior posts, I see some have achieved success by changing to
â'All Unassignedâ', but I have other web sites that listen on other IP
addresses, so this is not a good option, and shouldnâ't be required. The
DefaultAppPool runs under Identity: â'Network Serviceâ'.
When I go to http://cfsdev/ReportServer, things seem to work, as it just
displays basic text, see NOTE 3. However, when I browse to:
http://cfsdev/Reports, I am greeted with a red error image, along with â'The
request failed with HTTP status 400: Bad Request.â' There are no events in
the Event Log when this happens. The only details on whatâ's happening behind
the scenes is in a file E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
Services\LogFiles\ReportServerWebApp__03_21_2006_14_06_06.log, details in
NOTE 4.
I have, in prior attempts, changed the ReportServerURL key in the
RSWebApplication.config file under Report Manager to:
<ReportServerUrl>https://cfsdev/ReportServer</ReportServerUrl>, but still no
change in behavior. It is currently changed back to itâ's default, see NOTE
5. I get similar results when browsing from a LAN client or on the actual
server computer.
So Iâ'm out of ideas, and I need this development installation to support and
develop reporting apps for my production SQL Server 2005. Anyone with ideas,
please help!
-R. Mariotti
NOTE 1:
I have tried uninstalling SharePoint
(http://support.microsoft.com/?kbid=829114), then retrying the install fresh
(after an uninstall of SQL Server 2005), but the â'Failed on Reporting
Services setupâ' error persists. So share point doesnâ't appear to be the
issue.
NOTE 2:
â'The prerequisite check failed for a default report server installation:
First time install, the SQL instance is either not selected or is not a
local installâ'
NOTE 3:
cfsdev/ReportServer - /
----
----
Microsoft SQL Server Reporting Services Version 9.00.1399.00
NOTE 4:
w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: The request failed with HTTP status
400: Bad Request.
w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
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.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!7!3/21/2006-14:06:22:: 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)
NOTE 5:
E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
Services\ReportManager\RSWebApplication.config:
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
NOTE 6:
Server: Windows Small Business Server 2003 SP1
ISA Server, Exchange 2003, SQL Server 2000 (Default instance)Try setting your Default Website IP address to <All Unassigned>. Worked for
me on a SQL 2000 RS installation today.
"R Mariotti" wrote:
> Hello,
> I have been struggling with installing SQL Server 2005 Reporting services
> for several days now, so I figured that Iâ'd post my experience on this
> TechNet to see if anyone has any suggestions. Basically, the Server Manager
> always returns â'The request failed with HTTP status 400: Bad Request.â' Iâ've
> read similar posts on TechNet, as well as other newsgroups about this issue,
> and I will note where I have tried a solution below. Details about the
> server this reporting services is being installed on is in NOTE 6, at the end
> of this message.
> When installing SQL Server 2005 Developer Edition (came with my Visual
> Studio 2005) on this server (for development/testing purposes), I choose to
> install both the SQL Server Database Engine as well as Reporting Services.
> As a test, I use the domain admin account, and install the new 2005 version
> as a named instance: â'DEVELOPMENTâ'. When the installation proceeds to the
> section to install Reporting Services, the install fails, with a note:
> â'Failed on Reporting Services setup:
> The setup has encountered an unexpected error while setting reporting
> service and share point exclusion path.â'
> Sharepoint doesnâ't appear to have anything to do with this (see NOTE 1).
> After Reporting Services fails to install, I have to click â'Cancelâ', then
> re-install Reporting Services from Add/Remove Programs->SQL Server
> 2005->Change. During the reinstall, the option to "Install but do not
> configure the server" was preselected/disabled, so I had no option to install
> and configure. A â'Detailsâ?¦â' button next to this revealed a message, NOTE 2.
> This re-install appears to be successful. Since I didnâ't have the option to
> install AND configure, I then open Reporting Services Configuration, and
> connect to <server>, instance DEVELOPMENT.
> In Reporting Services Config, I proceed to install the Report Server and
> Report Manager Virtual Directories, give the Web Service the app pool of
> DefaultAppPool, and proceed to Database Setup. Since this is a new install
> and doesnâ't have a Reports database, I click â'Newâ?¦â' to create the Reports db
> on server <server>\DEVELOPMENT using â'Service Credentialsâ'. At this point,
> all â'Tasksâ' in the left pane of the Reports Services Config are check marks
> except for â'Encryptionâ', which has a !, but I understand this is optional.
> Now for IIS:
> In IIS, I see both the Reports and ReportServer virtual directories under
> Default Web Site, which currently listens on IP: 192.168.16.2, port 80 and
> 443 (SSL). In prior posts, I see some have achieved success by changing to
> â'All Unassignedâ', but I have other web sites that listen on other IP
> addresses, so this is not a good option, and shouldnâ't be required. The
> DefaultAppPool runs under Identity: â'Network Serviceâ'.
> When I go to http://cfsdev/ReportServer, things seem to work, as it just
> displays basic text, see NOTE 3. However, when I browse to:
> http://cfsdev/Reports, I am greeted with a red error image, along with â'The
> request failed with HTTP status 400: Bad Request.â' There are no events in
> the Event Log when this happens. The only details on whatâ's happening behind
> the scenes is in a file E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> Services\LogFiles\ReportServerWebApp__03_21_2006_14_06_06.log, details in
> NOTE 4.
> I have, in prior attempts, changed the ReportServerURL key in the
> RSWebApplication.config file under Report Manager to:
> <ReportServerUrl>https://cfsdev/ReportServer</ReportServerUrl>, but still no
> change in behavior. It is currently changed back to itâ's default, see NOTE
> 5. I get similar results when browsing from a LAN client or on the actual
> server computer.
> So Iâ'm out of ideas, and I need this development installation to support and
> develop reporting apps for my production SQL Server 2005. Anyone with ideas,
> please help!
> -R. Mariotti
>
> NOTE 1:
> I have tried uninstalling SharePoint
> (http://support.microsoft.com/?kbid=829114), then retrying the install fresh
> (after an uninstall of SQL Server 2005), but the â'Failed on Reporting
> Services setupâ' error persists. So share point doesnâ't appear to be the
> issue.
> NOTE 2:
> â'The prerequisite check failed for a default report server installation:
> First time install, the SQL instance is either not selected or is not a
> local installâ'
> NOTE 3:
> cfsdev/ReportServer - /
> ----
> ----
> Microsoft SQL Server Reporting Services Version 9.00.1399.00
> NOTE 4:
> w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: The request failed with HTTP status
> 400: Bad Request.
> w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 400: Bad Request.
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> 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.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!7!3/21/2006-14:06:22:: 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)
>
> NOTE 5:
> E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> Services\ReportManager\RSWebApplication.config:
> <UI>
> <ReportServerUrl></ReportServerUrl>
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> NOTE 6:
> Server: Windows Small Business Server 2003 SP1
> ISA Server, Exchange 2003, SQL Server 2000 (Default instance)
>|||Yeah, I had read that solution a few times during my research. Problem is,
the machine is a SBS2003 machine and therefore runs ISA Server with an
internal and external NIC. Additionally, the internal NIC hosts multiple web
sites on different IPs. For example:
ROUTER
|
192.168.1.2 (external NIC)
|
ISA SERVER
|
192.168.16.2 (web site 1)
192.168.16.3 (web site 2)
So you can see that setting "All Unassigned" won't work as I need ISA
Server's web publishing rules to be able to forward requests to a specific
site.
As a test, however, I created yet another test web site, manually re-created
the "reports" and "reportserver" virtual directories, and set the site to All
Unassigned. Still no luck; that test site has since been removed.
Thanks for the suggestion...
R. Mariotti
"HuttMan" wrote:
> Try setting your Default Website IP address to <All Unassigned>. Worked for
> me on a SQL 2000 RS installation today.
> "R Mariotti" wrote:
> > Hello,
> >
> > I have been struggling with installing SQL Server 2005 Reporting services
> > for several days now, so I figured that Iâ'd post my experience on this
> > TechNet to see if anyone has any suggestions. Basically, the Server Manager
> > always returns â'The request failed with HTTP status 400: Bad Request.â' Iâ've
> > read similar posts on TechNet, as well as other newsgroups about this issue,
> > and I will note where I have tried a solution below. Details about the
> > server this reporting services is being installed on is in NOTE 6, at the end
> > of this message.
> >
> > When installing SQL Server 2005 Developer Edition (came with my Visual
> > Studio 2005) on this server (for development/testing purposes), I choose to
> > install both the SQL Server Database Engine as well as Reporting Services.
> > As a test, I use the domain admin account, and install the new 2005 version
> > as a named instance: â'DEVELOPMENTâ'. When the installation proceeds to the
> > section to install Reporting Services, the install fails, with a note:
> >
> > â'Failed on Reporting Services setup:
> > The setup has encountered an unexpected error while setting reporting
> > service and share point exclusion path.â'
> >
> > Sharepoint doesnâ't appear to have anything to do with this (see NOTE 1).
> > After Reporting Services fails to install, I have to click â'Cancelâ', then
> > re-install Reporting Services from Add/Remove Programs->SQL Server
> > 2005->Change. During the reinstall, the option to "Install but do not
> > configure the server" was preselected/disabled, so I had no option to install
> > and configure. A â'Detailsâ?¦â' button next to this revealed a message, NOTE 2.
> > This re-install appears to be successful. Since I didnâ't have the option to
> > install AND configure, I then open Reporting Services Configuration, and
> > connect to <server>, instance DEVELOPMENT.
> >
> > In Reporting Services Config, I proceed to install the Report Server and
> > Report Manager Virtual Directories, give the Web Service the app pool of
> > DefaultAppPool, and proceed to Database Setup. Since this is a new install
> > and doesnâ't have a Reports database, I click â'Newâ?¦â' to create the Reports db
> > on server <server>\DEVELOPMENT using â'Service Credentialsâ'. At this point,
> > all â'Tasksâ' in the left pane of the Reports Services Config are check marks
> > except for â'Encryptionâ', which has a !, but I understand this is optional.
> > Now for IIS:
> >
> > In IIS, I see both the Reports and ReportServer virtual directories under
> > Default Web Site, which currently listens on IP: 192.168.16.2, port 80 and
> > 443 (SSL). In prior posts, I see some have achieved success by changing to
> > â'All Unassignedâ', but I have other web sites that listen on other IP
> > addresses, so this is not a good option, and shouldnâ't be required. The
> > DefaultAppPool runs under Identity: â'Network Serviceâ'.
> >
> > When I go to http://cfsdev/ReportServer, things seem to work, as it just
> > displays basic text, see NOTE 3. However, when I browse to:
> > http://cfsdev/Reports, I am greeted with a red error image, along with â'The
> > request failed with HTTP status 400: Bad Request.â' There are no events in
> > the Event Log when this happens. The only details on whatâ's happening behind
> > the scenes is in a file E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> > Services\LogFiles\ReportServerWebApp__03_21_2006_14_06_06.log, details in
> > NOTE 4.
> >
> > I have, in prior attempts, changed the ReportServerURL key in the
> > RSWebApplication.config file under Report Manager to:
> > <ReportServerUrl>https://cfsdev/ReportServer</ReportServerUrl>, but still no
> > change in behavior. It is currently changed back to itâ's default, see NOTE
> > 5. I get similar results when browsing from a LAN client or on the actual
> > server computer.
> >
> > So Iâ'm out of ideas, and I need this development installation to support and
> > develop reporting apps for my production SQL Server 2005. Anyone with ideas,
> > please help!
> >
> > -R. Mariotti
> >
> >
> > NOTE 1:
> > I have tried uninstalling SharePoint
> > (http://support.microsoft.com/?kbid=829114), then retrying the install fresh
> > (after an uninstall of SQL Server 2005), but the â'Failed on Reporting
> > Services setupâ' error persists. So share point doesnâ't appear to be the
> > issue.
> >
> > NOTE 2:
> > â'The prerequisite check failed for a default report server installation:
> > First time install, the SQL instance is either not selected or is not a
> > local installâ'
> >
> > NOTE 3:
> > cfsdev/ReportServer - /
> > ----
> > ----
> > Microsoft SQL Server Reporting Services Version 9.00.1399.00
> >
> > NOTE 4:
> > w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: The request failed with HTTP status
> > 400: Bad Request.
> > w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: HTTP status code --> 500
> > --Details--
> > System.Net.WebException: The request failed with HTTP status 400: Bad Request.
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> > at
> > Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> > methodname)
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> > 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.Page.OnInit(EventArgs e)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > w3wp!ui!7!3/21/2006-14:06:22:: 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)
> >
> >
> > NOTE 5:
> > E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> > Services\ReportManager\RSWebApplication.config:
> > <UI>
> > <ReportServerUrl></ReportServerUrl>
> > <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> > <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> > </UI>
> >
> > NOTE 6:
> > Server: Windows Small Business Server 2003 SP1
> > ISA Server, Exchange 2003, SQL Server 2000 (Default instance)
> >|||The below solution is working for me.
1) make up backup copy of both Rsreportserver and RSwebapplication.config
files
2) In RsReportServer.config file change the
<UrlRoot>http://machine/ReportServer</UrlRoot> to
<UrlRoot>http://hostheadername/ReportServer</UrlRoot>
3) And in RSWebapplication.config file, remove the
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
and change the
<ReportServerUrl>http://machinename/ReportServer</ReportServerUrl> to
<ReportServerUrl>http://hostheadername/ReportServer</ReportServerUrl>
4) Recycle the IIS server (ie. start â' run â' iisreset)
"R Mariotti" wrote:
> Hello,
> I have been struggling with installing SQL Server 2005 Reporting services
> for several days now, so I figured that Iâ'd post my experience on this
> TechNet to see if anyone has any suggestions. Basically, the Server Manager
> always returns â'The request failed with HTTP status 400: Bad Request.â' Iâ've
> read similar posts on TechNet, as well as other newsgroups about this issue,
> and I will note where I have tried a solution below. Details about the
> server this reporting services is being installed on is in NOTE 6, at the end
> of this message.
> When installing SQL Server 2005 Developer Edition (came with my Visual
> Studio 2005) on this server (for development/testing purposes), I choose to
> install both the SQL Server Database Engine as well as Reporting Services.
> As a test, I use the domain admin account, and install the new 2005 version
> as a named instance: â'DEVELOPMENTâ'. When the installation proceeds to the
> section to install Reporting Services, the install fails, with a note:
> â'Failed on Reporting Services setup:
> The setup has encountered an unexpected error while setting reporting
> service and share point exclusion path.â'
> Sharepoint doesnâ't appear to have anything to do with this (see NOTE 1).
> After Reporting Services fails to install, I have to click â'Cancelâ', then
> re-install Reporting Services from Add/Remove Programs->SQL Server
> 2005->Change. During the reinstall, the option to "Install but do not
> configure the server" was preselected/disabled, so I had no option to install
> and configure. A â'Detailsâ?¦â' button next to this revealed a message, NOTE 2.
> This re-install appears to be successful. Since I didnâ't have the option to
> install AND configure, I then open Reporting Services Configuration, and
> connect to <server>, instance DEVELOPMENT.
> In Reporting Services Config, I proceed to install the Report Server and
> Report Manager Virtual Directories, give the Web Service the app pool of
> DefaultAppPool, and proceed to Database Setup. Since this is a new install
> and doesnâ't have a Reports database, I click â'Newâ?¦â' to create the Reports db
> on server <server>\DEVELOPMENT using â'Service Credentialsâ'. At this point,
> all â'Tasksâ' in the left pane of the Reports Services Config are check marks
> except for â'Encryptionâ', which has a !, but I understand this is optional.
> Now for IIS:
> In IIS, I see both the Reports and ReportServer virtual directories under
> Default Web Site, which currently listens on IP: 192.168.16.2, port 80 and
> 443 (SSL). In prior posts, I see some have achieved success by changing to
> â'All Unassignedâ', but I have other web sites that listen on other IP
> addresses, so this is not a good option, and shouldnâ't be required. The
> DefaultAppPool runs under Identity: â'Network Serviceâ'.
> When I go to http://cfsdev/ReportServer, things seem to work, as it just
> displays basic text, see NOTE 3. However, when I browse to:
> http://cfsdev/Reports, I am greeted with a red error image, along with â'The
> request failed with HTTP status 400: Bad Request.â' There are no events in
> the Event Log when this happens. The only details on whatâ's happening behind
> the scenes is in a file E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> Services\LogFiles\ReportServerWebApp__03_21_2006_14_06_06.log, details in
> NOTE 4.
> I have, in prior attempts, changed the ReportServerURL key in the
> RSWebApplication.config file under Report Manager to:
> <ReportServerUrl>https://cfsdev/ReportServer</ReportServerUrl>, but still no
> change in behavior. It is currently changed back to itâ's default, see NOTE
> 5. I get similar results when browsing from a LAN client or on the actual
> server computer.
> So Iâ'm out of ideas, and I need this development installation to support and
> develop reporting apps for my production SQL Server 2005. Anyone with ideas,
> please help!
> -R. Mariotti
>
> NOTE 1:
> I have tried uninstalling SharePoint
> (http://support.microsoft.com/?kbid=829114), then retrying the install fresh
> (after an uninstall of SQL Server 2005), but the â'Failed on Reporting
> Services setupâ' error persists. So share point doesnâ't appear to be the
> issue.
> NOTE 2:
> â'The prerequisite check failed for a default report server installation:
> First time install, the SQL instance is either not selected or is not a
> local installâ'
> NOTE 3:
> cfsdev/ReportServer - /
> ----
> ----
> Microsoft SQL Server Reporting Services Version 9.00.1399.00
> NOTE 4:
> w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: The request failed with HTTP status
> 400: Bad Request.
> w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 400: Bad Request.
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> 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.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!7!3/21/2006-14:06:22:: 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)
>
> NOTE 5:
> E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> Services\ReportManager\RSWebApplication.config:
> <UI>
> <ReportServerUrl></ReportServerUrl>
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> NOTE 6:
> Server: Windows Small Business Server 2003 SP1
> ISA Server, Exchange 2003, SQL Server 2000 (Default instance)
>
I have been struggling with installing SQL Server 2005 Reporting services
for several days now, so I figured that Iâ'd post my experience on this
TechNet to see if anyone has any suggestions. Basically, the Server Manager
always returns â'The request failed with HTTP status 400: Bad Request.â' Iâ've
read similar posts on TechNet, as well as other newsgroups about this issue,
and I will note where I have tried a solution below. Details about the
server this reporting services is being installed on is in NOTE 6, at the end
of this message.
When installing SQL Server 2005 Developer Edition (came with my Visual
Studio 2005) on this server (for development/testing purposes), I choose to
install both the SQL Server Database Engine as well as Reporting Services.
As a test, I use the domain admin account, and install the new 2005 version
as a named instance: â'DEVELOPMENTâ'. When the installation proceeds to the
section to install Reporting Services, the install fails, with a note:
â'Failed on Reporting Services setup:
The setup has encountered an unexpected error while setting reporting
service and share point exclusion path.â'
Sharepoint doesnâ't appear to have anything to do with this (see NOTE 1).
After Reporting Services fails to install, I have to click â'Cancelâ', then
re-install Reporting Services from Add/Remove Programs->SQL Server
2005->Change. During the reinstall, the option to "Install but do not
configure the server" was preselected/disabled, so I had no option to install
and configure. A â'Detailsâ?¦â' button next to this revealed a message, NOTE 2.
This re-install appears to be successful. Since I didnâ't have the option to
install AND configure, I then open Reporting Services Configuration, and
connect to <server>, instance DEVELOPMENT.
In Reporting Services Config, I proceed to install the Report Server and
Report Manager Virtual Directories, give the Web Service the app pool of
DefaultAppPool, and proceed to Database Setup. Since this is a new install
and doesnâ't have a Reports database, I click â'Newâ?¦â' to create the Reports db
on server <server>\DEVELOPMENT using â'Service Credentialsâ'. At this point,
all â'Tasksâ' in the left pane of the Reports Services Config are check marks
except for â'Encryptionâ', which has a !, but I understand this is optional.
Now for IIS:
In IIS, I see both the Reports and ReportServer virtual directories under
Default Web Site, which currently listens on IP: 192.168.16.2, port 80 and
443 (SSL). In prior posts, I see some have achieved success by changing to
â'All Unassignedâ', but I have other web sites that listen on other IP
addresses, so this is not a good option, and shouldnâ't be required. The
DefaultAppPool runs under Identity: â'Network Serviceâ'.
When I go to http://cfsdev/ReportServer, things seem to work, as it just
displays basic text, see NOTE 3. However, when I browse to:
http://cfsdev/Reports, I am greeted with a red error image, along with â'The
request failed with HTTP status 400: Bad Request.â' There are no events in
the Event Log when this happens. The only details on whatâ's happening behind
the scenes is in a file E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
Services\LogFiles\ReportServerWebApp__03_21_2006_14_06_06.log, details in
NOTE 4.
I have, in prior attempts, changed the ReportServerURL key in the
RSWebApplication.config file under Report Manager to:
<ReportServerUrl>https://cfsdev/ReportServer</ReportServerUrl>, but still no
change in behavior. It is currently changed back to itâ's default, see NOTE
5. I get similar results when browsing from a LAN client or on the actual
server computer.
So Iâ'm out of ideas, and I need this development installation to support and
develop reporting apps for my production SQL Server 2005. Anyone with ideas,
please help!
-R. Mariotti
NOTE 1:
I have tried uninstalling SharePoint
(http://support.microsoft.com/?kbid=829114), then retrying the install fresh
(after an uninstall of SQL Server 2005), but the â'Failed on Reporting
Services setupâ' error persists. So share point doesnâ't appear to be the
issue.
NOTE 2:
â'The prerequisite check failed for a default report server installation:
First time install, the SQL instance is either not selected or is not a
local installâ'
NOTE 3:
cfsdev/ReportServer - /
----
----
Microsoft SQL Server Reporting Services Version 9.00.1399.00
NOTE 4:
w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: The request failed with HTTP status
400: Bad Request.
w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: HTTP status code --> 500
--Details--
System.Net.WebException: The request failed with HTTP status 400: Bad Request.
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at
Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
methodname)
at
Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
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.Page.OnInit(EventArgs e)
at System.Web.UI.Control.InitRecursive(Control namingContainer)
at System.Web.UI.Page.ProcessRequestMain(Boolean
includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!7!3/21/2006-14:06:22:: 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)
NOTE 5:
E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
Services\ReportManager\RSWebApplication.config:
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>
NOTE 6:
Server: Windows Small Business Server 2003 SP1
ISA Server, Exchange 2003, SQL Server 2000 (Default instance)Try setting your Default Website IP address to <All Unassigned>. Worked for
me on a SQL 2000 RS installation today.
"R Mariotti" wrote:
> Hello,
> I have been struggling with installing SQL Server 2005 Reporting services
> for several days now, so I figured that Iâ'd post my experience on this
> TechNet to see if anyone has any suggestions. Basically, the Server Manager
> always returns â'The request failed with HTTP status 400: Bad Request.â' Iâ've
> read similar posts on TechNet, as well as other newsgroups about this issue,
> and I will note where I have tried a solution below. Details about the
> server this reporting services is being installed on is in NOTE 6, at the end
> of this message.
> When installing SQL Server 2005 Developer Edition (came with my Visual
> Studio 2005) on this server (for development/testing purposes), I choose to
> install both the SQL Server Database Engine as well as Reporting Services.
> As a test, I use the domain admin account, and install the new 2005 version
> as a named instance: â'DEVELOPMENTâ'. When the installation proceeds to the
> section to install Reporting Services, the install fails, with a note:
> â'Failed on Reporting Services setup:
> The setup has encountered an unexpected error while setting reporting
> service and share point exclusion path.â'
> Sharepoint doesnâ't appear to have anything to do with this (see NOTE 1).
> After Reporting Services fails to install, I have to click â'Cancelâ', then
> re-install Reporting Services from Add/Remove Programs->SQL Server
> 2005->Change. During the reinstall, the option to "Install but do not
> configure the server" was preselected/disabled, so I had no option to install
> and configure. A â'Detailsâ?¦â' button next to this revealed a message, NOTE 2.
> This re-install appears to be successful. Since I didnâ't have the option to
> install AND configure, I then open Reporting Services Configuration, and
> connect to <server>, instance DEVELOPMENT.
> In Reporting Services Config, I proceed to install the Report Server and
> Report Manager Virtual Directories, give the Web Service the app pool of
> DefaultAppPool, and proceed to Database Setup. Since this is a new install
> and doesnâ't have a Reports database, I click â'Newâ?¦â' to create the Reports db
> on server <server>\DEVELOPMENT using â'Service Credentialsâ'. At this point,
> all â'Tasksâ' in the left pane of the Reports Services Config are check marks
> except for â'Encryptionâ', which has a !, but I understand this is optional.
> Now for IIS:
> In IIS, I see both the Reports and ReportServer virtual directories under
> Default Web Site, which currently listens on IP: 192.168.16.2, port 80 and
> 443 (SSL). In prior posts, I see some have achieved success by changing to
> â'All Unassignedâ', but I have other web sites that listen on other IP
> addresses, so this is not a good option, and shouldnâ't be required. The
> DefaultAppPool runs under Identity: â'Network Serviceâ'.
> When I go to http://cfsdev/ReportServer, things seem to work, as it just
> displays basic text, see NOTE 3. However, when I browse to:
> http://cfsdev/Reports, I am greeted with a red error image, along with â'The
> request failed with HTTP status 400: Bad Request.â' There are no events in
> the Event Log when this happens. The only details on whatâ's happening behind
> the scenes is in a file E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> Services\LogFiles\ReportServerWebApp__03_21_2006_14_06_06.log, details in
> NOTE 4.
> I have, in prior attempts, changed the ReportServerURL key in the
> RSWebApplication.config file under Report Manager to:
> <ReportServerUrl>https://cfsdev/ReportServer</ReportServerUrl>, but still no
> change in behavior. It is currently changed back to itâ's default, see NOTE
> 5. I get similar results when browsing from a LAN client or on the actual
> server computer.
> So Iâ'm out of ideas, and I need this development installation to support and
> develop reporting apps for my production SQL Server 2005. Anyone with ideas,
> please help!
> -R. Mariotti
>
> NOTE 1:
> I have tried uninstalling SharePoint
> (http://support.microsoft.com/?kbid=829114), then retrying the install fresh
> (after an uninstall of SQL Server 2005), but the â'Failed on Reporting
> Services setupâ' error persists. So share point doesnâ't appear to be the
> issue.
> NOTE 2:
> â'The prerequisite check failed for a default report server installation:
> First time install, the SQL instance is either not selected or is not a
> local installâ'
> NOTE 3:
> cfsdev/ReportServer - /
> ----
> ----
> Microsoft SQL Server Reporting Services Version 9.00.1399.00
> NOTE 4:
> w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: The request failed with HTTP status
> 400: Bad Request.
> w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 400: Bad Request.
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> 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.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!7!3/21/2006-14:06:22:: 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)
>
> NOTE 5:
> E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> Services\ReportManager\RSWebApplication.config:
> <UI>
> <ReportServerUrl></ReportServerUrl>
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> NOTE 6:
> Server: Windows Small Business Server 2003 SP1
> ISA Server, Exchange 2003, SQL Server 2000 (Default instance)
>|||Yeah, I had read that solution a few times during my research. Problem is,
the machine is a SBS2003 machine and therefore runs ISA Server with an
internal and external NIC. Additionally, the internal NIC hosts multiple web
sites on different IPs. For example:
ROUTER
|
192.168.1.2 (external NIC)
|
ISA SERVER
|
192.168.16.2 (web site 1)
192.168.16.3 (web site 2)
So you can see that setting "All Unassigned" won't work as I need ISA
Server's web publishing rules to be able to forward requests to a specific
site.
As a test, however, I created yet another test web site, manually re-created
the "reports" and "reportserver" virtual directories, and set the site to All
Unassigned. Still no luck; that test site has since been removed.
Thanks for the suggestion...
R. Mariotti
"HuttMan" wrote:
> Try setting your Default Website IP address to <All Unassigned>. Worked for
> me on a SQL 2000 RS installation today.
> "R Mariotti" wrote:
> > Hello,
> >
> > I have been struggling with installing SQL Server 2005 Reporting services
> > for several days now, so I figured that Iâ'd post my experience on this
> > TechNet to see if anyone has any suggestions. Basically, the Server Manager
> > always returns â'The request failed with HTTP status 400: Bad Request.â' Iâ've
> > read similar posts on TechNet, as well as other newsgroups about this issue,
> > and I will note where I have tried a solution below. Details about the
> > server this reporting services is being installed on is in NOTE 6, at the end
> > of this message.
> >
> > When installing SQL Server 2005 Developer Edition (came with my Visual
> > Studio 2005) on this server (for development/testing purposes), I choose to
> > install both the SQL Server Database Engine as well as Reporting Services.
> > As a test, I use the domain admin account, and install the new 2005 version
> > as a named instance: â'DEVELOPMENTâ'. When the installation proceeds to the
> > section to install Reporting Services, the install fails, with a note:
> >
> > â'Failed on Reporting Services setup:
> > The setup has encountered an unexpected error while setting reporting
> > service and share point exclusion path.â'
> >
> > Sharepoint doesnâ't appear to have anything to do with this (see NOTE 1).
> > After Reporting Services fails to install, I have to click â'Cancelâ', then
> > re-install Reporting Services from Add/Remove Programs->SQL Server
> > 2005->Change. During the reinstall, the option to "Install but do not
> > configure the server" was preselected/disabled, so I had no option to install
> > and configure. A â'Detailsâ?¦â' button next to this revealed a message, NOTE 2.
> > This re-install appears to be successful. Since I didnâ't have the option to
> > install AND configure, I then open Reporting Services Configuration, and
> > connect to <server>, instance DEVELOPMENT.
> >
> > In Reporting Services Config, I proceed to install the Report Server and
> > Report Manager Virtual Directories, give the Web Service the app pool of
> > DefaultAppPool, and proceed to Database Setup. Since this is a new install
> > and doesnâ't have a Reports database, I click â'Newâ?¦â' to create the Reports db
> > on server <server>\DEVELOPMENT using â'Service Credentialsâ'. At this point,
> > all â'Tasksâ' in the left pane of the Reports Services Config are check marks
> > except for â'Encryptionâ', which has a !, but I understand this is optional.
> > Now for IIS:
> >
> > In IIS, I see both the Reports and ReportServer virtual directories under
> > Default Web Site, which currently listens on IP: 192.168.16.2, port 80 and
> > 443 (SSL). In prior posts, I see some have achieved success by changing to
> > â'All Unassignedâ', but I have other web sites that listen on other IP
> > addresses, so this is not a good option, and shouldnâ't be required. The
> > DefaultAppPool runs under Identity: â'Network Serviceâ'.
> >
> > When I go to http://cfsdev/ReportServer, things seem to work, as it just
> > displays basic text, see NOTE 3. However, when I browse to:
> > http://cfsdev/Reports, I am greeted with a red error image, along with â'The
> > request failed with HTTP status 400: Bad Request.â' There are no events in
> > the Event Log when this happens. The only details on whatâ's happening behind
> > the scenes is in a file E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> > Services\LogFiles\ReportServerWebApp__03_21_2006_14_06_06.log, details in
> > NOTE 4.
> >
> > I have, in prior attempts, changed the ReportServerURL key in the
> > RSWebApplication.config file under Report Manager to:
> > <ReportServerUrl>https://cfsdev/ReportServer</ReportServerUrl>, but still no
> > change in behavior. It is currently changed back to itâ's default, see NOTE
> > 5. I get similar results when browsing from a LAN client or on the actual
> > server computer.
> >
> > So Iâ'm out of ideas, and I need this development installation to support and
> > develop reporting apps for my production SQL Server 2005. Anyone with ideas,
> > please help!
> >
> > -R. Mariotti
> >
> >
> > NOTE 1:
> > I have tried uninstalling SharePoint
> > (http://support.microsoft.com/?kbid=829114), then retrying the install fresh
> > (after an uninstall of SQL Server 2005), but the â'Failed on Reporting
> > Services setupâ' error persists. So share point doesnâ't appear to be the
> > issue.
> >
> > NOTE 2:
> > â'The prerequisite check failed for a default report server installation:
> > First time install, the SQL instance is either not selected or is not a
> > local installâ'
> >
> > NOTE 3:
> > cfsdev/ReportServer - /
> > ----
> > ----
> > Microsoft SQL Server Reporting Services Version 9.00.1399.00
> >
> > NOTE 4:
> > w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: The request failed with HTTP status
> > 400: Bad Request.
> > w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: HTTP status code --> 500
> > --Details--
> > System.Net.WebException: The request failed with HTTP status 400: Bad Request.
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> > at
> > Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> > methodname)
> > at
> > Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> > 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.Page.OnInit(EventArgs e)
> > at System.Web.UI.Control.InitRecursive(Control namingContainer)
> > at System.Web.UI.Page.ProcessRequestMain(Boolean
> > includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> > w3wp!ui!7!3/21/2006-14:06:22:: 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)
> >
> >
> > NOTE 5:
> > E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> > Services\ReportManager\RSWebApplication.config:
> > <UI>
> > <ReportServerUrl></ReportServerUrl>
> > <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> > <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> > </UI>
> >
> > NOTE 6:
> > Server: Windows Small Business Server 2003 SP1
> > ISA Server, Exchange 2003, SQL Server 2000 (Default instance)
> >|||The below solution is working for me.
1) make up backup copy of both Rsreportserver and RSwebapplication.config
files
2) In RsReportServer.config file change the
<UrlRoot>http://machine/ReportServer</UrlRoot> to
<UrlRoot>http://hostheadername/ReportServer</UrlRoot>
3) And in RSWebapplication.config file, remove the
<ReportServerVirtualDirectory>/ReportServer</ReportServerVirtualDirectory>
and change the
<ReportServerUrl>http://machinename/ReportServer</ReportServerUrl> to
<ReportServerUrl>http://hostheadername/ReportServer</ReportServerUrl>
4) Recycle the IIS server (ie. start â' run â' iisreset)
"R Mariotti" wrote:
> Hello,
> I have been struggling with installing SQL Server 2005 Reporting services
> for several days now, so I figured that Iâ'd post my experience on this
> TechNet to see if anyone has any suggestions. Basically, the Server Manager
> always returns â'The request failed with HTTP status 400: Bad Request.â' Iâ've
> read similar posts on TechNet, as well as other newsgroups about this issue,
> and I will note where I have tried a solution below. Details about the
> server this reporting services is being installed on is in NOTE 6, at the end
> of this message.
> When installing SQL Server 2005 Developer Edition (came with my Visual
> Studio 2005) on this server (for development/testing purposes), I choose to
> install both the SQL Server Database Engine as well as Reporting Services.
> As a test, I use the domain admin account, and install the new 2005 version
> as a named instance: â'DEVELOPMENTâ'. When the installation proceeds to the
> section to install Reporting Services, the install fails, with a note:
> â'Failed on Reporting Services setup:
> The setup has encountered an unexpected error while setting reporting
> service and share point exclusion path.â'
> Sharepoint doesnâ't appear to have anything to do with this (see NOTE 1).
> After Reporting Services fails to install, I have to click â'Cancelâ', then
> re-install Reporting Services from Add/Remove Programs->SQL Server
> 2005->Change. During the reinstall, the option to "Install but do not
> configure the server" was preselected/disabled, so I had no option to install
> and configure. A â'Detailsâ?¦â' button next to this revealed a message, NOTE 2.
> This re-install appears to be successful. Since I didnâ't have the option to
> install AND configure, I then open Reporting Services Configuration, and
> connect to <server>, instance DEVELOPMENT.
> In Reporting Services Config, I proceed to install the Report Server and
> Report Manager Virtual Directories, give the Web Service the app pool of
> DefaultAppPool, and proceed to Database Setup. Since this is a new install
> and doesnâ't have a Reports database, I click â'Newâ?¦â' to create the Reports db
> on server <server>\DEVELOPMENT using â'Service Credentialsâ'. At this point,
> all â'Tasksâ' in the left pane of the Reports Services Config are check marks
> except for â'Encryptionâ', which has a !, but I understand this is optional.
> Now for IIS:
> In IIS, I see both the Reports and ReportServer virtual directories under
> Default Web Site, which currently listens on IP: 192.168.16.2, port 80 and
> 443 (SSL). In prior posts, I see some have achieved success by changing to
> â'All Unassignedâ', but I have other web sites that listen on other IP
> addresses, so this is not a good option, and shouldnâ't be required. The
> DefaultAppPool runs under Identity: â'Network Serviceâ'.
> When I go to http://cfsdev/ReportServer, things seem to work, as it just
> displays basic text, see NOTE 3. However, when I browse to:
> http://cfsdev/Reports, I am greeted with a red error image, along with â'The
> request failed with HTTP status 400: Bad Request.â' There are no events in
> the Event Log when this happens. The only details on whatâ's happening behind
> the scenes is in a file E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> Services\LogFiles\ReportServerWebApp__03_21_2006_14_06_06.log, details in
> NOTE 4.
> I have, in prior attempts, changed the ReportServerURL key in the
> RSWebApplication.config file under Report Manager to:
> <ReportServerUrl>https://cfsdev/ReportServer</ReportServerUrl>, but still no
> change in behavior. It is currently changed back to itâ's default, see NOTE
> 5. I get similar results when browsing from a LAN client or on the actual
> server computer.
> So Iâ'm out of ideas, and I need this development installation to support and
> develop reporting apps for my production SQL Server 2005. Anyone with ideas,
> please help!
> -R. Mariotti
>
> NOTE 1:
> I have tried uninstalling SharePoint
> (http://support.microsoft.com/?kbid=829114), then retrying the install fresh
> (after an uninstall of SQL Server 2005), but the â'Failed on Reporting
> Services setupâ' error persists. So share point doesnâ't appear to be the
> issue.
> NOTE 2:
> â'The prerequisite check failed for a default report server installation:
> First time install, the SQL instance is either not selected or is not a
> local installâ'
> NOTE 3:
> cfsdev/ReportServer - /
> ----
> ----
> Microsoft SQL Server Reporting Services Version 9.00.1399.00
> NOTE 4:
> w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: The request failed with HTTP status
> 400: Bad Request.
> w3wp!ui!7!3/21/2006-14:06:21:: e ERROR: HTTP status code --> 500
> --Details--
> System.Net.WebException: The request failed with HTTP status 400: Bad Request.
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
> at
> Microsoft.ReportingServices.UI.Global.RSWebServiceWrapper.GetSecureMethods()
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String
> methodname)
> at
> Microsoft.SqlServer.ReportingServices2005.RSConnection.ValidateConnection()
> 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.Page.OnInit(EventArgs e)
> at System.Web.UI.Control.InitRecursive(Control namingContainer)
> at System.Web.UI.Page.ProcessRequestMain(Boolean
> includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
> w3wp!ui!7!3/21/2006-14:06:22:: 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)
>
> NOTE 5:
> E:\Program Files\SQL Server 2005\MSSQL.2\Reporting
> Services\ReportManager\RSWebApplication.config:
> <UI>
> <ReportServerUrl></ReportServerUrl>
> <ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
> <ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
> </UI>
> NOTE 6:
> Server: Windows Small Business Server 2003 SP1
> ISA Server, Exchange 2003, SQL Server 2000 (Default instance)
>
HELP! Question about SQL Reporting Services Licensing
Hi,
I urgently need the answer to a question about SQL Reporting Services
licensing.
I need to install SQL Reporting Services on an IIS server that hasn't
got SQL Server installed on it. The Reporting Services database will
deliberately go on a remote SQL Server. I don't want to install SQL
Server on the IIS server - I just want to install SQL Reporting
Services and put in a valid SQL Server license code when prompted
during the setup. However, I can't seem to get a license code from
anywhere as our company has some sort of global agreement with
Microsoft which means we don't get to see the actual license codes.
I'm also told by our licensing guy that SQL Reporting Services isn't
on our Select CDs.
Has anyone else installed SQL Reporting Services on a server that
hasn't got SQL Server on it? If so, how did you do it? I'm genuinely
not after some giving me a dodgy license code - I want to pay for the
license, but I can't seem to get one through our company!!! :-<
Is SQL Reporting Services on Select CDs in a way that means I won't be
prompted for a license code? If not, what are you meant to do if your
company has a global agreement with Microsoft? I'm almost at the
point of going down to PC World to buy a copy of SQL Server, but I
imagine this would be viewed very dimly by my company! There must be
a sensible solution to this.
I really need to know the answer to this VERY soon, so any help with
this will really be appreciated.
Thanks,
RichI have the setup that you are talking about.
I dont think you have to provide the SQL Server license
code while installing Reportinf services.
All you have to do is provide the name of the SQL Server
instance and you'll be on your way to installing RS.
>--Original Message--
>Hi,
>I urgently need the answer to a question about SQL
Reporting Services
>licensing.
>I need to install SQL Reporting Services on an IIS server
that hasn't
>got SQL Server installed on it. The Reporting Services
database will
>deliberately go on a remote SQL Server. I don't want to
install SQL
>Server on the IIS server - I just want to install SQL
Reporting
>Services and put in a valid SQL Server license code when
prompted
>during the setup. However, I can't seem to get a license
code from
>anywhere as our company has some sort of global agreement
with
>Microsoft which means we don't get to see the actual
license codes.
>I'm also told by our licensing guy that SQL Reporting
Services isn't
>on our Select CDs.
>Has anyone else installed SQL Reporting Services on a
server that
>hasn't got SQL Server on it? If so, how did you do it?
I'm genuinely
>not after some giving me a dodgy license code - I want to
pay for the
>license, but I can't seem to get one through our
company!!! :-<
>Is SQL Reporting Services on Select CDs in a way that
means I won't be
>prompted for a license code? If not, what are you meant
to do if your
>company has a global agreement with Microsoft? I'm
almost at the
>point of going down to PC World to buy a copy of SQL
Server, but I
>imagine this would be viewed very dimly by my company!
There must be
>a sensible solution to this.
>I really need to know the answer to this VERY soon, so
any help with
>this will really be appreciated.
>Thanks,
>
>Rich
>.
>|||Also remember that if you install RS on a machine where SQL Server isn't installed, then you need a
SQL Server license for the machine where you install RS (in addition to the SQL Server license you
have for the SQL Server machine).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:4cc301c490e1$ad09abb0$a301280a@.phx.gbl...
> I have the setup that you are talking about.
> I dont think you have to provide the SQL Server license
> code while installing Reportinf services.
> All you have to do is provide the name of the SQL Server
> instance and you'll be on your way to installing RS.
> >--Original Message--
> >Hi,
> >
> >I urgently need the answer to a question about SQL
> Reporting Services
> >licensing.
> >
> >I need to install SQL Reporting Services on an IIS server
> that hasn't
> >got SQL Server installed on it. The Reporting Services
> database will
> >deliberately go on a remote SQL Server. I don't want to
> install SQL
> >Server on the IIS server - I just want to install SQL
> Reporting
> >Services and put in a valid SQL Server license code when
> prompted
> >during the setup. However, I can't seem to get a license
> code from
> >anywhere as our company has some sort of global agreement
> with
> >Microsoft which means we don't get to see the actual
> license codes.
> >I'm also told by our licensing guy that SQL Reporting
> Services isn't
> >on our Select CDs.
> >
> >Has anyone else installed SQL Reporting Services on a
> server that
> >hasn't got SQL Server on it? If so, how did you do it?
> I'm genuinely
> >not after some giving me a dodgy license code - I want to
> pay for the
> >license, but I can't seem to get one through our
> company!!! :-<
> >
> >Is SQL Reporting Services on Select CDs in a way that
> means I won't be
> >prompted for a license code? If not, what are you meant
> to do if your
> >company has a global agreement with Microsoft? I'm
> almost at the
> >point of going down to PC World to buy a copy of SQL
> Server, but I
> >imagine this would be viewed very dimly by my company!
> There must be
> >a sensible solution to this.
> >
> >I really need to know the answer to this VERY soon, so
> any help with
> >this will really be appreciated.
> >
> >Thanks,
> >
> >
> >Rich
> >.
> >|||RS is an asp.net application. If you run it on the SQL Server box then you
need IIS running on it. You could use it only for RS and use your IIS server
for all your other web stuff but RS does not function without IIS.
Bruce L-C
"AJ3" <AJ3@.discussions.microsoft.com> wrote in message
news:6EAE3496-34C9-417D-8627-9F185BBB4A91@.microsoft.com...
> My IIS and SQL Server runs on 2 different boxes. Due to licensing if I
> install RS on sql box, how do I connect reports in my .net apps. Is there
a
> link or resource that can give me more insight on this?
> "Tibor Karaszi" wrote:
> > Also remember that if you install RS on a machine where SQL Server isn't
installed, then you need a
> > SQL Server license for the machine where you install RS (in addition to
the SQL Server license you
> > have for the SQL Server machine).
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > <anonymous@.discussions.microsoft.com> wrote in message
> > news:4cc301c490e1$ad09abb0$a301280a@.phx.gbl...
> > > I have the setup that you are talking about.
> > > I dont think you have to provide the SQL Server license
> > > code while installing Reportinf services.
> > > All you have to do is provide the name of the SQL Server
> > > instance and you'll be on your way to installing RS.
> > > >--Original Message--
> > > >Hi,
> > > >
> > > >I urgently need the answer to a question about SQL
> > > Reporting Services
> > > >licensing.
> > > >
> > > >I need to install SQL Reporting Services on an IIS server
> > > that hasn't
> > > >got SQL Server installed on it. The Reporting Services
> > > database will
> > > >deliberately go on a remote SQL Server. I don't want to
> > > install SQL
> > > >Server on the IIS server - I just want to install SQL
> > > Reporting
> > > >Services and put in a valid SQL Server license code when
> > > prompted
> > > >during the setup. However, I can't seem to get a license
> > > code from
> > > >anywhere as our company has some sort of global agreement
> > > with
> > > >Microsoft which means we don't get to see the actual
> > > license codes.
> > > >I'm also told by our licensing guy that SQL Reporting
> > > Services isn't
> > > >on our Select CDs.
> > > >
> > > >Has anyone else installed SQL Reporting Services on a
> > > server that
> > > >hasn't got SQL Server on it? If so, how did you do it?
> > > I'm genuinely
> > > >not after some giving me a dodgy license code - I want to
> > > pay for the
> > > >license, but I can't seem to get one through our
> > > company!!! :-<
> > > >
> > > >Is SQL Reporting Services on Select CDs in a way that
> > > means I won't be
> > > >prompted for a license code? If not, what are you meant
> > > to do if your
> > > >company has a global agreement with Microsoft? I'm
> > > almost at the
> > > >point of going down to PC World to buy a copy of SQL
> > > Server, but I
> > > >imagine this would be viewed very dimly by my company!
> > > There must be
> > > >a sensible solution to this.
> > > >
> > > >I really need to know the answer to this VERY soon, so
> > > any help with
> > > >this will really be appreciated.
> > > >
> > > >Thanks,
> > > >
> > > >
> > > >Rich
> > > >.
> > > >
> >
> >
> >|||Rich,
I've recently implemented SQL Reporting Services on our server, and
here is what I found out.
Reporting Services rides on the SQL Server license. If you install
Reporting Services on a machine with SQL Server, it's no extra cost.
If you install RS on a non SQL machine, all you have to do is purchase
the SQL Server license to cover RS on the non SQL machine.
In our organization, it was included in the Select agreement. I don't
know if we have a different select package than you do though. I did
not need the SQL Server Serial Key to install reporting services, just
notified our IT Software shop that I needed to purchase the additional
license and cut the proper forms.
So all you should have to do is let your IT shop know you need the
licensing to cover an installation of SQL server on your IIS web
server, don't install SQL Server on it, but install SQL Server
Reporting Services onto your IIS server.
Hope this helps...
TnNytehawk
richard.warner@.zurich.com (RichW) wrote in message news:<c0650c20.0409020144.509e6798@.posting.google.com>...
> Hi,
> I urgently need the answer to a question about SQL Reporting Services
> licensing.
> I need to install SQL Reporting Services on an IIS server that hasn't
> got SQL Server installed on it. The Reporting Services database will
> deliberately go on a remote SQL Server. I don't want to install SQL
> Server on the IIS server - I just want to install SQL Reporting
> Services and put in a valid SQL Server license code when prompted
> during the setup. However, I can't seem to get a license code from
> anywhere as our company has some sort of global agreement with
> Microsoft which means we don't get to see the actual license codes.
> I'm also told by our licensing guy that SQL Reporting Services isn't
> on our Select CDs.
> Has anyone else installed SQL Reporting Services on a server that
> hasn't got SQL Server on it? If so, how did you do it? I'm genuinely
> not after some giving me a dodgy license code - I want to pay for the
> license, but I can't seem to get one through our company!!! :-<
> Is SQL Reporting Services on Select CDs in a way that means I won't be
> prompted for a license code? If not, what are you meant to do if your
> company has a global agreement with Microsoft? I'm almost at the
> point of going down to PC World to buy a copy of SQL Server, but I
> imagine this would be viewed very dimly by my company! There must be
> a sensible solution to this.
> I really need to know the answer to this VERY soon, so any help with
> this will really be appreciated.
> Thanks,
>
> Rich|||Hi,
Thank you all for your answers to my question.
I think my problem came partly from only previously having used an
MSDN version of SQL Reporting Services (which does prompt for a
license code), and partly from being told by the licensing guy in my
company that SQL Reporting Services isn't on the Select CDs.
I'll go back to the licensing guy and ask him to find it on the Select
CDs.
Thanks again - I really appreciate your help.
Best wishes,
Rich|||Hi,
Sorry - one last question - I don't suppose anyone knows which Select
CD SQL Reporting Services is on? When I did a search on the Microsoft
site's list of Select CDs, it didn't show up, so I'm wondering if it's
on one of the SQL Server Select CDs rather than its own CD?
Thanks again,
Rich|||Hi again!
Don't worry - I've now got my hands on the Select CD version of SQL
Reporting Services.
Thank you all again for your help,
Rich
I urgently need the answer to a question about SQL Reporting Services
licensing.
I need to install SQL Reporting Services on an IIS server that hasn't
got SQL Server installed on it. The Reporting Services database will
deliberately go on a remote SQL Server. I don't want to install SQL
Server on the IIS server - I just want to install SQL Reporting
Services and put in a valid SQL Server license code when prompted
during the setup. However, I can't seem to get a license code from
anywhere as our company has some sort of global agreement with
Microsoft which means we don't get to see the actual license codes.
I'm also told by our licensing guy that SQL Reporting Services isn't
on our Select CDs.
Has anyone else installed SQL Reporting Services on a server that
hasn't got SQL Server on it? If so, how did you do it? I'm genuinely
not after some giving me a dodgy license code - I want to pay for the
license, but I can't seem to get one through our company!!! :-<
Is SQL Reporting Services on Select CDs in a way that means I won't be
prompted for a license code? If not, what are you meant to do if your
company has a global agreement with Microsoft? I'm almost at the
point of going down to PC World to buy a copy of SQL Server, but I
imagine this would be viewed very dimly by my company! There must be
a sensible solution to this.
I really need to know the answer to this VERY soon, so any help with
this will really be appreciated.
Thanks,
RichI have the setup that you are talking about.
I dont think you have to provide the SQL Server license
code while installing Reportinf services.
All you have to do is provide the name of the SQL Server
instance and you'll be on your way to installing RS.
>--Original Message--
>Hi,
>I urgently need the answer to a question about SQL
Reporting Services
>licensing.
>I need to install SQL Reporting Services on an IIS server
that hasn't
>got SQL Server installed on it. The Reporting Services
database will
>deliberately go on a remote SQL Server. I don't want to
install SQL
>Server on the IIS server - I just want to install SQL
Reporting
>Services and put in a valid SQL Server license code when
prompted
>during the setup. However, I can't seem to get a license
code from
>anywhere as our company has some sort of global agreement
with
>Microsoft which means we don't get to see the actual
license codes.
>I'm also told by our licensing guy that SQL Reporting
Services isn't
>on our Select CDs.
>Has anyone else installed SQL Reporting Services on a
server that
>hasn't got SQL Server on it? If so, how did you do it?
I'm genuinely
>not after some giving me a dodgy license code - I want to
pay for the
>license, but I can't seem to get one through our
company!!! :-<
>Is SQL Reporting Services on Select CDs in a way that
means I won't be
>prompted for a license code? If not, what are you meant
to do if your
>company has a global agreement with Microsoft? I'm
almost at the
>point of going down to PC World to buy a copy of SQL
Server, but I
>imagine this would be viewed very dimly by my company!
There must be
>a sensible solution to this.
>I really need to know the answer to this VERY soon, so
any help with
>this will really be appreciated.
>Thanks,
>
>Rich
>.
>|||Also remember that if you install RS on a machine where SQL Server isn't installed, then you need a
SQL Server license for the machine where you install RS (in addition to the SQL Server license you
have for the SQL Server machine).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<anonymous@.discussions.microsoft.com> wrote in message
news:4cc301c490e1$ad09abb0$a301280a@.phx.gbl...
> I have the setup that you are talking about.
> I dont think you have to provide the SQL Server license
> code while installing Reportinf services.
> All you have to do is provide the name of the SQL Server
> instance and you'll be on your way to installing RS.
> >--Original Message--
> >Hi,
> >
> >I urgently need the answer to a question about SQL
> Reporting Services
> >licensing.
> >
> >I need to install SQL Reporting Services on an IIS server
> that hasn't
> >got SQL Server installed on it. The Reporting Services
> database will
> >deliberately go on a remote SQL Server. I don't want to
> install SQL
> >Server on the IIS server - I just want to install SQL
> Reporting
> >Services and put in a valid SQL Server license code when
> prompted
> >during the setup. However, I can't seem to get a license
> code from
> >anywhere as our company has some sort of global agreement
> with
> >Microsoft which means we don't get to see the actual
> license codes.
> >I'm also told by our licensing guy that SQL Reporting
> Services isn't
> >on our Select CDs.
> >
> >Has anyone else installed SQL Reporting Services on a
> server that
> >hasn't got SQL Server on it? If so, how did you do it?
> I'm genuinely
> >not after some giving me a dodgy license code - I want to
> pay for the
> >license, but I can't seem to get one through our
> company!!! :-<
> >
> >Is SQL Reporting Services on Select CDs in a way that
> means I won't be
> >prompted for a license code? If not, what are you meant
> to do if your
> >company has a global agreement with Microsoft? I'm
> almost at the
> >point of going down to PC World to buy a copy of SQL
> Server, but I
> >imagine this would be viewed very dimly by my company!
> There must be
> >a sensible solution to this.
> >
> >I really need to know the answer to this VERY soon, so
> any help with
> >this will really be appreciated.
> >
> >Thanks,
> >
> >
> >Rich
> >.
> >|||RS is an asp.net application. If you run it on the SQL Server box then you
need IIS running on it. You could use it only for RS and use your IIS server
for all your other web stuff but RS does not function without IIS.
Bruce L-C
"AJ3" <AJ3@.discussions.microsoft.com> wrote in message
news:6EAE3496-34C9-417D-8627-9F185BBB4A91@.microsoft.com...
> My IIS and SQL Server runs on 2 different boxes. Due to licensing if I
> install RS on sql box, how do I connect reports in my .net apps. Is there
a
> link or resource that can give me more insight on this?
> "Tibor Karaszi" wrote:
> > Also remember that if you install RS on a machine where SQL Server isn't
installed, then you need a
> > SQL Server license for the machine where you install RS (in addition to
the SQL Server license you
> > have for the SQL Server machine).
> >
> > --
> > Tibor Karaszi, SQL Server MVP
> > http://www.karaszi.com/sqlserver/default.asp
> > http://www.solidqualitylearning.com/
> >
> >
> > <anonymous@.discussions.microsoft.com> wrote in message
> > news:4cc301c490e1$ad09abb0$a301280a@.phx.gbl...
> > > I have the setup that you are talking about.
> > > I dont think you have to provide the SQL Server license
> > > code while installing Reportinf services.
> > > All you have to do is provide the name of the SQL Server
> > > instance and you'll be on your way to installing RS.
> > > >--Original Message--
> > > >Hi,
> > > >
> > > >I urgently need the answer to a question about SQL
> > > Reporting Services
> > > >licensing.
> > > >
> > > >I need to install SQL Reporting Services on an IIS server
> > > that hasn't
> > > >got SQL Server installed on it. The Reporting Services
> > > database will
> > > >deliberately go on a remote SQL Server. I don't want to
> > > install SQL
> > > >Server on the IIS server - I just want to install SQL
> > > Reporting
> > > >Services and put in a valid SQL Server license code when
> > > prompted
> > > >during the setup. However, I can't seem to get a license
> > > code from
> > > >anywhere as our company has some sort of global agreement
> > > with
> > > >Microsoft which means we don't get to see the actual
> > > license codes.
> > > >I'm also told by our licensing guy that SQL Reporting
> > > Services isn't
> > > >on our Select CDs.
> > > >
> > > >Has anyone else installed SQL Reporting Services on a
> > > server that
> > > >hasn't got SQL Server on it? If so, how did you do it?
> > > I'm genuinely
> > > >not after some giving me a dodgy license code - I want to
> > > pay for the
> > > >license, but I can't seem to get one through our
> > > company!!! :-<
> > > >
> > > >Is SQL Reporting Services on Select CDs in a way that
> > > means I won't be
> > > >prompted for a license code? If not, what are you meant
> > > to do if your
> > > >company has a global agreement with Microsoft? I'm
> > > almost at the
> > > >point of going down to PC World to buy a copy of SQL
> > > Server, but I
> > > >imagine this would be viewed very dimly by my company!
> > > There must be
> > > >a sensible solution to this.
> > > >
> > > >I really need to know the answer to this VERY soon, so
> > > any help with
> > > >this will really be appreciated.
> > > >
> > > >Thanks,
> > > >
> > > >
> > > >Rich
> > > >.
> > > >
> >
> >
> >|||Rich,
I've recently implemented SQL Reporting Services on our server, and
here is what I found out.
Reporting Services rides on the SQL Server license. If you install
Reporting Services on a machine with SQL Server, it's no extra cost.
If you install RS on a non SQL machine, all you have to do is purchase
the SQL Server license to cover RS on the non SQL machine.
In our organization, it was included in the Select agreement. I don't
know if we have a different select package than you do though. I did
not need the SQL Server Serial Key to install reporting services, just
notified our IT Software shop that I needed to purchase the additional
license and cut the proper forms.
So all you should have to do is let your IT shop know you need the
licensing to cover an installation of SQL server on your IIS web
server, don't install SQL Server on it, but install SQL Server
Reporting Services onto your IIS server.
Hope this helps...
TnNytehawk
richard.warner@.zurich.com (RichW) wrote in message news:<c0650c20.0409020144.509e6798@.posting.google.com>...
> Hi,
> I urgently need the answer to a question about SQL Reporting Services
> licensing.
> I need to install SQL Reporting Services on an IIS server that hasn't
> got SQL Server installed on it. The Reporting Services database will
> deliberately go on a remote SQL Server. I don't want to install SQL
> Server on the IIS server - I just want to install SQL Reporting
> Services and put in a valid SQL Server license code when prompted
> during the setup. However, I can't seem to get a license code from
> anywhere as our company has some sort of global agreement with
> Microsoft which means we don't get to see the actual license codes.
> I'm also told by our licensing guy that SQL Reporting Services isn't
> on our Select CDs.
> Has anyone else installed SQL Reporting Services on a server that
> hasn't got SQL Server on it? If so, how did you do it? I'm genuinely
> not after some giving me a dodgy license code - I want to pay for the
> license, but I can't seem to get one through our company!!! :-<
> Is SQL Reporting Services on Select CDs in a way that means I won't be
> prompted for a license code? If not, what are you meant to do if your
> company has a global agreement with Microsoft? I'm almost at the
> point of going down to PC World to buy a copy of SQL Server, but I
> imagine this would be viewed very dimly by my company! There must be
> a sensible solution to this.
> I really need to know the answer to this VERY soon, so any help with
> this will really be appreciated.
> Thanks,
>
> Rich|||Hi,
Thank you all for your answers to my question.
I think my problem came partly from only previously having used an
MSDN version of SQL Reporting Services (which does prompt for a
license code), and partly from being told by the licensing guy in my
company that SQL Reporting Services isn't on the Select CDs.
I'll go back to the licensing guy and ask him to find it on the Select
CDs.
Thanks again - I really appreciate your help.
Best wishes,
Rich|||Hi,
Sorry - one last question - I don't suppose anyone knows which Select
CD SQL Reporting Services is on? When I did a search on the Microsoft
site's list of Select CDs, it didn't show up, so I'm wondering if it's
on one of the SQL Server Select CDs rather than its own CD?
Thanks again,
Rich|||Hi again!
Don't worry - I've now got my hands on the Select CD version of SQL
Reporting Services.
Thank you all again for your help,
Rich
help! question about hardware request for SQL Server and Analysis Services
I built a database with a huge table which has 18 billion lines for 6(or 7) columns.
And in the Analysis Services the table is used to create a dimention and a measure.
One of the other two dimentions is made form a 4000 line table,and the other is
made from a 3 million line table(time dimension table).
The specification of my Server is Windows Server 2003 with Xeon Intel Cpu 5160 @.3.00GHz,
2.99GHz,4.00G RAM.
The problem comes out when i start the processing of Analysis Services.
the "time out" error comes out after 1 hour, however, the performance i need
is completing the Processing for one cube within 10 munites.
I want to know the hardware request to reach my needs and how to speed the
processing of Analysis Services.
Thank you
So, to be clear, you have an 18 billion row fact table, you have built a cube on top of it and you want a full process to complete in 10 minutes?
Chris
|||Dear Mr
yes! I wanna a full process within 10 minutes.
Can it be done?
thanks in advance
tomigisi
|||The short answer is no, not if you're using MOLAP storage for your measure group. The best throughput I've ever seen for cube processing with MOLAP storage is around 200000 rows per second, and that was a maximum rather than something that could be consistently achieved throughout the whole process; you should be happy with 60-70000 rows per second if you've got a top-end server and a properly-tuned relational datasource.
I would experiment with using ROLAP or HOLAP storage, or with pre-aggregating your fact table in some way to reduce the overall number of rows.
Sorry,
Chris
|||We have a monster server: 8 - 3.2GHZ processors, a disk frame that reads/writes 400 MB/sec, 32 GB of ram, etc and we couldn't even process 18 Billion rows that fast. The slowdown is reading rows from the DB, and most likely not the server (unless you have slow disks).
sqlWednesday, March 21, 2012
Help! Invalid URI: The hostname could not be parsed.
I have installed SQL server 2005 and reporting services. When i try this: http://localhost/reports/ I get ->
Invalid URI: The hostname could not be parsed.
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.UriFormatException: Invalid URI: The hostname could not be parsed.
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:
[UriFormatException: Invalid URI: The hostname could not be parsed.] System.Uri.CreateThis(String uri, Boolean dontEscape, UriKind uriKind) +1647482
System.Uri..ctor(String uriString) +17
Microsoft.ReportingServices.Diagnostics.UIConfiguration.ParseXML(XmlNode node, RSConfiguration configObject) +1051
Microsoft.ReportingServices.Diagnostics.RSConfiguration.ParseDocument() +972
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +32
[ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.]
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Load() +166
Microsoft.ReportingServices.Diagnostics.RSConfiguration.Construct(String configFileName) +62
Microsoft.ReportingServices.Diagnostics.RSConfiguration..ctor(String configFileName, String location) +296
Microsoft.ReportingServices.Diagnostics.RSConfigurationManager..ctor(String configFileName, String configLocation) +134
Microsoft.ReportingServices.UI.Global.get_ConfigurationManager() +84
Microsoft.ReportingServices.UI.Global.get_Configuration() +4
Microsoft.ReportingServices.UI.GlobalApp.Application_AuthenticateRequest(Object sender, EventArgs e) +84
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64
Reporting services config manager shows all green checks. Any ideas?
thanks, Jason
What happens when you go to http://servername/reportserver? Do you see an entry in the RSReportServerXXX.log file that describes the property that it is trying to read? Does the RSReportServer.config configuration file look OK?
Monday, March 12, 2012
HELP! EM wont connect after apply sp3a,reporting services and VS.net 2003
Install SQL 2000 on a completelyu up to date windows 2003 advanced server,
then applied sp3a, then a installed reporting service developer addition,
then installed VS .net 2003 the reinstalled reporting services to get the
Report Developer.
Now I can't connect to the Server using EM.
Get SQL_alloc_handle on SQL_handle_env failed.
Tried all types of registrations.
Any suggestions short of starting from scratch?Make an ODBC trace of the connection attempt & open a case with the Webdata
team. They handle the MDAC problems with SQL.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Will do that if re-install of tools SQL fails. How do I open a case with the
WEBdata Team.
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:XWmAGmZ9DHA.704@.cpmsftngxa07.phx.gbl...
> Make an ODBC trace of the connection attempt & open a case with the
Webdata
> team. They handle the MDAC problems with SQL.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
then applied sp3a, then a installed reporting service developer addition,
then installed VS .net 2003 the reinstalled reporting services to get the
Report Developer.
Now I can't connect to the Server using EM.
Get SQL_alloc_handle on SQL_handle_env failed.
Tried all types of registrations.
Any suggestions short of starting from scratch?Make an ODBC trace of the connection attempt & open a case with the Webdata
team. They handle the MDAC problems with SQL.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Will do that if re-install of tools SQL fails. How do I open a case with the
WEBdata Team.
"Kevin McDonnell [MSFT]" <kevmc@.online.microsoft.com> wrote in message
news:XWmAGmZ9DHA.704@.cpmsftngxa07.phx.gbl...
> Make an ODBC trace of the connection attempt & open a case with the
Webdata
> team. They handle the MDAC problems with SQL.
> Thanks,
> Kevin McDonnell
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>
>
HELP! Default Date Parameters Expression in Reporting Services
How do I add a default date parameter to get this:
@.StartDate: Last Sunday
@.EndDate : Yesterday
So if I was to run this today I want the reports StartDate As Sunday, November 11, 2007
and
EndDate >>> Yesterday Thursday, November 15, 2007
Hi,
From your description, it seems that you want to add some parameters to filter the report, right?
If so, I suggest that you should associate a Query Parameter with a Report Parameter. Assume that you handle your querying works in a stored procedure, you can use getdate() method to get the current date, datediff() and dateadd() method to calculate the date. See the following code snippet (Just the idea, not the executable code.):
declare @.InputDay,@.StartDay,@.EndDay
-- @.EndDay=getdate()-1
case @.InputDay='Sun'
-- @.StartDay=getdate()-7
case @.InputDay='Mon'
-- @.StartDay=getdate()-1
case @.InputDay='Tue'
-- @.StartDay=getdate()-2
case @.InputDay='Wed'
-- @.StartDay=getdate()-3
case @.InputDay='Thu'
-- @.StartDay=getdate()-4
case @.InputDay='Fri'
-- @.StartDay=getdate()-5
case @.InputDay='Sat'
-- @.StartDay=getdate()-6
Thanks.
Friday, March 9, 2012
Help! Chart rendering problems (SOAP access)
Good day everyone!
I am displaying a line chart by SOAP access of reporting services. The is
rendered to my aspx page well for the first time, but if I change the
parameters, and call rs.Render, it's supposed to show a different picture,
but it's still showing the same one.
The problem is the picture always have the same name coming from the
streamID, so the IE browser get the same picture from its cache instead of
getting the image from disk.
I tried to change the StreamRoot every time, it works, but it's not what I
want.
So the question is:
Is there a way to have different streamID for a chart everytime you want to
render the chart?
Thanks!Could someone help?
"frank" wrote:
> Good day everyone!
> I am displaying a line chart by SOAP access of reporting services. The is
> rendered to my aspx page well for the first time, but if I change the
> parameters, and call rs.Render, it's supposed to show a different picture,
> but it's still showing the same one.
> The problem is the picture always have the same name coming from the
> streamID, so the IE browser get the same picture from its cache instead of
> getting the image from disk.
> I tried to change the StreamRoot every time, it works, but it's not what I
> want.
> So the question is:
> Is there a way to have different streamID for a chart everytime you want to
> render the chart?
> Thanks!
>
I am displaying a line chart by SOAP access of reporting services. The is
rendered to my aspx page well for the first time, but if I change the
parameters, and call rs.Render, it's supposed to show a different picture,
but it's still showing the same one.
The problem is the picture always have the same name coming from the
streamID, so the IE browser get the same picture from its cache instead of
getting the image from disk.
I tried to change the StreamRoot every time, it works, but it's not what I
want.
So the question is:
Is there a way to have different streamID for a chart everytime you want to
render the chart?
Thanks!Could someone help?
"frank" wrote:
> Good day everyone!
> I am displaying a line chart by SOAP access of reporting services. The is
> rendered to my aspx page well for the first time, but if I change the
> parameters, and call rs.Render, it's supposed to show a different picture,
> but it's still showing the same one.
> The problem is the picture always have the same name coming from the
> streamID, so the IE browser get the same picture from its cache instead of
> getting the image from disk.
> I tried to change the StreamRoot every time, it works, but it's not what I
> want.
> So the question is:
> Is there a way to have different streamID for a chart everytime you want to
> render the chart?
> Thanks!
>
Wednesday, March 7, 2012
HELP! - SQL Mail
Hello every1,
My question to you all is why can't I see the SQL Mail icon in the Support
Services folder in my SQL Server? how (if possible) do I make that icon
appear?
Currently I'm running SQL Server 2000 in Windows XP Professional
Thanx in advance for your help,
SB-Rhttp://www.aspfaq.com/2403
"segis bata" <segisbata@.hotmail.com> wrote in message
news:OliQj%23TbGHA.4520@.TK2MSFTNGP03.phx.gbl...
> Hello every1,
> My question to you all is why can't I see the SQL Mail icon in the Support
> Services folder in my SQL Server? how (if possible) do I make that icon
> appear?
> Currently I'm running SQL Server 2000 in Windows XP Professional
> Thanx in advance for your help,
> SB-R
>
My question to you all is why can't I see the SQL Mail icon in the Support
Services folder in my SQL Server? how (if possible) do I make that icon
appear?
Currently I'm running SQL Server 2000 in Windows XP Professional
Thanx in advance for your help,
SB-Rhttp://www.aspfaq.com/2403
"segis bata" <segisbata@.hotmail.com> wrote in message
news:OliQj%23TbGHA.4520@.TK2MSFTNGP03.phx.gbl...
> Hello every1,
> My question to you all is why can't I see the SQL Mail icon in the Support
> Services folder in my SQL Server? how (if possible) do I make that icon
> appear?
> Currently I'm running SQL Server 2000 in Windows XP Professional
> Thanx in advance for your help,
> SB-R
>
help! - line numbers
Please help me!
Is there some possibility to add line numbers to a table in Reporting
Services? Can't find it anywhere...
Thanks!
ArmandsAdd a field which contains
=rownumber(nothing)
It should gen line numbers for you.
--
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.
"Armands Brants" <armands.brants@.navigator.lv> wrote in message
news:%23ImZxVKTFHA.208@.TK2MSFTNGP10.phx.gbl...
> Please help me!
> Is there some possibility to add line numbers to a table in Reporting
> Services? Can't find it anywhere...
>
> Thanks!
> Armands
>
Is there some possibility to add line numbers to a table in Reporting
Services? Can't find it anywhere...
Thanks!
ArmandsAdd a field which contains
=rownumber(nothing)
It should gen line numbers for you.
--
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.
"Armands Brants" <armands.brants@.navigator.lv> wrote in message
news:%23ImZxVKTFHA.208@.TK2MSFTNGP10.phx.gbl...
> Please help me!
> Is there some possibility to add line numbers to a table in Reporting
> Services? Can't find it anywhere...
>
> Thanks!
> Armands
>
Monday, February 27, 2012
HELP!
i am running a windows sharepoint services site.. I get an error that says "Unable to connect to database. Check database connection information and make sure the database server is running."
i check my event log and get this..
Event Type:Information
Event Source:MSSQLSERVER/MSDE
Event Category:None
Event ID:1
Date:5/10/2004
Time:8:49:04 AM
User:N/A
Computer:211551S
Description:
You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the Microsoft Windows Server 2003 family. To reduce your computer'
s vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or M
SDE from http://www.microsoft.com/sql/downloads/default.asp
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
how do I get this thing up and running again.. please e-mail me at jason_adolf@.sra.com
That's an informational message in your event log that you
will get if you are running SQL Server at something less
than SP3. You should install SQL Server SP3.
-Sue
On Mon, 10 May 2004 06:01:05 -0700, jason7
<jason_adolf@.sra.com> wrote:
>i am running a windows sharepoint services site.. I get an error that says "Unable to connect to database. Check database connection information and make sure the database server is running."
>i check my event log and get this..
>Event Type:Information
>Event Source:MSSQLSERVER/MSDE
>Event Category:None
>Event ID:1
>Date:5/10/2004
>Time:8:49:04 AM
>User:N/A
>Computer:211551S
>Description:
>You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the Microsoft Windows Server 2003 family. To reduce your computer
's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or
MSDE from http://www.microsoft.com/sql/downloads/default.asp
>For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
>
>how do I get this thing up and running again.. please e-mail me at jason_adolf@.sra.com
i check my event log and get this..
Event Type:Information
Event Source:MSSQLSERVER/MSDE
Event Category:None
Event ID:1
Date:5/10/2004
Time:8:49:04 AM
User:N/A
Computer:211551S
Description:
You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the Microsoft Windows Server 2003 family. To reduce your computer'
s vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or M
SDE from http://www.microsoft.com/sql/downloads/default.asp
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
how do I get this thing up and running again.. please e-mail me at jason_adolf@.sra.com
That's an informational message in your event log that you
will get if you are running SQL Server at something less
than SP3. You should install SQL Server SP3.
-Sue
On Mon, 10 May 2004 06:01:05 -0700, jason7
<jason_adolf@.sra.com> wrote:
>i am running a windows sharepoint services site.. I get an error that says "Unable to connect to database. Check database connection information and make sure the database server is running."
>i check my event log and get this..
>Event Type:Information
>Event Source:MSSQLSERVER/MSDE
>Event Category:None
>Event ID:1
>Date:5/10/2004
>Time:8:49:04 AM
>User:N/A
>Computer:211551S
>Description:
>You are running a version of Microsoft SQL Server 2000 or Microsoft SQL Server 2000 Desktop Engine (also called MSDE) that has known security vulnerabilities when used in conjunction with the Microsoft Windows Server 2003 family. To reduce your computer
's vulnerability to certain virus attacks, the TCP/IP and UDP network ports of Microsoft SQL Server 2000, MSDE, or both have been disabled. To enable these ports, you must install a patch, or the most recent service pack for Microsoft SQL Server 2000 or
MSDE from http://www.microsoft.com/sql/downloads/default.asp
>For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
>
>how do I get this thing up and running again.. please e-mail me at jason_adolf@.sra.com
HELP!
Report services has suddenly refused all access from Internet Explorer (Error
403 - Forbidden).
The only change that has been made to IIS recently (that I am aware of but
others have access as well) is an upgrade from PHP 4 to PHP 5 but other
websites on the same server appear to be working correctly so I'm not
convinced this is the cause of the problem.
Can anyone please shed some light on this or atleast point me in the right
direction to avoid my having to re-install from scratch.
Thanks for any advice.
Ray HojkaWas Reporting Services installed to the default web site?
Perhaps the PHP upgrade program decided to "help" you out with your security
permissions in IIS ?|||Hi Al
Yes RS was installed to the default website. Do you have any idea what
permissions could have been changed. As far as I can tell everything looks
ok on that front but I could well be wrong.
"Al" wrote:
> Was Reporting Services installed to the default web site?
> Perhaps the PHP upgrade program decided to "help" you out with your security
> permissions in IIS ?
403 - Forbidden).
The only change that has been made to IIS recently (that I am aware of but
others have access as well) is an upgrade from PHP 4 to PHP 5 but other
websites on the same server appear to be working correctly so I'm not
convinced this is the cause of the problem.
Can anyone please shed some light on this or atleast point me in the right
direction to avoid my having to re-install from scratch.
Thanks for any advice.
Ray HojkaWas Reporting Services installed to the default web site?
Perhaps the PHP upgrade program decided to "help" you out with your security
permissions in IIS ?|||Hi Al
Yes RS was installed to the default website. Do you have any idea what
permissions could have been changed. As far as I can tell everything looks
ok on that front but I could well be wrong.
"Al" wrote:
> Was Reporting Services installed to the default web site?
> Perhaps the PHP upgrade program decided to "help" you out with your security
> permissions in IIS ?
Subscribe to:
Posts (Atom)