SQL Nexus not passing correct SQL username/password to ReadTrace.exe

Apr 8, 2010 at 9:06 AM

Hi Everyone,

I am trying to process a .TRC file generated using SQLDiag.exe. But when I try to import it using SQL Nexus, the process fails, with the ReadTrace log below. It is apparent that ReadTrace is being invoked with the wrong username/password combination for logging into my database. But, I cannot find where I can set this information in SQL Nexus. The database ReadTrace is being instructed to use is in fact the same one that SQL Nexus was currently logged into when it invoked ReadTrace. Access was established for SQL Nexus using a username password combination too (not Windows authentication.) Does anybody have an idea how I can configure either SQL Nexus or ReadTrace to be supplied the proper credentials?

Thanks,

Behzad

*****************************************************************

 

04/08/10 12:50:00.649 [0X00000AAC] Readtrace a SQL Server trace processing utility.
Version 9.01.0109 built for x86.
Copyright (c) Microsoft Corporation 1997-2008. All rights reserved.
04/08/10 12:50:00.649 [0X00000AAC] Number of processors: 8
04/08/10 12:50:00.649 [0X00000AAC]     Active proc mask: 0x000000FF
04/08/10 12:50:00.649 [0X00000AAC]         Architecture: 0
04/08/10 12:50:00.649 [0X00000AAC]            Page size: 4096
04/08/10 12:50:00.649 [0X00000AAC]         Highest node: 0
04/08/10 12:50:00.649 [0X00000AAC]         Processor(s): 0x00000055 Function units: Shared
04/08/10 12:50:00.649 [0X00000AAC]         Processor(s): 0x000000AA Function units: Shared
04/08/10 12:50:00.649 [0X00000AAC]           Processors: 0x000000FF assigned to Numa node: 0
04/08/10 12:50:00.649 [0X00000AAC] -SELMAN
04/08/10 12:50:00.649 [0X00000AAC] -dsqlnexus_890117_2
04/08/10 12:50:00.649 [0X00000AAC] -U%s
04/08/10 12:50:00.649 [0X00000AAC] -P**
04/08/10 12:50:00.649 [0X00000AAC] -T18
04/08/10 12:50:00.649 [0X00000AAC] -IE:\SQLDiagOutput\ELMAN__sp_trace.trc
04/08/10 12:50:00.649 [0X00000AAC] -f
04/08/10 12:50:00.649 [0X00000AAC] -oC:\Documents and Settings\behzad\Local Settings\Temp\2\RML
04/08/10 12:50:00.649 [0X00000AAC] -H!PSSDIAG
04/08/10 12:50:00.649 [0X00000AAC] Using language id (LCID): 1024 [English_United States.1252] for character formatting with NLS: 0x00000001 and Defined: 0x00000001
04/08/10 12:50:00.649 [0X00000AAC] <FILTER>
<COLUMN NAME="HOST">
<AND>
<ARGUMENT>
<TYPE>NOT EQUAL<TYPE>
<VALUE>PSSDIAG<VALUE>
</ARGUMENT>
</AND>
</COLUMN>
</FILTER>
04/08/10 12:50:00.649 [0X00000AAC] Attempting to cleanup existing RML files from previous execution
04/08/10 12:50:00.649 [0X00000AAC] Using extended RowsetFastload synchronization
04/08/10 12:50:00.649 [0X00000AAC] Establishing initial database connection:
04/08/10 12:50:00.649 [0X00000AAC] Server: ELMAN
04/08/10 12:50:00.649 [0X00000AAC] Database: sqlnexus_890117_2
04/08/10 12:50:00.649 [0X00000AAC] Authentication: SQL
04/08/10 12:50:00.852 [0X00000AAC] Initial HRESULT: 0x80040E4D
04/08/10 12:50:00.867 [0X00000AAC] 
04/08/10 12:50:00.867 [0X00000AAC] Dumping error record 1 of 1:
04/08/10 12:50:00.867 [0X00000AAC] --------------------------------------------------------------------------
04/08/10 12:50:00.867 [0X00000AAC]    Description       = Login failed for user '%s'.
04/08/10 12:50:00.867 [0X00000AAC]    Source            = Microsoft SQL Native Client
04/08/10 12:50:00.867 [0X00000AAC]    ERRORINFO.hrError = 0x80040e4d
04/08/10 12:50:00.867 [0X00000AAC]    ERRORINFO.dwMinor = 18456
04/08/10 12:50:00.867 [0X00000AAC]    ERRORINFO.clsid   = {85ECAFCC-BDD9-4B03-97A8-FA65CBE3859B}
04/08/10 12:50:00.867 [0X00000AAC]    SQL State         = 28000
04/08/10 12:50:00.867 [0X00000AAC]    Native Error      = 18456
04/08/10 12:50:00.867 [0X00000AAC] Unable to connect to the specified server.
04/08/10 12:50:00.867 [0X00000AAC] ERROR: Performance analysis failed to initialize.  See previous errors and correct the problem before retrying.
04/08/10 12:50:00.867 [0X00000AAC] *******************************************************************************
* ReadTrace encountered one or more ERRORS. An error condition typically      *
* stops processing early and the ReadTrace output may be unusable.            *
* Review the log file for details.                                            *
*******************************************************************************
04/08/10 12:50:00.883 [0X00000AAC] ***** ReadTrace exit code: -9

04/08/10 12:50:00.649 [0X00000AAC] Readtrace a SQL Server trace processing utility.

Version 9.01.0109 built for x86.

Copyright (c) Microsoft Corporation 1997-2008. All rights reserved.

04/08/10 12:50:00.649 [0X00000AAC] Number of processors: 8

04/08/10 12:50:00.649 [0X00000AAC]     Active proc mask: 0x000000FF

04/08/10 12:50:00.649 [0X00000AAC]         Architecture: 0

04/08/10 12:50:00.649 [0X00000AAC]            Page size: 4096

04/08/10 12:50:00.649 [0X00000AAC]         Highest node: 0

04/08/10 12:50:00.649 [0X00000AAC]         Processor(s): 0x00000055 Function units: Shared

04/08/10 12:50:00.649 [0X00000AAC]         Processor(s): 0x000000AA Function units: Shared

04/08/10 12:50:00.649 [0X00000AAC]           Processors: 0x000000FF assigned to Numa node: 0

04/08/10 12:50:00.649 [0X00000AAC] -SELMAN

04/08/10 12:50:00.649 [0X00000AAC] -dsqlnexus_890117_2

04/08/10 12:50:00.649 [0X00000AAC] -U%s

04/08/10 12:50:00.649 [0X00000AAC] -P**

04/08/10 12:50:00.649 [0X00000AAC] -T18

04/08/10 12:50:00.649 [0X00000AAC] -IE:\SQLDiagOutput\ELMAN__sp_trace.trc

04/08/10 12:50:00.649 [0X00000AAC] -f

04/08/10 12:50:00.649 [0X00000AAC] -oC:\Documents and Settings\behzad\Local Settings\Temp\2\RML

04/08/10 12:50:00.649 [0X00000AAC] -H!PSSDIAG

04/08/10 12:50:00.649 [0X00000AAC] Using language id (LCID): 1024 [English_United States.1252] for character formatting with NLS: 0x00000001 and Defined: 0x00000001

04/08/10 12:50:00.649 [0X00000AAC] <FILTER>

<COLUMN NAME="HOST">

<AND>

<ARGUMENT>

<TYPE>NOT EQUAL<TYPE>

<VALUE>PSSDIAG<VALUE>

</ARGUMENT>

</AND>

</COLUMN>

</FILTER>

04/08/10 12:50:00.649 [0X00000AAC] Attempting to cleanup existing RML files from previous execution

04/08/10 12:50:00.649 [0X00000AAC] Using extended RowsetFastload synchronization

04/08/10 12:50:00.649 [0X00000AAC] Establishing initial database connection:

04/08/10 12:50:00.649 [0X00000AAC] Server: ELMAN

04/08/10 12:50:00.649 [0X00000AAC] Database: sqlnexus_890117_2

04/08/10 12:50:00.649 [0X00000AAC] Authentication: SQL

04/08/10 12:50:00.852 [0X00000AAC] Initial HRESULT: 0x80040E4D

04/08/10 12:50:00.867 [0X00000AAC] 

04/08/10 12:50:00.867 [0X00000AAC] Dumping error record 1 of 1:

04/08/10 12:50:00.867 [0X00000AAC] --------------------------------------------------------------------------

04/08/10 12:50:00.867 [0X00000AAC]    Description       = Login failed for user '%s'.

04/08/10 12:50:00.867 [0X00000AAC]    Source            = Microsoft SQL Native Client

04/08/10 12:50:00.867 [0X00000AAC]    ERRORINFO.hrError = 0x80040e4d

04/08/10 12:50:00.867 [0X00000AAC]    ERRORINFO.dwMinor = 18456

04/08/10 12:50:00.867 [0X00000AAC]    ERRORINFO.clsid   = {85ECAFCC-BDD9-4B03-97A8-FA65CBE3859B}

04/08/10 12:50:00.867 [0X00000AAC]    SQL State         = 28000

04/08/10 12:50:00.867 [0X00000AAC]    Native Error      = 18456

04/08/10 12:50:00.867 [0X00000AAC] Unable to connect to the specified server.

04/08/10 12:50:00.867 [0X00000AAC] ERROR: Performance analysis failed to initialize.  See previous errors and correct the problem before retrying.

04/08/10 12:50:00.867 [0X00000AAC] *******************************************************************************

* ReadTrace encountered one or more ERRORS. An error condition typically      *

* stops processing early and the ReadTrace output may be unusable.            *

* Review the log file for details.                                            *

*******************************************************************************

04/08/10 12:50:00.883 [0X00000AAC] ***** ReadTrace exit code: -9

 

Coordinator
Apr 8, 2010 at 3:38 PM

ReadTrace can be invoked separately by calling the ReadTrace.EXE directly and supplying the required parameters. The credentials that you use to connect to the SQL instance when SQL Nexus is launched is used to import the Profiler Traces into the same SQL instance that you are connected to.

There is a connect button if you are using the latest version of SQL Nexus which will allow you to change the authentication details and the server name that Nexus connects to.

HTH