14,494 questions
Thank you for your reply. Any special configuration or parameter for accessing database on cloud?
ODBC client driver for MSSQL database on AWS Cloud
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 18%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETW%3C/text%3E%3C/svg%3E)
Tan Wei Yean
116
Reputation points
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 Other
Accepted answer
-
Tan Wei Yean 116 Reputation points
2021-05-05T06:08:45.22+00:00 -
Olaf Helper 47,436 Reputation points2021-05-05T07:08:52.313+00:00 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;
Sign in to comment -
2 additional answers
Sort by: Most helpful
-
Olaf Helper 47,436 Reputation points
2021-05-05T05:29:42.71+00:00 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.
-
CathyJi-MSFT 22,396 Reputation points Microsoft External Staff2021-05-05T06:13:51.937+00:00 Hi @Tan Wei Yean ,
> 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.