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 |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
 Posted - 2008-03-03 : 16:01:50
|
| I have Report server and Report Tempdb database in SQL 2000. Is there anyone who has done. Please explain how to migrate Reporting Services from 2000 to 2005 in steps. |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-03 : 22:24:42
|
| rmaio or SQL Experts:Please advise me regarding this |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-03 : 22:28:01
|
| Do you like to upgrade RS or just move RS DBs to sql2k5? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-03 : 22:29:57
|
| IF just moving Report DBS will work fine, then i want to go for that.But rmaio, do i have to do anything important to make reporting services work?Thanks rmaio. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-03 : 22:48:40
|
| Have to go through RS configuration again to point RS to new sql server. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-03 : 22:58:02
|
| I did everything you said but it asks for encryption password and doesn't wanna upgrade when i pressed upgrade button. I don't who created password.Its hard to figure out.Now what i should do? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-03 : 23:29:49
|
| Can you reset password in RS configuration? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-03-03 : 23:33:33
|
| Nope. |
|
|
|
|
|
|
How to Migrate Reporting Services from 2000to 2005