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

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.

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

上一篇:PS将偏暗的童星照片打造出怀旧风格效果


下一篇:PHP开发者常犯的10个MySQL错误