Showing posts with label rename. Show all posts
Showing posts with label rename. Show all posts

Tuesday, March 20, 2012

Reports not updating since server rename

I renamed the SQL 2000 server, it houses MOM 2006 and reporting services and
the reports no longer update, is it look for the old server name?Yes - correct!
Here are the instructions to follow when you rename a reporting server.
http://msdn2.microsoft.com/en-us/library/ms345235.aspx
Immy
"Gonzo" <no@.no.com> wrote in message
news:uWkZV5tZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>I renamed the SQL 2000 server, it houses MOM 2006 and reporting services
>and the reports no longer update, is it look for the old server name?
>|||I've already done that though.
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:%23Si4YwuZHHA.5020@.TK2MSFTNGP05.phx.gbl...
> Yes - correct!
> Here are the instructions to follow when you rename a reporting server.
> http://msdn2.microsoft.com/en-us/library/ms345235.aspx
> Immy
>
> "Gonzo" <no@.no.com> wrote in message
> news:uWkZV5tZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>>I renamed the SQL 2000 server, it houses MOM 2006 and reporting services
>>and the reports no longer update, is it look for the old server name?
>|||whats the exact errors you are getting?
"Gonzo" <no@.no.com> wrote in message
news:uwvvCNvZHHA.1580@.TK2MSFTNGP05.phx.gbl...
> I've already done that though.
> "Immy" <therealasianbabe@.hotmail.com> wrote in message
> news:%23Si4YwuZHHA.5020@.TK2MSFTNGP05.phx.gbl...
>> Yes - correct!
>> Here are the instructions to follow when you rename a reporting server.
>> http://msdn2.microsoft.com/en-us/library/ms345235.aspx
>> Immy
>>
>> "Gonzo" <no@.no.com> wrote in message
>> news:uWkZV5tZHHA.2552@.TK2MSFTNGP06.phx.gbl...
>>I renamed the SQL 2000 server, it houses MOM 2006 and reporting services
>>and the reports no longer update, is it look for the old server name?
>>
>

Saturday, February 25, 2012

Reporting Svcs not working after renaming the server - help!

Hi,
we had to rename our server running SQL server and reporting services
(including IIS), and now the reporting services don't work anymore.
I guess the easiest way would probably be uninstalling the reporting
services and then re-installing them again, but I wanted to ask if there
was another way...
Thanks!
JensWhat errors are you getting? Can you navigate to
http://localhost/reportserver? You may just need to run rsconfig.exe to
reset the connection string but I need to know the errors first.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jens Weiermann" <wexman@.wexman.com> wrote in message
news:u8DGsWtcEHA.2352@.TK2MSFTNGP09.phx.gbl...
> Hi,
> we had to rename our server running SQL server and reporting services
> (including IIS), and now the reporting services don't work anymore.
> I guess the easiest way would probably be uninstalling the reporting
> services and then re-installing them again, but I wanted to ask if there
> was another way...
> Thanks!
> Jens|||Daniel Reib [MSFT] wrote:
> What errors are you getting? Can you navigate to
> http://localhost/reportserver? You may just need to run rsconfig.exe to
> reset the connection string but I need to know the errors first.
Hi Daniel,
thanks for your answer - but I'm afraid it is too late now <g> as we've
already uninstalled the reporting services and re-installed them again.
However, now I got a different problem: While reports are working in
general, subscriptions are *not*.
When I try to make a new abonnement, I'm receiving an internal error
"@.owner_login_name was specified and is invalid" (sorry, translation from
German version, might not be the exact wording).
Any suggestions?
Regards,
Jens|||There are two ways to fix this problem. Install the following SQL fix:
http://support.microsoft.com/default.aspx?scid=kb;en-us;821334
Or use RSconfig to have RS talk to it's catalog using sql auth.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jens Weiermann" <spamgoeshere@.solidsoftware.de> wrote in message
news:OmlQkw8cEHA.4092@.TK2MSFTNGP10.phx.gbl...
> Daniel Reib [MSFT] wrote:
> > What errors are you getting? Can you navigate to
> > http://localhost/reportserver? You may just need to run rsconfig.exe to
> > reset the connection string but I need to know the errors first.
> Hi Daniel,
> thanks for your answer - but I'm afraid it is too late now <g> as we've
> already uninstalled the reporting services and re-installed them again.
> However, now I got a different problem: While reports are working in
> general, subscriptions are *not*.
> When I try to make a new abonnement, I'm receiving an internal error
> "@.owner_login_name was specified and is invalid" (sorry, translation from
> German version, might not be the exact wording).
> Any suggestions?
> Regards,
> Jens