Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
BeginnerBob
Starting Member
2 Posts |
 Posted - 2005-09-08 : 08:09:28
|
| I'm getting the errorxpsql.cpp: Error 87 from GetProxyAccount on line 604 when I try and runexec master.dbo.xp_cmdshell 'DTSRun /S "server" /U "user" /P "password" /N "dts package" /G "{9EF5325F-1BDF-436E-A59F-003BD7B8F884}" '.Can any one help. |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-09-08 : 09:48:15
|
| is the account you are using for your userid and password a sysadmin account. If not, you have to use a proxy account to use xp_cmdshell, which is a big security no-no and it is not something I would allow on my production boxes.====================================================Regards,Sean Roussy"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?) |
 |
|
|
|
|
|
Error when trying to run DTS