RS 2005 Testing - database connection issue

Hi,
From my own PC, I have created a report in Report Builder (RB) that has a
SQL server database as a data source, and when I go to run it (in either RB
or Report Manager), I get the following message: -
"Cannot create a connection to data source 'dataSource'.
(rsErrorOpeningConnection)
--
An error has occurred during report processing. (rsProcessingAborted)"
However, when I run the report in Report Builder directly on the test
server, the report is produced no probs!
Any ideas as to why this is happening?
Cheers
TrevorReport Builder is probable running with NT Auth. Do you have permissions to
the data source and model that may be different then when run on the local
machine?
Try to follow how the connections are working. Client machine RB -> Model
-> Data Source. Somewhere there looks like your client has no access to or
it does not exist.
--
| Thread-Topic: RS 2005 Testing - database connection issue
| thread-index: AcXEPOQcb4FfUXeUQNyO6UODzJAI5Q==| X-WBNR-Posting-Host: 195.44.12.109
| From: =?Utf-8?B?YXVsZHJlaWR5?= <auldreidy@.discussions.microsoft.com>
| Subject: RS 2005 Testing - database connection issue
| Date: Wed, 28 Sep 2005 07:57:05 -0700
| Lines: 19
| Message-ID: <5777EA31-DEBF-4071-91B3-D6CE0C7004B0@.microsoft.com>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.sqlserver.reportingsvcs
| NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.2.250
| Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA03.phx.gbl
| Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.reportingsvcs:53272
| X-Tomcat-NG: microsoft.public.sqlserver.reportingsvcs
|
| Hi,
|
| From my own PC, I have created a report in Report Builder (RB) that has a
| SQL server database as a data source, and when I go to run it (in either
RB
| or Report Manager), I get the following message: -
|
| "Cannot create a connection to data source 'dataSource'.
| (rsErrorOpeningConnection)
| --
| An error has occurred during report processing. (rsProcessingAborted)"
|
| However, when I run the report in Report Builder directly on the test
| server, the report is produced no probs!
|
| Any ideas as to why this is happening?
|
| Cheers
| Trevor
|
|