asked on

Is it possible to access SQL Database from AWS?

Hi Expert,

One of our client requested me that they want to access SQL Database from Amazon Web Services . Is it possible. If yes/no please explain. They are already using AWS for their new systems and it really working well. New tooling, technology, TpaaS infrastructure etc. what are our options if they want to keep using the current DB back ends

They also told me they can also migrate their DB back end needs to AWS.

Kelvin Sparks

It is generally possible to access any database using Access that it located anywhere. The AWS envirnomnent is no different, although can be fun to set up. I'd be looking to migrate the SQL Servers to the same AWS datacenter for performance reasons.

When I connect Access to cloud SQL databases, I always use DSN-Less connections, althought it is possible to work with DSNs.

Kelvin

Zahid Ahamed

ASKER

Kelvin,

Thanks for your reply. This SQL Instance on premise location not in cloud AWS. And the client want to access from AWS to on premise SQL Server. They are already using AWS for their new systems. So do they need to migrate SQL server to AWS or can connect using DSN to on premise SQL Server. Could you please guide me how can I configure DSN in order connect on premise SQL Server from AWS.

Zahid

Kelvin Sparks

Providing your local database server is able to be contacted from the cloud (many organisations will not permit that), then you should be able to.

Kelvin

ASKER CERTIFIED SOLUTION

Shalom Carmel

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

EugeneZ

yes, you can ..

see this doc

Using a Microsoft SQL Server Database as a Source for AWS Database Migration Service
http://docs.aws.amazon.com/dms/latest/userguide/CHAP_Source.SQLServer.html

Zahid Ahamed

ASKER

Thanks for the details.