November 18, 2004 at 12:56 am
Hi,
I have a win2K Adv Svr with clustering. When i run exec sp_xxx 1 to write to a map drive named I, it return output as Logon failure: unknown user name or bad password.
Any idea what went wrong? The win2K adv svr is using the administrator account and the mapped drive winK server is connected as user named abc which has administrator priviledge. It was working before but now it doesn't.
Thanks.
November 18, 2004 at 5:51 am
Did abc's password expire/change? Is the account locked?
Good Hunting!
AJ Ahrens
webmaster@kritter.net
November 18, 2004 at 7:51 pm
Hi,
Nope, abc's password was not expired /changed/locked. From Windows explorer, I can login and view the contents in that I drive. To add, the database server administrator is a domain administrator logon and the abc id on the other win2K server is not a domain administrator but a local administrator.
November 19, 2004 at 5:21 am
Can you try giving the UNC path ?
November 19, 2004 at 5:39 am
I have used the below but no use.
xp_cmdshell 'dir \\172.16.x.x\test'
xp_cmdshell 'dir \\abcserver\test'
xp_cmdshell 'dir I:'
November 21, 2004 at 6:30 pm
Hi,
Just for anyone's info, i have solved it. I have joined the abc's server which is a win2K to the domain, reboot it and added the domain administrator to the folder's priviledge.
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply