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,516 of 19,505   
   Tony to All   
   Re: about Windows authentication   
   23 Nov 11 12:56:42   
   
   From: johansson.andersson@telia.com   
      
   "Erland Sommarskog"  skrev i meddelandet   
   news:Xns9FA67F5A617A7Yazorman@127.0.0.1...   
   > 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   
      
   Good explained!   
      
   //Tony   
      
   --- 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