Renamed SQL server and reporting services web site is down?

I renamed my SQL server (MOM 2005 server) and everything works fine execpt
the reporting services. If I type http://server/reports I get an error page
which says:
Error:
The request failed with HTTP status 401: Unauthorized.I'm assuming your reporting service is on the same server that you renamed?
If so, follow these steps.
I've used the steps on a couple of occassions and they work fine.
http://msdn2.microsoft.com/en-us/library/ms345235.aspx
Immy
"Gonzo" <no@.no.com> wrote in message
news:eWhERBVZHHA.3968@.TK2MSFTNGP06.phx.gbl...
>I renamed my SQL server (MOM 2005 server) and everything works fine execpt
>the reporting services. If I type http://server/reports I get an error
>page which says:
> Error:
>
> The request failed with HTTP status 401: Unauthorized.
>
>|||Hi, first of all I can't locate the Reporting Services Configuration tool
and where would the RSReportServer.config be?
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:OSdX6MVZHHA.5060@.TK2MSFTNGP04.phx.gbl...
> I'm assuming your reporting service is on the same server that you
> renamed? If so, follow these steps.
> I've used the steps on a couple of occassions and they work fine.
> http://msdn2.microsoft.com/en-us/library/ms345235.aspx
> Immy
> "Gonzo" <no@.no.com> wrote in message
> news:eWhERBVZHHA.3968@.TK2MSFTNGP06.phx.gbl...
>>I renamed my SQL server (MOM 2005 server) and everything works fine execpt
>>the reporting services. If I type http://server/reports I get an error
>>page which says:
>> Error:
>>
>> The request failed with HTTP status 401: Unauthorized.
>>
>>
>|||Immy, sorry I found them. A bog thanks as it all works now!!!
"Immy" <therealasianbabe@.hotmail.com> wrote in message
news:OSdX6MVZHHA.5060@.TK2MSFTNGP04.phx.gbl...
> I'm assuming your reporting service is on the same server that you
> renamed? If so, follow these steps.
> I've used the steps on a couple of occassions and they work fine.
> http://msdn2.microsoft.com/en-us/library/ms345235.aspx
> Immy
> "Gonzo" <no@.no.com> wrote in message
> news:eWhERBVZHHA.3968@.TK2MSFTNGP06.phx.gbl...
>>I renamed my SQL server (MOM 2005 server) and everything works fine execpt
>>the reporting services. If I type http://server/reports I get an error
>>page which says:
>> Error:
>>
>> The request failed with HTTP status 401: Unauthorized.
>>
>>
>

Rename server running Reporting Services

Has anyone successfuly renamed a SSRS 2005 server? I tried this:
http://technet.microsoft.com/en-us/library/ms345235.aspx
to no avail. The SSRS service is running, I just can't connect to it using
MSIE (http://localhost/reports or http://localhost/reportserver) or
Management Studio. ISS is up and running. I'm using MSSQL 2005 Enterprise
SP1 on Windows Server 2003 Standard.
Thank you,
--
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.comCheck the Reporting services Configuration Manager whether it is connected to
your database server using
All Programs\SQL Server 2005\Configuration Tools\Reporting services
Configuration
And in Internet Information Services Manager check whether the
server/websites containing reportserver is started using
start -> run -> inetmgr
Also try using http://your servername/reportserver
--
Regards,
ArvindRavish
"Alain Quesnel" wrote:
> Has anyone successfuly renamed a SSRS 2005 server? I tried this:
> http://technet.microsoft.com/en-us/library/ms345235.aspx
> to no avail. The SSRS service is running, I just can't connect to it using
> MSIE (http://localhost/reports or http://localhost/reportserver) or
> Management Studio. ISS is up and running. I'm using MSSQL 2005 Enterprise
> SP1 on Windows Server 2003 Standard.
> Thank you,
> --
>
> Alain Quesnel
> alainsansspam@.logiquel.com
> www.logiquel.com
>
>|||I had already tried all those things. Couldn't connect. I also tried
rebooting the server after making the recommended modifications. That
doesn't work either. Funny thing is, I have all green checkmarks in
Reporting Services Configuration Manager. Also note that the computer rename
occurs after a Ghost multicast and a sysprep (so that we can have different
names for all servers).
Thank you,
--
Alain Quesnel
alainsanspam@.logiquel.com
www.logiquel.com
"ArvindRavish" <ArvindRavish@.discussions.microsoft.com> wrote in message
news:ECA81F96-D43B-4E36-B8B7-2A10C473F395@.microsoft.com...
> Check the Reporting services Configuration Manager whether it is connected
> to
> your database server using
> All Programs\SQL Server 2005\Configuration Tools\Reporting services
> Configuration
> And in Internet Information Services Manager check whether the
> server/websites containing reportserver is started using
> start -> run -> inetmgr
> Also try using http://your servername/reportserver
> --
> Regards,
> ArvindRavish
>
> "Alain Quesnel" wrote:
>> Has anyone successfuly renamed a SSRS 2005 server? I tried this:
>> http://technet.microsoft.com/en-us/library/ms345235.aspx
>> to no avail. The SSRS service is running, I just can't connect to it
>> using
>> MSIE (http://localhost/reports or http://localhost/reportserver) or
>> Management Studio. ISS is up and running. I'm using MSSQL 2005 Enterprise
>> SP1 on Windows Server 2003 Standard.
>> Thank you,
>> --
>>
>> Alain Quesnel
>> alainsansspam@.logiquel.com
>> www.logiquel.com
>>

removing a user from a database problem

I have followed the procedure in http://support.microsoft.com/kb/275312
to change object ownership so that I can delete a user.
This appears to have worked ( subsequent runs tell me that the
original user owns no objects and a query on the sysobjects table
filtered on their uid confirms this)
When I go to delete the user in enterprise manager it tells me that
the user still owns objects ( i have refreshed the view and even
exited EM to no effect)
I am using SQL server 2000 sp4
Any help much appreciated...
TIAHi
Have you tried sp_dropuser stored procedure in QA?
<pryan@.meticulus.com> wrote in message
news:1185880756.933653.204030@.19g2000hsx.googlegroups.com...
>I have followed the procedure in http://support.microsoft.com/kb/275312
> to change object ownership so that I can delete a user.
> This appears to have worked ( subsequent runs tell me that the
> original user owns no objects and a query on the sysobjects table
> filtered on their uid confirms this)
> When I go to delete the user in enterprise manager it tells me that
> the user still owns objects ( i have refreshed the view and even
> exited EM to no effect)
> I am using SQL server 2000 sp4
> Any help much appreciated...
> TIA
>

removing a user from a database problem

I have followed the procedure in http://support.microsoft.com/kb/275312
to change object ownership so that I can delete a user.
This appears to have worked ( subsequent runs tell me that the
original user owns no objects and a query on the sysobjects table
filtered on their uid confirms this)
When I go to delete the user in enterprise manager it tells me that
the user still owns objects ( i have refreshed the view and even
exited EM to no effect)
I am using SQL server 2000 sp4
Any help much appreciated...
TIAHi
Have you tried sp_dropuser stored procedure in QA?
<pryan@.meticulus.com> wrote in message
news:1185880756.933653.204030@.19g2000hsx.googlegroups.com...
>I have followed the procedure in http://support.microsoft.com/kb/275312
> to change object ownership so that I can delete a user.
> This appears to have worked ( subsequent runs tell me that the
> original user owns no objects and a query on the sysobjects table
> filtered on their uid confirms this)
> When I go to delete the user in enterprise manager it tells me that
> the user still owns objects ( i have refreshed the view and even
> exited EM to no effect)
> I am using SQL server 2000 sp4
> Any help much appreciated...
> TIA
>

removing a user from a database problem

I have followed the procedure in http://support.microsoft.com/kb/275312
to change object ownership so that I can delete a user.
This appears to have worked ( subsequent runs tell me that the
original user owns no objects and a query on the sysobjects table
filtered on their uid confirms this)
When I go to delete the user in enterprise manager it tells me that
the user still owns objects ( i have refreshed the view and even
exited EM to no effect)
I am using SQL server 2000 sp4
Any help much appreciated...
TIA
Hi
Have you tried sp_dropuser stored procedure in QA?
<pryan@.meticulus.com> wrote in message
news:1185880756.933653.204030@.19g2000hsx.googlegro ups.com...
>I have followed the procedure in http://support.microsoft.com/kb/275312
> to change object ownership so that I can delete a user.
> This appears to have worked ( subsequent runs tell me that the
> original user owns no objects and a query on the sysobjects table
> filtered on their uid confirms this)
> When I go to delete the user in enterprise manager it tells me that
> the user still owns objects ( i have refreshed the view and even
> exited EM to no effect)
> I am using SQL server 2000 sp4
> Any help much appreciated...
> TIA
>