ReportBuilder 2005 and non-SSL

I've installed SQL Server 2005 CTP and I can't get ReportBuilder to
work. Everything is on a single XP computer. There are two possible
issues I can think of:
1. I've installed this "side-by-side" with an instance of SQL Server
2000 and Reporting Services 2000. Thus the virtual directories
localhost/Reports and ReportServer are already in use. I configured the
2005 to use Reports2 and ReportServer2.
2. There is no SSL certificate on my machine. I was hoping just to run
everything via http:. I noticed when I installed that the setup dialog
told that I had a certificate (!) and so it was going to install things
for SSL. However if I look in RSReportServer.config, I see <Add
Key="SecureConnectionLevel" Value="0"/>, which I believe means no SSL.
When I try to download reportbuilder from the Report Manager page, it
tells me that the download has been interrupted. If I just try to
execute the report builder .exe from the web directory, it does start
up and presents me with a user name/password dialog box. If I fill this
in and press OK, it tells me "No report server was found at
https://localhost/reportserver. That is, it is looking at the wrong
virtual directory and using the wrong protocol.
Is there some way to configure ReportBuilder so it uses a non-default
URL for the report server? Can I even use the CTP version without a
certificate?
Thanks...MikeDid you find the solution? I am having the same problem.
mike@.kraley.com wrote:
> I've installed SQL Server 2005 CTP and I can't get ReportBuilder to
> work. Everything is on a single XP computer. There are two possible
> issues I can think of:
> 1. I've installed this "side-by-side" with an instance of SQL Server
> 2000 and Reporting Services 2000. Thus the virtual directories
> localhost/Reports and ReportServer are already in use. I configured the
> 2005 to use Reports2 and ReportServer2.
> 2. There is no SSL certificate on my machine. I was hoping just to run
> everything via http:. I noticed when I installed that the setup dialog
> told that I had a certificate (!) and so it was going to install things
> for SSL. However if I look in RSReportServer.config, I see <Add
> Key="SecureConnectionLevel" Value="0"/>, which I believe means no SSL.
> When I try to download reportbuilder from the Report Manager page, it
> tells me that the download has been interrupted. If I just try to
> execute the report builder .exe from the web directory, it does start
> up and presents me with a user name/password dialog box. If I fill this
> in and press OK, it tells me "No report server was found at
> https://localhost/reportserver. That is, it is looking at the wrong
> virtual directory and using the wrong protocol.
> Is there some way to configure ReportBuilder so it uses a non-default
> URL for the report server? Can I even use the CTP version without a
> certificate?
> Thanks...Mike

ReportBuilder

I installed RS 2005 on my machine. Everything works except the reportbuilder.
When I launch it I get the message
An unhandled exception of type
'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
Additional information: The attempt to connect to the report server failed.
Check your connection information and that the report server is a compatible
version.
Any ideasRoland,
Which build of SQL Server 2005 are you using?
Which OS?
Was it a clean install or after uninstall of earlier builds?
I don't recall seeing this specific error reported before although
there were some problems with early builds of Report Builder.
You might want to visit
http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
for any similar reports.
Andrew Watt
MVP - InfoPath
On Sat, 15 Oct 2005 01:13:01 -0700, Roland
<Roland@.discussions.microsoft.com> wrote:
>I installed RS 2005 on my machine. Everything works except the reportbuilder.
>When I launch it I get the message
>An unhandled exception of type
>'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
>Additional information: The attempt to connect to the report server failed.
>Check your connection information and that the report server is a compatible
>version.
>Any ideas|||I installed it from the MSDN Visual Studio 2005 Beta 2 DVD
Select @.@.version in SQL gives
Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
Apr 9 2005 20:56:37
Copyright (c) 1988-2004 Microsoft Corporation
Beta Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
The reportbuilder.exe : version 9.0.1116.0, assembly version 9.0.242.0
Installed on a Windows XP (with SP2) machine
Is it possible that the fact my installed OS is Dutch, is causing the
problem ?
"Andrew Watt [MVP - InfoPath]" wrote:
> Roland,
> Which build of SQL Server 2005 are you using?
> Which OS?
> Was it a clean install or after uninstall of earlier builds?
> I don't recall seeing this specific error reported before although
> there were some problems with early builds of Report Builder.
> You might want to visit
> http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
> for any similar reports.
> Andrew Watt
> MVP - InfoPath
> On Sat, 15 Oct 2005 01:13:01 -0700, Roland
> <Roland@.discussions.microsoft.com> wrote:
> >I installed RS 2005 on my machine. Everything works except the reportbuilder.
> >When I launch it I get the message
> >An unhandled exception of type
> >'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
> >
> >Additional information: The attempt to connect to the report server failed.
> >Check your connection information and that the report server is a compatible
> >version.
> >
> >Any ideas
>|||Hi
That was the April CTP.
Between then and now, there were 2 more CTP's. Probably a bug with that old
version.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Roland" <Roland@.discussions.microsoft.com> wrote in message
news:CE1A6B37-EFE2-4537-A39A-0016A7B7A503@.microsoft.com...
>I installed it from the MSDN Visual Studio 2005 Beta 2 DVD
> Select @.@.version in SQL gives
> Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
> Apr 9 2005 20:56:37
> Copyright (c) 1988-2004 Microsoft Corporation
> Beta Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> The reportbuilder.exe : version 9.0.1116.0, assembly version 9.0.242.0
> Installed on a Windows XP (with SP2) machine
> Is it possible that the fact my installed OS is Dutch, is causing the
> problem ?
> "Andrew Watt [MVP - InfoPath]" wrote:
>> Roland,
>> Which build of SQL Server 2005 are you using?
>> Which OS?
>> Was it a clean install or after uninstall of earlier builds?
>> I don't recall seeing this specific error reported before although
>> there were some problems with early builds of Report Builder.
>> You might want to visit
>> http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
>> for any similar reports.
>> Andrew Watt
>> MVP - InfoPath
>> On Sat, 15 Oct 2005 01:13:01 -0700, Roland
>> <Roland@.discussions.microsoft.com> wrote:
>> >I installed RS 2005 on my machine. Everything works except the
>> >reportbuilder.
>> >When I launch it I get the message
>> >An unhandled exception of type
>> >'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException'
>> >occurred in ReportBuilder.exe
>> >
>> >Additional information: The attempt to connect to the report server
>> >failed.
>> >Check your connection information and that the report server is a
>> >compatible
>> >version.
>> >
>> >Any ideas|||Roland,
April CTP was, if I remember correctly, only the second public build
with Report Builder in it. I remember having problems connecting to
Report Builder in one early build but don't remember if it was April
CTP.
If you have access to MSDN or BetaPlace I suggest you update to
September CTP. You will need a matching copy of Visual Studio 2005
(which is the VS2005 Release Candidate).
Uninstall order of the April CTP is VERY important. Read the Sept CTP
/ Visual Studio 2005 RC documentation CAREFULLY.
After a successful uninstall, the install order is SQL Server 2005
Sept CTP first then Visual Studio 2005 Release Candidate.
Andrew Watt
MVP - InfoPath
On Sun, 16 Oct 2005 11:13:01 -0700, Roland
<Roland@.discussions.microsoft.com> wrote:
>I installed it from the MSDN Visual Studio 2005 Beta 2 DVD
>Select @.@.version in SQL gives
>Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
> Apr 9 2005 20:56:37
> Copyright (c) 1988-2004 Microsoft Corporation
> Beta Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>The reportbuilder.exe : version 9.0.1116.0, assembly version 9.0.242.0
>Installed on a Windows XP (with SP2) machine
>Is it possible that the fact my installed OS is Dutch, is causing the
>problem ?
>"Andrew Watt [MVP - InfoPath]" wrote:
>> Roland,
>> Which build of SQL Server 2005 are you using?
>> Which OS?
>> Was it a clean install or after uninstall of earlier builds?
>> I don't recall seeing this specific error reported before although
>> there were some problems with early builds of Report Builder.
>> You might want to visit
>> http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
>> for any similar reports.
>> Andrew Watt
>> MVP - InfoPath
>> On Sat, 15 Oct 2005 01:13:01 -0700, Roland
>> <Roland@.discussions.microsoft.com> wrote:
>> >I installed RS 2005 on my machine. Everything works except the reportbuilder.
>> >When I launch it I get the message
>> >An unhandled exception of type
>> >'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
>> >
>> >Additional information: The attempt to connect to the report server failed.
>> >Check your connection information and that the report server is a compatible
>> >version.
>> >
>> >Any ideas|||Installing the Sept CTP Release of SQL 2005 did solve my problem of using the
reportbuilder. Indeed the installation order is important; as I also have SQL
2000 with Reporting Services 2000/SP2 on the same machine I had to reinstall
also the SP2 of RS 2000 because the uninstall of the version of RS2005 also
influences the behaviour of RS2000
"Andrew Watt [MVP - InfoPath]" wrote:
> Roland,
> April CTP was, if I remember correctly, only the second public build
> with Report Builder in it. I remember having problems connecting to
> Report Builder in one early build but don't remember if it was April
> CTP.
> If you have access to MSDN or BetaPlace I suggest you update to
> September CTP. You will need a matching copy of Visual Studio 2005
> (which is the VS2005 Release Candidate).
> Uninstall order of the April CTP is VERY important. Read the Sept CTP
> / Visual Studio 2005 RC documentation CAREFULLY.
> After a successful uninstall, the install order is SQL Server 2005
> Sept CTP first then Visual Studio 2005 Release Candidate.
> Andrew Watt
> MVP - InfoPath
> On Sun, 16 Oct 2005 11:13:01 -0700, Roland
> <Roland@.discussions.microsoft.com> wrote:
> >I installed it from the MSDN Visual Studio 2005 Beta 2 DVD
> >Select @.@.version in SQL gives
> >
> >Microsoft SQL Server 2005 - 9.00.1116 (Intel X86)
> > Apr 9 2005 20:56:37
> > Copyright (c) 1988-2004 Microsoft Corporation
> > Beta Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
> >
> >The reportbuilder.exe : version 9.0.1116.0, assembly version 9.0.242.0
> >
> >Installed on a Windows XP (with SP2) machine
> >Is it possible that the fact my installed OS is Dutch, is causing the
> >problem ?
> >
> >"Andrew Watt [MVP - InfoPath]" wrote:
> >
> >> Roland,
> >>
> >> Which build of SQL Server 2005 are you using?
> >>
> >> Which OS?
> >>
> >> Was it a clean install or after uninstall of earlier builds?
> >>
> >> I don't recall seeing this specific error reported before although
> >> there were some problems with early builds of Report Builder.
> >>
> >> You might want to visit
> >> http://lab.msdn.microsoft.com/productfeedback/default.aspx and search
> >> for any similar reports.
> >>
> >> Andrew Watt
> >> MVP - InfoPath
> >>
> >> On Sat, 15 Oct 2005 01:13:01 -0700, Roland
> >> <Roland@.discussions.microsoft.com> wrote:
> >>
> >> >I installed RS 2005 on my machine. Everything works except the reportbuilder.
> >> >When I launch it I get the message
> >> >An unhandled exception of type
> >> >'Microsoft.SqlServer.ReportingServices2005.RSConnection.MissingEndpointException' occurred in ReportBuilder.exe
> >> >
> >> >Additional information: The attempt to connect to the report server failed.
> >> >Check your connection information and that the report server is a compatible
> >> >version.
> >> >
> >> >Any ideas
> >>
>sql

Report Viewing and Vista

Hi

I am facing a strange problem while viewing a Windows Report in Windows Vista.

I have a machine which has Vista installed as the Operating system. I have two user id created to log into the system.

(Assumed user A and User B). Both the users have the same login credentials. However, the default user of the system is

User B.

I have a windows application, which uses Winreports for viewing the reports. I am creating the entire rdlc on - the - fly based on

the parameters specified from the User Interface. If I log into the system using user A and try to view the reports, the report is

perfectly generated and is being viewed properly without any error. However, if I log into the system using User B (the

default user of the system) and then try to view the same report (with all the parameters same) I am getting an Unauthorised

Access Violation error.

Please help with some of our valuable suggestions.

FYI: This happens only on PC having Windows Vista as the Operating System

Thanking you in advance,

Kind Regards,

PS

Hi Everybody,

Thank you very much to everybody who went through this issue.

Actually, the profile of user B had some issues. I deleted the account User B and re - created again, and it worked fine.

Thanking You once again,

Kind Regards,

Pratik

Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.sql

Report Viewer webpart did not work in wss 3.0

Hi,

I just installed a fresh lab machine with WSS 3.0 and SQL 2005. I registered the RS web parts.

In the home page I added the Reports Explorer and the Report viewer web parts. I set up the Reports Explorer and the list of reports are showed.

When I connect the Report Viewer Web part to get report from the Report Explorer web part I get the maintenance WSS page. I have to delete the Report Viewer web part to have the page working again.

If I use only the Reports Viewer with a report (not connected to Reports Explorer) is working just fine.

Any ideas what could be the problem? Any hints on how to investigate this is also much appreciated.

Thanks,

Dan

I also ran into this and I reported it as an issue on connect.microsoft.com. However, according to the feedback, it is by design and it won't be fixed.|||

Thanks Teo,

I hope it will be solved at some point. Until then, I am using RS in integration mode. It works very nice.

Dan

|||

Take a look at this;

http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/webrssp2.mspx

When I try to add a Web Part to a SharePoint page, I get the following error message: "A Web Part or Web Form Control on this Web Part Page cannot be displayed or imported because it is not registered on this site as safe."

Make sure you have followed all of the steps in the Installing the Web Parts section, Installation Process subsection of this paper, including using the –url option to stsadm. If you used the –globalinstall option, try leaving it out so the Web Part package is installed to the bin directory of the virtual server. Manually verify that the bin directory under your SharePoint Web root contains a file called RSWebParts.dll. If you installed SharePoint in the default Web root, this directory would be C:\Inetpub\wwwroot\bin. A copy of this DLL may be found in C:\Program Files\Microsoft SQL Server\80\Tools\Reporting Services\SharePoint\RSWebParts.cab (assuming that Reporting Services is installed in the default location).

|||He has the web parts working allright. It's just that the RS 2005 web parts are coded against the WSS 2.0 object model and don't support connections. Based on what I've heard they won't be enhanced to support the WSS 3.0 connections feature.

Report Viewer Question

I am using rs on a SQL 2000 DB and have an application built using VWDE 2005
to display reports. I installed the ReportViewer control and set the
appropriate URL and report path. When I open the page, I first get a popup
to enter the password (is there a way to avoid this?) and then I get what
looks like a report manager window on the screen. I have to navigate to my
reports, select the one I want and then click on the "Full Screen" icon to
see the report.
How can I get a page to simply present the report when opened?
WayneIs the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
use the new controls to display reports you need to have RS 2005 installed
(which can use a SQL Server 2000 DB, that is what I am doing).
If you want it hardcode during design then using the for Report Path (click
on the upper right of the control to fill in the report tasks) put in
something like this: /MyFolder/MyReport not sure if case sensitive but it
could be. For your server this is what I have: http://Myserver/ReportServer
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am using rs on a SQL 2000 DB and have an application built using VWDE
>2005 to display reports. I installed the ReportViewer control and set the
>appropriate URL and report path. When I open the page, I first get a popup
>to enter the password (is there a way to avoid this?) and then I get what
>looks like a report manager window on the screen. I have to navigate to my
>reports, select the one I want and then click on the "Full Screen" icon to
>see the report.
> How can I get a page to simply present the report when opened?
> Wayne
>|||The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
own the server.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going to
> use the new controls to display reports you need to have RS 2005 installed
> (which can use a SQL Server 2000 DB, that is what I am doing).
> If you want it hardcode during design then using the for Report Path
> (click on the upper right of the control to fill in the report tasks) put
> in something like this: /MyFolder/MyReport not sure if case sensitive
> but it could be. For your server this is what I have:
> http://Myserver/ReportServer
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a popup
>>to enter the password (is there a way to avoid this?) and then I get what
>>looks like a report manager window on the screen. I have to navigate to my
>>reports, select the one I want and then click on the "Full Screen" icon to
>>see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>|||I am pretty sure that the server needs to be RS2005. Looking at the info on
the controls it specifies RS 2005 for the server report. If you service
upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
supposed to be backward compatible.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I don't
> own the server.
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks) put
>> in something like this: /MyFolder/MyReport not sure if case sensitive
>> but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set the
>>appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the "Full
>>Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>|||Thanks for the information - I'll check with my service provider.
Wayne
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23GcxKud%23FHA.160@.TK2MSFTNGP12.phx.gbl...
>I am pretty sure that the server needs to be RS2005. Looking at the info on
>the controls it specifies RS 2005 for the server report. If you service
>upgrades to RS 2005, they can continue to host RS 2000 reports. RS 2005 is
>supposed to be backward compatible.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
> news:OGU9aOd%23FHA.2300@.TK2MSFTNGP10.phx.gbl...
>> The RS is on a SQL Server 2000 (NOT 2005). It is a service I buy - I
>> don't own the server.
>>
>> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
>> news:O4u0TFb%23FHA.1028@.TK2MSFTNGP11.phx.gbl...
>> Is the RS installed on SQL 2000 DB RS 2005 or RS 2000. If you are going
>> to use the new controls to display reports you need to have RS 2005
>> installed (which can use a SQL Server 2000 DB, that is what I am doing).
>> If you want it hardcode during design then using the for Report Path
>> (click on the upper right of the control to fill in the report tasks)
>> put in something like this: /MyFolder/MyReport not sure if case
>> sensitive but it could be. For your server this is what I have:
>> http://Myserver/ReportServer
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Wayne Wengert" <wayneSKIPSPAM@.wengert.org> wrote in message
>> news:ehdD%23G19FHA.160@.TK2MSFTNGP12.phx.gbl...
>>I am using rs on a SQL 2000 DB and have an application built using VWDE
>>2005 to display reports. I installed the ReportViewer control and set
>>the appropriate URL and report path. When I open the page, I first get a
>>popup to enter the password (is there a way to avoid this?) and then I
>>get what looks like a report manager window on the screen. I have to
>>navigate to my reports, select the one I want and then click on the
>>"Full Screen" icon to see the report.
>> How can I get a page to simply present the report when opened?
>> Wayne
>>
>>
>

Report Services installation problem

I've installed SQL Express 2005 on an XP Professional machine and I'm trying to configure Report Services. In Reporting Services Configuration Manager, all items are "green" except "Web Service Identity". The value is <machinename>\ASPNET and isn't configurable. I've searched the forums and followed the advice I've found to remove and reinstall .NET, but it hasn't helped. User ASPNET does exist on the machine with a local account, and IIS5 is running. SQL gurus, please help me figure out what to do! Thanks.The Web Service Identity is supposed to be read-only. If everything is grean RS should be already configured and good to go. What's not working?|||

I apologize - I didn't offer full details. I was frustrated!

Clicking "Apply" on the "Web Service Identity" dialogue results in an error. Clicking the link for details reveals this:

---

ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias.

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

---

The ASPNET user does exist however! I don't understand what's wrong. Thanks for your help.

|||

Not sure what's going on. It's seeme like there is something wrong with the ASPNET account. Is ReportServer vroot in IIS running under asp.net 2.0. Are any other web applications on that machine working OK?

|||That's a little over my head, I know little about IIS. Other "web pages" are accessible, such as http://localhost/printers and http://localhost/tsweb. This machine is dedicated to running SQL Server Express, so no other applications are running that I can test for web connectivity. Any direction you can point me in is greatly appreciated! Thanks again for your help.|||

1. Open up Internet Information Services applet in the Administrators group.

2. Right-click on the ReportServer node and choose Properties. Flip to the ASP.NET tab. What's the ASP.NET version?

|||The ASP.NET version is 2.0.50727. Thanks for helping me through this!

Report Services installation problem

I've installed SQL Express 2005 on an XP Professional machine and I'm trying to configure Report Services. In Reporting Services Configuration Manager, all items are "green" except "Web Service Identity". The value is <machinename>\ASPNET and isn't configurable. I've searched the forums and followed the advice I've found to remove and reinstall .NET, but it hasn't helped. User ASPNET does exist on the machine with a local account, and IIS5 is running. SQL gurus, please help me figure out what to do! Thanks.The Web Service Identity is supposed to be read-only. If everything is grean RS should be already configured and good to go. What's not working?|||

I apologize - I didn't offer full details. I was frustrated!

Clicking "Apply" on the "Web Service Identity" dialogue results in an error. Clicking the link for details reveals this:

---

ReportServicesConfigUI.WMIProvider.WMIProviderException: The account name is not valid. Specify an account in the form domain\alias.

at ReportServicesConfigUI.WMIProvider.RSReportServerAdmin.SetWebServiceIdentity(String applicationPool)

---

The ASPNET user does exist however! I don't understand what's wrong. Thanks for your help.

|||

Not sure what's going on. It's seeme like there is something wrong with the ASPNET account. Is ReportServer vroot in IIS running under asp.net 2.0. Are any other web applications on that machine working OK?

|||That's a little over my head, I know little about IIS. Other "web pages" are accessible, such as http://localhost/printers and http://localhost/tsweb. This machine is dedicated to running SQL Server Express, so no other applications are running that I can test for web connectivity. Any direction you can point me in is greatly appreciated! Thanks again for your help.|||

1. Open up Internet Information Services applet in the Administrators group.

2. Right-click on the ReportServer node and choose Properties. Flip to the ASP.NET tab. What's the ASP.NET version?

|||The ASP.NET version is 2.0.50727. Thanks for helping me through this!

Report Services

Are SQL Reports services like report builder included with SQLExpress. I just installed VStudio 2005 and SQLExpress. I cannot find SQL report builder. Crystal reports works fine. Do I have to install SQL SErver Developer edition, included with VStudio 2005.

I am new to SQL development. Sorry if it is a simple question.

Bill

Report Server didn't included in SQL Server Express. SQL Server Developer Edition has all features like Enterprise:

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

WBR, Evergray
--
Words mean nothing...

Report Service not showing up in WSS 3.0 Central Admin

I installed the Reporting Service for Share Point just fine but when I go to central admin I do not see the reporting service section. Any Ideas?Can you check under site settings -> Site collection features and see if the feature is activated?|||

Install SharePoint.exe and Install SharePointRS.msi with same user ?

|||I had installed the reporting service and share point as different users on the server. I reinstalled RS using the same login as was used to install WSS and I now have the Report Service in Central Admin. THanks for all of the help.

Report Service error

Hi,
I installed the SQL Reporting services with MS SQL 2000 database server,
implemented the form authentication custom security extention, every thing
worked just perfect, because some other issues, I tried to modify the URL
Root in RSReportServer.config file, from http://<servername>/ReportServer to
a http://<external IP address>/ReportServer. then when I try to run the
report manager, I got "The report server installation is not initialized.
Check the documentation for more information. (rsReportServerNotActivated)
Get Online Help", then I tried everything this newgroup provided such as
rsactivate, rskeymgmt -d to delete the key then use rsconfig to regenerate
the new key, but no matter what I do, I keep getting this error message, when
I run rsactivate, I got error message said that the report service is
activated already.
because this is the production server, please Help!
Thanks at advance.
YanI guess you also need to modify the report service url from
http://<servername>/ReportService.asmx to http://<external IP
address>/ReportService.asmx somewhere in your implementation.
Don
"Yan" wrote:
> Hi,
> I installed the SQL Reporting services with MS SQL 2000 database server,
> implemented the form authentication custom security extention, every thing
> worked just perfect, because some other issues, I tried to modify the URL
> Root in RSReportServer.config file, from http://<servername>/ReportServer to
> a http://<external IP address>/ReportServer. then when I try to run the
> report manager, I got "The report server installation is not initialized.
> Check the documentation for more information. (rsReportServerNotActivated)
> Get Online Help", then I tried everything this newgroup provided such as
> rsactivate, rskeymgmt -d to delete the key then use rsconfig to regenerate
> the new key, but no matter what I do, I keep getting this error message, when
> I run rsactivate, I got error message said that the report service is
> activated already.
> because this is the production server, please Help!
>
> Thanks at advance.
>
> Yan

Report Server Windows Service Problem

Hello,

I am my department's Sys Admin and a relativelty Noobie when it comes to SQL server. So I recently Installed SQL Server 2005 on a Win2003 Server. During install I set my domain account as the service account login. After the DB and Web Application were setup and running good I realized that the SQL service accounts were logging in as my domain account. Not a good thing right? So in SQL Server Configuration Manager I changed the services from logging on as my domain account to the local system account instead.

Enter the problem: now I notice in application event viewer the Report Server Windows Service is erroring every minute. The error reads "Report server windows service cannot connect to the report server database." Im sure this was caused by me changing what account the report server service logs in as and local system account not having appropriate permissions. So what account should the report server windows service log in as? I see where to change the windows report service identity in Configure Report Server but I am not able to backup an encryption key? Thanks in advance!

If everything is installed locally I'd suggest you use LocalSystem although the setup suggests you use a domain account. Use the Reporting Services Configuration Manager (found under the Configuration Tools program group in the Microsoft SQL Server 2005 program group) to reset the Windows Service account. Since you don't have a backup of the encryption key, you may need to delete the encrypted content (Encryption Keys section) before you can reset the account. The following info may help. The moral of this story is that you should always back up the encryption key (you can use the config utility) as a last step after RS is set up.

Report Server Web Site Shows File Not Found

Hi -

I have installed VS2005 and SQL Server 2005, with all reporting services features turned on. When I look at IIS i see applications for ReportingServer and Reports.

But i cannot seem to browse or run any reports. From SQL Server management Studio, from IIS, from browser all give same results - page not found. Did I miss a configuration? Who needs permissions to what? I created the report in VS2005 and deployed it but i cannot see it in the IIS virtual directory for ReportServices. When i look at folders in management studio, i see the folders for the project, and the report, but they dont show up in IIS.

HELP! nothing works!

Deployed reports don't go into IIS. They are stored internally in the reporting services databases.

Go to http://localhost/reports

This should show you 'Report Manager'. You can execute your reports from there.

Regards

Paul

|||When you deploy reports in VS, what is the ReportServerUrl property of the project? You should be able to access the same url from IE.|||

The ReportServer settings on the project are to the Reporting Services web services. For URL access to a report you need to look at the help file. Here is an example:

http://servername/reportserver?/SampleReports/Employee Sales Summary&rs:Command=Render&rs:format=HTML4.0

Report server times out with error "report server is not responding"

Hi. We have RS2005/SP1 installed on Win2003/SP1. When we first installed it and it was running under Windows Authentication, we did not notice any slowness or timeouts while working with Report Manager or Management Studio. However, after we switched to Forms Authentication and set up the security extension sample provided, both the Report Manager and Management Studio (connected to Reporting Services) started to time out very often (even when simply browsing through the folders). It seems that Report Manager is timing out more often than Management Studio, however. After Report Manager times out, if I click the "Home" link or hit the "Back" button and try the same operation again, it usually works. The next few clicks work fine and I get a quick response, then it times out again.

Any help would be appreciated. Thanks

- Mark

Hi Mark,

We have not seen this problem reported before. I will take a look and if there is anything we can do about it, I will let you know.

|||

Hi Brad.

Have you been able to gather any information on this? Any suggestions as far as things to try to troubleshoot the issue?

Thanks

- Mark

|||

Hi Mark,

I did not get very far with this one. One person I talked to said to make the timeout in the Web.config file longer for SessionState. I looked and found the following in my web.config

<sessionState mode="InProc" cookieless="false" timeout="20" />

You could try changing this value to 100 or changing cookieless to true.

Otherwise I have not heard of anything to help on this one.

One other item to look at is the Web.Config settings in the following link.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp

Report server spawning multiple w3wp.exe threads

We have Win2003 SP1, SQL 2000 SP4, RS 2000 SP2 installed on our dev
machine and it works ok - having problems using anonamous access under
IIS but that is another issue.....
On our production server ( win2003 SP1, SQL 2000 SP4 ) we installed RS
2000 and SP2, accepting all the default installation options accept
SSL, and we have the following problems....
When we try to access http:\\servername\reports it takes a good few
minutes to load the web page, after asking for a domain user account,
and then the whole server runs like a dog.
Just getting to the first web page creates 12-15 copies of w3wp.exe,
each of which swallow between 20 and 130 MB of memory, and ramps up the
CPU usage.
I you try to upload a report, or access an existing report it spawns
off another 8-10 copies of w3wp.exe and eats more memory, and seriously
slows the server down.
The only way to release the resources it has useems to be to restart
IIS.
I "think" that this may be due to some hardening or lock down of
production server, but I am struggling on what to do next.
The RS logs do not seem to show any problems, but the Win App log shows
"ID 124 ReportServer Service has been activated" 5-6 times for every
action you take against reporting services.
I have been through the "checking reporting services is installed"
guides and it all seems ok, so there is something key I am missing here
!!!
Anyone else had similar problems and found the solution, or could at
least point me in the right direction to progress this issue !An update...
Thanks our freinds at the hosting company, it turns out this was all
due to .Net framework and IIS
We have apps running under 1.1 and 2.0 frameworks, and RS was set to
use default app pool on the IIS config.
Created a new app pool, and let both RS directories use that instead -
bingo !
Lots of w3wp.exe still created, but not hosing the box, and the number
goes up and down as usage changes.
Advice has been to create a new app pool just for reporting services,
as it is a hungry beast !

Report server service wont start

Windows server 2000 sp4.

Has existing sql server 2000 development running.

Installed sql server 2005 as instance name=sqlserver2005.

Reporting server configuration panel - Server status - Start service fails

The tellmemore link shows:

System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)

The Application event log shows:

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'NTSERVER1\ASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

AnyOne?

Jerry Cicierega

I found the answer:

http://support.microsoft.com/?kbid=911846

Thanx

Report server service pack

How can I determine what version of service pack for reporting services is
installed on our servers?
I would deeply appreciate step by step instructions.
TIA...Go to http://yourserver/Reportserver
SP1 is Version 8.00.878.00
SP2 is Version 8.00.1038.00
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trisha" <trisha@.nospam.nospam> wrote in message
news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> How can I determine what version of service pack for reporting services is
> installed on our servers?
> I would deeply appreciate step by step instructions.
> TIA...|||Thank you Bruce.
What would version 8.00.743.00 refer to?
TIA...
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > How can I determine what version of service pack for reporting services is
> > installed on our servers?
> >
> > I would deeply appreciate step by step instructions.
> >
> > TIA...
>
>|||That must be RTM (release to Manufacturing, i.e. the first release). That
means you have no service packs installed. Given all the fixes I strongly
recommend applying both service packs.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Trisha" <trisha@.nospam.nospam> wrote in message
news:630BE97F-B5D7-4083-87FC-714D990B90A1@.microsoft.com...
> Thank you Bruce.
> What would version 8.00.743.00 refer to?
> TIA...
> "Bruce L-C [MVP]" wrote:
> > Go to http://yourserver/Reportserver
> >
> > SP1 is Version 8.00.878.00
> > SP2 is Version 8.00.1038.00
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> > "Trisha" <trisha@.nospam.nospam> wrote in message
> > news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > > How can I determine what version of service pack for reporting
services is
> > > installed on our servers?
> > >
> > > I would deeply appreciate step by step instructions.
> > >
> > > TIA...
> >
> >
> >|||Bruce,
I just googled for 8.00.743.00 and it turns out to be the installation
version.
Thanks
"Bruce L-C [MVP]" wrote:
> Go to http://yourserver/Reportserver
> SP1 is Version 8.00.878.00
> SP2 is Version 8.00.1038.00
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > How can I determine what version of service pack for reporting services is
> > installed on our servers?
> >
> > I would deeply appreciate step by step instructions.
> >
> > TIA...
>
>|||Thanks Bruce...
"Bruce L-C [MVP]" wrote:
> That must be RTM (release to Manufacturing, i.e. the first release). That
> means you have no service packs installed. Given all the fixes I strongly
> recommend applying both service packs.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Trisha" <trisha@.nospam.nospam> wrote in message
> news:630BE97F-B5D7-4083-87FC-714D990B90A1@.microsoft.com...
> > Thank you Bruce.
> >
> > What would version 8.00.743.00 refer to?
> >
> > TIA...
> >
> > "Bruce L-C [MVP]" wrote:
> >
> > > Go to http://yourserver/Reportserver
> > >
> > > SP1 is Version 8.00.878.00
> > > SP2 is Version 8.00.1038.00
> > >
> > >
> > > --
> > > Bruce Loehle-Conger
> > > MVP SQL Server Reporting Services
> > >
> > > "Trisha" <trisha@.nospam.nospam> wrote in message
> > > news:567D207F-3AED-4D63-96C0-96B0A37C1671@.microsoft.com...
> > > > How can I determine what version of service pack for reporting
> services is
> > > > installed on our servers?
> > > >
> > > > I would deeply appreciate step by step instructions.
> > > >
> > > > TIA...
> > >
> > >
> > >
>
>|||When you said "both service packs," does that mean that SP2 doesn't include
fixes from SP1?
When I read through the SP2 docs it wasn't clear to me, but it seemed like
if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
installations.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
> That must be RTM (release to Manufacturing, i.e. the first release). That
> means you have no service packs installed. Given all the fixes I strongly
> recommend applying both service packs.
>|||SP2 includes everything that comes with SP1. So installing just SP2 is
sufficient.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nerf Herder" <null@.notta.org> wrote in message
news:Xns964CAFD1F116Ejjjjjj@.207.46.248.16...
> When you said "both service packs," does that mean that SP2 doesn't
> include
> fixes from SP1?
> When I read through the SP2 docs it wasn't clear to me, but it seemed like
> if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
> installations.
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
>> That must be RTM (release to Manufacturing, i.e. the first release). That
>> means you have no service packs installed. Given all the fixes I strongly
>> recommend applying both service packs.
>>
>|||I was a little sloppy with that statement. As Robert said, SP2 is all that
is needed to upgrade with.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nerf Herder" <null@.notta.org> wrote in message
news:Xns964CAFD1F116Ejjjjjj@.207.46.248.16...
> When you said "both service packs," does that mean that SP2 doesn't
> include
> fixes from SP1?
> When I read through the SP2 docs it wasn't clear to me, but it seemed like
> if I ran SP2 on an RTM or SP1 installation that I'd end up with equivalent
> installations.
>
>
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
> news:O9bvCaMUFHA.3244@.TK2MSFTNGP15.phx.gbl:
>> That must be RTM (release to Manufacturing, i.e. the first release). That
>> means you have no service packs installed. Given all the fixes I strongly
>> recommend applying both service packs.
>>
>|||Thanks
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in
news:#X0vnASUFHA.228@.TK2MSFTNGP12.phx.gbl:
> I was a little sloppy with that statement. As Robert said, SP2 is all
> that is needed to upgrade with.
>

Report Server serious issues!

I am having serious issues with RS. i have installed the SP1 and I am
able to launch the main reports page, i.e. http://myserver/Reports and
it re-directs to http://myserver/Reports/Pages/Folder.aspx.
Here i can see all the various options etc. Now I created a sample
connection as per the \MSSQL\Reporting
Services\Samples\Reports\Readme.htm file. The problem is I am unable to
upload any RDL file. It tries to do it, and then comes back with this
message:
"An internal error occurred on the report server. See the error log for
more details. (rsInternalError) Get Online Help Timeout expired. The
timeout period elapsed prior to completion of the operation or the
server is not responding. "
I also tried using the rs -i PublishSampleReports.rss -s
http://gacorwks7047a/reportserver -v parentFolder="Sample Reports"
method but that too times out on me.
"The operation has timed-out.
The operation has timed-out.
The operation has timed-out.
The operation has timed-out.
The operation has timed-out."
The other wierd part is that from VS .net2003 when i open a Report
wizard and i can create new shared data source OK (for example local-
pubs using windows authentication), but then when i create the new
report and select the same shared data source i get
"A connection cannot be made to the database. Set and check the
connection string."..
please help!!!
thanx much
-rI'd be looking at the account used to start the Reporting service and see if
it has appropriate access to the 2 reports databases.
"rajeev.unnikrishnan@.gmail.com" wrote:
> I am having serious issues with RS. i have installed the SP1 and I am
> able to launch the main reports page, i.e. http://myserver/Reports and
> it re-directs to http://myserver/Reports/Pages/Folder.aspx.
> Here i can see all the various options etc. Now I created a sample
> connection as per the \MSSQL\Reporting
> Services\Samples\Reports\Readme.htm file. The problem is I am unable to
> upload any RDL file. It tries to do it, and then comes back with this
> message:
> "An internal error occurred on the report server. See the error log for
> more details. (rsInternalError) Get Online Help Timeout expired. The
> timeout period elapsed prior to completion of the operation or the
> server is not responding. "
>
> I also tried using the rs -i PublishSampleReports.rss -s
> http://gacorwks7047a/reportserver -v parentFolder="Sample Reports"
> method but that too times out on me.
> "The operation has timed-out.
> The operation has timed-out.
> The operation has timed-out.
> The operation has timed-out.
> The operation has timed-out."
> The other wierd part is that from VS .net2003 when i open a Report
> wizard and i can create new shared data source OK (for example local-
> pubs using windows authentication), but then when i create the new
> report and select the same shared data source i get
> "A connection cannot be made to the database. Set and check the
> connection string."..
> please help!!!
> thanx much
> -r
>|||the ReportingServices starts under LocalAccount, and the Sql box uses
NT authentication, so i guess this rules it out?
any more suggestions - pleeeeeeeeeeeeez
thanx
-r
Mary Bray [SQL Server MVP] wrote:
> I'd be looking at the account used to start the Reporting service and
see if
> it has appropriate access to the 2 reports databases.
>
> "rajeev.unnikrishnan@.gmail.com" wrote:
> > I am having serious issues with RS. i have installed the SP1 and I
am
> > able to launch the main reports page, i.e. http://myserver/Reports
and
> > it re-directs to http://myserver/Reports/Pages/Folder.aspx.
> >
> > Here i can see all the various options etc. Now I created a sample
> > connection as per the \MSSQL\Reporting
> > Services\Samples\Reports\Readme.htm file. The problem is I am
unable to
> > upload any RDL file. It tries to do it, and then comes back with
this
> > message:
> > "An internal error occurred on the report server. See the error log
for
> > more details. (rsInternalError) Get Online Help Timeout expired.
The
> > timeout period elapsed prior to completion of the operation or the
> > server is not responding. "
> >
> >
> > I also tried using the rs -i PublishSampleReports.rss -s
> > http://gacorwks7047a/reportserver -v parentFolder="Sample Reports"
> >
> > method but that too times out on me.
> > "The operation has timed-out.
> > The operation has timed-out.
> > The operation has timed-out.
> > The operation has timed-out.
> > The operation has timed-out."
> >
> > The other wierd part is that from VS .net2003 when i open a Report
> > wizard and i can create new shared data source OK (for example
local-
> > pubs using windows authentication), but then when i create the new
> > report and select the same shared data source i get
> > "A connection cannot be made to the database. Set and check the
> > connection string."..
> >
> > please help!!!
> > thanx much
> > -r
> >
> >|||It sounds like the timeout in IIS is set too small. Try looking in IIS
Manager.
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<rajeev.unnikrishnan@.gmail.com> wrote in message
news:1112318394.235320.77230@.f14g2000cwb.googlegroups.com...
> the ReportingServices starts under LocalAccount, and the Sql box uses
> NT authentication, so i guess this rules it out?
> any more suggestions - pleeeeeeeeeeeeez
> thanx
> -r
>
> Mary Bray [SQL Server MVP] wrote:
>> I'd be looking at the account used to start the Reporting service and
> see if
>> it has appropriate access to the 2 reports databases.
>>
>> "rajeev.unnikrishnan@.gmail.com" wrote:
>> > I am having serious issues with RS. i have installed the SP1 and I
> am
>> > able to launch the main reports page, i.e. http://myserver/Reports
> and
>> > it re-directs to http://myserver/Reports/Pages/Folder.aspx.
>> >
>> > Here i can see all the various options etc. Now I created a sample
>> > connection as per the \MSSQL\Reporting
>> > Services\Samples\Reports\Readme.htm file. The problem is I am
> unable to
>> > upload any RDL file. It tries to do it, and then comes back with
> this
>> > message:
>> > "An internal error occurred on the report server. See the error log
> for
>> > more details. (rsInternalError) Get Online Help Timeout expired.
> The
>> > timeout period elapsed prior to completion of the operation or the
>> > server is not responding. "
>> >
>> >
>> > I also tried using the rs -i PublishSampleReports.rss -s
>> > http://gacorwks7047a/reportserver -v parentFolder="Sample Reports"
>> >
>> > method but that too times out on me.
>> > "The operation has timed-out.
>> > The operation has timed-out.
>> > The operation has timed-out.
>> > The operation has timed-out.
>> > The operation has timed-out."
>> >
>> > The other wierd part is that from VS .net2003 when i open a Report
>> > wizard and i can create new shared data source OK (for example
> local-
>> > pubs using windows authentication), but then when i create the new
>> > report and select the same shared data source i get
>> > "A connection cannot be made to the database. Set and check the
>> > connection string."..
>> >
>> > please help!!!
>> > thanx much
>> > -r
>> >
>> >
>|||thanx for the suggestion, i checked the tinmeout was 900 secons
something, i have cranked it up to 10,000 seconds and it still times
out..
i think it has something to do with the permissions, in terms of aspnet
users access with respect to some folder or some service - but i cannot
pinpoint what. But then why should VS act weird and not be able to use
the shared DS'
i hope someone can walk me thro some trouble shooting steps and default
access.
thanx again!!
-r
Brian Welcker wrote:
> It sounds like the timeout in IIS is set too small. Try looking in
IIS
> Manager.
> --
> Brian Welcker
> Group Program Manager
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> <rajeev.unnikrishnan@.gmail.com> wrote in message
> news:1112318394.235320.77230@.f14g2000cwb.googlegroups.com...
> >
> > the ReportingServices starts under LocalAccount, and the Sql box
uses
> > NT authentication, so i guess this rules it out?
> >
> > any more suggestions - pleeeeeeeeeeeeez
> >
> > thanx
> > -r
> >
> >
> > Mary Bray [SQL Server MVP] wrote:
> >> I'd be looking at the account used to start the Reporting service
and
> > see if
> >> it has appropriate access to the 2 reports databases.
> >>
> >>
> >> "rajeev.unnikrishnan@.gmail.com" wrote:
> >>
> >> > I am having serious issues with RS. i have installed the SP1 and
I
> > am
> >> > able to launch the main reports page, i.e.
http://myserver/Reports
> > and
> >> > it re-directs to http://myserver/Reports/Pages/Folder.aspx.
> >> >
> >> > Here i can see all the various options etc. Now I created a
sample
> >> > connection as per the \MSSQL\Reporting
> >> > Services\Samples\Reports\Readme.htm file. The problem is I am
> > unable to
> >> > upload any RDL file. It tries to do it, and then comes back with
> > this
> >> > message:
> >> > "An internal error occurred on the report server. See the error
log
> > for
> >> > more details. (rsInternalError) Get Online Help Timeout expired.
> > The
> >> > timeout period elapsed prior to completion of the operation or
the
> >> > server is not responding. "
> >> >
> >> >
> >> > I also tried using the rs -i PublishSampleReports.rss -s
> >> > http://gacorwks7047a/reportserver -v parentFolder="Sample
Reports"
> >> >
> >> > method but that too times out on me.
> >> > "The operation has timed-out.
> >> > The operation has timed-out.
> >> > The operation has timed-out.
> >> > The operation has timed-out.
> >> > The operation has timed-out."
> >> >
> >> > The other wierd part is that from VS .net2003 when i open a
Report
> >> > wizard and i can create new shared data source OK (for example
> > local-
> >> > pubs using windows authentication), but then when i create the
new
> >> > report and select the same shared data source i get
> >> > "A connection cannot be made to the database. Set and check the
> >> > connection string."..
> >> >
> >> > please help!!!
> >> > thanx much
> >> > -r
> >> >
> >> >
> >|||is the fact that i have on that machine .net sdk 1.0, 2.0, SQL 2k, SQL
2005, Analysis Server all running causing some of these issues?|||RS is a 1.1 application, if you have multipe versions of dotnet installed
you definitely have to have IIS configured for RS to be using 1.1. However,
usually when this is a problem you get an error, not a timing out issue.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<rajeev.unnikrishnan@.gmail.com> wrote in message
news:1112358696.050931.32410@.l41g2000cwc.googlegroups.com...
> is the fact that i have on that machine .net sdk 1.0, 2.0, SQL 2k, SQL
> 2005, Analysis Server all running causing some of these issues?
>|||thanx for ur input.. i have since uninstalled sdk2 and re-done
asnet_regiis for 1.1 and still have the same issues..
why does VS 2003 also have the same issue, as to not being able to use
the shared DS even though it is valid!
i am really perplexed here, i have uninstalled and reinstalled rs about
50 times now (with the SP).. the weird thing is that on my personal
laptop all the installation when just fine!!!
thanx
-r
Bruce L-C [MVP] wrote:
> RS is a 1.1 application, if you have multipe versions of dotnet
installed
> you definitely have to have IIS configured for RS to be using 1.1.
However,
> usually when this is a problem you get an error, not a timing out
issue.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> <rajeev.unnikrishnan@.gmail.com> wrote in message
> news:1112358696.050931.32410@.l41g2000cwc.googlegroups.com...
> > is the fact that i have on that machine .net sdk 1.0, 2.0, SQL 2k,
SQL
> > 2005, Analysis Server all running causing some of these issues?
> >|||Are you setting a query timeout on the report in the report designer?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<rajeev.unnikrishnan@.gmail.com> wrote in message
news:1112375976.133779.139770@.o13g2000cwo.googlegroups.com...
> thanx for ur input.. i have since uninstalled sdk2 and re-done
> asnet_regiis for 1.1 and still have the same issues..
> why does VS 2003 also have the same issue, as to not being able to use
> the shared DS even though it is valid!
> i am really perplexed here, i have uninstalled and reinstalled rs about
> 50 times now (with the SP).. the weird thing is that on my personal
> laptop all the installation when just fine!!!
>
> thanx
> -r
>
> Bruce L-C [MVP] wrote:
>> RS is a 1.1 application, if you have multipe versions of dotnet
> installed
>> you definitely have to have IIS configured for RS to be using 1.1.
> However,
>> usually when this is a problem you get an error, not a timing out
> issue.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> <rajeev.unnikrishnan@.gmail.com> wrote in message
>> news:1112358696.050931.32410@.l41g2000cwc.googlegroups.com...
>> > is the fact that i have on that machine .net sdk 1.0, 2.0, SQL 2k,
> SQL
>> > 2005, Analysis Server all running causing some of these issues?
>> >
>|||nopes.. all i have done (:-() is install rs, install rs sp1 and try
opening up the default report manager page. this works fine. but when i
try to upload the rdl file, it doesnt do it. same with vs 2003, it
opens the project, and then when i supply the right url, and try to
deploy the file, it tires and then says time-out!!
what could be screwed up here?
thanx again!
-r|||I don't think it has anything to do with security. It really looks like some
sort of network name resolution issues. Do you have a proxy server? Are you
using fully qualified machine names?
--
Brian Welcker
Group Program Manager
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
<rajeev.unnikrishnan@.gmail.com> wrote in message
news:1112380865.139398.189170@.l41g2000cwc.googlegroups.com...
> nopes.. all i have done (:-() is install rs, install rs sp1 and try
> opening up the default report manager page. this works fine. but when i
> try to upload the rdl file, it doesnt do it. same with vs 2003, it
> opens the project, and then when i supply the right url, and try to
> deploy the file, it tires and then says time-out!!
> what could be screwed up here?
> thanx again!
> -r
>|||well i am running on my local machine (localhost) - so how does the
proxy come into play?..
yes, the machine itself go thro a proxy server to go outside the
company network, but i dont think reportserver needs to go outside the
network to open the report ( OR DOES IT- to come to think of it, the
xslt files ect need to be pulled in real time?!).. if it does matter
where do i set the proxy server settings?
thanx very much!
-r

Report Server Security Issue.

Hi,
We have installed SQL Server ReportingServices on a machine which can
be accessed from out side. now any one who types
http:\\sitename.com\reportserver can access the reports hosted here.
pls give me some solution how to solve this issue.
We tried removing anonymous access for that reportserver in IIS . but
then our application is not able to access the reports as we stored the
URLs of reports in database and call the reports when its required to
create a report.
is this the right way to implement the reporting services ?
JeswanthYou need to implement forms authentication. You do not want to have
anonymous.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<jeswanthj@.gmail.com> wrote in message
news:1147948860.574176.133460@.i40g2000cwc.googlegroups.com...
> Hi,
> We have installed SQL Server ReportingServices on a machine which can
> be accessed from out side. now any one who types
> http:\\sitename.com\reportserver can access the reports hosted here.
> pls give me some solution how to solve this issue.
> We tried removing anonymous access for that reportserver in IIS . but
> then our application is not able to access the reports as we stored the
> URLs of reports in database and call the reports when its required to
> create a report.
> is this the right way to implement the reporting services ?
>
> Jeswanth
>

Report Server Project Template missing

Hi - I have installed VS 2005 Professional Edition and SQL 2005 Developer Edition with all the options(Reporting Services etc...). When I try to create new project, there is no "Report Server Project Template" under "Business Intelligence Projects". How to get that tempalte? Can any one help on this?

mail to : sugunsg@.yahoo.com

thanks in advance
sugu

Try reinstalling the client tools from reporting services again, there might have been a problem that could take longer to investigate than reinstalling the client components.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de