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.
>>
>>
>

Renamed RS Server; unable to access site

Good evening. I just renamed the server that hosts both SQL Server and Reporting Services. I am now unable to access the report manager website (http://localhost/reports). I receive an error stating "The underlying connection was closed: The remote name could not be resolved." As suggested by previous posts, I ran the rsconfig.exe utility specifying the new server name along with the security information. I am now able to access the report server (http://localhost/reportserver) and I can successfully run reports. I am still receiving the same error when attempting to access the report manager website, however. I have searched the registry and replaced the only instance of the old server name in a key pertaining to Reporting Services and rebooted, but I still have the same problem.
Please provide any information that will resolve this problem. Thanks in advance,
KevinIn your Report Manager directory, look for a RSWebApplication.config file. Open that baby up and look for something like:
<ReportServerUrl>http://Youroldservername/ReportServer</ReportServerUrl>
You might spot your old server name there. I've been playing with that file today, which sparked the idea. Not a clue if it works or not!
Hope it helps!
- T
"Kevin" wrote:
> Good evening. I just renamed the server that hosts both SQL Server and Reporting Services. I am now unable to access the report manager website (http://localhost/reports). I receive an error stating "The underlying connection was closed: The remote name could not be resolved." As suggested by previous posts, I ran the rsconfig.exe utility specifying the new server name along with the security information. I am now able to access the report server (http://localhost/reportserver) and I can successfully run reports. I am still receiving the same error when attempting to access the report manager website, however. I have searched the registry and replaced the only instance of the old server name in a key pertaining to Reporting Services and rebooted, but I still have the same problem.
> Please provide any information that will resolve this problem. Thanks in advance,
> Kevin
>|||You need to update the server URL in the file rswebapplication.config
--
This posting is provided "AS IS" with no warranties, and confers no rights
"Kevin" <Kevin@.discussions.microsoft.com> wrote in message
news:09D00359-881C-41F5-9D16-BE40D5A4023A@.microsoft.com...
> Good evening. I just renamed the server that hosts both SQL Server and
Reporting Services. I am now unable to access the report manager website
(http://localhost/reports). I receive an error stating "The underlying
connection was closed: The remote name could not be resolved." As suggested
by previous posts, I ran the rsconfig.exe utility specifying the new server
name along with the security information. I am now able to access the
report server (http://localhost/reportserver) and I can successfully run
reports. I am still receiving the same error when attempting to access the
report manager website, however. I have searched the registry and replaced
the only instance of the old server name in a key pertaining to Reporting
Services and rebooted, but I still have the same problem.
> Please provide any information that will resolve this problem. Thanks in
advance,
> Kevin
>|||That did the trick. Thanks for all of your help!
Kevin
"Brian Hartman [MSFT]" wrote:
> You need to update the server URL in the file rswebapplication.config
> --
> This posting is provided "AS IS" with no warranties, and confers no rights
> "Kevin" <Kevin@.discussions.microsoft.com> wrote in message
> news:09D00359-881C-41F5-9D16-BE40D5A4023A@.microsoft.com...
> > Good evening. I just renamed the server that hosts both SQL Server and
> Reporting Services. I am now unable to access the report manager website
> (http://localhost/reports). I receive an error stating "The underlying
> connection was closed: The remote name could not be resolved." As suggested
> by previous posts, I ran the rsconfig.exe utility specifying the new server
> name along with the security information. I am now able to access the
> report server (http://localhost/reportserver) and I can successfully run
> reports. I am still receiving the same error when attempting to access the
> report manager website, however. I have searched the registry and replaced
> the only instance of the old server name in a key pertaining to Reporting
> Services and rebooted, but I still have the same problem.
> >
> > Please provide any information that will resolve this problem. Thanks in
> advance,
> > Kevin
> >
>
>|||We completed an installation of SQL Server 2000 Reporting Services and
upon trying to visit the server to publish or view the normal menu we
get only the following error:
-2147467259 (0x80004005)
The local user on the IIS server has access to the Report Database , I
can create a UDL and get a Connection Successful from the IIS box. But
I can't seem to get my normal startup page from any PC.
Thanks,
Teros wrote On 7/27/2004 4:25 PM:
> In your Report Manager directory, look for a RSWebApplication.config file. Open that baby up and look for something like:
> <ReportServerUrl>http://Youroldservername/ReportServer</ReportServerUrl>
> You might spot your old server name there. I've been playing with that file today, which sparked the idea. Not a clue if it works or not!
> Hope it helps!
> - T
>
> "Kevin" wrote:
>
>>Good evening. I just renamed the server that hosts both SQL Server and Reporting Services. I am now unable to access the report manager website (http://localhost/reports). I receive an error stating "The underlying connection was closed: The remote name could not be resolved." As suggested by previous posts, I ran the rsconfig.exe utility specifying the new server name along with the security information. I am now able to access the report server (http://localhost/reportserver) and I can successfully run reports. I am still receiving the same error when attempting to access the report manager website, however. I have searched the registry and replaced the only instance of the old server name in a key pertaining to Reporting Services and rebooted, but I still have the same problem.
>>Please provide any information that will resolve this problem. Thanks in advance,
>>Kevin

Rename SQL Bit in Reporting services

Hello,

What is the best way to rename a bit "True/False" to "Open/Closed" or "yes/no" in the expression editior.

Thanks

B

What a simple answer...

=iif(Fields!Fieldname.Value = 0 , "No" , "Yes")

I think sql somehow translates the 0 to a false...

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 SQLServer 2005 Express Registry Keys

MS update cannot install a Service Pack to SQL Server 2005 Express because a
component of an earlier version (a CTP, the Reporting Services component)
cannot be uninstalled. Can anyone tell me which set of registry keys I
should delete after removing SQL Server 2005 in order to reinstall on a
clean sustem?
Many thanks.Hi Andrew
"Andrew Chalk" wrote:

> MS update cannot install a Service Pack to SQL Server 2005 Express because
a
> component of an earlier version (a CTP, the Reporting Services component)
> cannot be uninstalled. Can anyone tell me which set of registry keys I
> should delete after removing SQL Server 2005 in order to reinstall on a
> clean sustem?
> Many thanks.
Do these help?
http://msdn2.microsoft.com/en-us/library/ms143505.aspx
http://support.microsoft.com/kb/909967/
http://blogs.msdn.com/astebner/arch.../13/465401.aspx
John|||Thanks.This http://blogs.msdn.com/astebner/arch.../13/465401.aspx
had the brute force method that did it.
- A
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EC308ED0-5BEE-486D-9D66-573845FC5360@.microsoft.com...
> Hi Andrew
> "Andrew Chalk" wrote:
>
> Do these help?
> http://msdn2.microsoft.com/en-us/library/ms143505.aspx
> http://support.microsoft.com/kb/909967/
> http://blogs.msdn.com/astebner/arch.../13/465401.aspx
> John
>

Removing SQLServer 2005 Express Registry Keys

MS update cannot install a Service Pack to SQL Server 2005 Express because a
component of an earlier version (a CTP, the Reporting Services component)
cannot be uninstalled. Can anyone tell me which set of registry keys I
should delete after removing SQL Server 2005 in order to reinstall on a
clean sustem?
Many thanks.
Hi Andrew
"Andrew Chalk" wrote:

> MS update cannot install a Service Pack to SQL Server 2005 Express because a
> component of an earlier version (a CTP, the Reporting Services component)
> cannot be uninstalled. Can anyone tell me which set of registry keys I
> should delete after removing SQL Server 2005 in order to reinstall on a
> clean sustem?
> Many thanks.
Do these help?
http://msdn2.microsoft.com/en-us/library/ms143505.aspx
http://support.microsoft.com/kb/909967/
http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
John
|||Thanks.This http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
had the brute force method that did it.
- A
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EC308ED0-5BEE-486D-9D66-573845FC5360@.microsoft.com...
> Hi Andrew
> "Andrew Chalk" wrote:
>
> Do these help?
> http://msdn2.microsoft.com/en-us/library/ms143505.aspx
> http://support.microsoft.com/kb/909967/
> http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
> John
>

Removing SQLServer 2005 Express Registry Keys

MS update cannot install a Service Pack to SQL Server 2005 Express because a
component of an earlier version (a CTP, the Reporting Services component)
cannot be uninstalled. Can anyone tell me which set of registry keys I
should delete after removing SQL Server 2005 in order to reinstall on a
clean sustem?
Many thanks.
Hi Andrew
"Andrew Chalk" wrote:

> MS update cannot install a Service Pack to SQL Server 2005 Express because a
> component of an earlier version (a CTP, the Reporting Services component)
> cannot be uninstalled. Can anyone tell me which set of registry keys I
> should delete after removing SQL Server 2005 in order to reinstall on a
> clean sustem?
> Many thanks.
Do these help?
http://msdn2.microsoft.com/en-us/library/ms143505.aspx
http://support.microsoft.com/kb/909967/
http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
John
|||Thanks.This http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
had the brute force method that did it.
- A
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EC308ED0-5BEE-486D-9D66-573845FC5360@.microsoft.com...
> Hi Andrew
> "Andrew Chalk" wrote:
>
> Do these help?
> http://msdn2.microsoft.com/en-us/library/ms143505.aspx
> http://support.microsoft.com/kb/909967/
> http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
> John
>

Removing SQLServer 2005 Express Registry Keys

MS update cannot install a Service Pack to SQL Server 2005 Express because a
component of an earlier version (a CTP, the Reporting Services component)
cannot be uninstalled. Can anyone tell me which set of registry keys I
should delete after removing SQL Server 2005 in order to reinstall on a
clean sustem?
Many thanks.Hi Andrew
"Andrew Chalk" wrote:
> MS update cannot install a Service Pack to SQL Server 2005 Express because a
> component of an earlier version (a CTP, the Reporting Services component)
> cannot be uninstalled. Can anyone tell me which set of registry keys I
> should delete after removing SQL Server 2005 in order to reinstall on a
> clean sustem?
> Many thanks.
Do these help?
http://msdn2.microsoft.com/en-us/library/ms143505.aspx
http://support.microsoft.com/kb/909967/
http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
John|||Thanks.This http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
had the brute force method that did it.
- A
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:EC308ED0-5BEE-486D-9D66-573845FC5360@.microsoft.com...
> Hi Andrew
> "Andrew Chalk" wrote:
>> MS update cannot install a Service Pack to SQL Server 2005 Express
>> because a
>> component of an earlier version (a CTP, the Reporting Services component)
>> cannot be uninstalled. Can anyone tell me which set of registry keys I
>> should delete after removing SQL Server 2005 in order to reinstall on a
>> clean sustem?
>> Many thanks.
> Do these help?
> http://msdn2.microsoft.com/en-us/library/ms143505.aspx
> http://support.microsoft.com/kb/909967/
> http://blogs.msdn.com/astebner/archive/2005/09/13/465401.aspx
> John
>

Removing Rich Text formatting from a field

I have a field where the data is stored with RTF. I know SQL Reporting Services cannot display it properly. Is there way to remove the RTF formatting codes through a function to just pull out the text and displya it in the text box?

I had a similiar problem and found this link helpful:

http://www.4guysfromrolla.com/webtech/042501-1.shtml

I just took the function provided in the above link and placed it in the Code section of my report. It may need some tweaking depending on your specific needs but hopefully it will help.

|||

place this code in your Code section:

function StripRTF(ByVal rtf as String) as String
rtb.Rtf = rtf
return rtb.Text
end function

Add a reference to the System.Windows.Forms namespace and create a class instance of System.Windows.Forms.RichTextBox with an instance name of rtb

|||

Hi,

Code Snippet

function StripRTF(ByVal rtf as String) as String
rtb.Rtf = rtf
return rtb.Text
end function

I've similar problem and the above function works in Report Designer. However, when it is deployed in ReportServer, it didn't work at all.

Is there something we need to do in the Report Server?

For your info, both Report Designer and Report Server sits in different machine.

Please help.

Regards

Kamal

|||I am having the same issue. The code works fine in report designer, but out on the report server I get "#Error" in place of what is supposed to be the parsed text.

Ideas?

Thanks in advance

Removing Rich Text formatting from a field

I have a field where the data is stored with RTF. I know SQL Reporting Services cannot display it properly. Is there way to remove the RTF formatting codes through a function to just pull out the text and displya it in the text box?

I had a similiar problem and found this link helpful:

http://www.4guysfromrolla.com/webtech/042501-1.shtml

I just took the function provided in the above link and placed it in the Code section of my report. It may need some tweaking depending on your specific needs but hopefully it will help.

|||

place this code in your Code section:

function StripRTF(ByVal rtf as String) as String
rtb.Rtf = rtf
return rtb.Text
end function

Add a reference to the System.Windows.Forms namespace and create a class instance of System.Windows.Forms.RichTextBox with an instance name of rtb

|||

Hi,

Code Snippet

function StripRTF(ByVal rtf as String) as String
rtb.Rtf = rtf
return rtb.Text
end function

I've similar problem and the above function works in Report Designer. However, when it is deployed in ReportServer, it didn't work at all.

Is there something we need to do in the Report Server?

For your info, both Report Designer and Report Server sits in different machine.

Please help.

Regards

Kamal

Removing quotations from cvs export in SSRS

I am trying to export a report from sql server reporting services in a csv format, but I do not want the text qualified with quotations. Is there any way to do this?

You should be able to do that with a filter. See this blog entry for a similar (although not exact) match to what you're trying to do:

http://blogs.msdn.com/bimusings/archive/2006/07/19/671743.aspx

Buck Woody

removing logs

I have over 200 log files with a date and timestamp in the filename in the
Reporting Services\LogFiles folder that are 33MB each. This is a development
machine. How do I get rid of them? Can I just delete them?
Thanks,
--
Dan D.You can delete, it creates again, but I dont think you require this much log
files for your development server. For production yes you need to have a
backup. Before deleting keep a backup or Zip all the log files and keep it in
a seperate place.
If it is so important, you can run a program which is available in the
samples to read the log files and reporting.
and ofcourse schedule it to remove. default it keeps it for 60 days.
Amarnath
"Dan D." wrote:
> I have over 200 log files with a date and timestamp in the filename in the
> Reporting Services\LogFiles folder that are 33MB each. This is a development
> machine. How do I get rid of them? Can I just delete them?
> Thanks,
> --
> Dan D.|||I never thought about log files for reportserver. Most of the files are
small, under 50K. I don't know what was in the files that were so large.
I removed them.
Thanks,
--
Dan D.
"Amarnath" wrote:
> You can delete, it creates again, but I dont think you require this much log
> files for your development server. For production yes you need to have a
> backup. Before deleting keep a backup or Zip all the log files and keep it in
> a seperate place.
> If it is so important, you can run a program which is available in the
> samples to read the log files and reporting.
> and ofcourse schedule it to remove. default it keeps it for 60 days.
> Amarnath
> "Dan D." wrote:
> > I have over 200 log files with a date and timestamp in the filename in the
> > Reporting Services\LogFiles folder that are 33MB each. This is a development
> > machine. How do I get rid of them? Can I just delete them?
> >
> > Thanks,
> > --
> > Dan D.

Removing deployed reports

Hi All,

I deployed many reports on sql server reporting services. I want to remove some of the unnecessary reports. How to remove it?

thanking You,

Thanks,

Muniappan Kandasamy

SQL 2005? If so, in SQL Server Management Studio you can attach to your reporting server instance and then select the report and set its hidden property to true, or delete it outright:

On the login popup, check out your list of Server Types provided, you should see a 'Reporting Services' item. If you are already in the Mgmt studio, on the object explorer, click the Connect button and in the dropdown you'll see a reporting services item. Once you are in, you should be able to find your report objects and do whatever you need to them.

Cheers!

Wayne

|||

Thank you

Removing deployed reports

Hi All,

I deployed many reports in sql server 2005 reporting services. I want to remove some of the unnecessary reports. How to remove those reports?

thank you

thanks,

Muniappan Kandasamy

1. Open report manager (http://localhost/reports).

2. Navigate to your report server project.

3. Click the Show Details button.

4. Check the reports you want to delete then click delete.

Removing BUILTIN\Administrators

We need to remove the BUILTIN\Administrators from reporting services. I.T. personnel do not want to be able to see restricted reports. We have two department users that have been added as Content Managers and we are running reporting services under a created domain user account that we created and not a system service. I have removed BUILTIN\Administrators from the Home folder and when I check, it comes right back. Do I need to deny access to BUILTIN\Administrator on SQL Server 2005 itself? I would apprecate any suggestions.

I used the link below and followed the steps to remove the BUILTIN\Administrators group from SQL Server 2005 and SRS 2005. Hopefully this will be helpful to others.

http://www.mssqltips.com/tip.asp?tip1017

Removing Administrators access to all folders

We would like to not allow our administrators to see sensitive Payroll information in Reporting Services. I have removed 'BUILTIN\Administrators' from all folders, yet those in the Domain Admins group can still see all of the adminstrative functions, as well as all of the folders. We don't want them to see some of the folders.

Does this have to do with the Domain Admins having local Admin rights on the server?

I think you have to install RS with another service, not Local Service or Networkservice, you can make the service to be installed to the name of a special user Financee\FinanceeAdministrator, after it remove builtin\administrators on the folders you dont want them to see,

|||Can we take Domain Administrator's out of the Local Administrators group on the server and get the same effect?|||Domain administrators are the superpowerful users, I dont think you can deny access to them