Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1362
  • Last Modified:

Cannot install the SRS Connector in CRM 4.0

Hi,

Having issues connecting the SRS Connector in CRM

The error is -

Unable to validate SQL Server Reporting Services report server installation. Please check that it is installed correctly on the local machine.

Our CRM install is on Server1 and our SQL is on Server2 does the connector need to be on the CRM or SQL server?
0
NPProjects
Asked:
NPProjects
  • 10
  • 9
  • 5
  • +2
1 Solution
 
rakeshAgarwalCommented:
It should be run on sql and we had the same issue.


Are you using named instance or   default instance of sql server


regards
Rakesh
0
 
NPProjectsAuthor Commented:
We have managed to install it on the server with sql but we don't know how to get it to send reports to the crm server. It doesn't seem to have a config or management interface.

How do I find out if its named or default?
0
 
rakeshAgarwalCommented:

 I was asking that question. Because installation of named instance is bit different.  You will not get any configuration.

>>How do I find out if its named or default?

Open sql  it will  show you server name. if your server name and  machine name are same  then its default instance.  You  dont need this right now.


>>It doesn't seem to have a config or management interface

It does not have any management interface :)


Are you able to  see the reports in crm.  This tool is used to authenticate crm user to view reports. It picks up all the settings automatically.


Hope this helps
Ragards
Rakesh
0
Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

 
NPProjectsAuthor Commented:
No I can't see or run reports in CRM. Thats the problem i'm trying to solve.

The general CRM web interface error comes up when trying to access the reports saying: reporting error the report cannot be displayed try this action again and if the problem continues check the microsoft crm community for solutions or contact your organisations microsoft dynamics admin or microsoft support.

any ideas?
0
 
rakeshAgarwalCommented:
Open the  reporting  manager url  
Check wether  you have orgname_mscrm folder or not

if you dont have
publish the  all the reports to report server  <install location of crm/tools
else


/publishreport.exe  <<orgname>>
2.  Go  to report server   ,  open report manager  you will see orgname_mscrm folder
3. you will see folder 4.0
4.  Scroll down to datasource
5.  Select from datasource --> crm extensons
6.  Credential will be provided by user at run time

0
 
WilyGuyCommented:
Sometimes you have to IISRESET one or both websites. (CRM and SRS)
0
 
NPProjectsAuthor Commented:
Hi,

Is a reset the same as a restart?
0
 
WilyGuyCommented:
Not technically. If you restart, it does reset IIS.  What I am talking about is from a command prompt typing IISRESET which will just reset the websites.
0
 
NPProjectsAuthor Commented:
Hi,

The reset didn't work i'm afraid.
Anything else it could be?
0
 
rakeshAgarwalCommented:
start --> run --> type in iisreset
0
 
NPProjectsAuthor Commented:
I ran it in command prompt and it ran successfully but the reports still won't run.


0
 
rakeshAgarwalCommented:
Have you  done this in both the machine CRM and sql  machine.
0
 
rakeshAgarwalCommented:
I hope you must have followed this step.

 Please let me know if you are having difficulty in following this step.

2.  Go  to report server   ,  open report manager  you will see orgname_mscrm folder
3. you will see folder 4.0
4.  Scroll down to datasource
5.  Select from datasource --> crm extensons
6.  Credential will be provided by user at run time
0
 
NPProjectsAuthor Commented:
no, just on the CRM machine. The SQL machine doesn't have IIS installed.
0
 
NPProjectsAuthor Commented:
yes I have followed the step above

does the server with sql on it need IIS for al this to work?
0
 
rakeshAgarwalCommented:
okie  
have you followed above steps  thats important
0
 
rakeshAgarwalCommented:
nope it does not need iis to be installed
0
 
rakeshAgarwalCommented:
can you send me screen shot of your report manager
0
 
NPProjectsAuthor Commented:
hi,  the URL or the GUI and which bit?
0
 
WilyGuyCommented:
So SRS is installed on the CRM server then? (or on SQL or a third server?)

Are they in separate Application Pools in IIS?  Are the Application Pools running with the same or different identity?

Where did you install the SRS Data Connector?

0
 
NPProjectsAuthor Commented:
Server 1 has sbs 2008 with CRM installed

Server 2 has server 2008 installed with SQL and the SRS connector.

CRM is set up to see server 2 but won't run reports.

Have changed the settings as above but no joy....
0
 
WilyGuyCommented:
Alright so is SRS on SQL? Not the SRS connector, but SRS (installed and configured)?

From your question about whether you needed IIS on the SQL server, that leads me to wonder.
0
 
NPProjectsAuthor Commented:
I have Reporting Services installed and Configured on the SQL Server but no IIS. This is also the server I have the connector installed on.

 
0
 
WilyGuyCommented:
SRS requires IIS as it is a web based application. I am not sure how you would have been able to install SRS without it.

so if you go to http://SQLSERVERNAME/Reports and http://SQLSERVERNAME/ReportServer what do you see?

And if you have SRS on a Named Instance as was noted above, you would need to change your installation of the Data Connector.
0
 
RonCairnsIT MAnagerCommented:
Hello,

I am almost in the same situation -

I have SQLSERVER 2005 and MS CRM 4.0 both on 2008 64bit server.
On CRM I am trying to install SQL Reporting Server and no joy.
However, on CRM server https:\\localhost\OURCRM I can run reports.
Users cannot run reports !!!
Any ideas please ?
0
 
sangraalusCommented:
This does not work. I cannot find crm extensions on the Report Server. I have SQL 2008 R2
0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

  • 10
  • 9
  • 5
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now