sql server reporting services: Unstable Permissions? -- sql server reporting services

Unstable Permissions?

Jeremy
3/31/2005 1:21:55 PM

sql server reporting services:

Hello,

I've been using Report Services for several months with no problems,
suddenly I started getting 401 unauthorized errors with no changes on my
part.

The strange part is that it works fine for an hour or two, then quits. If I
restart IIS the problem goes away, but there are several web applications on
the same server and would prefer to not restart it several times a day.

Any ideas?

Jeremy

Re: Unstable Permissions?

Kaisa M. Lindahl
4/1/2005 9:40:18 AM

I don't know what to do about the permissions. But if you run IIS 6.0, you
can use different Application Pools.
Create a new application pool, and add your Report Server site to that. Then
you can recycle just this app pool, and not the whole IIS.
Is this a problem from all clients? I've seen a few people mentioning that
Windows XP SP2 might cause some problems with authentication in Report
Server.

Kaisa M. Lindahl

[quoted text, click to view]