RS2005 - Backend database SQL 2000

Hot Topic

SQLSERVERAGENT reporting lots of errors in event log - HELP
Report printing in landscape from SQL Reporting Services designer or browser
SQL CE Installation Location
Getting the value of "SET ROWCOUNT"
Format Date in Reports
Normalize data
Installing SQL Server 2005 Express
Error "An attempt to attach an auto-named database for file"
Infinite Loop in cursor
Setting up SQL Server 2005 Express Edition with Advance Services

SQL Server

Move an analyis Database
For new in SSIS. To send data from operational d/base to data warehouse
Data flow task multiple destinations
Migrating DTS Active X/ADO script to SSIS
SQL Server 2005 Developer Edition Setup Error
SQLCE 2.0 and SQLCE 3.0, both on same server
How to write a query
Problem of adding trusted accounts to reporting services: 'Some or all identity references could not be translated'
Getdate() overflowing datetime
Final Model

RS2005 - Backend database SQL 2000

Hi,

Is it possible to have RS2005 with the backend as SQL Server 2000 (may be on a remote machine)

I.e. the Reportserver and ReportServerTempDb will reside on SQL Server 2000.

With which edition of SQL Server 2005 is it possible

TIA,
Tanmaya

Answer this question

RS2005 - Backend database SQL 2000

  • Tryst

    Dear,

    U can link a datasource from sqlserver2000.But u cannot have a reportserver and reportservertempdatabase on sqlserver2000.

    No edition of sqlserver2005 support this.

    HTH

    sufian



  • xavito

    Thanks,

    RS2005 enterprise edition works with backend as SQL 2000.

    In Reporting Services configuration manager -> database set, I connected to the machine having SQL 2000 and successfully created the Reportserver and ReportServerTempDb.

    However, am getting an error at 'Create Grants Right Script'. I am giving the credentials of system adminstrator (i.e. sa)

    Am I going wrong in giving the credentials Which User's credentials am I suppose to enter there

    Has anyone tried this scenario

    Thanks
    Tanmaya

  • bozo14

    Yes, this is possible and supported. For example, you can install RS 2005 Enterprise Edition with the metadata being stored on a SQL Server 2000 Enterprise Edition.

    -- Robert



  • nikoo

    Please be careful in doing this as it does change some things on that backend. I messed up our backup software by doing this. In short the backup software does not support 2005 server yet and the things that report service installs, installed something that our back software was using....
  • RS2005 - Backend database SQL 2000
Answer this question