Żieda fil-Lore: SSRS jgħidlekx Me “rsAccessDenied”, Iżda … I really do jkollhom aċċess

Ftit ġimgħat lura, 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 (l-karatteristika prinċipali li tkun lookup għaqlija fuq parametru bi diversi eluf valuri jitfittex warajh).

Dan kien qed jaħdem kbir fl-ambjent iżvilupp iżda fl-ittestjar aċċettazzjoni mill-utenti (UAT) ambjent, it wouldn’t work. Firing up the debugger, aħna se ara d-dettalji ta 'eċċezzjoni bħal din:

L-permessi mogħtija lill-utent "UAT_domain mosssvc" mhumiex biżżejjed biex iwettqu din l-operazzjoni.(rsAccessDenied).

Jekk inti tagħmel tfittxija live fuq l-iżball ta 'hawn fuq, 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" dritt. We probably tried them all.

Fil-każ tagħna, 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, miżjuda l-parti web u li tissolva problema tagħna.

Nisperaw li dan se jiffrankaw xi ħadd siegħa jew tnejn matul il-linja.

</aħħar>

Abbona għall-blog tiegħi.

Tags:

Ħalli Irrispondi

Your email address mhux se jkun ippubblikat. Meħtieġa oqsma huma mmarkati *