current community

your communities

more stack exchange communities

Stack Exchange Inbox Reputation and Badges
tour help
Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I'm trying to link my SQL-Server 2005 on Windows Server 2008 R2 with MySQL 5.5.40 on a different computer. I have followed this guide:

http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/

However, when i try to test the connection under "Linked Servers" as you can see in this screenshot:

enter image description here

i'm getting this error:

enter image description here

The ODBC data source was added as shown in above link as you can see here:

enter image description here

What can be the reason for this? Note that the Server2008 is a 64bit OS, if that matters.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

The ODBC Connection needs to be a System DSN. The connection is made as the service account, not you, and so the service account doesn't know about your User DSN.

From the article:

Select the System DSN tab to configure a data source for the entire system.

share|improve this answer
    
Thanks, i've realized it already. But i've still problems to connect. Maybe you know why. I get "access denied" and "using password no" which indicates that the password defined in the ODBC data source is not even used in MySql. Do you have an idea why? Because if i click "Test" in the MySql-Connector for the ODBC datasource(image above) it connects and authenticates successfully. –  Tim Schmelter Jan 29 at 13:23
    
Now it seems to work (at least the connection part). I've get it to work with this answer. –  Tim Schmelter Jan 29 at 13:43

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.