<div>
SQL Server Agent jobs can run via a proxy account. You should be able to set up a proxy acount with the necessary permissions on the A server so it can backup the databases on that server. I am assuming that the problem you are having is that the NT-Authority account on server B cannot access Server A.
</div>


SQL Server Agent jobs can run via a proxy account. You should be able to set up a proxy acount with the necessary permissions on the A server so it can backup the databases on that server. I am assuming that the problem you are having is that the NT-Authority account on server B cannot access Server A.

<div>
Thanks a lot rboyd56.<br />
But how do I set up a proxy account?<br />
Do you mean a normal local user on Server A?
</div>


Thanks a lot rboyd56.
But how do I set up a proxy account?
Do you mean a normal local user on Server A?

<div>
ok I found were to add an proxyuser and credentials.<br />
but with which user do i have to do this?<br />
I created a new local user (administrator) on server A.<br />
under this new account runs the sqlserveragent. wht do I have to do now?<br />
please help!<br />
thanks a lot<br />
arthrex
</div>


ok I found were to add an proxyuser and credentials.
but with which user do i have to do this?
I created a new local user (administrator) on server A.
under this new account runs the sqlserveragent. wht do I have to do now?
please help!
thanks a lot
arthrex

<div>
Closed, 500 points refunded.<br />
Vee_Mod<br />
Community Support Moderator
</div>


Closed, 500 points refunded.
Vee_Mod
Community Support Moderator

<div>
<div class="content wysiwyg-content">
I need to run a backup for server A. On server A we have SQL-Express.<br />
I would like to do this via SQL Server Agent on server B &gt;&gt;&nbsp;SQL Server 2005.<br />
The problem is, that both Servers are in the DMZ.<br />
The agent runs under NT-Authority.<br />
If I run the maintainance plan the backups works, because it's running in sa-context.<br />
If I run it via agent it's fainling because NT-Authority has no access.<br />
So how is it possible to run the agent properly?<br />
<br />
Thanks a lot<br />
arthrex
</div>
</div>


I need to run a backup for server A. On server A we have SQL-Express.
I would like to do this via SQL Server Agent on server B >> SQL Server 2005.
The problem is, that both Servers are in the DMZ.
The agent runs under NT-Authority.
If I run the maintainance plan the backups works, because it's running in sa-context.
If I run it via agent it's fainling because NT-Authority has no access.
So how is it possible to run the agent properly?

Thanks a lot
arthrex

Backup in DMZ via SQL Server Agent

Microsoft SQL Server 2005 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. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.