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.


2
0
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

Description

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 Yide [MSFT] 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.

Steve