Invalid Authorization Specification - running SSIS packages on SQL Server 2022

• winston Smith

  SSCoach

  Points: 19500

  More actions

  July 8, 2024 at 2:53 pm

  #4434148

  Hi!

  Im trying to run an SSIS package on SQL Server 2022. It fails with the error: Invalid Authorization Specification.

  I can run the SSIS package from my local machine & other servers, just not from the SQL Server 2022 Virtual Machine. The Connect String is as follows:

  Integrated Security=SSPI;Persist Security Info=False;Data Source=MyVMName;

  What I have tried:

  • Installing the latest OLE DB Driver 19 on the VM.
  • Specifying the driver in the connection string. again, it works on my local machine but not when running the ssis package from the SQL Server 2022 VM.
  • Running as 32 & 64 bit.
  • Note - connecting from a UDL on the SQL Server 2022 VM, using Microsoft OLEDB provider for SQL Server succeeds.

  None of the above has worked.

  I would appreciate any advice on how to get this working.

  • This topic was modified 4 months, 2 weeks ago by  winston Smith.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  July 9, 2024 at 3:10 pm

  #4434558

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.