troubleshooting Question


Avatar of dspencercl
dspencercl asked on
MySQL ServerMicrosoft Legacy OSWindows 7
4 Comments1 Solution525 ViewsLast Modified:
I am attempting to give access to the xp_cmdshell to two windows groups on my server.

What I have set up is this:

In The master database, I have given my user ( which is actually a group...DOMAIN\GroupName ) Execute permission on the xp_cmdshell object.

I have enabled the actual xp_cmdshell feature via the script:

-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
-- To update the currently configured value for advanced options.
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
-- To update the currently configured value for this feature.

When I attempt to access the xp_cmdshell via my application, I recieve the following error:

System.Data.SQLCLient.SQLEXception The xp_cmdshell proxy account information cannot be reteieved or is invalid

The other item of not here is that this only occurs on windows 7.  When i install this app on XP all flavors, I never run into this, and have not had to create a proxy account, and i do not even know what that refers to.

Could anyone point me in the right direction?



Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros