Re: Problem with SQL Server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: David W. Simmonds (david_at_simmonds.ca)
Date: 02/05/04 

Date: Thu, 05 Feb 2004 16:54:10 GMT

I am running the SQL Profiler on the machine that is running SQL Server. I
am running an ASP.NET form from a webpage in a browser on another machine.

The Filters are set as default and are like you suggest. The Application
Name is empty. I added Audit Login Failed Filter. It says:

NTUserName is NETWORK SERVICE
LoginName is NT AUTHORITY\NETWORK SERVICE

I've attached the trace.

I still cannot connect.

"Kevin Yu [MSFT]" <v-kevy@online.microsoft.com> wrote in message
news:AtfYRu76DHA.3496@cpmsftngxa07.phx.gbl...
> Hi David
>
> Since you got nothing from the SQL trace, there might be something wrong
> with the Trace Properties. When you are creating a new trace, before Click
> the Run button, please check the Events tab and Filters tab. Make sure
that
> Security Audit / Audit Login and Audit Logout has been added to the right
> tree view in Events tab. And ApplicationName/ Like property has not been
> set. So that the profiler can trace the actions performed by your
> application.
>
> If you are working in a domain environment, please also try to impersonate
> a domain user which is the administrator of both the web server and SQL
> server. Generally, this will work in most cases. If the problem still
> persists, would you please paste the trace log here?
>
> If anything is unclear, please feel free to reply to the post.
>
> Kevin Yu
> =======
> "This posting is provided "AS IS" with no warranties, and confers no
> rights."
>

begin 666 Test.trc
M^ (`", `````````&P`!``H`!@`+`!(`$ `1``T`"0`,``X`````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````````````````````````````````````````````````
M````````````````&@`"``#T_P(``/W_! $```#\_SX,``H`0GX'" `````,
M`$)^!P@`````#@!"?@<(``````\`0GX'" `````1`$)^!P@`````% !"?@<(
M`````/O_( H```<:`%,`40!,`" `4 !R`&\`9@!I`&P`90!R````]O\$```"
M``X`$-0'`@`$``4`"0`S``$`/ `;``0`````]O\$% `(``$`;$P`;P!G`&D`
M;@`@`&8`80!I`&P`90!D`" `9@!O`'(`( !U`',`90!R`" `)P!.`%0`( !!
M`%4`5 !(`$\`4@!)`%0`60!<`$X`10!4`%<`3P!2`$L`( !3`$4`4@!6`$D`
M0P!%`"<`+@````8`($X`10!4`%<`3P!2`$L`( !3`$4`4@!6`$D`0P!%````
M"0`$``````H`.BX`3@!E`'0`( !3`'$`; !#`&P`:0!E`&X`= `@`$0`80!T
M`&$`( !0`'(`;P!V`&D`9 !E`'(````+`#I.`%0`( !!`%4`5 !(`$\`4@!)
M`%0`60!<`$X`10!4`%<`3P!2`$L`( !3`$4`4@!6`$D`0P!%````# `$- ``
I``X`$-0'`@`$``4`"0`S``@`'@`;``04````]O\$!0`!`!L`! 4`````
`
end

Quantcast