Hi @Alok Kr Gupta ,

Seems you have done all possible troubleshooting for ms sql, SMO 2.0 or above has to be installed on mid server. 
what error are you getting ? Or mssql pattern itself are not getting triggered? If that so check the port number on which sql installed and ask network team to open it if it is blocked.

Accept the solution if it helped.