Re: SQL Profiler - Empty NTUserName

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ravi M (anonymous_at_discussions.microsoft.com)
Date: 06/04/04 

Date: Fri, 4 Jun 2004 02:15:16 -0700

Dear Mr.Vinod,
Thanx for your quick response.
The LoginName in my application is a SQL Server username.
It gets displayed properly in the Trace. Only the
NTUserName is missing.
We havent made any change to our application since we
migrated to the new server machine with SQL2K. And as i
said, the Trace file in our previous server with SQL7.0
was showing the NTUserName.
Any other ideas ?

Reg,
Ravi M
>-----Original Message-----
>This is not the expected behaviour. In my environment
with SQL Server 2000 +
>SP3. All the NT Authentication connections have the
NTUserName and LoginName
>correctly. Check if the LoginName in your application has
a SQL Server
>username. It might probally the reason ... I cant think
of anything wrong
>here apart from that.
>
>--
>HTH,
>Vinod Kumar
>MCSE, DBA, MCAD, MCSD
>http://www.extremeexperts.com
>
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techinfo/productdoc/2000/book
s.asp
>
>
>"Ravi M" <anonymous@discussions.microsoft.com> wrote in
message
>news:D3B491E9-6AAA-4D03-860D-D0DF8F7E7531@microsoft.com...
>> Recently we migrated our application from SQL7.0 to SQL
2000 and a new
>Server machine. Since then, the NTUserName datacolumn in
the trace files is
>always EMPTY if the value of "ApplicationName" datacolumn
is "Microsoft(R)
>Windows (R) 2000 Operating System". Can anyone please
suggest me what might
>be wrong.
>
>
>.
>

Relevant Pages

  • Re: SQL Profiler - Empty NTUserName
    ... NTUserName is the NT Autentication ie Windows Authentication Username. ... Server Authentication connections. ... Books Online for SQL Server SP3 at ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Profiler - Empty NTUserName
    ... and all the 2000 Pro clients have nt username, but only one of the XP users ... > NTUserName is the NT Autentication ie Windows Authentication Username. ... > the case on SQL Server 7.0. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL Profiler - Empty NTUserName
    ... All the NT Authentication connections have the NTUserName and LoginName ... Check if the LoginName in your application has a SQL Server ... Books Online for SQL Server SP3 at ...
    (microsoft.public.sqlserver.tools)
  • Re: One Web Service updates SQL, another cant?
    ... section of the Trace Properties dialog. ... And then I start getting the database closed errors on subsequent calls. ... > The error suggests that somehow the connection to SQL Server is being ... Could we have a look at your connection string? ...
    (microsoft.public.sqlserver.security)
  • Re: Track deadlocks and locks that take too long
    ... I looked at the trace definition in your example code and it had the value 2 which means just that. ... Tibor Karaszi, SQL Server MVP ... As long as you tell it to on the General page of the profiler. ... declare @TraceID int ...
    (microsoft.public.sqlserver.programming)