Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi All,
I am trying to connect IBM DB@ database but getting below error. Please anyone can help me to solve this issue.
IBM DB2: ERROR [08001] [IBM] SQL30081N A communication error has been detected. Communication protocol being used: "SSL". Communication API being used: "SOCKETS". Location where the error was detected: "SOCKETS". Communication function detecting the error: "sqlccSSLSocketSetup". Protocol specific error code(s): "420", "*", "*". SQLSTATE=08001
Regards,
Vinod
Hi v-cgao-msft,
Thanks for your response, I will check and let you know the result.
Regards,
Vinod
Hi @Anonymous ,
The SQL30081N error indicates there is a problem with the network communication between your client and the DB2 server. Error code "420" in the context of SSL usually points to an issue related to SSL communication, which could be caused by several factors such as SSL certificate problems, incorrect SSL configuration, or network issues like firewalls or proxy settings.
1. If you are using an older version of the IBM DB2 drivers, consider updating to the latest version as it might contain fixes for SSL-related issues.
2. Ensure that the SSL configuration on both the client and the DB2 server is correct. This includes the SSL certificate, the key database, and the stash file.
3. Make sure that there are no network issues such as firewalls, proxies, or any other security appliances that could be blocking or inspecting SSL traffic.
4. Confirm that the SSL certificate has not expired and is valid. Also, check that the client trusts the certificate chain leading up to the certificate.
Power Query IBM Db2 database connector - Power Query | Microsoft Learn
Solved: Re: IBM DB2 Connection - Page 2 - Power Platform Community (microsoft.com)
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
13 | |
11 | |
8 | |
8 |
User | Count |
---|---|
17 | |
10 | |
7 | |
7 | |
7 |