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.

[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....