SQLClient, SSPI, Username and Password!

I cannot believe that I just now discovered that you can have a connection string from a PPC to a "network" SQL 2000 that uses

SSPI

with a USERNAME and PASSWORD...

And that it actually does WINDOWS AUTHENTICATION with this un/pw!!!!!!!

I just died and went to heaven!

Confirmation that this does in fact work!

http://msdn2.microsoft.com/en-us/lib...3(SQL.80).aspx

This is so great - PPC with windows authentication.

And I can use the PASSWORD that's entered on the PPC by the user to not only make the network SQL connection but also to encrypt the SQL CE database on the pocket pc!