Sql Server 2008 R2 keeps disconnecting after a few minutes -- how can I prevent this?

That is not supposed to happen.

We would need more information about this disconnects. How do notice them? Do you get an error message at some point?

What does this query return?

SELECT connectionproperty('Net_transport')

I seem to recall that SSMS 2008 R2 has some irritating quirks; I have mainly stayed away from it. Maybe this is something that strikes? You could download SSMS 2012 from

http://www.microsoft.com/en-us/download/details.aspx?id=29062

(When you click download you get a list of options, select the one with Management Studio.)

And why SSMS 2012 and not SSMS 2014? Because SSMS 2014 has some new (very) irritating quirks.

---

Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se