Re: Cross VPN Domain Authentication


"Daniel Jameson" <danjam47@xxxxxxxxxxxxxxxx> wrote in message
news:%23d5h3kFqHHA.196@xxxxxxxxxxxxxxxxxxxxxxx
Hi,

We use a Cisco point-to-point VPN to allow employees to connect to the
corporate network from their remote computers that are not members of the
corporate Active Directory domain.

When VPN connected from my non-domain member computer, I open the Windows'
"Run" dialog box and type the path of a shared folder on the corporate
network. After a brief delay I get the "Connect to <path>" dialog box
that requests a User name and Password that I would like to use to connect
to the share. I provide suitable credentials, and after another brief
delay I am connected to the share, and I can open documents and copy files
to and from the share (as folder permissions allow).

So far, however, when I write .NET desktop applications that use the
SqlConnection class to connect to SQL Server via domain authentication, I
cannot get an application to connect through the VPN*. Is there any way
to get a database application to pop up a "Connect to <SqlInstance>"
dialog box so that users can provide their domain credentials to get a
connection to SQL Server from a computer that is not a domain member? I'm
interested in both the SQL 2000 and SQL 2005 cases.

Try using Run As to execute the app, with the right-click->Run As... menu,
or by creating a shortcut to the EXE and setting the "Run with different
credentials" checkbox (properties->shortcut [tab]->Advanced [button].) The
former is a one-off way to do it; the latter causes a login prompt when the
shortcut is used to run the app.

When prompted, specify domain credentials (in domain\user, or user@domain
format) for the impersonation context. If that works, a Win32 app could
call LoginAsUser to internally provide a seamless login facility... not sure
what the .net equivilent is -- but if the Run As login prompt is adequate,
it's a moot point.


-Mark



* I get "Login failed for user ''. The user is not associated with a
trusted SQL Server connection..."

--
Thank you,

Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org







.

Quantcast