File and database via gateway on a Windows AWS Server

[cmoltedo]

Hello everyone,

I spent a week trying to connect a cloud report with the data in an AWS EC2 instance with a Windows server.

My sources of data are a Microsoft SQL server in another machine and some excel and CSV files. My SQL server is running in another machine and can be reached via an internal AWS network and with the respective security group configuration.

I could expose/"connect with the app" to the SQL server via a gateway install in my Windows server. I also have the files in the server but I can't expose them via the gateway, showing me bad credentials when I try to add them as files new data source. I also tried to upload and share via one drive, but I couldn't link the files via sharepoint.

I hope someone could help me.

Regards,

[v-henryk-mstf]

Hi @cmoltedo ,

It seems to be impossible to reproduce this scene, you can post this question in the AWS forum, there will be relevant engineers to answer for you.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[cmoltedo]

Thanks @v-henryk-mstf, but the forum you mentioned was closed a year ago, it has no activity.