when refreshing report the database connection stays open causing multiple open connections

[ataft]

I have setup a SQL Server database connection using the enterprise data gateway. The connection is good and refreshes the data just fine.

The problem is that each time a refresh happens, scheduled once a day, the database connection stays open on the database. There were 12 open connections before we noticed a problem with the db and had to restart the database to clear all of those connections.

Anyone know of a solution?

thanks

adam

[v-shex-msft]

HI @ataft,

What version of enterprise gateway you used? AFAIK, it only open one active session to handle refresh operation even if refresh operation triggered many times.

Regards,

Xiaoxin Sheng

[ataft]

14.16.6745.2

[v-shex-msft]

Hi @ataft,

Can you please use SQL Server Profiler to trace more detailed information and share here to help us clarify your scenario?

SQL Server Profiler

Regards,

Xiaoxin Sheng

[ataft · Accepted solution]

Thanks for asking questions on this issue! This must have been an anomoly of some kind. I have not been able to reproduce the problem. The past few days I've done everything to try to cause the problem and it doesn't happen.