Create a SQL Server Linked Server access to MySQL (RDS running in AWS)

Create a SQL Server Linked Server to MySQL (RDS running in AWS) We have running MYSQL at Amazon RDS and need to connect it creating a linked server using...

Create a SQL Server Linked Server to MySQL (RDS running in AWS)

We have running MYSQL at Amazon RDS and need to connect it creating a linked server using SQL Server Management studio

SQL Server Management Studio(SSMS) is an ideal environment for managing the infrastructure of the SQL Server database and SQL Server itself. With SSMS, you can easily connect to your SQL Server instance running in local as well as to external Servers, configure and monitor database objects, as well as execute queries. Besides this, there is a possibility to create an ODBC connection to external data from SSMS.

I will share the step by step how to create a connection to MYSQL database from SSMS using ODBC driver.

Prerequisites

1 – ODBC Driver

2 – SQL Server with Management Studio

Get the odbc driver and install it from this url http://dev.mysql.com/downloads/connector/odbc/

In my case, I have downloaded and installed mysql-connector-odbc-8.0.20-winx64.msi

Create DSN using ODBC connector

Go to Start > Administrative Tools > Data Sources (ODBC) > System DSN and select Add

Image – 1

Image – 2

Now ODBC connection successful to the MySQL server running (Amazon RDS)

Next, open SQL Management Studio and connect to local server using Windows authentication as per the image – 3

Image – 3

Expand Server Objects – and add a New Linked Server

as per the image -4 need to fill the details

Image – 4

As per the image – 5 need to select Security page

Image – 5

As per image – 6 select the Server options to make the changes in red

Image – 6

Now you should be able to connect to the MYSQL Server running in Amazon RDS

It’s connected to the MYSQL Database using SQL Server linked server.

 

You may also like:

Windows cannot be installed to this disk. the selected disk has an MBR partition table

How to install PHP7.1 and PHP 5.6 in Ubuntu 14

How to install IIS Web Server on Amazon EC2 Instance (Windows Server 2008)

Windows process activation service failed to start

Setup metered Internet Connection in Windows 10

Categories
SQL ServerWindows

I am a proud Indian, proud father, a blogger, Being in a profession as System administrator, my passion is troubleshooting computer issues, I do like sharing solutions through blogging making videos of solving issues.
No Comment

Leave a Reply

*

*

RELATED BY