views:

1015

answers:

2

I really want to use SQL-server from a C#/.NET appliaction without using SQL-Server accounts or adding the affected computer to the same domain or to any domain at all or to use the same logon-name as the domain.

Isn't there any way? Did someone try to do this using the MONO implementation of SSPI?

A: 

Have you considered using impersonation in the application ?

u07ch
YES! I have! I tried the sample code from http://support.microsoft.com/kb/306158/en-us (The last long one with interop: "Impersonate a Specific User in Code") on my mobile computer and put some sqlconnection/sqlreader code inside. But it failed because my computer cannot simply impersonate some domain account. That domain account needs to be logged on! And that's not possible on my computer because it has no connection to the domain
Christian
+1  A: 

To rephrase your question, you want to use domain authentication without domains.

No, that's not possible.

You can set them each up on domains and use trusts between the domains, or you can use SQL authentication.

Brent Ozar
I still think it were possible if one wrote his own TDS-client and NTLM authentication. It might work with the mono-projekts code
Christian