Post reply

Help with Named Instance using Virtual Account to access filesystem

  • January 29, 2014 at 11:15 am

    #303842

    I decided during SQL 2012 install to use the new virtual account for the service accounts for SQL Server and SQL Server Agent. Now I am having trouble getting a SQL Agent job to execute the xp_dirtree command on a network shared file folder. I see some MSDN documentation telling me that a virtual account uses an account name built as <domainName>\<computerName>$ but this is not working for me. The SQL Server is a named instance and that may be my issue. Can anyone shed any light on what account would be attempting to read the network share?

  • February 3, 2014 at 12:42 pm

    #1685614

    This article explains the virtual accounts

    http://msdn.microsoft.com/en-us/library/ms143504.aspx

    It recommends using MSA (Managed Service Accounts), with specific privileges.

    As per paragraph "Windows Privileges and Rights", you should use the "NT Service\SQLAGENT$InstanceName" for the Agent and "NT Service\MSSQL$<InstanceName>" for SQL Server.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply