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

No comments:

Post a Comment