Post reply

cmdshell error.

  • May 8, 2006 at 8:01 am

    #114535

    Hi all,

    I have a small question.

    im trying to move some files e.g., .txt from one server to another server by using cmdshell 'move f:\*.txt \\server2\F$\'

    but it shows the msg... Access is denied.

    but its running when im using this command in the MSDOS prompt.

    plz tell what kind of access is needed?????

    Thanks

    Noman

  • May 8, 2006 at 8:19 am

    #636534

    Hi,

    Has the startup account of SQL Server the right to write on the other server?

    If you do this from Dos prompt you're using your user account and not the one SQL Server is using.

    This kind of things happens when you use a local system account as startup for SQL Server.

    Holger

  • May 8, 2006 at 9:38 am

    #636554

    YES, i guess this is the real problem, my server is running on System Account.

    but what if when i dont want to change it from system account to another account.?? bcz it is the publisher and may be if i changes the SQL Server account from system to another, it may occur any kind of problems.?? is it so??? is there any chance of any kind of errors or in replication.??

    please guide me, ..

    Thanx

    Noman 

  • May 8, 2006 at 4:05 pm

    #636632

    Thanx !!

    I have solved my problem. thanks buddy. it was the same problem that you have mentioned.

    Regards,

    Noman

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply