Backup in DMZ via SQL Server Agent

Posted on 2007-07-24
Last Modified: 2008-01-14
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
Question by:arthrex
    LVL 16

    Expert Comment

    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.

    Author Comment

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

    Author Comment

    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

    Accepted Solution

    SQL Express doesn't have an agent.
    So it's not possible to do it the way I wanted it to do.
    I managed it with sqlcmd and a scheduled task.

    Thanks anyway rboyd56!
    LVL 1

    Expert Comment

    Closed, 500 points refunded.
    Community Support Moderator

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Join & Write a Comment

    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    24 Experts available now in Live!

    Get 1:1 Help Now