<div>
Does the account that runs sql agent jobs have rights to get that data from the remote server? When you run it in sql management studio, it's running as you, but as a scheduled job, it's running as the agent account, which may not have the same rights.
</div>


Does the account that runs sql agent jobs have rights to get that data from the remote server? When you run it in sql management studio, it's running as you, but as a scheduled job, it's running as the agent account, which may not have the same rights.

<div>
how to set agent account that will run under my credential?
</div>


how to set agent account that will run under my credential?

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am executing a stored proc which runs fine in sql server management studio which uses link server. But when I put that<br />
stored proc inside a job &amp;&nbsp;runs that jobs, it fails.<br />
<br />
Here is the security setting for Link server <br />
<br />
I have added my windows login to (Local server login to remote server login mappings:)<br />
selected the radio button (Be made using the login's current security context)<br />
<br />
Please help.<br />
<br />
Thanks
</div>
</div>


Hi,

I am executing a stored proc which runs fine in sql server management studio which uses link server. But when I put that
stored proc inside a job & runs that jobs, it fails.

Here is the security setting for Link server 

I have added my windows login to (Local server login to remote server login mappings:)
selected the radio button (Be made using the login's current security context)

Please help.

Thanks

SQL Server 2008/Link server question

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

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.