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 2000 Forums
 SQL Server Development (2000)
 Reporting Services prompts for login everytime?

Author  Topic 

SQLServerDBA_Dan
Aged Yak Warrior

752 Posts

Posted - 2005-10-21 : 09:14:01
Problem:
Reporting services prompts for a login at every login attempt to the test environment. This does not happen on dev and prod. I can't seem to find out what's different about that instance of reporting services.

I've got 3 instances of SQL Reporting Services installed (Dev, test, & prod).

Dev:
- SQL & SRS reside on same box (Dev01)
Test:
- SQL & SRS are located on separate boxes (Test01 & TestIIS)
(Yes, yes, I know it's not good to that the "test" setup does not match the production but I didn't set it up.)
Prod:
- SQL & SRS reside on same box (PROD01)

All use NT Auth to connect to reports and the ReportServer service runs under "NT Authority\NetworkService". Everything, including the users, are in the same domain.

So basically I just would like to know what would cause the domain login dialog to pop up every time.


Thanks.

karuna
Aged Yak Warrior

582 Posts

Posted - 2005-10-21 : 11:08:33
I'm not sure, but probably you have selected Integrated And Digest or Basic Authentication on IIS?

Thanks

Karunakaran
Go to Top of Page
   

- Advertisement -