home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.ms-sqlserver      Notorious Rube Goldberg contraption      19,505 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 18,515 of 19,505   
   Erland Sommarskog to Tony   
   Re: about Windows authentication   
   23 Nov 11 11:31:09   
   
   From: esquel@sommarskog.se   
      
   Tony (johansson.andersson@telia.com) writes:   
   > Now to my question When was these two accounts created because I have   
   > not added these two ? I assume that these two was automatically added   
   > when I installed SQL Server ? Is that correct understood ?   
      
   When you ran the Setup wizard, you were prompted to add a user to be   
   sysadmin, and there was a button Add Current User, and that answers your   
   question.   
      
   Although, it does not really stop there. Say that you would add a new   
   Windows user on your machine and log into Windows with this user. I would   
   expect that this new user would be able to connect to at least the Express   
   instance. This is because with Express, Setup automatically add the group   
   BUILTIN\Users to SQL Server. (I don't think this happens with Standard.)   
      
   More generally, you can get access to an SQL Server instance, solely by   
   being member of a Windows group. This is useful in bigger corporations,   
   since this permits an administrator to give a new employee access to a   
   number of resources - file shares, printers, databases etc - by a single   
   addition to the Active Directory.   
      
   --   
   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)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca