Connection string - Trusted_Connection=Yes

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

Re: Connection string - Trusted_Connection=Yes

tony wong wrote:
> 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
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.

Re: Connection string - Trusted_Connection=Yes

"tony wong" wrote in message
news:uYAQeAi9HHA.4180@TK2MSFTNGP05.phx.gbl...
> 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.

--
Anthony Jones - MVP ASP/ASP.NET