Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
torpkevuk
Starting Member
6 Posts |
 Posted - 2007-11-27 : 11:55:28
|
| Sorry if this is in the wrong place.I have sql server 2000 with reporting services. I have written a report which connects to our test database (2 datasources within reporting services, connecting to 2 different databases on the test server)When I preview my reports within reporting services, it works just fine, when I deploy it I receive an error:An error has occurred during report processing. (rsProcessingAborted) Get Online HelpCannot create a connection to data source 'Incident_Tracking'. (rsErrorOpeningConnection) Get Online HelpLogin failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Heres the connection string I have for the Incident_Tracking data source within reporting services:data source=SCWSQL02;initial catalog=Incident_TrackingIn the credentials tab I have 'Use Windows Authentication (Integrated Security)I checked the reportserver and it looks like the datasource is the same there as in reporting services- <DataSourceDefinition> <Extension>SQL</Extension> <ConnectString>data source=SCWSQL02;initial catalog=Incident_Tracking</ConnectString> <CredentialRetrieval>Integrated</CredentialRetrieval> <Enabled>True</Enabled> </DataSourceDefinition>Can anyone shed any light on this? Thanks. |
|
|
|
|
|
Cannot create a connection to data source