SQL Server Report Builder ver. 3 Automatically Disconnects from Server Every Hour

Hello Experts,
Today was my first of a 3 day training for Microsoft SQL Server Reporting. Every hour, the Report Builder would automatically disconnect from the Server and everyone in the class needed to click, 'disconnect' and then 'connect' to re-establish the connection. Do you know what is causing the program to disconnect? And where we can we adjust the settings to keep the program from disconnecting every hour?
Thank you very much for your help with this.
Respectfully, Chop
ChoppAsked:
Who is Participating?
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
Then it has to do with the network/internet..Are you guys working on your local env?
0
 
Pawan KumarConnect With a Mentor Database ExpertCommented:
Are you guys leaving the system idle for times. If yes then it is fine. Same this happens with SQL Server ( SSMS ) also.

It is the designed behavior if the leave the system for some time the connection gets disconnected.
0
 
ChoppAuthor Commented:
We are not leaving the system idle. We are using the program continuously during our training.
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
ChoppAuthor Commented:
Thank you for your help, Pawan. It may indeed have to do with the network settings. We did not figure it out yet. If we do, I will post what we find out. In the meantime, in case this is useful for someone else, we did try adjusting the 'Edit Session Timeout' seconds in the Server Properties. See the screenshot below.
Server Properties Screenshot
0
 
Pawan KumarDatabase ExpertCommented:
great....
0
 
ChoppAuthor Commented:
Thank you for your help. If you figure it out, please let me know. If we figure it out, I will let you know.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.