March 13, 2009 at 3:54 pm
Hi,
Please clarify me the below are correct or not
Microsoft SQL Server Reporting Services Version 8.00.743.00 (RTM version )
Microsoft SQL Server Reporting Services SP2(8.00.0878)
Microsoft SQL Server Reporting Services SP2(8.00.1038)
thanx
March 13, 2009 at 3:58 pm
The short answer is no you cannot install it without at least SP3a and don't worry the installer will tell you. So install SP4 and then try again.
Kind regards,
Gift Peddie
March 13, 2009 at 4:13 pm
Thanks,
I installed sql server 2000 standard edition and applied SP4. Now I installed reporting services standard edition.So here I want to make the reporting services version.
what is the RTM version of reporting services and sp1 and sp2 versions
March 13, 2009 at 4:21 pm
You need to install SP2 after you install RTM but the actual question why are you trying to install this now when you can install SQL Server 2005 Express Tool kit edition and develop small reports free. This thing is so old you also need VS2003 which is obsolete to develop your reports. Goodluck because there is limited material to use this product.
Kind regards,
Gift Peddie
March 13, 2009 at 4:44 pm
We using sql server 2000 reporting services.Now we are upgrading to sql server 2005.Please clarify the below so that I can start my upgrade test.
Can we upgrade SQL Server2000 Reporting services standard edition(RTM version) directly to SQL Server 2005 reporting services OR do we need apply the service packs(SP1 or SP2) for SQL Server 2000 reporting services and then upgrade to sql server 2005 reporting services?
thanks
March 13, 2009 at 5:02 pm
So you need the SSRS 2000 upgrade guide use the two below and service packs is not required, the reason you need service pack for 2000 is because SSRS was an add on in 2004. So read the two links below carefully and you can upgrade without issues.
http://msdn.microsoft.com/en-us/library/ms143747(SQL.90).aspx
http://www.microsoft.com/Sqlserver/2005/en/us/reporting-services-faq.aspx
Kind regards,
Gift Peddie
March 13, 2009 at 6:08 pm
Thanks Peddie,
To test the upgrade I foolowed the below steps:
1.Build new test server
2.install sql server 2000 and applied sp4 in the test server
3.Restored the databses from production into test server.
4.Moved the login
5.moved the jobs.
6.How can move the reporting services from production sql server to Test server?there is report server and report serverTempDb.Do I need just restored like other databases?
7.If I restore report server n reportServertempDb as other databases, when I install reporting services it will try to create report server and report serverTempDb right?
8.How can i move all the reports from production sql to test sql.
9.I want run the in-place upgrade in the test server?
please guide me how can I achieve steps 6,7,8.
thanks
March 13, 2009 at 6:15 pm
I need to know operating system so I can know IIS version before I give you the steps.
Kind regards,
Gift Peddie
March 13, 2009 at 6:18 pm
OS:windows 2003 R2 standard editon with service pack2.I already installed IIS6.0 and ASP.NET 1.1
March 13, 2009 at 6:27 pm
What do you mean IIS 6 is already installed? And Asp.net 1.1. I don't like that because SSRS 2005 require Asp.net 2.0 configured in IIS6 and it is very complicated. So let me know if any application is now running in IIS 6?
Kind regards,
Gift Peddie
March 13, 2009 at 6:46 pm
What do you mean IIS 6 is already installed? And Asp.net 1.1. I don't like that because SSRS 2005 require Asp.net 2.0 configured in IIS6 and it is very complicated. So let me know if any application is now running in IIS 6?
Peddie, I did not come to the point of installing 2005 yet, Iam just talking about 'How to transfer all the reports and when to restore ReportServer database n ReportServerTempDb' from the production sql 2000 to Test server in which I already installed sql server 2000, applied sp4, restored the production databases,logins,jobs.
Now my question is how to deal with reporting services to get the same picture in My test server as the Production Server has?
when we build the test server, we installed the IIS6.0 and ASP.NET 1.1 and it is registered with the IIS.
thanks
March 13, 2009 at 7:08 pm
This is the same IIS that will later be used to upgrade to SSRS 2005 if yes then you need to remove it and reinstall in and click on details and enable about ten to fifteen features needed to run Asp.net 2.0 because Asp.net 1.1 runs on Asp.net 2.0 but Asp.net 2.0 will not run with Asp.net 1.1 as default because IIS6 was created to run just static html Asp.net must be added and configured.
Kind regards,
Gift Peddie
March 13, 2009 at 7:34 pm
6.How can move the reporting services from production sql server to Test server?there is report server and report serverTempDb.Do I need just restored like other databases?
The links below show how to move ReportServerDB and TempReportServerDB to another computer and how to configure it, the second link shows how to move the Reports and how to configure it.
http://msdn.microsoft.com/en-us/library/ms156421(SQL.90).aspx
http://support.microsoft.com/?kbid=842425
7.If I restore report server n reportServertempDb as other databases, when I install reporting services it will try to create report server and report serverTempDb right?
NO. The reason you need the RDL files and other resources stored in your old ReportServerDB.
8.How can i move all the reports from production sql to test sql.
All that is covered in both links please follow the steps as is.
9.I want run the in-place upgrade in the test server?
If your migration worked correctly yes. But pay attention to all the files you need to move near the end MSDN article.
Kind regards,
Gift Peddie
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply