SSIS Service Account cannot use a Virtual Account - by Ed Vassie

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 795238 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 7/29/2013 1:44:53 AM
Access Restriction Public


When installing SQL2014, virtual accounts can be specified for most services.  However, SSIS does not allow a virtual account (eg NT SERVICE\MSDtsServer110), and gives an error saying the password is missing.

SSIS will accept the Network Service account (NT AUTHORITY\NetworkService) without requiring a password, and should also accept a virtual account.

Detail_GlobalRules.txt file showing install process and error given will be attached.
Sign in to post a comment.
Posted by Microsoft on 6/1/2016 at 7:56 PM
This is expected, you can only use NT Service\MsDtsServer120 for SSIS 2014 service.
Posted by Steve Murawski on 12/18/2013 at 12:42 PM
It installs fine with NT SERVICE\MSDtsServer120, but will error with NT SERVICE\MSDtsServer110.