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

Michael George george@idealso.com
Wed, 16 Feb 2005 16:13:44 -0500 (EST)

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