Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

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...

share|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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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