BIDS - Unable to connect to data source CRM on premise 2013

(0) Share

Report

Posted on by account payable

670

UNABLE TO CONNECT DATA SOURCE CRM ON PREMISE 2013 WHEN I CLICK ON QUERY DESIGNER .IF ANYONE KNOW ABOUT THIS ERROR PLEASE HELP ME

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Nuno 2,005 on at

Like (0)

Report

Restarting the IIS and CRM services should resolve it.

Was this reply helpful? Yes No
Suggested answer

Nausher Sayeed 522 on at

Like (0)

Report

Hi,

I belive you have IFD based authentication. Check IFD server and restart IIS

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

Is the connection string that you have the internal (claims based authentication) or external (ifd authentication).

It seems like you might be entering the wrong url. Try using the external url in your connection string. This should most likely give you the organization service.

Restarting IIS can help, but not sure that is your problem.

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

Hi Nuno Almeida

Restart iis and crm services but still showing same

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

Hi Nausher Sayeed

this is connect thru iis (local server) retsrted iis but still showing unable to connect database

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

Hi Aric Levin

this internal (claims based authentication) for test server

already restarted IIS but no change

Was this reply helpful? Yes No
Aric Levin - MVP 30,190 Moderator on at

Like (0)

Report

If you navigate your browser to:

https://**crmsvr.**.com/XRMServices/2011/Discovery.svc, do you get results?

Was this reply helpful? Yes No
account payable 670 on at

Like (0)

Report

showing like above screenshot .not geting result

Was this reply helpful? Yes No