Post reply

Log parser

  • May 27, 2010 at 1:42 am

    #221613

    Hi all,

    I am Trying to execute Log parser query through Xp_cmdshell like--

    exec master..xp_cmdshell 'C:\"Program Files"\"Log Parser 2.2"\logparser.exe "SELECT * FROM C:\inetpub\logs\LogFiles\W3SVC1\u_ex10052603.log TO IISLogsu_ex10052603" -o:SQL -server:servername -driver:"SQL Server" -database:Dbname -username:sa -password:PWEREE1 -createtable:ON'

    --It gives fallowing error like

    Task aborted.

    Cannot open <from-entity>: Error opening files: Error searching for files in

    folder C:\inetpub\logs\LogFiles\W3SVC1: Access is denied.

    NULL

    Statistics:

    -----------

    Elements processed: 0

    Elements output: 0

    Execution time: 0.01 seconds

    NULL

    NULL

    pls help me

  • May 27, 2010 at 3:14 am

    #1173185

    Do u have enough permissin to that location??

  • May 27, 2010 at 3:41 am

    #1173198

    Thank'Q For reply,Ratheesh.K.Nair

    Yes I have the all The permission to that location, In sa login I did all these things.In CMD prompt it is fine, By using xp_cmdshell i am getting problem.

  • May 27, 2010 at 11:53 am

    #1173492

    Does the account SQL is running under have permissions to that location?

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

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