Re: Connection lost at same time every hour (sometimes)

Hello Roger,

Thank you for your update. I'm sorry for the delay response due to the
weekend.

I'm glad we resolve this network issue.

I'd like to make a summary for this post:

Issue:
=============
a 3rd-party SQL application will lose connection to SBS server at the same
time every hour

Cause:
=============
New feature of Windows server 2003 sp2

Resolutions:
=============
Disable RSS and offloading support on SBS

Please do not hesitate to post in SBS newsgroup if you need any assistance
in the future. I look forward to working with you again.

Thank you and have a nice day,

Best regards,

Terence Liu(MSFT)

Microsoft CSS Online Newsgroup Support

Get Secure! - www.microsoft.com/security

=====================================================
This newsgroup only focuses on SBS technical issues. If you have issues
regarding other Microsoft products, you'd better post in the corresponding
newsgroups so that they can be resolved in an efficient and timely manner.
You can locate the newsgroup here:
http://www.microsoft.com/communities/newsgroups/en-us/default.aspx

When opening a new thread via the web interface, we recommend you check the
"Notify me of replies" box to receive e-mail notifications when there are
any updates in your thread. When responding to posts via your newsreader,
please "Reply to Group" so that others may learn and benefit from your
issue.

Microsoft engineers can only focus on one issue per thread. Although we
provide other information for your reference, we recommend you post
different incidents in different threads to keep the thread clean. In doing
so, it will ensure your issues are resolved in a timely manner.

For urgent issues, you may want to contact Microsoft CSS directly. Please
check http://support.microsoft.com for regional support phone numbers.

Any input or comments in this thread are highly appreciated.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------
| Reply-To: "Roger Cook" <roger-nospam-or-junk-at-redpuma.co.uk>
| From: "Roger Cook" <roger-nospam-or-junk-at-redpuma.co.uk>
| References: <eKEAK7DKIHA.748@xxxxxxxxxxxxxxxxxxxx>
<bPJGBzoKIHA.360@xxxxxxxxxxxxxxxxxxxxxx>
<ZJxOuvPLIHA.7968@xxxxxxxxxxxxxxxxxxxxxx>
<aD#CszPLIHA.4200@xxxxxxxxxxxxxxxxxxxxxx>
| Subject: Re: Connection lost at same time every hour (sometimes)
| Date: Sun, 2 Dec 2007 23:31:27 -0000
| Lines: 204
| X-Priority: 3
| X-MSMail-Priority: Normal
| X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
| X-RFC2646: Format=Flowed; Original
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
| Message-ID: <un9W4tTNIHA.2268@xxxxxxxxxxxxxxxxxxxx>
| Newsgroups: microsoft.public.windows.server.sbs
| NNTP-Posting-Host: dsl-217-155-20-126.zen.co.uk 217.155.20.126
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.windows.server.sbs:79552
| X-Tomcat-NG: microsoft.public.windows.server.sbs
|
| This problem may be finally resolved:-
|
| Looks like it was related to either RSS and/or TCP/IP offload:
|
| After making the two following alterations on the server the problem
seems
| to have gone away , although something still not quite right on at least
one
| of the other PCs.
|
|
|
| 2) Modify the registry to disable Receive Side Scaling
| a. Click Start, click Run, type regedit , and then click OK.
| b. Locate and then click the following registry subkey:
| HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
| c. If the EnableRSS registry entry does not exist, create it. To do this,
| follow these steps:
| a) On the Edit menu, point to New, and then click DWORD Value.
| b) In the New Value #1 box, type EnableRSS , and then press ENTER.
|
| d. Right-click EnableRSS, and then click Modify.
| e. In the Value data box, type 0 (zero), and then click OK.
| f. Exit Registry Editor.
|
| 3) Disable offloading support
| a. Click Start, click Run, type regedit , and then click OK.
| b. Locate and then click the following registry subkey:
| HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
| c. In the details pane, right-click EnableTCPA, and then click Modify.
|
| Note: If the EnableTCPA registry entry does not exist, create it. To do
| this, follow these steps:
| a) On the Edit menu, point to New, and then click DWORD Value.
| b) In the New Value #1 box, type EnableTCPA , and then press ENTER.
|
| d. In the Value data box, type 0 (zero), and then click OK.
| e. Exit Registry Editor.
| f. Restart the computer.
| ========================================
|
|
|
| "Terence Liu [MSFT]" <v-terliu@xxxxxxxxxxxxxxxxxxxx> wrote in message
| news:aD%23CszPLIHA.4200@xxxxxxxxxxxxxxxxxxxxxxxxx
| > Hello Roger,
| >
| > Thank you for your email.
| >
| > After analyze your ipconfig on SBS and client, the settings are
properly.
| > There is no event error on client and SBS. Then, other connection is
good,
| > and the problem only happen on the 3rd-party application. Therefore, I
| > think this is a 3rd-party software issue.
| >
| > Please check the application settings on client and SBS, and verify the
| > settings are properly.
| >
| > Does the Outlook on client works fine when the 3rd-party application
lose
| > network connection?
| >
| > Can you pin the SBS from the client when the 3rd-party application lose
| > network connection?
| >
| > Additional, I suggest you run clean boot on the SBS and the problematic
| > clients and then test the 3rd-party application connection.
| >
| > To clean boot the problematic computer, please use the steps below:
| > a. Click Start, click Run, and then in the Open box, type "MSCONFIG"
| > (without the quotation marks). Click OK.
| >
| > b. In the System Configuration Utility (MSConfig) window, click to
select
| > the Selective Startup button.
| >
| > c. Click to clear the check mark from the "Load startup items" below
| > Selective Startup.
| >
| > d. Click the Services tab, click to check the "Hide All Microsoft
| > Services"
| > box, and remove all the check marks from the remained Non-Microsoft
| > Services. Please note that the Exchange services could be marked as
| > non-Microsoft. Please do not disable those services.
| >
| > e. Click OK to close the MSConfig window. Click Yes when you are asked
to
| > restart your computer in order to enable the changes.
| >
| > f. After restarting, please check whether this issue will reoccur.
| >
| > g. If there are no more problems, please use the above steps to enable
| > services and startup items one by one in order to figure out the root
| > cause
| > of this issue.
| >
| > I hope these steps will give you some help.
| >
| > Thanks and have a nice day!
| >
| > Best regards,
| >
| > Terence Liu(MSFT)
| >
| > Microsoft CSS Online Newsgroup Support
| >
| > Get Secure! - www.microsoft.com/security
| >
| > =====================================================
| > This newsgroup only focuses on SBS technical issues. If you have issues
| > regarding other Microsoft products, you'd better post in the
corresponding
| > newsgroups so that they can be resolved in an efficient and timely
manner.
| > You can locate the newsgroup here:
| > http://www.microsoft.com/communities/newsgroups/en-us/default.aspx
| >
| > When opening a new thread via the web interface, we recommend you check
| > the
| > "Notify me of replies" box to receive e-mail notifications when there
are
| > any updates in your thread. When responding to posts via your
newsreader,
| > please "Reply to Group" so that others may learn and benefit from your
| > issue.
| >
| > Microsoft engineers can only focus on one issue per thread. Although we
| > provide other information for your reference, we recommend you post
| > different incidents in different threads to keep the thread clean. In
| > doing
| > so, it will ensure your issues are resolved in a timely manner.
| >
| > For urgent issues, you may want to contact Microsoft CSS directly.
Please
| > check http://support.microsoft.com for regional support phone numbers.
| >
| > Any input or comments in this thread are highly appreciated.
| > =====================================================
| >
| > This posting is provided "AS IS" with no warranties, and confers no
| > rights.
| >
| > --------------------
| > | Newsgroups: microsoft.public.windows.server.sbs
| > | From: v-terliu@xxxxxxxxxxxxxxxxxxxx (Terence Liu [MSFT])
| > | Organization: Microsoft
| > | Date: Thu, 22 Nov 2007 11:36:26 GMT
| > | Subject: RE: Connection lost at same time every hour (sometimes)
| > | X-Tomcat-NG: microsoft.public.windows.server.sbs
| > | MIME-Version: 1.0
| > | Content-Type: text/plain
| > | Content-Transfer-Encoding: 7bit
| > |
| > | Email from customer:
| > | ===================
| > |
| > | Hello Terence,
| > |
| > | Thanks for responding in the newsgroup - I attach the files that you
| > | requested. The server's internal NIC is the Intel Pro NIC. There are
two
| > | Broadcom NIC ,one disabled, the other is the Wan side NIC connected
to a
| > | router.
| > |
| > | Also a sample network monitoring session recorded on the SBS server at
| > | about the time the problem occurred. The problem workstation has an IP
| > | of 192.168.18.11 and you can see some errors in the network
| > | conversation.
| > |
| > | The two problems applications are Star (t2data.mdb and .ldb) and
| > | Officetalk (otdb.mdb and .ldb). Look at convs 28 and 29 between
client
| > | (.11) and server (.3) with SMB errors re: error Code 52
| > | STATUS_OBJECT_NAME_NOT_FOUND
| > |
| > |
| > |
| > | Regarding your other questions:-
| > |
| > | I have not installed Windows server 2003 Service Pack 2 yet (didn't
want
| > | to add to problems!). However have applied your registry alterations
| > | anyway.
| > |
| > | ===============
| > |
| > | Please let me know how about the things when you install the 3rd-party
| > | application server on another server but not SBS.- Worked fine on an
| > | old HP Proliant NT server until we changed to SBS 2003 R2 last month
| > |
| > | 4. Does the client lose all network connection when the 3rd-party
| > | application lose connection? NO
| > |
| > | 5. Does this issue happen on all clients? To some degree but
much
| > | worse on one although that could be how that PC is used.
| > |
| > | 6. Do you get any event error on the client or SBS? - Nothing in the
| > | event logs - only message is from the apps that they have lost
| > | connection to the database(s). Have also seen "disk or Network error"
| > | and one message about write-caching (but on another PC) - could it
| > | relate to write-caching on the DELL RAID 5 array ?
| > |
| > |
| > | ===============
| > | I wondered if it was to do with opportunistic logging but have
disabled
| > | that now. Fault seems very regular - now every 30-31 minutes. This
looks
| > | some sort of software timeout to me but affects two different mdb
-based
| > | applications.
| > |
| > | Don't know if network monitor capture will help. Any clues would be
| > | gratefully received !
| > |
| > | Regards
| > | Roger Cook
| > |
| >
|
|
|

.

Loading