Dodavanje do Lore: SSRS mi govori “rsAccessDenied”, Ali … Ja stvarno nemaju pristup

Nekoliko tjedana nazad, I was working with my developer colleague on a project involving SQL Server Reporting Services plug-in for MOSS. He was developing a web part that provides a fancy front-end to the report proper (glavna značajka se pametan pretraživanja na parametar s nekoliko tisuća pretraživati ​​vrijednosti iza njega).

Ovaj je rad velik u razvojnom okruženju, ali u testiranje korisnika prihvaćanje (UAT) okolina, it wouldn’t work. Firing up the debugger, vidjeli bismo iznimka detalje kao što su to:

Na dozvole dodijeljene korisnika 'UAT_domain mosssvc' nedostatne za obavljanje ovog postupka.(rsAccessDenied).

Ako to učinite uživo pretraživanje na gore navedene pogreške, you find it’s quite common. Scarily common. The worst kind of common because it has many different potential root causes and everyone’s suggested solution "feels" pravo. We probably tried them all.

U našem slučaju, the problem was that we had done a backup/restore of DEV to UAT. Somewhere in the data, something was still referring to "DEV_domain" (instead of the updated "UAT_Domain"). We created a new site, dodao je i da je dio web riješiti naš problema.

Nadam se da će to spasiti nekoga sat ili dva niz liniju.

</kraj>

Pretplatite se na moj blog.

Technorati Tags:

Dopust jedan Odgovor

Vaša email adresa neće biti objavljena. obavezna polja su označena *