Post reply

windows auth for backups, same question asked differently

  • November 4, 2011 at 1:44 pm

    #251182

    I have another post but i wanted to ask in a different way without all the detail. Simple question :).

    Can login to sql server with a windows auth account, and then just by the fact of logging with that account (no proxy account or credentials etc) have a backup executed by issuing tsql from the connection that i just logged in with, and have that backup use the same login to write the files on a network share?

    Jimmy

    "I'm still learning the things i thought i knew!"

  • November 4, 2011 at 2:22 pm

    #1403502

    Simple answer: No...

    The credentials you use to login to SQL Server have no bearing on the credentials being used by the backup. The backup will run in the context of the account that is running SQL Server.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply