If you setup SSRS 2005 with windows authentification across the board (your report datasets, datasources, models, etc.) is the expected behavior a or b
a) user tries to run report via WebPart in SharePoint and gets prompted for their domain username and password
b) user tries to run report via WebPart in SharePoint, credentials are passed, no need to input their username and password.
I am getting both, one user gets prompted while the rest of the staff don't and the report just opens. The user who's getting prompted tries their domain username and password and it doesn't work. This user is not locked out.
Windows Authentification Behavior
SuzyQ200225
Resolution:
The problem ended up being the fact that the account under which the SQL Server Agent is using, the one that I setup, did not have access to a folder that my SSIS package was trying to access. The first thing my SSIS package does is go to another server, pull a txt file and then does what I programmed it to do. Well, the package couldn't access the folder on that server...I had not added that account to the permissions (security) on that folder so that my SSIS package could successfully grab the txt. So it wasn't anything on my SQL Server, it was the folder permissions on the folder my SSIS package was pointing to in one of the steps on another server.
Aleaxue
Check the user's security settings in Internet Explorer.
Tools->Internet Options: Security Tab.
Option 1: Add the server your report is running on to the user's "Trusted sites" list.
Option 2: Click Custom Level... and check the "User Authentication" settings at the bottom of the list.
pjp