Credentials work for SSMS but not (ODBC) LogParser script

Posted by justSteve on Server Fault See other posts from Server Fault or by justSteve
Published on 2010-05-21T14:28:15Z Indexed on 2010/05/21 14:32 UTC
Read the original article Hit count: 321

Filed under:
|
|

Via SSMS I'm able to connect and navigate the server/db in question. but trying to connect via a logparser script the same credentials fail. I'm trying to execute this from the same box on which the server's running. the username is owner/dbo of the db. The db has mixed mode authentication.

[linebreaks for clarity]

C:\TTS\tools\LogParser>c:\tts\tools\logparser\logparser file:c:\tts\tools\logparser\errors2SQL.sql?source="C:\inetpub\logs\LogFiles\W3SVC8\u_ex100521.log"

-i:IISW3C

-o:SQL

-createTable:ON

-oConnString:"Driver={SQL Server Native Client 10.0};Server=servername\SQLEXPRESS;db=Tter;uid=logger2;pwd=foo"

-stats:OFF Task aborted. Error connecting to ODBC Server SQL State: 28000 Native Error: 18456 Error Message: [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'logger2'. C:\TTS\tools\LogParser>

© Server Fault or respective owner

Related posts about sql

Related posts about sql-server-2008