locked
Reporting services through CRM RRS feed

  • Question

  • I have setup Reporting Services for CRM installed on same server. When logged in on the Server, I can click reports tab and run the canned reports with no problem. However, when logged in from another computer on the network using same credentials, the Reports do not fire. I get unauthorized access from a win 2003 server and a general error from a vista m/c. It seems that IIS on the CRM server is not getting or handling the windows credentials from another m/c.
    Any ideas why. The CRM Server is also a Domain controller with AD installed if it makes any difference.
    This is for CRM 3.0

    Thanks.
    Saturday, April 4, 2009 5:12 PM

Answers

  • Since CRM and SQL are on the same server, normally KERBEROS authentication works automatically. 

    The problem sounds like the issue that happens when SQL and CRM are on separate boxes (Kerberos authentication failures) - you might have success by following some of the troubleshooting notes found here - http://blog.sonomapartners.com/2007/04/kerberos_and_de.html - They give an excellent summary of troublshooting tips and some suggestions on how to resolve the issue.

    I would pay special attention to the information around validating the SPN for the SQL Service - this might help resolve it.


    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Saturday, April 4, 2009 8:44 PM
    Moderator

All replies

  • Make sure the other machine has the CRM/SQL server in it's "Local Intranet Zone" and that IE is set up to automatically log in with current username / Password.
    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Saturday, April 4, 2009 5:26 PM
    Moderator
  • Both settings are in place.

    Saturday, April 4, 2009 6:15 PM
  • Since CRM and SQL are on the same server, normally KERBEROS authentication works automatically. 

    The problem sounds like the issue that happens when SQL and CRM are on separate boxes (Kerberos authentication failures) - you might have success by following some of the troubleshooting notes found here - http://blog.sonomapartners.com/2007/04/kerberos_and_de.html - They give an excellent summary of troublshooting tips and some suggestions on how to resolve the issue.

    I would pay special attention to the information around validating the SPN for the SQL Service - this might help resolve it.


    Scott Sewell, CustomerEffective | http:\\blog.CustomerEffective.com | Twitter:@ScottSewell
    Saturday, April 4, 2009 8:44 PM
    Moderator