title: Very Confused About SQL Server/SSMS Job Network Access/Accounts
body: <p>Okay all, the subject is a pretty poor one, but I'm not sure how else to put it. I have Server 2012 with a bunch of jobs, all owned by <code>sa</code>. They all worked fine ever since I began working here in January 2016, but we recently made <em>major</em> changes to our servers. Currently, we have a few servers off the domain, and set up together as a workgroup. They're clones of what we were running before the shakeup, so include all the data/logins. The main difference is that they can't talk to our Active Directory anymore.</p>
  
  <p>Back to SQL Server. Some of the jobs on the server have to read from and write to an FTP folder on one of the servers which is in the same workgroup. That is, both the 2012 server and the FTP server are on the same workgroup, so <em>should</em> talk to each other with no problem. However, some of the jobs keep failing because of logon errors when trying to connect to the FTP server. I'm not using FTP, but rather network locations, like <code>\\1.2.3.4\ftp\folder\file.txt</code> in my job code. This worked perfectly until the servers moved. Skipping the long and confusing reasons why, suffice it to say that this server won't be back in contact with Active Directory for some time. Indeed, letting it be so can't happen until we can shut down its on-domain counterpart. However, we can't do that until I get this working sans domain contact. Again, long story behind that catch-22.</p>
  
  <p>My questions after dealing with all this are:</p>
  
  <ul>
  <li>If the job in question is owned by <code>sa</code>, why do the logs show logon attempts by <code>nt access\network</code> authority?</li>
  <li>How/where can I change the username/password the 2012 server is using to talk to the FTP server?</li>
  <li>Is there a way I could access the FTP server, given the workgroup setup in place, that's easier than what I'm trying to do now? Sharing settings on the FTP folder, for instance?</li>
  </ul>
  
  <p>Thanks for any explanations anyone can offer. I'm thoroughly confused about permissions, accounts, credentials, and remote access and have no idea where to turn, having googled all of this exhaustively.</p>