Skip to main content

SQL Server connections not disconnecting after batchjob

  • October 28, 2014
  • 0 replies
  • 0 views

Problem:
When running batch programs that call the SQL Server connection under Enterprise server, the connection are established but when the job finishes why the connections are not being released? The connections are staying live according to the SQL Server Profiler.
Resolution:
Adding SQL(INIT=PROT) directive to the starting program resolved the SQL disconnect problem.

Incident# 2792915


#Server
#EnterpriseServer
#Enterprise

0 replies

Be the first to reply!