Context I have an Oracle 11g database instance and a SQL Server 2012 instance installed on 2 different servers in the same domain. The Oracle database is configured to accept connection with Integrated Security (ie. Active Directory authentication). SQL Server has the Reporting Services feature installed and configured. Reporting Services will connect to Oracle database using the Oracle .NET data provider from Microsoft. Issue When creating a data connection to the database in Visual Studio I have no problem to connect to the Oracle database using Integrated Security. I configured the connection with this connection string: Data Source=INSTANCE_NAME;Integrated Security=True;Unicode=True But whenever I try to create a data source in Reporting Services from the SSRS website, from Report Builder or from BIDS, I am getting a login error: ORA-01017: invalid username/password; logon denied I tried copying the exact same connection string but the result is always the same. It looks like Reporting Services is ignoring the "Integrated Security=True" option for an unknown reason. Notes The same issue occurs with SQL Server 2008 R2. Oracle .NET data provider from Oracle cannot be used with Reporting Services.

Hello, Follow the link below. It will help you. http://support.microsoft.com/kb/834305 http://social.msdn.microsoft.com/Forums/uk/sharepointbi/thread/140304c7-8643-4a2e-8645-d2c01396d506

Unfortunately, none of these posts had the answer to my problem. All the required datasource are already installed on the Reporting Server and I only have an authentication issue when I try to pass the current user credentials. If I use Oracle credentials directly, it works fine. I insist on the fact that I have no problem connecting to the database using Integrated Security in the Visual Studio data source connector. This only fails in SSRS.

I have found the solution to this problem some times after I posted here and I come back to answer it. So actually the problem was that Kerberos was not setup on the Oracle database. Therefore NTLM was being used and NTLM can only hop 1 server maximum. So when the client pass its credentials to the reporting server, has authentication already reached a hop count of 1, the reporting server will then send anonymous credentials to authenticate on the Oracle database, which of course fails. After setting up Kerberos on Oracle and enabled Kerberos authentication on the Report Server, everything went fine.

good to know, thank you for sharing.stong