Re: Connect pocket pc (2003) to sql sever in trusted/integrated/ss

It Work now!

Thanks a lot... the problems wasn't my connection string
it was SQL Server that was running in local system account.
Tp use "Server=YourServerHere,1433;Initial Catalog=YourDataBaseHere;
User ID=YourLoginHere;Password=YourPasswordHere;Integrated Security=SSPI;"

Sql Server MUST be running in a "Domain\user" account.

I don't really know how it's working an why windows desktop can connect
trusted when local system account... but it work well That way and seem
logical ;o)
Thanks for your help


"Ilya Tumanov [MS]" wrote:

Yes, you can as long as password and login are provided in connection
string. Here's connection string sample, note "Integrated Security=SSPI".



"Server=YourServerHere,1433;Initial Catalog=YourDataBaseHere;User
ID=YourLoginHere;Password=YourPasswordHere;Integrated Security=SSPI;"


--
Best regards,

Ilya

This posting is provided "AS IS" with no warranties, and confers no rights.

*** Want to find answers instantly? Here's how... ***

1. Go to
http://groups-beta.google.com/group/microsoft.public.dotnet.framework.compactframework?hl=en
2. Type your question in the text box near "Search this group" button.
3. Hit "Search this group" button.
4. Read answer(s).

"Vincent" <Vincent@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D5EB14B6-8230-4704-B138-AFE61BE93C5E@xxxxxxxxxxxxxxxx
Is it possible to use "windows integrated security" to connect to a sql
server from Pocket PC?

I mean that all windows user have an access to SQL server trought their
windows integrated security.

I have tryed to supply: <domain\user> and password but doesn't seem to
work
I can't find related article that tell that confirm that it work... but
some
mention on it (not clear)

1- Is it possible?
2- What connection string should i use? any example?
3- Is there particular configuration that we need to be aware of?

Currently our code is in c# on compact framework 1.0 SP3
Thanks a lot!





.

Loading