I'm trying to ship transaction logs from Server A to Server B. I keep getting permission denied errors when the agent tries to run because it isn't using the right credentials to connect to the backup folder share.
- Neither server is in a domain (and that's not an option).
- I've setup a shared folder on Server B in which to place the files, but Server A needs access to write to it. (Or vice-versa, Server B needs to read from a share that Server A provides.)
- I can't grant permission on Server B's share to Server A's SQL Agent because the servers are separated.
Is there a way I can specify the login credentials for Server A to use when connecting to Server B?
I'm referring to the first textbox on this screen: