Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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 ?

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.