Andrey Morozov
Reputation: 7969
SSAS Tabular: How to fix "Failed to connect to the server. Reason: SSL Security Error" while trying to open an existing model on server
After some long time passed since a SSAS Tabular model development and deployment I found myself unable to refresh the model (see screenshot below) furthermore I didn't change a thing in this model (and infrastructure was also the same) since the development time.
The error I got from the Tabular Model Designer
Failed to connect to the server. Reason: [DBNETLIB][ConnectionOpen (SECCreateCredentials()).]SSL Security error.
How to fix or get around this?
Upvotes: 0
Views: 690
Answers (1)
Andrey Morozov
Reputation: 7969
The solution I found was to change a provider (Menu -> Extensions -> Model -> Existing Connections -> Edit -> Build -> Advanced) from SQLOLEDB to SQLNCLIxx (from OLEDB to SQL Native Client)
Upvotes: 2
Related Questions
- "The server could not be contacted." error while deploying Model to SSAS
- Visual Studio SSAS Tabular Model does not show existing connections
- SSAS tabular model timeout raised during processing
- Processing SSAS tabular model fails in sql agent
- Failed to deploy analysis services tabular project in Visual Studio 2019
- How do I resolve the SSAS Tabular error stating changes could not be committed to the vertipaq engine?
- Exception when referencing SSAS Tabular model in C#
- Issue with remote connection to SSAS Tabular via non-Domain laptop
- Deploying tabular model to Azure Analysis Services
- Cannot connect to ssas server