[Mono-list] different behavior between .NET and Mono

[Michael George]

On Wed, February 16, 2005 5:00 pm, Dan Maltes said:
> You can use the user account in sql that already there for access to
that
> database, that's fine.  However, the connection must authenticate you by
sending the username and password, whereas with windows authentication,
your
> logged in windows user credentials would be sent automatically, and the
matched against a sql user, which is what cannot happen on mono.  So,
yes,
> your connection string could be altered to pass the sql user name and
password.

I have added a new user and I'm using it from the .NET code and the Mono
code.

Watching the MS-SQL profiler, I can see that both .NET and Mono are using
the SqlClient (ApplicationName column).  The .NET event classes are all
RPC: Completed  and the Mono event classes are SQL:BatchCompleted.  The
issued commands are similar but not identical (.NET has more spaces in the
command and Mono prefixes "SelectReferenceTables" with "dbo.").

Before the SQL batch completed line which is indicated on my browser
screen as the statement which threw the exception is an "Audit Login"
message.

I don't have any indications of errors in the Profiler log...

Is this possibly a bug in Mono?

> -----Original Message-----
> From: mono-list-admin@lists.ximian.com
> [mailto:mono-list-admin@lists.ximian.com] On Behalf Of Michael George
Sent: Wednesday, February 16, 2005 4:14 PM
> To: Dan Maltes
> Cc: 'Michael George'; 'A Rafael D Teixeira'; 'MonoList'
> Subject: RE: [Mono-list] different behavior between .NET and Mono
>
> On Wed, February 16, 2005 3:35 pm, Dan Maltes said:
>> Correct.  And you will need to a create sql user(s) that have access to
that database.  Then, the client app must use sql login instead of
windows authentication.
>
> I'm not a pro at MS-SQL, though I'm kinda learning my way around...
>
> So there's a difference between an SQL user and a Windows users?  I have
2
> users: Xuser with no Login Name and Permit DB access, and dbo with a
Login
> Name of Xuser and Permit DB access.  Looking at either users'
properties,
> I
> don't see how to know which type of user they are.
>
> As for the type of login, I'm guessing that will be part of the options
to
> the connection call rather than the connection string?  I don't see
anything
> that indicates the type of connection in the connection string...
>
> However, since the SQL logging output indicates SQL commands being
received,
> it seems that it already knows to use an SQL connection.
>
> Thank you very much!
>
>> From: mono-list-admin@lists.ximian.com
>> [mailto:mono-list-admin@lists.ximian.com] On Behalf Of Michael George
Sent: Wednesday, February 16, 2005 3:19 PM
>> To: A Rafael D Teixeira
>> Cc: Michael George; MonoList
>> Subject: Re: [Mono-list] different behavior between .NET and Mono On
Wed, February 16, 2005 2:42 pm, A Rafael D Teixeira said:
>>> AFAIK, our ADO.NET provider for SQLServer (it is part of Mono) only
can connect with SQL password, as the other protocol is a closed one
that ties with ActiveDirectory and/or NT Domain Controllers.
>>> Configure your database server to accept SQL connections, otherwise we
can't connect to it.
>> Looking at the properties for my database, the Security tab, under
Authentication I have "SQL Server and Windows" set.  I think that's
what you're saying to do, right?
>> -Michael George
>>  Ideal Solution, LLC
>> _______________________________________________
>> Mono-list maillist  -  Mono-list@lists.ximian.com
>> http://lists.ximian.com/mailman/listinfo/mono-list
>
>
> -Michael George
>  Ideal Solution, LLC
>
> _______________________________________________
> Mono-list maillist  -  Mono-list@lists.ximian.com
> http://lists.ximian.com/mailman/listinfo/mono-list
>
>


-Michael George
 Ideal Solution, LLC