d6f2bd77   
   From: esquel@sommarskog.se   
      
   Guillaume Filion (gfilion@gmail.com) writes:   
   > The old server is running Windows 2000 Server SP4 Small business   
   > server. It's a domain controller for sracq.intra.   
   >   
   > The new server is running Windows 2008 Server Enterprise SP2. It's a   
   > member of the workgroup SRACQ.   
      
   Thus, if you are logged in as DOMAIN\USER and try to connect to an   
   SQL Server instance which is not part of the domain, I would not expect   
   integrated security to succeed. Overall, integrated security in a workgroup   
   is difficult. The passwords must match. There is also a group-policy setting   
   that must permit it. (I don't remember that setting now.)   
      
   I would suggest that you either join the server to the domain, or that you   
   use SQL Server authentication.   
      
      
   --   
   Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se   
      
   Books Online for SQL Server 2005 at   
   http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx   
   Books Online for SQL Server 2000 at   
   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)