<div>
Seems like a privilege issue.<br />
Kindly check the credentials you are using in SSMS and the username you are using in the job to connect the linked server.<br />
Also check the username under which the job is supposed to run.
</div>


Seems like a privilege issue.
Kindly check the credentials you are using in SSMS and the username you are using in the job to connect the linked server.
Also check the username under which the job is supposed to run.

<div>
Usernames is the same for both
</div>


<div>
Is your MS Sql server service and SQL Agent service running under same account? If not then please try to run your agent service under same account under which your sql server service is running.
</div>


Is your MS Sql server service and SQL Agent service running under same account? If not then please try to run your agent service under same account under which your sql server service is running.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
My query to my linked db2 server &nbsp;works fine in a management studio. When I run the same exact query in a sql job. I get the error below. &nbsp;I am running sql server 2008 R2.<br />
<br />
Executed as user: NT AUTHORITY\SYSTEM. Cannot initialize the data source object of OLE DB provider &quot;IBMDASQL&quot; for linked server &quot;ISERIES&quot;. [SQLSTATE 42000] (Error 7303) &nbsp;OLE DB provider &quot;IBMDASQL&quot; for linked server &quot;ISERIES&quot; returned message &quot;CWBSY1006 - User ID is invalid &quot;. [SQLSTATE 01000] (Error 7412). &nbsp;The step failed
</div>
</div>


Hi,

My query to my linked db2 server  works fine in a management studio. When I run the same exact query in a sql job. I get the error below.  I am running sql server 2008 R2.

Executed as user: NT AUTHORITY\SYSTEM. Cannot initialize the data source object of OLE DB provider "IBMDASQL" for linked server "ISERIES". [SQLSTATE 42000] (Error 7303)  OLE DB provider "IBMDASQL" for linked server "ISERIES" returned message "CWBSY1006 - User ID is invalid ". [SQLSTATE 01000] (Error 7412).  The step failed

Issue with Sql Job and Linked Server Query

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.