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