Linked Server - Works for Windows account, Fails for 'sa'

• homebrew01

  SSC Guru

  Points: 55544

  More actions

  February 19, 2015 at 8:34 am

  #315489

  I have a linked server from MSSQL to MySQL.

  If I run a command to update a MySQL table with my Windows login from a query window, it works fine, so does a scheduled job. But if I logon to SQL as 'sa' and try to run it from a query window, I get the following error:

  OLE DB provider "MSDASQL" for linked server "MYSQL_WEB_PROD" returned message "[MySQL][ODBC 3.51 Driver]Access denied for user 'sa'@'111.222.333.444' (using password: YES)".

  Msg 7303, Level 16, State 1, Procedure usp_MySQL_Password_Update, Line 26

  Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MYSQL_WEB_PROD".

  SQL Server Agent Service & MSSQLSERVER Service are running as "Local System" ... Is that relevant ?

  Thoughts ??