Hi Lu Hao,
Thank you for providing these details, I realize that I had installed the same software in the same sequences as I did it referring to Nick's blog.
[View:~/365/b/readyxrm/posts/set-up-your-workstation-to-create-sql-server-reporting-services-reports-for-dynamics-365-revisited:750:50]
However I am having challenges to connect my Visual Studio to my current instance MS Dynamics 365 Online.
After providing the connection string and credentials, it gets in to a loop of checking my Organizations, it also prompts me to enter my Microsoft account repeatedly.
I am not sure if it is because of
Its all because of the latest update in the Microsoft TSL(Transport Security Layer) Protocol in SDK assemblies..Microsoft allowed the TSL connection 1.0 and 1.1 for the browsers or client to connect the CRM org.Now Microsoft will support only TSL 1.2 or above going forward(Reference) . If you are connecting your org with the old version of plugin registration tool , then you may face this issue.
I had this problem in my existing setup where I could connect to trial accounts, other instances but had this issue only for this instance. Since I couldn't fix it, I uninstalled and installed it again hoping to take care of the problem, but the problem still exist.
In Syed's blog http://mscrm365.blogspot.com/2018/01/dynamics-crm-v9-connection-error-in.html?m=1 , he mentions how to fix this
2.For Report: Uninstall Report Authoring Extension and install the latest.(Make sure Installed dll is the latest SDK 9.0). if this doesnt resolve the issue then follow the below step.
On the machine where VS is installed go to the start menu, then type run and then enter. Type in regedit and then OK.
Once the Registry Editor is open, go to: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319
Right click on the name of the folder (the v4.0.30319 folder) and select New, then DWORD. Give it the name of SchUseStrongCrypto and the Value of 1. Exit the Registry Editor, then restart your machine.
I tried that option, but I don't see a "NETFramework\v4.0.30319" in that path. Is my problem specific to me or are other also having this issue ?
Here are the steps followed
- Open Visual Studio
- Create a new Project
- Right Click on Report and add a new item
- Add a datasource, provide connection string
- Add a dataset, and provided a fetchxml query.
- There on it gets in to a loop for fetching organization
- My CRM is Two factor authentication enabled,
- When i clicked the query designer, once it was able to pull the values, but when i tried it again it started going in to a loop for fetching organizations and asking me to input my microsoft account.
Thanks,
Shyam
