Connection string - Trusted_Connection=Yes

[tony wong]

My asp application works well when i set up a default user for the asp
application.

i wish to integrate user with SQL server by using "Trusted_Connection=Yes"

it works well within the domain workstations (within LAN)

however some workstations (workgroup) are out of the domain, such as remote
workstations by VPN.

i try to add domain login details at those remote workstations but still
fails.

how can i do? Thanks.

tony

 

[Bob Barrows [MVP]]

My asp application works well when i set up a default user for the asp
application.

i wish to integrate user with SQL server by using
"Trusted_Connection=Yes"

it works well within the domain workstations (within LAN)

however some workstations (workgroup) are out of the domain, such as
remote workstations by VPN.

i try to add domain login details at those remote workstations but
still fails.

how can i do? Thanks.

AFAIK, it cannot be done. Trusted credentials have to come from within
the domain

 

[Anthony Jones]

My asp application works well when i set up a default user for the asp
application.

i wish to integrate user with SQL server by using "Trusted_Connection=Yes"

it works well within the domain workstations (within LAN)

however some workstations (workgroup) are out of the domain, such as remote
workstations by VPN.

i try to add domain login details at those remote workstations but still
fails.

how can i do? Thanks.

I'm not sure that I see the problem. If you want connections to the SQL
server to use the user credentials you would have turned off anonymous
access and turned on Windows integrated access.

The out of domain workstations should popup a domain logon dialog when an
attempt is made to access these pages.