Activity overview
Latest activity by MMMm
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...
SQL Agent job step fails to run SQL Data Compare Exe with UnauthorizedAccessException
Running SQL Data Compare exe in command prompt and power-shell under service account context works, and able to sync data. This is a scenario of syncing data from database backup file to local data...