rick
asked on
Error logging in from SSIS (But NOT SSMS)
A new database was set up, to which I have access. Only 2 tables and neither has data.
I can login from SQL Server Management Studio.
However, I get the following error when I test a connection from SSIS:
"Test connection failed because of an error in initializing provider. Logon failed for login (blah) due to trigger execution"
I've done the Google searches, but can't find anything specific.
I can login from SQL Server Management Studio.
However, I get the following error when I test a connection from SSIS:
"Test connection failed because of an error in initializing provider. Logon failed for login (blah) due to trigger execution"
I've done the Google searches, but can't find anything specific.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry - may be later today before I can check things out.
Thanks for the comments. Appreciate it.
Stay tuned...
Thanks for the comments. Appreciate it.
Stay tuned...
Rick, a feedback will be appreciated.
Cheers
Cheers
ASKER
Guys...i am so sorry about leaving this question out so long. Our warehouse went down, and I was pulled on to another project.
Regards Marten
Written on my phone, read with fantasy.