Connect pocket pc (2003) to sql sever in trusted/integrated/sspi

[Guest]

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!

 

[Ilya Tumanov [MS]]

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

 

[Guest]

I think i have alrealy try that...
but i will test it again. as i remember i think i had an error of the type
"Login failed for user '(null)'."
when SSPI is specified and "invalid login" when not SSPI is not specified
(witch is what i was expecting... in that case since no user "domain\user"
exist in sql)

I will post my result tomorrow
Thanks for the answers

 

[Guest]

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