ebc4cf98   
   From: esquel@sommarskog.se   
      
   Justin (kfwolf@hotmail.com) writes:   
   > We are using SQL Server 2008.   
   >   
   > As an administrator on the box (part of the admin group), I assumed I   
   > could use Windows authentication to log into sql server.   
   >   
   > However, it is giving me a login failure.   
   >   
   > #1) How can I verify that sql server is set up to use windows   
   > authentication?   
      
   It is. You cannot disable Windows authentication.   
      
   > #3) Can I assume that the admin group has the rights to login into SQL   
   > Server   
      
   No. Up to SQL 2005, the group BUILTIN\Administrators was by default   
   added when the server was installed, and you had to drop it, if you   
   did not want it.   
      
   Starting with SQL 2008, BUILTIN\Administrators is no longer added by   
   default, but when you install SQL 2008, you have to specify an account   
   that is to have sysadmin rights on the server.   
      
   > What group would a user need to be in to be able to have the ability to   
   > authenticate on the sql server (through enterprise manager).   
      
   Primarily you should ask the person who installed SQL Server which   
   user/group he specified.   
      
      
      
   --   
   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)