Na kuongeza kwa lore: SSRS Inaeleza Me “rsAccessDenied”, Lakini … Mimi kwa kweli Access

wiki chache nyuma, 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 (Kipengele kuu kuwa lookup wajanja juu ya parameter na elfu kadhaa maadili kutafutwa nyuma yake).

Hii ilikuwa kazi kubwa katika mazingira ya maendeleo lakini katika kupima mtumiaji kukubalika (UAT) mazingira, it wouldn’t work. Firing up the debugger, tunataka kuona maelezo isipokuwa kama hii:

ruhusa imetolewa user 'UAT_domain mosssvc' ni haitoshi kwa ajili ya kufanya operesheni hii.(rsAccessDenied).

Kama wewe ni kutafuta makosa juu ya kuishi kwenye, 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" haki. We probably tried them all.

Katika kesi yetu, 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, Aliongeza sehemu ya mtandao na kwamba kutatuliwa tatizo letu.

Hopefully hii ila mtu saa moja au mbili chini ya mstari.

</mwisho>

Kujiunga na blog yangu.

Tags technorati:

Kuondoka Reply

Anwani yako si kuchapishwa. Mashamba required ni alama *