CODEWITHSUNDEEP
mysqlsql-serverssms
Chevy Mark Sunderland
Chevy Mark Sunderland

Reputation: 435

How to create and configure a linked server to connect to MySQL in SQL Server Management Studio

I need create and configure a linked server to connect to MySQL in SQL Server Management Studio

This is the tutorial

I follow the instructions step by step but in the end the result is the following

enter image description here

what am I doing wrong?

please, can you help me?

Upvotes: 0

Views: 162

Answers (1)

Ganesh Chandrasekaran
Ganesh Chandrasekaran

Reputation: 1936

Create a 32Bit ODBC SYSTEM dsn connection, make sure the Test connection works.

Then run the following in your SQL Server Management Studio

EXEC master.dbo.sp_addlinkedserver @server = N'<somelinkname>', @srvproduct=N'MYSQL', @provider=N'MSDASQL', @datasrc=N'<32 Bit DNS Name >'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'<somelinkname>',@useself=N'False',@locallogin=NULL,@rmtuser=N'<mysql user>',@rmtpassword='<mysql pwd>'
GO

Upvotes: 1

Related Questions