I try to mimic a video demo to set a new connection manager in SSIS, using the sa account.
Problem:
1. I enabled the sa account usin the code below:
ALTER LOGIN [sa] ENABLE
GO
2. OK in SSMS, but not working in SSIS
3. I created a new SQL login in SSMS, and changed from Windows to Mixed
4. Login as the new SQL login, still failed
5. Pipename, TCI-IP, shared all are enabled
Solution:
Restarting the SQL Server service.