Hello,
Yes, that is possible.
You can use this command on the server and when an user do not use sql then
the connection will cut.
net config server /autodisconnect:time_before_autodisconnect
for example: net config server /autodisconnect:1
(it means minute)
and also you can show a message when connection cuts...
net config server /srvcomment:"your message is in here"
take it easy.
www.mesutsariyar.com
"Peter" wrote:
> I'm trying to resolve a disconnection issue to SQL Server 2005 Express
> installed in Windows 2003 server. Workstations are running an application
> which is located in a shared folder in the Windows 2003 Server and that
> application connects to the SQL Server 2005 Express. If any workstation has
> opened the application and the application has connected to the SQL Server
> and leaves the connection idle for a period of time, the connection will
> somehow disconnected.
>
> Is there a setting in Windows 2003 to disconnect idle connection
> automatically?
>
> If the issue is caused by shared folder being disconnected, I assume that I
> will not able to run the application anymore. What kind of error message
> should be received by the workstation when one tries to do something on the
> open application if the shared folder is somehow disconnected?
Similar Threads
Linear Mode
