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 |
erncelen
Starting Member
15 Posts |
Posted - 2005-09-23 : 05:51:00
|
I have a problem,I have run a series of bcp statement (in automatic way, running a stored proc).the command from stored proc is:EXEC @RetError = master..xp_cmdshell @RunCmd where @runcmd is the bcp command: bcp "celect * from table1" queryout "c:\pippo.dat" -n -S servername -TI use -T arg Because I don't want to leave password as clear text in the procedure.but:if the bcp is run directly on the windows command prompt, it works.if the bcp is run from sql store proc: EXEC @RetError = master..xp_cmdshell @RunCmd from the stored proc, the following error occur:SQLState = 28000, NativeError = 18456Error = [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\SYSTEM'.NULLDo you vave any suggestions? |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-23 : 15:14:06
|
You must be using Local System Account for your SQL Server services. Change that to a domain account that has local admin access. It should work after that.Tara |
|
|
|
|
|