Re: Problem with SQL Server [Solution]

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

Date: Thu, 05 Feb 2004 21:16:52 GMT

Apparently my sql server was not set to mixed mode authentication. Once I
set it to that mode, I can now supply a UID and PWD to the connect string
and all works fine.

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