How to configure sql server reporting server 2005

Posted on 2006-05-12
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
    LVL 11

    Accepted Solution

    "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,289483,sid87_gci1082707,00.html?bucket=ETA
    LVL 11

    Expert Comment

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

    you need to Use Configured SQL Reporting services.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
    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…
    Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

    760 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

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now