Creating a Linked Server in SSMS for a MySQL database
I had to help a fellow colleague with creating a “Linked Server” in SSMS (SQL Server Management Studio) for a MySQL DB.
I figured, I might as well slap it on here:
Creating a Linked Server in SSMS for a MySQL database
Step 1
Download the MySQL ODBC driver from mysql.com
Step 2
Install MySQL ODBC driver on Server where SQL Server resides
- Double Click Windows Installer file and follow directions.