Prev: Haven't figured it out yet :(
Next: report item not linked to a dataset
From: Joerg Schrocke on 12 Sep 2005 09:45
Hello!

We have a big problem with our Reporting Services. Sometime we get following
error when we try to run a report:

An error has occurred during report processing.
(rsProcessingAborted) Get Online Help
Cannot create a connection to data source 'PMO'.
(rsErrorOpeningConnection) Get Online Help
SQL Server does not exist or access denied.

The Reporting Services Server is a WebServer in the internet and gets his
data through a firewall from a internal SQL Server. Sometimes the connection
works fine, but after several reports, we get the error.
We don't have change anything on the firewall.

We connect to the Reporting Server through Windows Authentification and
using a shared dataSource to connect to the SQL Server throug SQL
Authentification.

What can be the problem that it sometimes works and sometimes not???


Please help us.

Many thanks,

Joerg


From: AshVsAOD on 13 Sep 2005 01:27
I too experience this problem. Only on one particular report. I have been
unable to find the solution, and have posted here in the past with no luck.

"Joerg Schrocke" <speedy1179(a)web.de> wrote in message
news:OCtQgA6tFHA.204(a)TK2MSFTNGP10.phx.gbl...
> Hello!
>
> We have a big problem with our Reporting Services. Sometime we get
following
> error when we try to run a report:
>
> An error has occurred during report processing.
> (rsProcessingAborted) Get Online Help
> Cannot create a connection to data source 'PMO'.
> (rsErrorOpeningConnection) Get Online Help
> SQL Server does not exist or access denied.
>
> The Reporting Services Server is a WebServer in the internet and gets his
> data through a firewall from a internal SQL Server. Sometimes the
connection
> works fine, but after several reports, we get the error.
> We don't have change anything on the firewall.
>
> We connect to the Reporting Server through Windows Authentification and
> using a shared dataSource to connect to the SQL Server throug SQL
> Authentification.
>
> What can be the problem that it sometimes works and sometimes not???
>
>
> Please help us.
>
> Many thanks,
>
> Joerg
>
>


From: chieko on 26 Sep 2005 17:16
Hi,

I'm having the same problem.... Does anyone know how to fix this problem???

Thanks!!

Chieko

"AshVsAOD" wrote:

> I too experience this problem. Only on one particular report. I have been
> unable to find the solution, and have posted here in the past with no luck.
>
> "Joerg Schrocke" <speedy1179(a)web.de> wrote in message
> news:OCtQgA6tFHA.204(a)TK2MSFTNGP10.phx.gbl...
> > Hello!
> >
> > We have a big problem with our Reporting Services. Sometime we get
> following
> > error when we try to run a report:
> >
> > An error has occurred during report processing.
> > (rsProcessingAborted) Get Online Help
> > Cannot create a connection to data source 'PMO'.
> > (rsErrorOpeningConnection) Get Online Help
> > SQL Server does not exist or access denied.
> >
> > The Reporting Services Server is a WebServer in the internet and gets his
> > data through a firewall from a internal SQL Server. Sometimes the
> connection
> > works fine, but after several reports, we get the error.
> > We don't have change anything on the firewall.
> >
> > We connect to the Reporting Server through Windows Authentification and
> > using a shared dataSource to connect to the SQL Server throug SQL
> > Authentification.
> >
> > What can be the problem that it sometimes works and sometimes not???
> >
> >
> > Please help us.
> >
> > Many thanks,
> >
> > Joerg
> >
> >
>
>
>
From: Brian on 24 Oct 2005 16:30
I am having the same problem. The reports work fine from my development box,
but when I deploy them to the reporting server, I get:

An error has occurred during report processing. (rsProcessingAborted) Get
Online Help
Cannot create a connection to data source 'dms_be'.
(rsErrorOpeningConnection) Get Online Help
SQL Server does not exist or access denied.

"Joerg Schrocke" wrote:

> Hello!
>
> We have a big problem with our Reporting Services. Sometime we get following
> error when we try to run a report:
>
> An error has occurred during report processing.
> (rsProcessingAborted) Get Online Help
> Cannot create a connection to data source 'PMO'.
> (rsErrorOpeningConnection) Get Online Help
> SQL Server does not exist or access denied.
>
> The Reporting Services Server is a WebServer in the internet and gets his
> data through a firewall from a internal SQL Server. Sometimes the connection
> works fine, but after several reports, we get the error.
> We don't have change anything on the firewall.
>
> We connect to the Reporting Server through Windows Authentification and
> using a shared dataSource to connect to the SQL Server throug SQL
> Authentification.
>
> What can be the problem that it sometimes works and sometimes not???
>
>
> Please help us.
>
> Many thanks,
>
> Joerg
>
>
>
 | 
Pages: 1
Prev: Haven't figured it out yet :(
Next: report item not linked to a dataset