July 16, 2013 at 8:31 am
what are the difference between configuring the accounts as network and local accounts while installing sql ?
July 16, 2013 at 8:44 am
local accounts will not be able to communicate across the network, i.e to file shares or other SQL server instances (for instance for mirroring or log shipping purposes)
---------------------------------------------------------------------
July 16, 2013 at 9:01 am
Another difference is that SQL logins tied to Windows accounts also require the Windows account to be active in order to login - another layer of security. I prefer the Windows accounts because you also know exactly who it belongs to. Since the authentication uses NT challenge/response, there's no password required logging in to SQL. With SQL logins, the users/developers/etc. can (and, sadly, do) share passwords.
My clear preference is to have SQL logins tied to Windows accounts except for logins used by applications.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply