JimS-Indy (1/2/2014)
What I was looking for was "standard" practice. If you set up a SS in an AD environment, and SQL Server Agent will need to access a network share, what account would one use?
The standard practice in this scenario is to use a basic low priv domain user account.
JimS-Indy (1/2/2014)
The account I did use works for non-network-share stuff (I'm not sure why...)
Could it be a local admin on the sql box??
JimS-Indy (1/2/2014)
but when I tried to add "WINNTDOM\sqlserveragent" to the group with access to the network share, it failed saying the account was not a user.... I also tried forward slash...
Always a \ never a /
Are you saying you have access to the Active Directory catalog\domain controller?
What group are you adding the account to?
The simplest way to achieve what you need is to ensure the account that the agent service is running under has been granted Share and NTFS privileges on the network location
JimS-Indy (1/2/2014)
There is a "global" account called "sqlserveragent", but I don't know the password for it, etc. I guess I'll have to wait for my IT guy to come back on monday.
Global accounts are not usually advised
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉