Thursday, December 13, 2007

Oh no, not another Reporting Server issue

We got puzzled with some nice error when opening the reports. We had nice two server setup with application server (ms crm) en database server (sql & reporting server). Changes all things for trust for delegation on install/service account level, unfortunately we still got 401.1 error e.g. http unauthorised.

The trick was in the kerberos authentication, you should add dword to registy (hkey_local_machine/software/microsoft/mscrm/... add NTLMForSQLRSServer with value 1 and everything started to work.

So just follow these steps:

1. On the Microsoft Dynamics CRM server, click Start, click Run, type regedit , and then click OK.
2. Open the following registry key: HKLM\Software\Microsoft\MSCRM
3. Right-click MSCRM, point to New, and then click DWORD value.
4. Type NTLMForSQLRSServer .
5. Double-click NTLMForSQLRSServer , type 1 , and then click OK.

So maybe this will also help also in your case, but yet you know what I gonna say.... no guarantees


Anonymous said...

You are my hero! This solved an issue that I couldn't track down for the life of me. Thanks again!

bittercoder said...

Brilliant - I was facing the exact same problem, I was going round in circles thinking this must be a Kerberos issue, turns out all I needed was a registry key!

Anonymous said...

Great solution.
My problem are solved now.
Thank you.

Superrr Groverrr said...

If the reporting services authorisation error occurs during installation, this registry key - obviously - does not exist, because of the installation breakdown/rollback. Any suggestions to at least get the installation past the authorisation error?