Nevyn (7/25/2014)
Right, but does it still do that when you pass in the credentials instead of using integrated security?
Hi
In the Connection manager of SSIS, I have the option to Use 'Windows NT Integrated Security' or 'Use a specific user name and password'. I have tried both options and I'll connect successfully. Still when I open an Analysis Processing Task, I get the same Information message 'A connection cannot be made. Ensure that the server is running'.
Regards
Brian Ellul
----------------------------------------------------------------------------------
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -