I installed reporting services with SQL server 2005 on Windows Server 2003 R2. After installation which run successful without warning I want to check my installation. I open IE on the server and type:
http://localhost/reportserver$SQLEXPRESS but all I got is:
localhost/ReportServer$SQLExpress - /
2 lines
-----------
-----------
Microsoft SQL Server Reporting Services Version 9.00.2047.00
And that's all. Why I cannot see the home directory displayed ?
Appart selecting Chinese_PRC_90 for the collate I think I have just validated the default option for everything.
When I start the RS Configuration Manager, I see the Initialization button in grey and I cannot access it. Is this normal ?
I have explained why it is not working in the thread below because Express is free Microsoft have it setup you have to choose use either the Algebra end which is the Advanced or Toolkit which is the Calculus end, to use both you need the no deployment developer edition which cost a few dollars. Hope this helps.
http://forums.asp.net/thread/1482957.aspx
|||Thank you for the answer. I tried to read carefully all the links you provided but I still cannot understand. On the server (Windows server 2003) I installed only the SQL Server 2005 Express Edition with Advanced Services SP1 (SQLEXPR_ADV.EXE). I did again the installation installing only SQL server engine with shared tools and reporting services with shared tools. I did not install any client part. But it is still the same.
|||
(SQL Server 2005 Express Edition Toolkit)
And because Express is free you cannot use the Tool Kit and the Advanced together because the Tool Kit is for the Calculus end and the Advanced is for the Algebra end, Microsoft have it setup you cannot have both, to use both you need the developer edition. Hope this helps.
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
I hope you understand the above, the developer edition.
http://www.provantage.com/microsoft-e32-00575~7MCSB0EX.htm
|||
Thank you for the help but this is just the information you already provided in the first link you gave.
I partially solved my problem. To access the reporting services I should use the URL:http://localhost/reports$SQLExpress.
This worked on a new installation I have done. And finally after comparing my new installation with old one I fixed my problem.
Also I used the information fromhttp://sqljunkies.com/Article/525B575A-7F61-483A-AC8F-FEC700C34674.scuk explaining how to move reporting service default directories.
Thank you.
|||I am glad you have resolved your problem but that is what I have been trying to explain to you now you are using the Tool Kit you cannot use any part of the Advanced. That is what Microsoft said you have to use both ends separately.
No comments:
Post a Comment