Integraged to Sharepoint mode, credential problems -- sql server reporting services

ShirleyH
5/7/2007 1:50:00 PM

I think I have Sharepoint and Reporting services correctly installed to use
windows trusted accounts, (using domain Active Directory logins, but not
Kerberos).

While writing my report, I designed the data set to use windows
authentication (instead of a SQL Server authentication).

From the Report Designer,(report runs fine) the deploy repeatedly asks for
Reporting Services login and won't accept any account credentials at all.

I can upload the report using Sharepoint but when I run the report I get
this error message: "An error has occurred during report processing. This
data source is configured to use Windows integrated securi6ty. Windows
integrated security is either disabled for this report server or your report
server is using Trusted account mode."

Thanks for any assistance,
Shirley

MC_in_BigD
5/8/2007 9:35:00 PM

If using the MOSS 2007 (Microsoft Office Sharepoint Server) , check that the
settings in the Reporting Services Managemnet section for security is set to
Windows Integrated and not Trusted.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Integraged to Sharepoint mode, credential problems