Hi,
What is the context for "unencrypted " here? I think this could be a SQL Server connectivity issue ?
SSAS 2017 - Connecting to unencrypted databases in Visual Studio in 1400 compability mode
I setup a new instance of SSAS 2017 on Windows 2012 R2, in Tabular mode. The developer is developing new models. He states all was working well, until last week. Now he cannot connect to unencrypted SQL data sources.
If he connects to one without a certificate (SQL 2014), he receives this error: "Failed to save modifications to the server. Error returned: 'COM error: Microsoft.Data.Mashup; The given credential is missing a required property. Data source kind: Odbc. Authentication kind: UsernamePassword. Property name: Password.'. "
If he connects to a source with an incorrect certificate, he receives these errors:
- The server name provided doesn't match the server name on the SQL server SSL certificate. Please contact your administrator or see the link below for more information. Alternatively, you could change your Connection encryption setting. Would you like to continue using an encrypted connection? If we say OK, error #2 or #3
- Failed to save modification to the server Error returned: 'COM error: Microsoft.Data.Mashup; the given credential is missing a required property. Data source kind: Odbc. Authentication kind: UsernamePassword. Property name: Password.'
- "Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: We're sorry, an error occurred during evaluation.. OLE DB or ODBC error: The command has been canceled..
We have made no changes to the instance in the last few weeks, and this DOES work in lower compatibility levels.
-
Lukas Yu -MSFT 5,816 Reputation points
2021-02-09T09:45:58.543+00:00