GD Bloggers

This is the blog site for Microsoft Global Delivery Communities focused in sharing the technical knowledge about devices, apps and cloud.
Follow Us On Twitter! Subscribe To Our Blog! Contact Us

Error after SQL Server 2012 installation: Login Failure for "SQL Server Integration Services 11.0" SSIS service

Error after SQL Server 2012 installation: Login Failure for "SQL Server Integration Services 11.0" SSIS service

  • Comments 3
  • Likes

When you install SQL Server 2012 and you try to connect to SSIS services, you cannot due to that the SSIS service not running. When you manually try to start the SSIS service the service may fail due to login failure of the service account.

By Default, SQL Server 2012 tries to use and create the account: "NT Service\MsDtsServer110" to start the "SQL Server Integration Services 11.0". If the user running the setup does not have enough permissions to create accounts and set the proper permissions so, this account will not be able to start the SSIS Service. This can be due to domain policy in quite large environments.

A simple resolution is to change the service account of the "SQL Server Integration Services 11.0" service to use the "Network Service" account.

 

Comments
  • of great help.thanks

  • Thanks a lot. But is it ok to set network service ? What is the impact in Production system ?

  • Ok I tried this, but it didn't resolve anything.

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment