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
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