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