By default, if you provide the CRM 2011 URL in the connection string, the BIDS component will pick the first CRM Organization in the list of orgs - even if you specify the Organization in the URL (not good).
To ensure that you are connected to the correct Organization, include the full URL and the Organization's unique name in the Connection String parmeters
Connection string:
https://acmecorp.crm.dynamics.com/;
Absolute Connection string:
https://acmecorp.crm.dynamics.com;crmnaorgfbc80/;
You will find your unique CRM Online organization name under the Settings/Customizations/DeveloperResources area
Here is an example of the full Connection string
Did you ever encounter an error when connecting to CRM Online saying LogonIdentityExWithUI():
ReplyDeleteAn authentication error occurred while connecting to server "https://xxx.crm4.dynamics.com/XRMServices/2011/Discovery.svc". Make sure that the connection string and credentials are correct, and try again?
I've been getting this for several CRM 2011 online environments (both non-365 and 365 accounts). My connection URL is https://xxx.crm4.dynamics.com/;
Connection to the CRM environment with the exact same credentials as my datasource works like a charm. Confusing!!