Execution Timeout Expired Error while executing an SQL query

Following error comes while executing an SQL query. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. This happens after 30 seconds, even though I have set the Command Timeout property to 300 seconds. Here’s what I’ve already verified: The connection is working fine. I've checked the remote query timeout, and it's set to 0 (unlimited). There are no packet drops or network issues. The query is optimized, properly indexed, and runs in seconds directly on SQL Server. There are no deadlocks, blocking processes, or transactions affecting the command. Connection pooling is not in use, and SQL logs show no issues. Any suggestions or insights on what could be causing this issue would be greatly appreciated!