Hi
Just tagging on to this thread, I'm having an issue with reporting services.
I have a data source which I want referencing via a DNS Entry as the database is mirrored, so the DNS entry will point to the live server.
Under the data source Connection String on Report Manager I have
data source=iris_test.forthports.net;initial catalog=IRIS;Integrated Security=SSPI; Trusted_Connection=true;
I have also selected the following:
- Credentials stored securely in the report server
- Use as Windows credentials when connecting to the data source
- Specified a valid domain account in the format DOMAIN\UserAccount
When I try to run the report I get the following error in Report Manager
An error has occurred during report processing.
Cannot create a connection to data source 'dsIrisSys'.
Login failed for user ''. The user is not associated with a trusted SQL Server connection.
On the SQL side the following errors are logged:
Date15/03/2010 13:01:43
LogSQL Server (Current - 15/03/2010 13:01:00)
SourceLogon
Message
Error: 17806, Severity: 20, State: 2.
Date15/03/2010 13:01:43
LogSQL Server (Current - 15/03/2010 13:01:00)
SourceLogon
Message
SSPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: 192.168.17.151]
Date15/03/2010 13:01:43
LogSQL Server (Current - 15/03/2010 13:01:00)
SourceLogon
Message
Error: 18452, Severity: 14, State: 1.
Date15/03/2010 13:01:43
LogSQL Server (Current - 15/03/2010 13:01:00)
SourceLogon
Message
Login failed for user ''. The user is not associated with a trusted SQL Server connection. [CLIENT: 192.168.17.151]
Both SSRS and SQL server are running on the same machine (SQLTEST02).
I'm not 100% on what I need for the SPN, but I have
Registered ServicePrincipalNames for CN=SQLTEST01,CN=Computers,DC=forthports,DC=
net:
HOST/sqltest01.forthports.net
HOST/SQLTEST01
Within IIS I have Integrated security set for the Reporting Services Website (which appears to work fine).
Lastly I can connect remotely using SSMS as the required DOMAIN\UserAccount.
I can't see why this is causing a problem - I would appreciate any help.
_____________________________________________________________________________MCITP: Business Intelligence Developer (2005)