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

Status : 

 


2
0
Sign in
to vote
ID 795238 Comments
Status Active 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 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