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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSRS2005: Authentication failure

Author  Topic 

rvaraganti
Starting Member

22 Posts

Posted - 2009-01-07 : 00:38:29
Hi,

When i use Windows Integrated Security for my datasource in my report am getting the following error:
"An error has occurred during report processing.
Cannot create a connection to data source 'data set name'.
For more information about this error navigate to the report server on the local server machine, or enable remote errors".

I have administrator permission on this server, though am not able to run my report with integrated security.

Report is working fine when i select "Credentials stored securely in Report Server" option with my user id.

Please help me to get rid of this error.



Thanks,
Rachitha.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-01-07 : 10:35:42
are you able to connect to report server using windows authentication?
Go to Top of Page

rvaraganti
Starting Member

22 Posts

Posted - 2009-01-09 : 01:12:37
Yes we are able to connect to REport server using Window Authentication.

Thanks,
Rachitha.
Go to Top of Page
   

- Advertisement -