Destination status could not be resolved. If using a smart-value ensure this resolves to a numeric s

[Hizkeel Khan]

Hi,

I know this questions has been asked and I have read but I wasn't able to find any solution for my problem. 

I have two separate workflows:

• For story, sub-tasks
• For Bugs, Story Bugs (custom field)

Let's say I have a story in Backlog and I have created two bugs and linked them with this story. The automation rule is that all of my bugs moved to In Progress only then the Story will be moved. Here is the screenshot of the automation rule. 


So when I these bugs from backlog to In Progress, My story moves to In Progress but I get an error every time. Attaching the error. 



Please let me know what I am doing wrong here. Thanks.
@Trudy Claspill 

[Alexey Matveev]

Hello,

You should have a look at the log in the SQL Server side. But my guess is that SQL Server wants Windows authentication, but you connect with sql server authentication mode.

[Test ifp test]

Hi,

thanks for reply.

I tried both Options in my SQL Server Windows authentification and mixed mode with both SQL and Windows. same Problem

where i can find These logs on SQL Server?

[Test ifp test]

He,

fixed the problem. the port was blocked from another sql instance.