Moving Reporting Databases (redux)

I am trying to move my reporting databases on Server1 to another server (Server2). The databases are named ReportServer$Server1 and ReportServer$Server1TempDB, and I would like them to be named ReportServer$Server2 and ReportServer$Server2TempDB on Server2. I have followed all the steps in the KB articles on moving databases, and I have restored the key from Server1 onto Server2. I can use the Report Manager to change the Data Source connection string on Server2. However, when I try to access a report, or delete an unwanted object, it always errors out, and there is a reference to ReportServer$Server1TempDB in the error message.

Where is this dependency on the old name coming from? Is there no way to rename the report server databases?

Thx

Helen

Further to my question, it appears that changing the name of the report databases when moving them to another server is not supported. I have solved my problem by using the configuration tool to create new report databases on Server1, named ReportServer and ReportServerTempDB. I then rebuilt all my reporting objects, and following the instructions in the various KB articles, successfully moved the 3 databases to Server2 (without changing their names).

If anyone knows how to move report server databases and also change their names, I'd love to know how you did it. Also, if anyone knows where the dependency on the name of the tempdb is (somewhere in the reportserver db) I'd alsp be interested.

Cheers

Moving Reporting Databases (redux)

I am trying to move my reporting databases on Server1 to another server (Server2). The databases are named ReportServer$Server1 and ReportServer$Server1TempDB, and I would like them to be named ReportServer$Server2 and ReportServer$Server2TempDB on Server2. I have followed all the steps in the KB articles on moving databases, and I have restored the key from Server1 onto Server2. I can use the Report Manager to change the Data Source connection string on Server2. However, when I try to access a report, or delete an unwanted object, it always errors out, and there is a reference to ReportServer$Server1TempDB in the error message.

Where is this dependency on the old name coming from? Is there no way to rename the report server databases?

Thx

Helen

Further to my question, it appears that changing the name of the report databases when moving them to another server is not supported. I have solved my problem by using the configuration tool to create new report databases on Server1, named ReportServer and ReportServerTempDB. I then rebuilt all my reporting objects, and following the instructions in the various KB articles, successfully moved the 3 databases to Server2 (without changing their names).

If anyone knows how to move report server databases and also change their names, I'd love to know how you did it. Also, if anyone knows where the dependency on the name of the tempdb is (somewhere in the reportserver db) I'd alsp be interested.

Cheers

Moving MASTER and MSDB to a New Server

I am working on a consolidation project. I would like to move my SQL
environment from SERVER1 to SERVER2. The old SQL is the default instance.
It's moving to an instance on SERVER2. The server name will be different
after the move. How do I move the MSDB and MASTER in this case?
ThanksHi,
Does this Help?
INF: Moving SQL Server databases to a new location with
Detach/Attach
http://support.microsoft.com/default.aspx?kbid=224071
Also Look into to the articles mentioned in References.
Regards
Thirumal
>--Original Message--
>I am working on a consolidation project. I would like to
move my SQL
>environment from SERVER1 to SERVER2. The old SQL is the
default instance.
>It's moving to an instance on SERVER2. The server name
will be different
>after the move. How do I move the MSDB and MASTER in
this case?
>Thanks
>
>.
>|||I've seen those articles. What's different in my case is that the name of
the server is also changing. I don't see references to that.
"Thirumal" <treddym@.hotmail.nospam.com> wrote in message
news:16b5a01c41cbc$aced51c0$a601280a@.phx.gbl...
> Hi,
> Does this Help?
> INF: Moving SQL Server databases to a new location with
> Detach/Attach
> http://support.microsoft.com/default.aspx?kbid=224071
> Also Look into to the articles mentioned in References.
> Regards
> Thirumal
> >--Original Message--
> >I am working on a consolidation project. I would like to
> move my SQL
> >environment from SERVER1 to SERVER2. The old SQL is the
> default instance.
> >It's moving to an instance on SERVER2. The server name
> will be different
> >after the move. How do I move the MSDB and MASTER in
> this case?
> >
> >Thanks
> >
> >
> >.
> >|||Hi,
The article is still applicable. You need to drop the old
server & add the new one.
http://www.karaszi.com/sqlserver/info_change_server_name.as
p
HTH
Regards
Thirumal
>--Original Message--
>I've seen those articles. What's different in my case is
that the name of
>the server is also changing. I don't see references to
that.
>
>"Thirumal" <treddym@.hotmail.nospam.com> wrote in message
>news:16b5a01c41cbc$aced51c0$a601280a@.phx.gbl...
>> Hi,
>> Does this Help?
>> INF: Moving SQL Server databases to a new location with
>> Detach/Attach
>> http://support.microsoft.com/default.aspx?kbid=224071
>> Also Look into to the articles mentioned in References.
>> Regards
>> Thirumal
>> >--Original Message--
>> >I am working on a consolidation project. I would like
to
>> move my SQL
>> >environment from SERVER1 to SERVER2. The old SQL is
the
>> default instance.
>> >It's moving to an instance on SERVER2. The server name
>> will be different
>> >after the move. How do I move the MSDB and MASTER in
>> this case?
>> >
>> >Thanks
>> >
>> >
>> >.
>> >
>
>.
>