Setting Up TFS Server outside of a domain

Im trying to set up TFS 2010 on a machine that is connected to a network, but not on the domain. I am trying to connect this to a SQL Server that is also connected to the network and also not on the domain. When I run through the TFS configuration Wizard and try to connect to the SQL Server, it fails with a message "A connection can not be made...." which looks like it cant see the Server. However when i connect through SQL Management Studio it works when i use SQL Authentication (not Windows Auth). I beleive its fa开发者_StackOverflowiling because TFS needs to connect using Windows Authetication (please correct me if im wrong). I can not add the Windows Authentication for my TFS machine onto the SQL machine becuase they are on different domains (again, pleas correct me if I'm wrong).

Does anyone have any suggestions?

Thanks.

I don't know if it's possible but have you tried duplicate local users for both TFS and SQL Server's Windows Authentication? I'm not entirely sure if this works or is even possible, but this may give you a setup where Windows Authentication is still used but without a domain. The main problem with this is that it's a maintenance PITA since you have to independently keep the two (or more) accounts in sync with each other (meaning username and passwords).

It's just a thought if adding the servers to a domain is completely impossible.

Would it be possible to enrol the server(s) onto the domain? Is there a reason they aren't already? It may be because TFS is trying to a use a named pipes connection rather than TCP which may be the cause