Microsoft SQL connection string and Windows Auth.

[usunto_bryjamus]

Hi,

I have application written in C# (in netcf 2) for Symbol device with Win
CE 5.0. This application login to Microsoft SQL server (2000) using SQL
client for mobile. Now I use SQL user and password. My customer has
ActiveDirectory and his stuff has user and password in AD and login to
SQL server from desktop using Windows authentication.

My question is:
Is it possible to create connection string using ActiveDirectory login
and password? I heard that Web aplication use impersonate (method
LogonUser and some more) for this but is it something familiar in netcf
(or P/Invoke)?

 

[Ginny Caughey [MVP]]

You would need to provide the Windows login and password in your SqlClient
connection string using the form DomainName\UserName for the user.