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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2012-08-10 : 15:22:00
|
| Hi,I am migrating reporting services from one server to other with same version and edition (2008 r2). Here what I did:1. Installed SSRS as default instance on new server.2. Backup and restore reportserver and reportservertempdb on new sever.3. configure SSRS on new server using existing reportserver db.Now I can see reports and data sources folder in report manager. These data sources are pointing to old server. I changed new server name but there is one option to type credentials and show report credentials are stored on report server. It shows account name (reportreader) but does not show password. How I can copy these credentials for data sources?Thanks |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-08-13 : 18:47:41
|
| Do you need to copy the credentials at the SQL level or at the report level? e.g., Do you need to create new LOGINs on the new server or is it a matter of putting the password into one of the report files?=================================================Show me a sane man and I will cure him for you. -Carl Jung, psychiatrist (1875-1961) |
 |
|
|
|
|
|
Reporting Services Data Source