• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 767
  • Last Modified:

How to configure sql server reporting server 2005

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
  • 2
1 Solution
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
"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
Ved Prakash AgrawalDatabase Consultant/Performance ArchitectCommented:
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now