up vote 0 down vote favorite
share [g+] share [fb]

How can I setup windows authentication between a Windows Server 2003 running IIS6 and Windows Server 2008 running SQL Server 2008, when both servers are standalone non-domain servers.

I want the sites on my 2003 server to connect to the databases on the 2008 server, but I don't want to store credentials in the connection strings.

link|improve this question
35% accept rate
feedback

1 Answer

up vote 3 down vote

Rather simple, create two accounts that are identical on both machines (same username/password). Set the app pool identity to that user and bam you have integrated authentication. That is all...

link|improve this answer
1  
Ok, just wanted to make sure I wasn't missing anything. Now go answer this questions: serverfault.com/questions/68748 – Ronnie Overby Sep 25 '09 at 17:28
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.