I have two VDIs with the exact same version of SSMS installed. On one, I can log into the standalone Integration Service of a remote server running SQL Server 2017, on the other I cannot. SSMS Error message

Every single other online result is not helpful, the usual culprit is not having the right version of SSMS or permissions set up on the remote server but that is not the case here. I also can't just use SSISDB because I need to grab packages from the Integration service itself, and also I want to make sure this error doesn't mean there's general problems with the VDI's setup.

The ONLY difference between the two copies of SSMS are the version of the Microsoft Data Access component and the OS Version.

If Anyone's encountered this specific case where a working Integration Service that can be connected to without issues won't work on a new machine please share what was wrong. Apparently the Firewall settings on the new VDI are correct but I'm not so sure myself. I don't have access to change them however.

  • 1
    No insight from me on using the Integration Services management nodule but there's nothing that UI does that you can't do with the command line dtutil – billinkc Nov 20 at 3:03
  • So both VDIs are trying to connect to the same single SSIS server, one can connect but the other can't? – J.D. Nov 20 at 4:23
  • Yep, it's very annoying. I Can work around it to get access to what I need, but I'd rather fix the core problem. – Baxter Nov 20 at 5:15

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.