Red Gate forums :: View topic - Running sqlcompare with another AD account
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

Running sqlcompare with another AD account

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
wkwathen



Joined: 06 Oct 2012
Posts: 3

PostPosted: Sat Oct 06, 2012 6:44 pm    Post subject: Running sqlcompare with another AD account Reply with quote

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/viewtopic.php?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
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Tue Oct 09, 2012 3:35 pm    Post subject: Reply with quote

Thanks for your post. Generally speaking, you'd need to be a SysAdmin to run SQL Compare on a box as we write and read from the registry a fair bit.

What credentials are you specifying for SQL Compare to use? Do they have administrative privileges?

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
wkwathen



Joined: 06 Oct 2012
Posts: 3

PostPosted: Tue Oct 09, 2012 6:06 pm    Post subject: Reply with quote

Hi Peter, the creds I am using to run sqlcompare is a local admin on both the CI build vm where sqlcompare is as well as the vm where SQL Server resides. The account has sysadmin privs as well in SQL Server.
Thanks-Kevin
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Wed Oct 10, 2012 4:03 pm    Post subject: Reply with quote

Thanks for your reply. Have you got UAC enabled on the VM? If so, can you try disabling that and let me know how you get on?

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group