Post reply

SQL Server Administrator runs as which OS user?

  • September 26, 2005 at 3:01 am

    #111786

    Hi

    We run SQL Server 2000 on Windows 2000 servers. I have a problem with a database job under SQL Server Agent that I want to copy a csv file from the database server to a remote server. Initially I tried exporting the database output directly to the remote server through a DTS job, but I just cannot get the file through, probably due to some access rights somewhere. Then I created a cmd script to perform the copying of the file. Run as administrator from a command shell window on the database server the copy is successful, but when this script is run as a CmdExec type step in a job, no copy takes place. The job step that runs the script returns OK. So now I wonder what OS login/account relates to the database user that runs jobs, and how I can give this login the correct access rights. It obviously does not run as administrator, since running the script manually works fine.

    Regards,

    Arnar Nesset

    arnar@runbox.no

  • September 26, 2005 at 3:10 am

    #592913

    Your right, OS account related to the service account, for example if you want to sql can connect to the share folder in the network, you must grant non local admin user as account for startup SQL.

    You must grant the user who grant to acccess the share folder as account for startup SQL.

    So, for your case, just change the account for starting up SQL/SQL Agent.

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

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