[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1112
  • Last Modified:

VFP9 error 2091 and access denied issues Server 2008 remote desktop.

We just completed a data and application migration from a Windows 2000 server to a Windows 2008 server environment. I'm having intermittent issues with my VFP9 applications.

The applications are running on a Windows 2008 R2 remote desktop server. The user sessions have drives mapped to the new file server, also a Windows Server 2008 R2, 64 bit.

I'm seeing intermittent errors, like 2091 - "table has become corrupted." Where the table of interest is not corrupted, and can be opened from vfp9.

Also, intermittently, I'll see 'access denied' errors opening a table. Examination of the security properties of the folder and tables in question shows Everyone to have full control.

any suggestions would be helpful.
0
jn2112
Asked:
jn2112
  • 2
1 Solution
 
pcelbaCommented:
Switch off SMB2 both on the server and workstations. Also oplocks should not be used for shared files access. Windows administrators should know how to do it.

Antivirus software should not check DBF and CDX data files and also other fox-related files like SCX, SCT, VCX, VCT, APP, ...
0
 
jrbbldrCommented:
I might add that you should probably run testing in a local access to the SQL Server (not using Remote Desktop) to minimize the variables and to ensure that there are no contributing factors being introduced by accessing via Remote Deskop.

Good Luck
0
 
jn2112Author Commented:
Had to look up how to turn off smb2 and opportunistic file locking elsewhere, but the solution was accurate
0

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now