Running sqlcompare with another AD account
wkwathen
Posts: 4
Hi, I'm trying to run sqlcompare command line via powershell with Jenkins using a different windows service account than the agent running Jenks. We were getting access denied and basically in the same situation as your customer in this thread --> http://www.red-gate.com/messageboard/vi ... hp?t=15259
I too would like to avoid using sql authentication and hope this feature comes soon!
So within powershell I tried running sqlcompare via "Start-process" which allows me to run the exe with different credentials and get this error:
"SQL Compare attempted to perform an operation not allowed by the security policy. To grant this application the required permission, contact your system administrator, or use the Microsoft .Net Framework Configuration Tool. Requested registry access is not allowed"
Suggestions?
Thanks-Kevin
I too would like to avoid using sql authentication and hope this feature comes soon!
So within powershell I tried running sqlcompare via "Start-process" which allows me to run the exe with different credentials and get this error:
"SQL Compare attempted to perform an operation not allowed by the security policy. To grant this application the required permission, contact your system administrator, or use the Microsoft .Net Framework Configuration Tool. Requested registry access is not allowed"
Suggestions?
Thanks-Kevin
Comments
What credentials are you specifying for SQL Compare to use? Do they have administrative privileges?
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Thanks-Kevin
Pete
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569