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ビュー
回答なし

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ