user getting error when refreshing data from sql server database using excel

Sree Vupalanchi 0

Users are getting the error when they refresh data from sql server. They are using excel tool to pull the data. See the below error.

DatasourceError: Microsoft SQL: A connection was successfully established with the server,

but then an error occured during the login process(Provider:SSL Provider, error:0 -The received certificate has expired)

Zhi Lv - MSFT 32,021 Reputation points Microsoft Vendor

2023-03-16T01:36:25.83+00:00

Hi @Sree Vupalanchi

Users are getting the error when they refresh data from sql server. They are using excel tool to pull the data. See the below error.

Do you mean you will connect and extract or pull data from an SQL Server database in Excel using VBA? Not in asp.net core application? And this error happens in Excel, right? If that is the case, the issue does not relate Asp.net Core, it is better to remove the Asp.net core tag and add the Excel tag.

Besides, from the error message, it seems that the issue relates the certificate, it is expired, you can try to update it.
Shaikh Abdul Salam 0 Reputation points

2023-03-16T14:22:04.61+00:00
This error message means that the SSL certificate being used by the SQL Server has expired, which is preventing users from connecting to the server via SSL/TLS. To resolve this issue, you can try the following steps:

Renew the SSL certificate for the SQL Server. You should be able to obtain a new SSL certificate from the Certificate Authority (CA) that issued the original certificate.

Install the new SSL certificate on the SQL Server. Once you have obtained the new SSL certificate, you will need to install it on the SQL Server. This typically involves importing the certificate into the Windows Certificate Store.

Configure the SQL Server to use the new SSL certificate. After installing the new SSL certificate on the SQL Server, you will need to configure the SQL Server to use it for SSL/TLS connections. This may involve updating the SQL Server configuration settings or updating the connection string used by the Excel tool.

Test the connection. Once you have renewed the SSL certificate and configured the SQL Server to use it, you should test the connection from the Excel tool to ensure that it is working properly.

If you are not comfortable performing these steps on your own, you may want to seek the assistance of a qualified IT professional who has experience with SSL/TLS certificates and SQL Server administration.