Posted by pb648174 on 01/17/07 12:09

As long as the username and password used is the same on both machines
it will work. So for a web app you make an IUSR account with the same
username and pass on the database server and give that IUSR account
access to the DB you are using and it works great.

Jonathan Wiggs wrote:
> Good afternoon,
>
> so here is a question I've been struggling with that I thought folks on
> the forum might have some wisdom kicking around on. I have several
> production servers that are living within a workgroup where there is no
> domain controler. However, I would still like to set up trusted
> security for my asp.net applications. IIS is living on one server, and
> SQL server on another. Is there a way I can add a trusted relationship
> to the machine and account that the IIS app is running under?
>
> My thanks in advance!
> Jonathan Wiggs
>
> *** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: Domain logins to a SQL 2005 Server User Rights Assignment
• Prev in forum: Re: NVARCHAR Search Problem using LIKE
• Thread view: Re: Trusted Security in a Workgroup

[Reply to this message]