title: IIB9 Message Flow Unable To Reconnect To SQL Server After Database Restart
body: <p>I am using <code>IIB 9.0.0.2</code>, in which I have created a message flow which is connecting to the SQL server Database (version 2012) to insert records in the tables.
  The code is written to interact with DB every 1 min.</p>
  
  <p>In case when the Database goes down, the broker is throwing the below error (which is as expected), but when the db comes up, it still throws the same error, instead of connecting back, until I restart the flow.</p>
  
  <blockquote>
    <p>Root SQL exception -1 /opt/ibm/IE02/2.0.1/lib/libodbcinterface.so
    Child SQL exception 16006 6005 [unixODBC][IBM][ODBC SQL Server Legacy
    Driver][SQL Server]SHUTDOWN is in progress.[/b] [13:35] 
    opt/ibm/IE02/2.0.1/lib/libodbcinterface.so Child SQL exception 20119
    [unixODBC][IBM][ODBC SQL Server Legacy Driver]20119[/b]</p>
  </blockquote>
  
  <p>Please suggest any configuration which I have to do at the flow/connection manager/server level to make the flow reconnect back after SQL server DB restart.</p>