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?
>>
>
Showing posts with label rename. Show all posts
Showing posts with label rename. Show all posts
Tuesday, March 20, 2012
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
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
Subscribe to:
Posts (Atom)