Re: Windows Authentication problem

From: Ran (ralmog@nyc.rr.com)
Date: 02/19/03 

From: "Ran" <ralmog@nyc.rr.com>
Date: Tue, 18 Feb 2003 20:01:07 -0500

I just had to add ASPNET user to sql database security!

"Ran" <ralmog@nyc.rr.com> wrote in message
news:#$u39D71CHA.2644@TK2MSFTNGP11.phx.gbl...
> Hi
> I'm using Ms Sql2k mixed authentication.
> When trying to make connection to data base with:
> Dim sqlConn As New SqlConnection("Server=localhost; Database=pubs;
> Trusted_Connection=yes;")
>
> sqlConn.Open()
>
> I get login failed for user 'servername\aspnet'
>
> I'm sure that my NT user is exists and works, after I checked it from the
> client tool sql query analayzer.
>
> Any ideas?
>
> Thanks a lot
>
> Ran
>
>