This issue affects any mixed environment where SMB2 and SMB1 are being used.
I have spent a couple of hours with Sage Tech today, trying to resolve a problem. (Edit: Solution is to disable SMB2 see below)
It appears they have no solution to it. (They offered to put me through to the customer experiance team, which I always take to meaning we cant fix it, what can we do to compensate you.)
If you have a mix of Windows 7/Vista and Windows XP workstations.
Hosting the Data on Windows 7 (or Vista/Server 2008) will cause XP workstations to get locked out if another XP workstation accesses the data in the preceding 10 seconds (or so).
During the lock out XP users get a message "waiting to access account.dta" or other .dta file
It appears that a Windows 7 workstation when working with a Windows 7 workstation acting as a server, prevents other XP workstations from accessing the file whilst it has it open. The lock out appears to last for about 10 seconds which is about the same amount of time as (according to computer manager monitoring the file share) the file is open.
I am thinking that perhaps Windows 7 prevents XP from opening files that other Windows 7 clients have open. Maybe this has been seen with other applications?
I would love to hear form anyone who has any experiance good or bad with this sort of scenario.
Need more, need help now?
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
- - - - - - - - - - - - - - - - - - pay-as-you-go support - no contract - tenth of an hour billing - expert help - fast service - no call queues
Need integration?
- - - - - - - - - - - - - - - - - - with your shipping system - website - invoicing system - crm - cms - manufacturing - order import - back to back orders..
Need a report?
- - - - - - - - - - - - - - - - - - Excel reporting that pulls data from Sage - custom layouts - layouts that change adapt to your brands and/or for drop shipping.
Want web hosting?
- - - - - - - - - - - - - - - - - - Your own domain name - email - a shop - wordpress - woo commerce - ticket systems - help desks - forums - portals
windows 7 XP mixed environment issue waiting to access accou
- brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
windows 7 XP mixed environment issue waiting to access accou
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
- brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: windows 7 XP mixed environment issue
How to disable SMB 2.0
Note It is possible that disabling SMB2 may have an adverse effect on other applications which may rely on this setting. We cannot guarantee that this will not occur, therefore you follow this advice at your own risk.
To disable SMB 2.0 on a client PC
Start > All Programs > Accessories > Right-click Command Prompt > Run as administrator.
Note the space after the = sign if you are not cutting and pasting
Reboot the PC.
To re - enable SMB 2.0 Once you have no XP machines left you will want to do this to get performance improvement.
Start > All Programs > Accessories > Right-click Command Prompt > Run as administrator.
Note the space after the = sign if you are not cutting and pasting
Reboot the PC.
For servers you may also need to add the following registry entry under
HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters
Value name: Smb2
Value type: REG_DWORD
0 = disabled
1 = enabled
Note It is possible that disabling SMB2 may have an adverse effect on other applications which may rely on this setting. We cannot guarantee that this will not occur, therefore you follow this advice at your own risk.
To disable SMB 2.0 on a client PC
Start > All Programs > Accessories > Right-click Command Prompt > Run as administrator.
Code: Select all
sc config lanmanworkstation depend= bowser/mrxsmb10/nsi
sc config mrxsmb20 start= disabled
exit
Reboot the PC.
To re - enable SMB 2.0 Once you have no XP machines left you will want to do this to get performance improvement.
Start > All Programs > Accessories > Right-click Command Prompt > Run as administrator.
Code: Select all
sc config lanmanworkstation depend= bowser/mrxsmb10/mrxsmb20/nsi
sc config mrxsmb20 start= auto
exit
Reboot the PC.
For servers you may also need to add the following registry entry under
HKLM\System\CurrentControlSet\Services\LanmanServer\Parameters
Value name: Smb2
Value type: REG_DWORD
0 = disabled
1 = enabled
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
-
- User
- Posts: 14
- Joined: 05 Aug 2014, 08:22
- Sage Version: Other
Re: windows 7 XP mixed environment issue waiting to access a
Bruce is this Disable SMB can cause also other problems like indexing problems?
Thanks very much for your Guide, on SMB
Brilliant!
Thanks very much for your Guide, on SMB
Brilliant!
- brucedenney
- Site Admin
- Posts: 4664
- Joined: 28 Feb 2006, 09:56
- Sage Version: v30 UK/Europe/Africa
Re: windows 7 XP mixed environment issue waiting to access a
If you have a mixed environment then it will cause a lot of issues.
there is a great little program that cn switch smb2 on or off.
Goolge for SMB2toggletoo it is done by someone at symantec
there is a great little program that cn switch smb2 on or off.
Goolge for SMB2toggletoo it is done by someone at symantec
For just about anything Sage :- Discount subscriptions, pay-as-you-go support, application integration, reports, layouts, linked excel spreadsheets, analysis or any other help making life with sage easier/less time consuming Contact me.
Who is online
Users browsing this forum: No registered users and 1 guest