470,596 Members | 1,446 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,596 developers. It's quick & easy.

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
Sep 13 '07 #1
2 5104
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.
Sep 13 '07 #2
"tony wong" <x3*@netvigator.comwrote in message
news:uY**************@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
Sep 14 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Brian Conway | last post: by
1 post views Thread by Jennifer | last post: by
4 posts views Thread by Avon | last post: by
1 post views Thread by Chris | last post: by
1 post views Thread by Aykut Canturk | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.