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 |
|
tbrothers
Yak Posting Veteran
83 Posts |
 Posted - 2008-08-21 : 16:11:18
|
| Hi,I had a report server crash this morning. It finally came up after multiple power on/off attempts. I stopped the Reporting Services, detached the databases, copied to a safe location and then reattached. The server is back in production.I setup a new server (different name) and attached the copied databases from above. SRS works fine ... Except that the credentials for the shared data sources seem to have been lost.Any ideas?Thanks,Terry |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tbrothers
Yak Posting Veteran
83 Posts |
Posted - 2008-08-21 : 16:21:08
|
| I did. I read all the MSDN articles about moving, migrating and restoring a SRS server and they didn't mention the data sources so I was just wondering if it were normal to loose them.Thanks,Terry |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Crashed Report Server