Sample Header Ad - 728x90

Red gate SQL Compare error while running using SQL Agent Job

-1 votes
1 answer
547 views
I created a SQL agent job to perform a SQL Compare using the below command line powershell.exe -File D:\SQLCompareReports\DEVvsPRJ\DEVvsPRJ.ps1 This below given is the command line code in DEVvsPRJ.ps1 file set-location "C:\Program Files (x86)\Red Gate\SQL Compare 13"; ./sqlcompare /s1:Server1 /db1:Database1/s2:Server2 /db2:Database2/r:"D:\SQLCompareReports\DEVvsPRJ\DEVvsPRJ.html" /rt:Classic /f So, when I tried executing the job it succeeded without any errors. But when I checked the location comparison report was not created. So I went back to Job history and found the following error. > ======== Copyright Copyright c Red Gate Software Ltd 2019 Unhandled Exception: 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() at > System.Threading.ExecutionContext.RunInternal(ExecutionContext > executionContext, ContextCallback callback, Object state, Boolean > preserveSyncCtx) at > System.Threading.ExecutionContext.Run(ExecutionContext > executionContext, ContextCallback callback, Object state, Boolean > preserveSyncCtx) at > System.Threading.ExecutionContext.Run(ExecutionContext > executionContext, ContextCallback callback, Object state) at > System.Threading.ThreadHelper.ThreadStart(). Process Exit Code 0. > The step succeeded. Can anyone please suggest me a way on how to automate this task or a way through this error.
Asked by l.lijith (918 rep)
May 17, 2019, 02:27 PM
Last activity: Oct 9, 2020, 12:07 PM