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?
AWS OFFICIALUpdated 6 months ago
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!