Unable to login to SQL Server database

TabularEditor / TabularEditor3

Bug reports, feature requests, discussion and documentation for Tabular Editor 3 (commercial version).

63 stars 7 forks source link

Unable to login to SQL Server database #677

Closed nimishnagpal closed 1 year ago

nimishnagpal commented 2 years ago

I am a model that has existing connections. It is Refresh fine. But in the tabular editor, if I try to "Update Schema" or "Import New Table" using those existing connections it is not allowing me to login.

Error Message: Unable to Connect to Source. Unable to connect to the database 'xxxx' on 'ServerName': A Connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The target principal name is incorrect.)

otykier commented 2 years ago

Hi @nimishnagpal This is a known issue in v. 3.3.5. To workaround, edit the connection details, click "Advanced" and then set "Trust Server Certificate" to "true".

nimishnagpal commented 2 years ago

Thanks for the quick response. That works for me.

Once I have set "Trust Server Certificate" to "true" under the advance settings, I am unable to re-visit the advance properties of the connection. Where again can I find the advanced settings for the connection?

otykier commented 2 years ago

You can edit connection details on the Data Source object of your model:

nimishnagpal commented 2 years ago

This data source property shows the GENERAL connection properties. I am looking for Advance settings like "Trust Server Certificate" property. Cannot find them here.

otykier commented 2 years ago

For a legacy data source, these settings are stored within the Connection String property. Click on the ellipsis button to bring up the connection details dialog:

For a structured data source, these options are not stored within the data model, as the Analysis Services engine uses some other data provider for connectivity. Tabular Editor, however, still uses the SqlClient provider, and so for that reason, it stores the advanced settings in the .tmuo file, which is saved next to your Model.bim file:

mlonsk commented 1 year ago

@otykier has this issue been resolved in never versions of Tabular Editor 3?

otykier commented 1 year ago

Yes, I am not aware of any current issues with SQL connections (except for a very specific case with dedicated Synapse pools, which will be fixed in the next update).