Home Forums SQL Server 2005 Administering xp_cmdshell RE: xp_cmdshell

  • July 13, 2010 at 11:36 pm

    #1192541

    river1 (7/12/2010)

    Hi,

    I execute a command (xp_cmdshell) , but i always receive this error:

    Login failed for user 'teste'.

    But the user is sysadmin and the password is correct.... and the functionality is already active in the surface area)

    Here is the command that i execute:

    Declare @osql varchar(8000)

    Set @osql='EXEC master.dbo.xp_cmdshell '+''''+'osql -Uteste -Pteste -Q"DBCC Checkdb (''''securdb'''')" -o"C:\teste1.txt"'''''''

    EXEC (@osql)

    Can someone help?

    Thank you

    Agghh... don't ever hardcode user security information in SQL Server. Use a trusted connection instead of declaring the -U and -P parameters and, as has already been suggested, add the -Sputserverinstancenamehere parameter. I'm not at a machine where I can look up how to declare a trusted connection so you'll need to lookup in Books Online but IIRC, it's -T or -E... can't remember which one.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)