SQL Server - Login timeout expired error but only on one server
Posted on 2011-05-03
I am trying setup my app on my prod server the way I did on my dev server.
I created an SSIS package on my devserver by using sql server management studio, opening a db, selecting import then using the wizard.
I did the exact same thing on my prod server, using the exact same settings and when I do, I get a Login timeout expired error. I can ping the server I am trying to import from both prod and dev.
Since I can ping both, and the settings are the same, I think that the issue is on my prod server.
I have no idea how to fix this.