can't connect to sql server

[Syndicate_Admin]

Hello everyone

I'm working on a BI file my schoolboy has worked on. When I connect to the sql server, the following error appears.

DataSource.Error: Microsoft SQL: A connection to the server was successfully established, but an error occurred during the sign-in process. (provider: SSL provider, error: 0- The certificate chain was issued by an untrusted authority.) Details: DataSourceKind-SQL DataSourcePath-kwthqdwh01; Vision_MC Message-A connection was successfully established with the server, but then an error occurred during the logon process. (provider: SSL provider, error: 0- The certificate chain was issued by an untrusted authority.) ErrorCode-2146232060 Number-2146893019 Class-20

I was able to open a new file and connect to the SQL server database. but the above error occurs in this file.

[v-lionel-msft]

Hi @Syndicate_Admin ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-lionel-msft]

Hi @Syndicate_Admin ,

What kind of credential did you use to connect to SQL Server? Please refer to the links.

Solved: DataSource.Error: Microsoft SQL: A connection was ... - Microsoft Power BI Community

Solved: Re: Error while connecting to SQL database after P... - Microsoft Power BI Community

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Syndicate_Admin , refer to these two past solutions if they can help

https://community.powerbi.com/t5/Desktop/Unable-to-connect-to-SQL-Server/m-p/565508

https://community.powerbi.com/t5/Desktop/Unable-to-connect-SQL-Server/m-p/461152