This error appears while setuping sql server integration service

2022-10-27T15:11:09.007+00:00

please close the following processes before continuing the setup:

devenv (14136)
ServiceHub.SettingHost (14596)
ServiceHub.VSDetouredHost (13884)
ServiceHub.Host.CLR.x86 (14856)
ServiceHub.IdentityHost (14212)
Microsoft.ServiceHub.Controller (14672)

my sql server version is 2017
my visual studio version is 2019
the needed version of ssis is 4.2

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,704 questions
SQL Server | Other
{count} votes

7 answers

Sort by: Most helpful
  1. Mark Westerweel 15 Reputation points
    2023-03-30T12:23:23.2066667+00:00

    Probably just close the Visual Studio program. This is what keeps these processes running. Your SQL server integration installation will do.

    3 people found this answer helpful.

  2. PandaPan-MSFT 1,931 Reputation points
    2022-10-28T02:12:56.433+00:00

    Hi @عمار احمد ابراهيم سالم ,
    I'm really agree with others that you need to provide more information. But so far, according to the error information you had provided, so.....did you try killing the program that mentioned?

    0 comments No comments

  3. Olaf Helper 47,441 Reputation points
    2022-10-28T05:14:16.37+00:00

    please close the following processes before continuing the setup:

    A clear message, there are some processes runing using some resources like DLL, which the SSIS installer what's to update/replace, which isn't possible while them are in use.
    You can close processes/shutdown the services.

    But even without installation should work, it will only require a server restart to replace/install everything.

    0 comments No comments

  4. ZoeHui-MSFT 41,491 Reputation points
    2022-10-28T06:31:20.307+00:00

    Hi @عمار احمد ابراهيم سالم ,

    Are you installing SSIS project?

    If yes, please close the VS when installing it and use task manager to close the service mentioned in the message.

    If the error still occurs after you end the tasks, try to re-start the machine and then install SSIS project.

    In addition, SSIS Version 3.16 is the latest general availability (GA) version , which does not support target server version SqlServer2022. Download SQL Server Integration Services Projects 3.16.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

  5. Alya Zulfia Amaranggana 0 Reputation points
    2023-01-24T09:21:42.2733333+00:00

    Hi

    To solve that problem as that message, you need to close those programs. If you use Windows, you can find them at

    1. task manager
    2. click details tab
    3. close those programs
    4. finally, you can install SSIS

    Regards,

    Alya

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.