Chopp
asked on
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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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.
great....
ASKER
Thank you for your help. If you figure it out, please let me know. If we figure it out, I will let you know.
ASKER