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 |
|
Westley
Posting Yak Master
229 Posts |
 Posted - 2006-09-05 : 06:39:21
|
| Hi guys, got some issues with moving the DB for reporting services 2000, As the DB is not using the default DB name "ReportServer", it use "TestReportServer" so the tempdb for it also call "TestReportServer". Once I try to move to a DB server where it has a DB name "ReportServerTempDB" exists (since it host another reporting services), it try to use that temp db instead of its own one. I can connect to my "TestReportServer" through the web interface after running RSConfig, but then its not using "TestReportServerTempDB" but instead it uses "ReportServerTempDB" (which is the default). Is there any way to change the temp db connection?Thanks |
|
|
Westley
Posting Yak Master
229 Posts |
Posted - 2006-09-06 : 01:31:02
|
| Don't worry, I found out the reason, as you can't really move the tempdb :(Thanks anyway |
 |
|
|
|
|
|
Move RS 2000 DB