March 24, 2009 at 11:17 am
I installed a named instance of Sql Server 2008. When I go to "Reporting Services Configuration manager" and click on "Report Manager URL" it displays a URL link on the right side of the page:
http:// :80/Reports_Jerry2008
When I click the link I get "Page not found" in the browser.
I read that you have to specify port 80 when using IIS 5.1 with XP pro.
I think I also read that 2008 doesn't use IIS the way 2005 did for reporting services.
Thanks in advance for the help.
Jerry
March 24, 2009 at 12:42 pm
What OS are you running? XP?
SSRS 2008 does not need IIS like SSRS 2005 do, it will have its own web host process
Your URL is clearly not complete
Did you use the "Reporting Service Configuration Manager" in the programs menu?
March 24, 2009 at 1:01 pm
What OS are you running? XP?
XP Professional SP3
SSRS 2008 does not need IIS like SSRS 2005 do, it will have its own web host process
As I mentioned I had read that but I still need IIS for web development.
Your URL is clearly not complete
The URL should have read http://MachineName:80/Reports_Jerry2008
Did you use the "Reporting Service Configuration Manager" in the programs menu?
Yes. .... Start ... All Programs ... Microsoft Sql Server 2008 ... Configuration Tools ... Reporting Services Configuration Manager.
March 24, 2009 at 1:08 pm
Thanks for the info
can you connect successfully to the MachineName in SSRS Config Manager? did the status say "Started" or "Stopped"?
It's also possible you need a different port between default IIS (80) and a new one for SSRS
unless SSRS installer added the ReportServer application pool under IIS
I have SSRS installed on my laptop, no IIS installed, worked fine
on our SSRS server, I can specify the TCP Port, Virtual Directory name, and it shows a URL at the bottom for you to click
March 24, 2009 at 1:47 pm
Thanks for the info
can you connect successfully to the MachineName in SSRS Config Manager? did the status say "Started" or "Stopped"?
It's also possible you need a different port between default IIS (80) and a new one for SSRS
unless SSRS installer added the ReportServer application pool under IIS
I have SSRS installed on my laptop, no IIS installed, worked fine
on our SSRS server, I can specify the TCP Port, Virtual Directory name, and it shows a URL at the bottom for you to click
Thanks for the reply.
Yes, I can successfully connect to the machine name. It said "Started"
Not sure on the different port. What would it be?
It showed the the same URL under "Web Service URL" and "Report Manager URL"
March 24, 2009 at 1:54 pm
My SSRS port says 80 (default), but that MAY conflict with your IIS if it's on port 80 already
Try giving it a different port (81, 8080), and re-start the SSRS and try again
I suppose you can check the TCP ports running
http://live.sysinternals.com/Tcpview.exe
March 24, 2009 at 2:27 pm
I changed it to port 81 and got this:
Reporting Services Error
--------------------------------------------------------------------------------
The report server has encountered a configuration error. (rsServerConfigurationError) Get Online Help
--------------------------------------------------------------------------------
SQL Server Reporting Services
At least that's different.
March 24, 2009 at 3:27 pm
I found the answer to my problem:
https://www.blogger.com/comment.g?blogID=6855339694180792214&postID=3752127317600592384&page=1
SS2008 installation requires you to create a Report Server DB or access an existing one. In 2005 I'm pretty sure it did it automatically.
March 24, 2009 at 3:28 pm
Also I did have to use port 81.
Won't work on port 80.
March 24, 2009 at 4:15 pm
higgins.jerry (3/24/2009)
I found the answer to my problem:https://www.blogger.com/comment.g?blogID=6855339694180792214&postID=3752127317600592384&page=1
SS2008 installation requires you to create a Report Server DB or access an existing one. In 2005 I'm pretty sure it did it automatically.
Very certain SSRS 2008 install CAN create the ReportServer and ReportServerTempDB for you, that's how I did mine because I did not have any current SSRS2008 databases to copy over
February 23, 2011 at 7:46 am
For those who stumble on this same problem wirth SSRS R2, I also found my solution in this thread. When I installed SQL 2008 R2 Enterprise Edition, I used the default configuration option. On the W7 box, the installation worked just fine out of the box. On XP Pro Sp3, I had the same problem as described in this thread.
I opened Report Services Configuration Manager
Navigated to Web service URL
Changed the default TCP Port from 80 to 81
Clicked Apply
Navigate to Report Manager URL
Clicked Advanced
Removed Port 80
Added Port 81
Clicked OK
Clicked Apply
Test the URL
Now I had some slowness when trying to opne the web server and report manager URL's. I opened the port (81) on the firewall and all slowness went away.
My question to the community is, "Would opening the port on the firewall increase my performance?"
February 23, 2011 at 9:45 pm
Hi,
Reporting Services configuration manager can assist you in creating the reportserver abd reportservertempdb databases for you.
the requirements for this are as follow. A sql server instance where you can host the databases and the account that you used for reporting services needs DBcreator nd dbowner rights on that instance.
once you have the above ready, you can go to the configure database section and choose create database for reporting services option and follow the config manager. once complete your reporting databases should be available.
hope this helps.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply