Comments
Sort by recent activity
I was able to get sql job step working by not using proxy. / comments
I was able to get sql job step working by not using proxy.
The service account has necessary permission. SQL Data compare works fine when running in cmd/powershell when logged into the server with that account. However, it fails when invoked via Sql job. The SQL job runs under a proxy account mapped to the above service account. Any idea what is happening here? What could be the "maybeFullPath" it is trying to access? System.UnauthorizedAccessException: Access to the path is denied. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.Pipes.NamedPipeClientStream.Connect(Int32 timeout) at RedGate.Ipc.NamedPipes.NamedPipeEndpointClient.Connect(Int32 timeoutMs) at RedGate.Ipc.Rpc.RpcConnectionProvider.TryGetConnection(TimeSpan timeout) at RedGate.Ipc.ReconnectingConnectionProvider.ReconnectionWorker() / comments
The service account has necessary permission. SQL Data compare works fine when running in cmd/powershell when logged into the server with that account. However, it fails when invoked via Sql job. T...