The previous post we have shared How to Create SQL Database In Microsoft Azure, this article will cover how you can configure and ODBC connectivity to the Azure SQL database.
Deploy an Azure SQL database is a very easy task and you don’t have to worry about the hardware, deployment issues around applications. You can deploy the SQL DB in a few minutes and start using it by using this you will save a lot of time and cost to hardware.
You can Download ODBC driver below links.There are 64 and32-bit versions of the ODBC drivers, install the one that matches your Windows operating system.
ODBC Driver 17.0 for SQL Server released for Microsoft SQL Server 2017 (currently version 17.2) (download)
ODBC Driver 13.0 for SQL Server released for Microsoft SQL Server 2016 SP1 and SQL Azure (currently version 13.1) (download)
ODBC Driver 13.0 for SQL Server released for Microsoft SQL Server 2016 (download)
SQL Server Native Client 11.0 released for Microsoft SQL Server 2012 (download)
Note:- It is recommended to check the “Use strong encryption for data” option, we have not checked because it is just a test and you can modify this anytime after successful configuration.
If everything is okay, a screen like below with message test Completed Successfully.
Now use this to configuring your application from any machine which is allowed from the firewall.
Download and Install the Microsoft Server Management Studio (SSMS) to access the DB and modify anything
Conclusion
We have created system DSN and created a connection to Azure SQL Database instance to your local machine. You can follow this and configure the connection to all your machines and application can access the DB from there.Note that you have to allow the IP to access the DB in the firewall configuration which Is explained in my previous post How to Create SQL Database In Microsoft Azure
Nakivo has released its new Backup and Replication solution Nakivo v10.8, which includes support for…
Oracle Cloud VMware Solution (OCVS) provides a customer-managed, native VMware-based cloud environment hosted in Oracle…
Vinchin is a professional provider of data protection solutions for enterprises. It provides a series…
In my previous blog post, I have explained about VMware Cloud Disaster Recovery (VCDR) Onboarding and…
vRealize Network Insight helps you build an optimized, highly available, and secure network infrastructure across…
Can you believe it's here again? SysAdmin Day is back, and with it comes endless gratitude…