Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
While trying to connect to SQL Server, i got this error message..please anyone can reply with proper solution..
Details: ": A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"
Solved! Go to Solution.
Hi @Tanuja_PBI
What kind of credential did you choose to connect to SQL, windows,database or microsoft account?
1. Please check whether the account you use in yoru credential has access to SQL currently.
2. Please check Encrypt Connections in your Data Source Setting. If it is checked, uncheck it and try again.
File->Options and Settings -> Data Source Settings, choose your SQL Server data source and select Edit and uncheck "Encrypt Connections" option.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Tanuja_PBI
What kind of credential did you choose to connect to SQL, windows,database or microsoft account?
1. Please check whether the account you use in yoru credential has access to SQL currently.
2. Please check Encrypt Connections in your Data Source Setting. If it is checked, uncheck it and try again.
File->Options and Settings -> Data Source Settings, choose your SQL Server data source and select Edit and uncheck "Encrypt Connections" option.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
wow! Thats great! it is working.....i did exactly what you mentioned in step-by-step..Thank you so much..
@Tanuja_PBI , refer these two
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |