Home Dashboard Directory Help
Search

SSIS Service Account cannot use a Virtual Account by Ed Vassie


Status: 

Active


2
0
Sign in
to vote
Type: Bug
ID: 795238
Opened: 7/29/2013 1:44:53 AM
Access Restriction: Public
1
Workaround(s)
view
1
User(s) can reproduce this bug

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.
Details
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
Sign in to post a workaround.
Posted by Steve Murawski on 12/18/2013 at 12:42 PM
Use NT SERVICE\MSDtsServer120
File Name Submitted By Submitted On File Size  
Detail_GlobalRules.txt 7/29/2013 68 KB