How can we help you today? How can we help you today?
rferraton
Activity overview Badges (0) Posts (1) Comments (5)

Activity overview

Latest activity by rferraton

Good to know ! Thanks My problem,  in that case, when i don't use a sql agent proxy account, the sql agent account (that is a named account) is used and in this case i have a licence error (which is normal...). Unfortunatly the account used for launching sql agent or sql server does not have enought privileges to login as a normal user for security reason... so i can't define a serial for this named account. May be you know a method to give a valid serial number to this kind of users/accounts ? / comments
  1. Community
  2. SQL Data Compare
  3. SQL Agent job step fails to run SQL Data Compare Exe with UnauthorizedAccessException
Good to know ! ThanksMy problem,  in that case, when i don't use a sql agent proxy account, the sql agent account (that is a named account) is used and in this case i have a licence error (which is...
0 votes
how to ignore sensitivity extented properties ?
  1. Community
  2. SQL Source Control
After activating "Classify Data" from SSMS 17.9 (new feature of SSMS) there are extended properties that was added to tables. Sources Control (based on git) seams not able to ignore theses extended...
2 followers 2 comments 0 votes
The issue does not appear when lauching the same script using a scheduled task / comments
  1. Community
  2. SQL Data Compare
  3. SQL Agent job step fails to run SQL Data Compare Exe with UnauthorizedAccessException
The issue does not appear when lauching the same script using a scheduled task
0 votes
SQL Compare Command Line V13.6.1.7928 ====================================================================================================================== Copyright c 1999 - 2018 Redgate Software Ltd The job script encountered the following errors. These errors did not stop the script: A job step received an error at line 3 in a PowerShell script. The corresponding line is 'C:\"Program Files (x86)"\"Red Gate"\"SQL Compare 13"\sqlcompare.exe /server1:.\DATAD1 /database1:SIGMA_SA /scripts2:D:\EXPLOIT\SCRIPT\SQL_DEV_PROVISIONING_RESULT\Databases\SIGMA_SA /q /synch /options:Default /report:D:\EXPLOIT\SCRIPT\SQL_DEV_PROVISIONING_RESULT\Databases\SIGMA_SA.html /reportType:Simple /rad /force '. Correct the script and reschedule the job. The error information returned by PowerShell is: ' ' A job step received an error at line 3 in a PowerShell script. The corresponding line is 'C:\"Program Files (x86)"\"Red Gate"\"SQL Compare 13"\sqlcompare.exe /server1:.\DATAD1 /database1:SIGMA_SA /scripts2:D:\EXPLOIT\SCRIPT\SQL_DEV_PROVISIONING_RESULT\Databases\SIGMA_SA /q /synch /options:Default /report:D:\EXPLOIT\SCRIPT\SQL_DEV_PROVISIONING_RESULT\Databases\SIGMA_SA.html /reportType:Simple /rad /force '. Correct the script and reschedule the job. The error information returned by PowerShell is: 'Unhandled Exception:  ' A job step received an error at line 3 in a PowerShell script. The corresponding line is 'C:\"Program Files (x86)"\"Red Gate"\"SQL Compare 13"\sqlcompare.exe /server1:.\DATAD1 /database1:SIGMA_SA /scripts2:D:\EXPLOIT\SCRIPT\SQL_DEV_PROVISIONING_RESULT\Databases\SIGMA_SA /q /synch /options:Default /report:D:\EXPLOIT\SCRIPT\SQL_DEV_PROVISIONING_RESULT\Databases\SIGMA_SA.html /reportType:Simple /rad /force '. Correct the script and reschedule the job. The error information returned by PowerShell is: '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() ' A job step received an error at line 3 in a PowerShell script. The corresponding line is 'C:\"Program Files (x86)"\"Red Gate"\"SQL Compare 13"\sqlcompare.exe /server1:.\DATAD1 /database1:SIGMA_SA /scripts2:D:\EXPLOIT\SCRIPT\SQL_DEV_PROVISIONING_RESULT\Databases\SIGMA_SA /q /synch /options:Default /report:D:\EXPLOIT\SCRIPT\SQL_DEV_PROVISIONING_RESULT\Databases\SIGMA_SA.html /reportType:Simple /rad /force '. Correct the script and reschedule the job. The error information returned by PowerShell is: ' ' ' Do you think it will need to have elevated privileges to call program in the c:\program files(x86) ?  / comments
  1. Community
  2. SQL Data Compare
  3. SQL Agent job step fails to run SQL Data Compare Exe with UnauthorizedAccessException
SQL Compare Command Line V13.6.1.7928======================================================================================================================Copyright c 1999 - 2018 Redgate Software L...
0 votes
PS : i use a proxy account that is the same that i use to launch the script manually. / comments
  1. Community
  2. SQL Data Compare
  3. SQL Agent job step fails to run SQL Data Compare Exe with UnauthorizedAccessException
PS : i use a proxy account that is the same that i use to launch the script manually.
0 votes
Same error for me, the path seam good become log show "SQL Compare Command Line V13.6.1.7928" It is after SQL Compare was launch that the error happened. No error happened when the powerscript is launch manually . Does sqlcompare need elevation rights maybe ? or workdir are different when launching directly or with sql agent ? / comments
  1. Community
  2. SQL Data Compare
  3. SQL Agent job step fails to run SQL Data Compare Exe with UnauthorizedAccessException
Same error for me,the path seam good become log show "SQL Compare Command Line V13.6.1.7928"It is after SQL Compare was launch that the error happened.No error happened when the powerscript is laun...
0 votes
Total activity
7
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
1