Problems connecting to Dynamics 365 Online using SQL Server Management Studio

(0) Share

Report

Posted on by JonClay

Hi everyone

I'm having an issue connecting my Dynamics 365 Online CRM to SQL Server Management Studio, and wondered if anyone could please help?

Firstly, my setup is:

CRM Server version - Server version: 9.2.21073.00130
SQL Server Management Studio version - 2018 v15.0.18386.0
TDS has been enabled in my CRM enviroment

I'm connecting SQL Server using MFA 2 factor authentication.

So, I can log on to the CRM fine using SQL Server as shown below:

However, the moment I click on anything in the Table tree in the left-hand menu, I get the following error:

I'm following the details as outlined here, but I'm unable to see the rest of my tables / entities.

Does anyone know why this might be?

Many thanks
Jon

All responses (1)

Answers (0)

edmunch on at

Like (0)

Report

RE: Problems connecting to Dynamics 365 Online using SQL Server Management Studio

There is an issue with using SSMS v15.0.18386.0 and I believe a fix is being worked on however no ETA. Can you try using a previous build such as v18.9.1 ?