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

windows 7 XP mixed environment issue waiting to access accou

Sage 50 general help forum - Free help and support for all general issues
Post Reply
User avatar
brucedenney
Site Admin
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

Post by brucedenney » 17 Jan 2011, 17:46

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.
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 avatar
brucedenney
Site Admin
Site Admin
Posts: 4664
Joined: 28 Feb 2006, 09:56
Sage Version: v30 UK/Europe/Africa

Re: windows 7 XP mixed environment issue

Post by brucedenney » 13 Dec 2011, 11:54

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.

Code: Select all

sc config lanmanworkstation depend= bowser/mrxsmb10/nsi 
sc config mrxsmb20 start= disabled
exit

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.

Code: Select all

sc config lanmanworkstation depend= bowser/mrxsmb10/mrxsmb20/nsi 
sc config mrxsmb20 start= auto 
exit

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
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.

ChristianNikolov
User
User
Posts: 14
Joined: 05 Aug 2014, 08:22
Sage Version: Other

Re: windows 7 XP mixed environment issue waiting to access a

Post by ChristianNikolov » 07 Aug 2014, 12:29

Bruce is this Disable SMB can cause also other problems like indexing problems?

Thanks very much for your Guide, on SMB

Brilliant!

User avatar
brucedenney
Site Admin
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

Post by brucedenney » 07 Aug 2014, 13:19

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
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.

Post Reply

Who is online

Users browsing this forum: Semrush [Bot] and 3 guests