Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can we use Analysis Service 2000 Cubes in 2005 Reportin Service 1
- Thread starter anumala28
- Start date
-
1
- #2
You should be able to access the cubes just fine, the same way you can access a SQL 2000 database in SRS 2005. Everything SQL 2005 is supposed to be backwards compatible with reading SQL 2000 data.
Now, there are some tools that aren't able to be used with a 2000 database, like DBMail, but those are tools which look for specific stored procedures and values in system databases, etc. SRS is technically just looking at the data.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
Now, there are some tools that aren't able to be used with a 2000 database, like DBMail, but those are tools which look for specific stored procedures and values in system databases, etc. SRS is technically just looking at the data.
Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"
- Status
Similar threads
- Locked
- Question
- Locked
- Question