xp_cmdshell

[KMM]

Hi !

I am trying to use xp_cmdshell
---
xp_cmdshell 'dir \abcc$'

---
where abc is host name
and C$ is shared name

I get the following error message
"Logon failure: unknown user name or bad password."
I execute the same command at the dos prompt , I get the directory listing

Any suggestions??

Thanks.
KMM

[Ray Miao]

Do you run this as sa? Also check sql services' startup account.


------------
KMM at 3/1/00 11:48:53 AM


Hi !

I am trying to use xp_cmdshell
---
xp_cmdshell 'dir \abcc$'

---
where abc is host name
and C$ is shared name

I get the following error message
"Logon failure: unknown user name or bad password."
I execute the same command at the dos prompt , I get the directory listing

Any suggestions??

Thanks.
KMM

[KMM]

I use WINNT authentication and log on as a user not as sa.
And how do I check the sql services startup account
Thanks


------------
Ray Miao at 3/1/00 12:10:18 PM

Do you run this as sa? Also check sql services' startup account.


------------
KMM at 3/1/00 11:48:53 AM


Hi !

I am trying to use xp_cmdshell
---
xp_cmdshell 'dir \abcc$'

---
where abc is host name
and C$ is shared name

I get the following error message
"Logon failure: unknown user name or bad password."
I execute the same command at the dos prompt , I get the directory listing

Any suggestions??

Thanks.
KMM