From: esquel@sommarskog.se   
      
   jh (NIE_SPAMUJ_jh@radio.kielce.pl) writes:   
   > Just to be sure: Is it possible to login from a _remote_ machine to SQL   
   > Server using Trusted Connection _without_ a Active Directory account?   
   >   
   > The story... I have a workgroup build with 3 PCs only. The first PC has   
   > installed SQL Server 2008 Express. I need to connect from other PCs with   
   > Trusted Connection. The message I get when connecting is: The login is   
   > from an untrusted domain and cannot be used with Windows authentication.   
   > Any chance to login (windows authentication) without a domain   
   > controller?   
      
   Yes, it is possible to do Windows authentication in a workgroup, but it   
   can be a battle.   
      
   To start with, you must have the same login and password on both machines.   
   There is also a Group Policy setting that needs to be set to Classic.   
      
   But I have never seen the error message you quote. The group-policy   
   setting eluded me for a long time, but I only got the message "is not   
   associated with a trusted connection". Then again, that was not SQL 2008;   
   maybe they have updated the error message.   
      
      
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Links for SQL Server Books Online:   
   SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx   
   SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx   
   SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)