How to configure sql server reporting server 2005

Posted on 2006-05-12
Medium Priority
Last Modified: 2012-08-14
I have installed sql server 2005 reporting services. Using this i need to generate the reports from the data source in sql server 2000 not from 2005. I am unable to initialize the sql reporting server 2005. anyone can help me on how to initialize the reporting server.
Also i am able to generate the reports by connecting sql 2000 database, but unable to deploy this to sql reporting server 2005.Can anyone tell me is this possible to deploy the report generated from different datasource (sql 2000) into reporting service 2005.

Thanks in advance
sivakumar mali
Question by:pml_siva
  • 2
LVL 11

Accepted Solution

Ved Prakash Agrawal earned 2000 total points
ID: 16669329
"Note that Express cannot be installed on any system that has any version of SQL Server 2005 or its support tools -- i.e., data transformation services, reporting services, the tools package, and so on"

found on http://searchsqlserver.techtarget.com/tip/1,289483,sid87_gci1082707,00.html?bucket=ETA
LVL 11

Expert Comment

by:Ved Prakash Agrawal
ID: 16669344
Hi I think you have problem with the encryption key. so that you are not able to initialize the report.you need to create encryption keys and then tried to Initialize the report Services.

you need to Use Configured SQL Reporting services.


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

864 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question