Customer experience | Sales, Customer Insights,...

VS 2015 BIDS unable to Connect CRM Online

(0) Share

Report

Posted on by saravananc

107

Am facing the issue connecting the CRM Online in Reporting service Visual studio 2015

I have installed the CRM Report Service Extension 8.0

I have tried below steps nothing works out.

I have installed the fiddler configure the ts1.2 still the same issue.

The CRM link and User Name & password were correct in the browser it's working fine.

Please help out with this issue.

I have the same question (0)

All responses (21)

Answers (0)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

One small correction - there is no ts1.2 there is tls1.2 and if you used your version of protocol - that's first candidate to check why this way didn't work.

As alternative approach - try to install 9.0 Report Authoring Extension instead of 8.0 that you installed - www.microsoft.com/.../details.aspx

Was this reply helpful? Yes No
saravananc 107 on at

Like (0)

Report

Thanks for the Reply I have mention protocol in the fiddler as tls1.2. and I have CRM Reporting Extension 9.0 still am facing the same issue.

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Ok. Next thing to check - can you please show url that you use in DataSet?

Was this reply helpful? Yes No
saravananc 107 on at

Like (0)

Report

Connection string : https://<orgName>.crm4.dynamics.com/;org5b24ed4c;

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

For the url try to use

disco.crm4.dynamics.com/;org5b24ed4c

I tried and it worked for me from the first attempt without Fiddler turned on and without any issue (I'm on the 9.0 version of FetchXml Authoring extension).

Was this reply helpful? Yes No
saravananc 107 on at

Like (0)

Report

Did u mean i have remove the "https://" from the URL ?

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (0)

Report
No. This url trimmer sometimes do the bad work.

What I mean is to use disco instead of orgname so your url should look like following:

https://disco.crm4.dynamics.com/;org5b24ed4c

Was this reply helpful? Yes No
saravananc 107 on at

Like (0)

Report

I have applied as suggested same error

"">disco.crm4.dynamics.com/;org5b24ed4c"

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (0)

Report

Ok. Next question - where did you get that orgid from?

Was this reply helpful? Yes No
saravananc 107 on at

Like (0)

Report

From the Developer resources

Was this reply helpful? Yes No