Let me reboot my question on SQL Server virtual accounts permissions

The (same) MSDN article on the same version 2012 of SQL Server "Configure Windows Service Accounts and Permissions" states:

If "virtual accounts cannot be authenticated to a remote location" then why:

  • to use permissions of of a machine account and
  • in the the format of domain account?

The same article, in "New Account Types Available with Windows 7 and Windows Server 2008 R2" section contains:

  • " Virtual Accounts

    Virtual accounts in Windows Server 2008 R2 and Windows 7 are managed local accounts that provide the following features to simplify service administration. The virtual account is auto-managed, and the virtual account can access the network in a domain environment. If the default value is used for the service accounts during SQL Server setup on Windows Server 2008 R2 or Windows 7, a virtual account using the instance name as the service name is used, in the format NT SERVICE\<SERVICENAME>. Services that run as virtual accounts access network resources by using the credentials of the computer account in the format <domain_name>\<computer_name>$"

How should I better understand accessing the network without authentication ?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.