Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
error uploading .rdls - sql server 2008 and crm 4.0 RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    hello,

    i've written some .rdl reports in VS2008.  i can access them via VS, but when i attempt to upload as external files to crm 4.0, i receive a generic error message:  "an error has occurred."

    i see where some people have had trouble using sql server 2008, but that is where our crm databases are - is this a problem?  what else might i check?  do i need to do something to set up the connector between reporting services and crm, or is that already there by default?

    any ideas?

    thanks!!
    gg
    Monday, February 1, 2010 9:24 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    the ssrs report connector from crm is normally used when the sql and crm not installed on the same server.
    Check if your user you are using has access to publish reports on SSRS.
    Open the SSRS admin console and see if your user has access.

    In some cases installing the SSRS data connector locally solves some problems aswell.

    The error you are getting seems to be access related.
    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Tuesday, February 2, 2010 5:27 AM

All replies

  • Question
    Sign in to vote
    1
    Sign in to vote
    SSRS 2008 is not compatiblem with SSRS 2005 so if you are using SQL 2005 Reporting Servicces you will need to develop reports in Visual Studio 2005. If you're using SQL 2008 RS you may check error log on SSRS server.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    • Proposed as answer by kgorczewski Monday, February 1, 2010 9:31 PM
    Monday, February 1, 2010 9:31 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    thanks for the quick response.

    sorry, i'm not really clear on the setup of this - it's my understanding that with the crm install, ssrs is automatically installed (or configured??).  i looked on the server and don't see any options for ssrs specifically.  obviously, i don't do the server installs.  :)

    does ssrs need to be installed separately on this server, or should it be there based on the crm and/or sql server (2008) install? 

    thanks!!
    gg
    Monday, February 1, 2010 9:49 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    report server is a part of sql server and can be installed on other machine or can sit on sql machine. Which ms sql server do you have 2008 or 2005 ?
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Monday, February 1, 2010 10:03 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    2008

    I will take a look at the configuration/permissions and post back here whether or not it's resolved.  Thanks!

    Monday, February 1, 2010 10:11 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Okay, I am running SSRS 2008 and using .rdls created in VS2008; still receiving the error.  I've checked the application logs on the server and don't see any errors.

    Any ideas of what else to check?

    thanks!gg
    Monday, February 1, 2010 10:59 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    the ssrs report connector from crm is normally used when the sql and crm not installed on the same server.
    Check if your user you are using has access to publish reports on SSRS.
    Open the SSRS admin console and see if your user has access.

    In some cases installing the SSRS data connector locally solves some problems aswell.

    The error you are getting seems to be access related.
    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Tuesday, February 2, 2010 5:27 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    ok, thanks for this info.  i'm checking to see if i have publishing rights and will post back here whether or not that resolved it.
    Tuesday, February 2, 2010 8:43 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    I am having this same problem.  I have MS-CRM 4.0, SQL 2008 and SSRS 2008 on the same server (testing box).  I wrote the report in VS2008 and tried to upload in the CRM interface and I get the generic 'an error occurred' error with no detail.

    Is VS2008 supported in CRM 4.0, or do I need to go back to 2005?  That would suck, considering that 2008 has the ability to interpret HTML fields and activities use that.

    I checked rights and my user has full admin access to the server and SSRS.
    Friday, March 5, 2010 4:22 PM