Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jcasse
Starting Member
3 Posts |
 Posted - 2010-12-07 : 09:33:18
|
| Bonjour! I have a problem with my SQL Server 2008 R2, on a VMWARE, Win Server 2008. I have installed 2 software MS Great Plains and another commercial software, I have 2 instances running. It's seems that the client lose the connection to the SQL Server,probably because there were no activity, so in MS Great Plain it stop with a SQL errror, in the other software, I need to restart the software or redo the connection. Is there a setting or something I'm missing??Joel |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-07 : 12:30:20
|
| I don't believe the client loses the connection due to no activity. By default, it closes the connection on every batch.You haven't set your databases to autoclose have you? If you have, fix that.Also, What version of GP? If not 10, then SQL 2008 (nor 64 bit OS) are supported and you should be using 32 bit version of SQL 2005. |
 |
|
|
jcasse
Starting Member
3 Posts |
Posted - 2010-12-07 : 13:00:05
|
| GP2010, and I have check the Auto close and it is to false on the databases.Joel |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-07 : 13:22:28
|
| what is the error message? |
|
|
|
jcasse
Starting Member
3 Posts |
Posted - 2010-12-08 : 09:02:14
|
| Thnks guys, the SYS. Admin found a bug in the Virtual Server ESX box, every 30 mintues it was doing something to all virtual servers, that was disconnecting the network without having any event logs.Regards, Joel :) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Losing connection