Monday, September 26, 2016

Fast Solution to Problem: Desperate plea for help - Win7 and SBS 2008 network/share disconnections

Desperate plea for help - Win7 and SBS 2008 network/share disconnections

Hi all,

I am experiencing a nasty problem that had frustrated me for several weeks now!

Scenario:
1.
Windows Server 2008 SBS Premium Edition (not R2)
  Network share: \\Server\DBShare
  also mapped as J:\ on client computers
   Share contains some Access 2002 ('access xp') back-end (BE) databases

2.
Clients: diverse set of machines: XP, Vista, Win7, etc...
  ALL have Access XP (2002) installed (runtime) and run a horrible 13 year old front end (FE) that has been under spasmodic development since 1997. It is mission critical and there is no budget to rewrite is since it is sprawling and has its hooks into every
device, procedure, policy and activity we do.
  Front-end is run locally, resides in users %appdata% path.

Problem:
Currently 8x NON-windows 7 devices access the system daily, remain connected 24 hours a days and never give disk or network errors.
ANY windows 7 device is guaranteed to give disk or network error messages, at some point - from 30 minutes to 15 hours into opening the front end and being left idle.
NOTE: I was sent here from the access forum as they thought Win7 forum would be more appropriate.
For non-access users, Access is like the canary in the coalmine
when it comes to network connection problems.
Even a slight network disruption causes it to complain about network errors and to require the database connection
to be re-created, losing data and potentially corrupting this file-system database.

I had everyone set up using j:\variousdatabases.mdb   but read this was a
nono so I scripted a change of all mapped drives to UNC pathnames in the
connection property of the linked tables.
 With this change, sometimes I just
get an 'odd' Disk or network error, then am able to reconnect - but this
disturbs me terribly because 1.
it may be  doing damage to the db, 2.
It
means I need to write error handling to trap this for over 300 forms, and even
then I suspect there will be things I cannot trap and 3. It also SOMETIMES
does not reconnect and I get repeated messages...
or even an appcrash.

When I say ANY, I mean I have 4 test devices: a workstation, a mini-pc, a
laptop and a netbook.
This started out as an 'test upgrade' to Win7 on the
workstation - but after this Show-stopping issue, it turned into a desperate
troubleshooting jamboree, involving more systems and more trials because the
solution just seemed around the corner.

Now, a week later, I am ready to give up on computeres forever and go live
under a bridge, since I am unable to solve this and have already invested so
much time into it!

Here is what I think I have ruled out and why:

Not a network infrastructure problem. 
I can unlug a minipc with vista on it (same exact hardware) and connect it to
the ethernet port of one of the evil test win7 machines and it plugs away
happily for over 24 hours.
All machines are on the same 24 port switch.
All 
nonwin7 machines work like a dream, even when moved to the port/cables
used by the win7 machines.

Not a server NIC problem.
See above.
Other non win7 devices all purring away without disconnect.

Not a server problem.
SBS2008 has been working *untouched* for the last 7 months.
Only reason to
look at it recently was to try solve this damn problem... 
All non win7 clients are happy as can be, still.

Not MS's (apparently horrid?) dynamic scaling TCP stack or offloading on the
SERVER.
EVERYTHING in the nic driver that could be offloaded (and was by default,
without problems on other non-win7 clients) has been turned OFF.
I have also
disabled the chimney and all other Auto-Tuning features on the Server.
(FYI - all nonwin7 clients STILL happy, server shows no noticeable increase
in processor usage)

Not MS's (apparently horrid?) dynamic scaling TCP stack or offloading on the
CLIENTS.
Done the same again on the clients - auto tuning off, offloading off wherever
possible.
Latest NIC drivers installed that give plenty of offloading options
to disable.

Not Offline Files
These have been disabled on the server shares, on the client and in the group
policy just to make a point.

Not the MiniPc/The Laptop/The Netbook/The Workstation
Seems unlikely that ALL 4 would not work due to hardware error AND
inapproriate drivers, but I ran out of ideas - so I imaged the win7 MiniPC
and put Vista back on.
To my chagrin, the Vista OS on the same device works
perfectly.
Re-image to the Win7 OS and BOOM - same problem.

Not IPv6
Disabled on clients and server

Not IPX/SPX
Not installed on client/server
Not network traffic
(happens when I have all but 5 computers turned off and nobody in the
office as well as in the middle of the day when users are 'using'.)

Not time of day
Happens after 15 mins in the middle of the afternoon, or after 6 hours at 
4:32am - does not coincide with error log events on server or client, does not
coincide with DHCP renewals (which are 2 weeks anyway)

Not server autodisconnect
This is set to -1 in both server and client (I know it is not relevant on the client))
I also tried adding a keepconn regentry of ffffff (I know the reported max is
64k but it does not help me to have the connection drop after 18 hours.)
FYI - No effect with or without keepconn registry entries. 

Not Power saving
4 machines, 4 different ranges of random stuff to stop turning off - from
network cards to windows power schemes to simply disabling acpi.
Problem
continues

Not my version of Windows 7
Tried our company VLK Win7 Enterprise and my personal copy of win7 ultimate
and the netbooks win7 home premium.
SAME SAME SAME

Not my out of date drivers
Stock MS drivers on old machines that were not built for Win7 show me the
same error
Laptop and Netbook (latter preinstalled by vendor) also give same problem

Its not that I am not using the drive\UNC.
I ran a separate script that just does a DIR() on the folder every 10 seconds
and still, I eventually get the disk errors.

Its not that I am not querying the database and the connection is timing out
There is a Database lookup Every 2 minues in the FE to check for new data in a table
Its not a domain/roaming profile issue
I have tried logged in as domain user with roaming profile, admin user not on
the domain, from PCs formally added to the domain and even from laptops
not registered on the domain.

Its not System Restore
Turned off on the clients
Its not SMB signing
Turned this off in the Server Group policy and still same problems...
PLEASE HELP! 

Any ideas would be much much appreciated!

Thanks in advance for helping to make my new year better! & Happy holidays to those of you lucky enough not to be troubleshooting this!

Alex

Anwsers to the Problem Desperate plea for help - Win7 and SBS 2008 network/share disconnections

Download Error Fixer (Free)

Thank you diana,
I have tried my luck in the Technet Server forum you suggested.
For others wanting to follow my progress here is the link:
http://social.technet.microsoft.com/Forums/en-US/smallbusinessserver/thread/0527a084-1953-47f0-ae83-febb52af14fc
Happy new year!

Manually editing the Windows registry

Manually editing the Windows registry to remove invalid MACHINE_CHECK_EXCEPTION keys is not recommended unless you are PC service professional. Incorrectly editing your registry can stop your PC from functioning and create irreversible damage to your operating system. In fact, one misplaced comma can prevent your PC from booting entirely!


Caution: Unless you an advanced PC user, we DO NOT recommend editing the Windows registry manually. Using Registry Editor incorrectly can cause serious problems that may require you to reinstall Windows. We do not guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

To manually repair your Windows registry, first you need to create a backup by exporting a portion of the registry related to MACHINE_CHECK_EXCEPTION (eg. Windows Operating System):

  • Click the Start button.
  • Type "command" in the search box... DO NOT hit ENTER yet!
  • While holding CTRL-Shift on your keyboard, hit ENTER.
  • You will be prompted with a permission dialog box.
  • Click Yes.
  • A black box will open with a blinking cursor.
  • Type "regedit" and hit ENTER.
  • In the Registry Editor, select the Error 0x9C-related key (eg. Windows Operating System) you want to back up.
  • From the File menu, choose Export.
  • In the Save In list, select the folder where you want to save the Windows Operating System backup key.
  • In the File Name box, type a name for your backup file, such as "Windows Operating System Backup".
  • In the Export Range box, be sure that "Selected branch" is selected.
  • Click Save.
  • The file is then saved with a .reg file extension.
  • You now have a backup of your MACHINE_CHECK_EXCEPTION-related registry entry.

Another Safe way to Repair the Problem: Desperate plea for help - Win7 and SBS 2008 network/share disconnections:

How to Fix Desperate plea for help - Win7 and SBS 2008 network/share disconnections with SmartPCFixer?

1. Download SmartPCFixer . Install it on your system.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be fixed.

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related: How to Update & Download NVidia GeForce 6100/nForce 420 WHQL Certified driver v.178.13,How to Update & Download NVidia GeForce 7600 GS Video Driver v.295.75 Certified,How Can I Update & Download NVidia GeForce 820M Driver v.344.48 WHQL,[Solved] Download NVidia GeForce GTX 560M VGA Driver v.296.17 Certified,Way to Update & Herunterladen NVidia GeForce GT 130M Video Treiber v.295.75 Certified,How to Update & Download SONY SVE14A1X1RH Realtek Ethernet Driver,Where to Download SONY SVS13A2W9ES Bluetooth Driver (Intel) v.2.6 - 2.6.23.40059,Best Way to Update & Download SONY VGN-CR203E Conexant HDAUDIO SoftV92 Data Fax Modem with SmartCP Setup Program v.7.62.0.50 driver,Best Way to Download SONY VGN-FE790G/N Wireless LAN Driver v.10.6.0.29,Method to Update & Download SONY VGN-NR31Z/S Firmware Extension Parser Device v.8.0.2.3,How to Fix Error 0x0000c1f5 SoluciĆ³n?,Error 0x80071a91 Win7 Fix Patch,Error 0x800ccc60 Windows Live Mail [Solved],Error Message 0x800ccc79 Outlook 2000 Fix,What is Error 0xc1ab0001?,[Answered] x64 saplugin dll,How to Fix Problem - Kb943729 Download?,Troubleshooting: Bccode D1 Error,Java Runtime Tech Support,Troubleshooting: ERROR NO SUCH GROUP Error
Read More: Dell 922 AIO printer needs driver update for windows 7 premiun [Solved],How Can You Fix - design review 2010 non funziona con windows 7?,data points on chart don't correspond to data in table [Solved],Troubleshoot:Dell 968 AIO will not print. Error,Troubleshooting:Data Validation - Is it possible to select more than one item at a time? Like a Filter. Error

No comments:

Post a Comment