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 查看次数
没有答案

您未登录。 登录 发布回答。

一个好的回答可以清楚地解答问题和提供建设性反馈,并能促进提问者的职业发展。

回答问题的准则