In order to avoid incorrect integration with MS SSMS, the working environment must meet the following conditions:
Disable the Allow inprocess option of MSDASQL OLE DB Provider for ODBC Drivers. For this, find the MSDASQL provider in the list of Linked Servers and double-click on it
In the appeared Provider Options window, clear the Allow inprocess checkbox
Create a new Linked Server
Make sure to select Microsoft OLE DB Provider for ODBC Drivers and specify the following parameters
The Salesforce MC tables are already available to be fetched. To get the Account table data, click on the New Query button at the pivot
Edit the SQL query for your needs
As a result, you can see the contents of the selected table retrieved directly from the Salesforce MC account you are connected to.
If the Linked Server was created with the Allow inprocess option enabled, then you should delete this Linked Server and create it again with the Allow inprocess option disabled.