SQL connection error while running workflow
I am getting SQL connection error while running workflow but I can import source and target using same connection
I am new in informatica. I am able to import source and target table from MS SQL server using SQL connection. But when I am create relational connection with same information it is not working, Workflow failed with SQL connection error.
Could someone advise me how I resolve this problem.
Re: SQL connection error while running workflow
[QUOTE=Sandeepb;22833]I am getting SQL connection error while running workflow but I can import source and target using same connection
I am new in informatica. I am able to import source and target table from MS SQL server using SQL connection. But when I am create relational connection with same information it is not working, Workflow failed with SQL connection error.
Could someone advise me how I resolve this problem.[/QUOTE]
Hi Sandeep,
Check out with MS-SQL DBA...
But beofre doing so, try to fix this by resuming the job. Hope this will do the needful...
If your job failing again... then contact your DBA (MS-SQL). One of the reason is due to server down also...
Check out and reply back if you are facing the same....