question

TanWeiYean-3330 avatar image
0 Votes"
TanWeiYean-3330 asked OlafHelper-2800 commented

ODBC client driver for MSSQL database on AWS Cloud

I would like to check if I need to install ODBC client drivers to access my MSSQL database on AWS cloud. Do I install the same client drivers that is used for database that is on premise?

sql-server-general
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

TanWeiYean-3330 avatar image
0 Votes"
TanWeiYean-3330 answered OlafHelper-2800 commented

Thank you for your reply. Any special configuration or parameter for accessing database on cloud?

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Any special configuration or parameter for accessing database on cloud?

Take care the connection is encrypted, see https://www.connectionstrings.com/sql-server/ => Encrypt=yes;



0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

Do I install the same client drivers that is used for database that is on premise?

Yes, it doesn't matter where the SQL Server is hosted, we always use the same data provider to access SQL Server.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @TanWeiYean-3330,

if I need to install ODBC client drivers to access my MSSQL database on AWS cloud. Do I install the same client drivers that is used for database that is on premise?

Yes, you are right. You need to install the same client drivers. It doesn’t matter where SQL server is hosted as Olaf mentioned.

Suggest you check the SQL server version and OS environment( Windows or Linux or macOS), before download ODBC Driver for SQL Server. Please read the MS document Download ODBC Driver for SQL Server and System requirements, installation, and driver files.

Any special configuration or parameter for accessing database on cloud?

Did you use SSMS connecting to SQL database on AWS cloud? There is no special configuration.


If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar queries.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.