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