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.

(more…)

\