Here are steps will help you.

1. Create regkey NTLMForSQLRSServer DWORD to 1 on CRM server in the
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSCRM registry.

2. Run IE from a third machine. Uncheck Internet
option->Advanced->Security->Enable Integrated Windows Authentication (require
restart). Close all IE windows, and start a new IE window.

Unchecking this option makes sure Kerberos does not work on your client. So
your browser will use NTLM always.

If you see the listing working, but when you view the report contents, you
saw "null" connection error returned by SRS. (this will happen when SRS and
CRM DB are not on the same machine).

Open SRS report manager.
Modify the property of “MSCRM_DataSource�
1.Chang the credentials from “Windows integrated security� to “Credentials
stored securely in the report server�.
2.Type in domain user account name, such as “crmdom\user1�, and password.
This user should be a high priviledge SQL user, such as SQL admin.
3.Check both options “Use as Windows credentials when connecting to the data
source� and “Impersonate the authenticated user after a connection has been
made to the data source�.
4.Hit “apply�.

Thanks!

Min Fan



--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Curt Spanburgh" wrote: