EC2 Windows Instance Excel issue

0

Hello,

I have an ec2 windows instance (AMI: Windows_Server-2022-English-Full-Base-2023.08.10 ami-0ccf0745a25b6c3a4), which i have an excel installed with a license. Now, with a help of data source i want to connect to my RDS SQL Server Instance. But i have the following error:

"Initialization of the data source failed. Check the database server or contact your database administrator. Make sure the external database is available, and then try the operation again. If you see this message again, create a new data source to connect to the database."

Now i have checked my SG and everything is setup as required. The SG of the EC2 Instance is referenced in the SG of the DB on port 1433. Also i have an IIS server installed which already communicating with the RDS SQL Server Instance. Only the excel is the issue. From my local machine i can connect and execute this query which uses the same port-1433.

What could be the issue here?

  • Okay, i found solution. In the connection string of the Data Connection, the provider should be: Provider=SQLOLEDB.1; And with this the connection is successfull!

Vasko
已提問 6 個月前檢視次數 109 次
沒有答案

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南