Tacobell777
asked on
xp_cmdshell Error 87 from GetProxyAccount on line 604
I am getting the following error
[Macromedia][SQLServer JDBC Driver][SQLServer]xpsql.cp
This is through ODBC... The user I am using in the ODBC connection is not a domain user, just a login created within SQL itself...
I found some articles that talk about this problem, but it refers to me setting up domain user - I don;t have access to the domain, neither do I want to work with a domain user, is there any way of fixing this?
Other info:
The odbc calls a Stored Procedure with the following reference to xp_cmdshell
-- create the string to perform the export
SET @string = 'bcp "##' + @fileName + '" out "' + @path + @fileName + '.xls" -c -U"export" -P"export"'
-- perform the export
EXEC master..xp_cmdshell @string
[Macromedia][SQLServer JDBC Driver][SQLServer]xpsql.cp
This is through ODBC... The user I am using in the ODBC connection is not a domain user, just a login created within SQL itself...
I found some articles that talk about this problem, but it refers to me setting up domain user - I don;t have access to the domain, neither do I want to work with a domain user, is there any way of fixing this?
Other info:
The odbc calls a Stored Procedure with the following reference to xp_cmdshell
-- create the string to perform the export
SET @string = 'bcp "##' + @fileName + '" out "' + @path + @fileName + '.xls" -c -U"export" -P"export"'
-- perform the export
EXEC master..xp_cmdshell @string
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also, I'm sure you know what the risk is by allowing non-syadmins the ability to execute XP_CMDSHELL....
ASKER
Maybe a stupid question, but how do I get in there?
ASKER
I am aware about the security risk, but this is a dev server, and I need the functionality today - when it moves to production the IT dep. can handle it ;-))
ASKER
Duhhhhhhhhh, got it...
ASKER
Perfect, muchos gracias...
Weird--looks like the email notification isn't working tonight...Glad you found it...