All geek questions in one place

Power connection

I try to connect to db runing on (localdb) \ v11.0 with a power request, but always get the following error:

DataSource.Error: Microsoft SQL: The instance of SQL Server you were trying to connect to does not support encryption. Details: Message = The instance of SQL Server you were trying to connect to does not support encryption. Quantity = 20 Grade = 20

Thanks for any comment.

+5
source share
2 answers

In the query editor, go to File-> Options and Settings → Data Source Settings. Select your (localdb) \ v11.0 and select "Edit" and disable "Encrypt connections." After it is turned off, you should be able to Refresh on the "Home" tab.

Greetings.

+4
source

In older versions of Power Query, manually disabling encryption would be the only way to solve this problem.

If you receive this message in newer versions (2.27 or later), if you get this error, you will be immediately prompted to disable encryption. If this does not work, Send-A-Frown to contact our support services.

0
source

Source: https://habr.com/ru/post/1210525/

More articles:


All Articles