Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bogey
Posting Yak Master
166 Posts |
 Posted - 2010-04-15 : 09:21:54
|
| Our reporting servcies and databases for ssrs reside on different boxes. Can SSRS 2005 use SQL 2008 for its databases? If anyone has done something similar what is the best way to get to SSRS 2008 when you have the Reporting and databases for reporting on seperate machinesthanks. |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-04-15 : 11:06:20
|
| When you say "use sql 2008 for its databases" what are you referring to?Do you mean as data sources?______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
bogey
Posting Yak Master
166 Posts |
Posted - 2010-04-15 : 13:29:51
|
SSRS uses 2 databases to store its info in. If we are currently using SSRS 2005 and our dbms is MS SQL 2005 we want to upgrade the DBMS to 2008. Can we leave the SSRS as 2005 and upgrade the backend to 2008?Hope that helps. quote:
Originally posted by savior faire
When you say "use sql 2008 for its databases" what are you referring to?Do you mean as data sources?______________________________________________Talk sense to a fool and he calls you foolish.
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
SSRS 2005 Upgrade to 2008