Bonjour à tous,
J'utilise un travail de SQL Server faisant appel à un package de SSIS .
En cas d'exécution, ce travail émet un message d'erreur indiquant que la connexion au SSIS est refusée .
.Message
Executed as user: NT Service\SQLSERVERAGENT. Microsoft (R) SQL Server Execute Package Utility Version 12.0.2000.8 for 64-bit Copyright (C) Microsoft Corporation. All rights reserved. Started: 11:36:17 Could not load package "\MSDB\mypackage" because of error 0xC00160AE. Description: Connecting to the Integration Services service on the computer "NAME" failed with the following error: "Accès refusé." By default, only administrators have access to the Integration Services service. On Windows Vista and later, the process must be running with administrative privileges in order to connect to the Integration Services service. See the help topic for information on how to configure access to the service. Source: Started: 11:36:17 Finished: 11:36:17 Elapsed: 0.016 seconds. The package could not be loaded. The step failed.
Comment puis-je résoudre ce problème ?
J'utilise SQL Server 2014 Standard et Windows Server 2012 R2 Standard.
Cordialement.
Partager