Home Forums SQL Server 2005 SQL Server 2005 Security SQL Agent Unable to Initiate Linked Server without User Logged on RE: SQL Agent Unable to Initiate Linked Server without User Logged on

  • April 8, 2010 at 8:00 am

    #1148289

    Ok. Here's the complete error message. Remember, if I am logged onto the job as the jobs starts, the job would finish fine, without any error at all.

    Date4/1/2010 4:00:00 AM

    LogJob History (DownloadUpdates)

    Step ID1

    ServerS-SQL

    Job NameDownloadUpdates

    Step NameDownloadFromMAX

    Duration00:00:01

    Sql Severity16

    Sql Message ID7412

    Operator Emailed

    Operator Net sent

    Operator Paged

    Retries Attempted0

    Message

    Executed as user: PNPS\sqlservice. Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MAX". [SQLSTATE 42000] (Error 7303) OLE DB provider "MSDASQL" for linked server "MAX" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "MAX" returned message "[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed". [SQLSTATE 01000] (Error 7412) OLE DB provider "MSDASQL" for linked server "MAX" returned message "[Microsoft][ODBC driver for Oracle][Oracle]ORA-12541: TNS:no listener". [SQLSTATE 01000] (Error 7412). The step failed.