Cannot connect to SQL to edit, but package runs fine

  • 4Views
  • Last Post 2 weeks ago
0
votes
Summit PCB DB Integration posted this 3 weeks ago

I have packages on a daily import cycle.  The package runs with no errors and imports data to my SQL Server correctly.   However, when I try to edit the package I get an error that "error occurred while establishing a connection to SQL Server".  Same error if I try to edit or test the connection.  Same error if I try to create a new connection.  Is there anything more descriptive that might help diagnose why running the pagacke succeeds but trying to edit fails?  pictures below.  Thanks!

 

pic1pic 2

 

 

Order By: Standard | Newest | Votes
0
votes
Summit PCB DB Integration posted this 3 weeks ago

 

Doh.  Didn't have the new SkyVIa IP address whitelisted.  The running of a package must use the old one (which we had whitelisted) and the editing of a package must use the new one.  All good now.

 

0
votes
Mariia Zaharova posted this 2 weeks ago

Hello!

 

Thank you for contacting our Skyvia Team!

 

Glad to see that the issue is resolved.

 

Best regards,

Mariia

Close