October 12, 2016 at 11:29 am
Hi,
I have a SQL Scheduled Job that communicates with a MySQL via a Linked Server and ODBC connection. However, when I manually run the PROCS that fail using the Scheduled Job, the process runs successfully.
When running manually, I am running using my account, meanwhile the Scheduled Job uses the Admin account.
When I manually test the ODBC connection and Linked Server connection both run successfully.
When running the job, I get the following message:
Message
Executed as user: DOMAIN\Admin. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MY_LINKEDSERVERNAME". [SQLSTATE 42000] (Error 7303) OLE DB provider "MSDASQL" for linked server "MY_LINKEDSERVERNAME" returned message "The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: 0X.XX". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "MY_LINKEDSERVERNAME" returned message "[MySQL][ODBC 5.3(a) Driver]Access denied for user 'MY_ID'@'SERVERNAME.DOMAINNAME.com' (using password: NO)". [SQLSTATE 01000] (Error 7412). The step failed.
Does anyone have insight as to what might be causing this?
October 13, 2016 at 12:28 pm
Does the id Domain\Admin have access to the MySQL database you are trying to connect to?.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply