Reporting Services and Linked Server - can't stop execution of pro

Hello,
I have the same problem with Reporting Services and Linked Server.
The Reporting Services receive data source from stored procedure, which
executes inside it stored procedure on the Linked Server. If Reporting
Service successfully forms the report, then everything is OK, but if there
are some troubles (e.g. I close the browser page where report was forming), I
have the problem: the process on the Linked Server doesnâ't stop itself. Itâ's
continuing executing for eternity and locks other processes. The only way to
stop it â' is to kill it. Iâ'll try to set timeouts in the configuration of
Reporting Service and Query Timeout in the Server Options of Linked Server,
but it doesnâ't help. This problem shows itself only if I work through Linked
Server.
Thanks for your help.
Boris.The default timeout for linked server queries is 600 seconds, i.e. 10
minutes. This can be changed in SQL Server using an sp_configure option
"remote query timeout".
Yes, you're right, this is a problem which has nothing to do with Reporting
Services. You may want to repost the relevant part of your question to a SQL
Server forum. You may get more advice on the issue.
HTH
Charles Kangai, MCT, MCDBA
"Boris" wrote:
> Hello,
> I have the same problem with Reporting Services and Linked Server.
> The Reporting Services receive data source from stored procedure, which
> executes inside it stored procedure on the Linked Server. If Reporting
> Service successfully forms the report, then everything is OK, but if there
> are some troubles (e.g. I close the browser page where report was forming), I
> have the problem: the process on the Linked Server doesnâ't stop itself. Itâ's
> continuing executing for eternity and locks other processes. The only way to
> stop it â' is to kill it. Iâ'll try to set timeouts in the configuration of
> Reporting Service and Query Timeout in the Server Options of Linked Server,
> but it doesnâ't help. This problem shows itself only if I work through Linked
> Server.
> Thanks for your help.
> Boris.
>sql

REPORTING SERVICES 2005 AND VISUAL STUDIO 2003

Hi everyone
I would like to put the following question...
I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
MSQL2000 Database?
Do I need to Install Visual Studio 2005 ?
Thanks a lot
MiltosRS 2005 comes with a version of VS 2005. You do not have to purchase it.
Just install the BI tools from the SQL Server 2005 disk. RS 2005 can use SQL
Server 2000 db for its object/metadata (as long as you have the SQL Server
2005 license) the biggest issue is installing side by side on the database
with RS 2000. The other issue is IIS. One part of IIS (RS 2000) needs to
stay at 1.1, the other needs to be at 2.0. So you upgrade IIS with 2.0
framework and then you have to get the initial sites back to 1.1.
I believe all of this is possible but it is non-trivial.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
<milmen@.tellas.gr> wrote in message
news:1155895924.922028.277620@.m79g2000cwm.googlegroups.com...
> Hi everyone
> I would like to put the following question...
> I have a machine with XP Pro SP2, MSSQL 2000, Reporting Services 2000
> and V.S. 2003, could I Install Rep Serv 2005 and create reports on an
> MSQL2000 Database?
> Do I need to Install Visual Studio 2005 ?
> Thanks a lot
> Miltos
>|||I have the same predicament.
I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
RS2000
The client wanted to upgrade SQL to 2005 but now I have difficulties
running my application which runs on Framework 1.1 to call RS2005 now
using Framework 2.
So to solve it, I downgraded RS back to 2000.|||There was no reason to downgrade RS. There are two ways to be integrating:
URL Integration and Web Services. Both are still available to you from your
application. The web server has to be told which sites are still running
1.1, then the sites used by RS 2005 use 2.0.
Also, his case was that he wanted to have RS 2000 and RS 2005 side by side.
That does not seem to be the case for you. Your situation seemed to be one
of integration which should not be a problem at all.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"rGenius" <ruellacaste@.gmail.com> wrote in message
news:1156490695.127315.56360@.b28g2000cwb.googlegroups.com...
>I have the same predicament.
> I have worked on a project created in VS 2003 Framework 1.1, SQL 2000,
> RS2000
> The client wanted to upgrade SQL to 2005 but now I have difficulties
> running my application which runs on Framework 1.1 to call RS2005 now
> using Framework 2.
> So to solve it, I downgraded RS back to 2000.
>

Reporting services 2005

Hello,

I installed SQL Server 2005 into a Windows 2005 Pro machine, I have following question:

1. will I be able to use Reporting services to deploy the reports to the same machine as a report server?

2. Can I modify and deploy mo old reports written in RS2000

3. Is there any web site that show step by step how I can work with RS2005?

Thanks,

for the first question, of course, you can
for the third question, you can view the tutorial on reporting servicein sqlserver2005 help, first you should install both 'adventurework'database and 'adventureworkdw'database which are used in the tutorial.The install manual is also in sqlserver2005 help

Reporting Services -- Connection issues

RS Web Site and database on the same WIN 2003 Server. Visual Studio dev on
a XP Pro.
Installation was no problem ... installed the AdventureWorks sample reports
(via a Command script).
Able to open http://<servername>/reports however when running the sample
reports the following message is received "An error has occurred during
report processing. (rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'AdventureWorks'.
(rsErrorOpeningConnection)"
I have unsuccessfully reset the "Data Source Properties" several ways
(credential are not required and Use Win credentals with Impersonate, and
etc)
Additionally when creating a report with VS all the dataset queries run fine
... the report "Preview" returns the report and no error when doing a
"Build". However when "Deploying" this error message is returned " The
report server cannot open a connection to the report server database. A
connection to the database is required for all requests and processing."
Some sort of successful connection has to exist to return the Web page with
the sample reports listed and the successful "Preview'. So what's the
problem.
Could this be an issue because the SQL Server installation is a 'Named
Instance' .. If so is there a work around?
Thanks in advance
GeneH
I miss posted this question ... I have move it to sqlserver.reportingsvcs
thanks
"GeneH" wrote:

> RS Web Site and database on the same WIN 2003 Server. Visual Studio dev on
> a XP Pro.
> Installation was no problem ... installed the AdventureWorks sample reports
> (via a Command script).
> Able to open http://<servername>/reports however when running the sample
> reports the following message is received "An error has occurred during
> report processing. (rsProcessingAborted) Get Online Help
> Cannot create a connection to data source 'AdventureWorks'.
> (rsErrorOpeningConnection)"
> I have unsuccessfully reset the "Data Source Properties" several ways
> (credential are not required and Use Win credentals with Impersonate, and
> etc)
> Additionally when creating a report with VS all the dataset queries run fine
> ... the report "Preview" returns the report and no error when doing a
> "Build". However when "Deploying" this error message is returned " The
> report server cannot open a connection to the report server database. A
> connection to the database is required for all requests and processing."
>
> Some sort of successful connection has to exist to return the Web page with
> the sample reports listed and the successful "Preview'. So what's the
> problem.
> Could this be an issue because the SQL Server installation is a 'Named
> Instance' .. If so is there a work around?
> --
> Thanks in advance
> GeneH
sql

Reporting Manager - Not all buttons seem to work

I just installed the eval on a XP Pro machine and
everything seems to work fine except in certain places in
the web app. Buttons just don't seem to have a related
event for the onclick or onsubmit. If you click it
nothing happens.
Anyone else run across this?Hi Brian:
It could be the client side javascript files supporting ASP.NET are
not installed properly. Find and run 'aspnet_regiis.exe -c'
HTH,
--
Scott
http://www.OdeToCode.com/
On Fri, 8 Oct 2004 13:16:59 -0700, "Brian Fairchild"
<bfairchild@.NOSPAMintelemedia.com> wrote:
>I just installed the eval on a XP Pro machine and
>everything seems to work fine except in certain places in
>the web app. Buttons just don't seem to have a related
>event for the onclick or onsubmit. If you click it
>nothing happens.
>Anyone else run across this?