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

[Dan Maltes]

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.

-Dan

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