Hi all,
My first post on here, and I've had a search for similar but unfortunately can't find anything that points me in the right direction, so please go easy on me!
My scenario;
I am dabbling with PHP and this is the reason for me doing this on my own development PC (Windows XP SP3) rather than the main server. The PHP is all working okay, so I think we can ignore that aspect. This problem seems to be an authentication problem.
I am unable to access my Foxpro tables that are shared out from our main server (SBS 2003), I am using ODBC and this is working fine for running other applications.
When I try to query a table the error I get returned is [Microsoft][ODBC Visual FoxPro Driver]File 'table.dbf' does not exist.
When I look on the server in the event log I can see the following;
Event Type: Failure Audit
Event Source: Security
Event Category: Logon/Logoff
Event ID: 529
Date: 02/11/2009
Time: 10:31:57
User: NT AUTHORITY\SYSTEM
Computer: DOMAIN_CONTROLLER
Description:
Logon Failure:
Reason: Unknown user name or bad password
User Name: IWAM_MYPC
Domain: MYPC
Logon Type: 3
Logon Process: NtLmSsp
Authentication Package: NTLM
Workstation Name: MYPC
So I have sussed that it is something to do with the anonymous access on IIS on my development PC, and I have tried a few known good username/password combinations, but cannot seem to get around this.
Can anyone point me in the right direction please? As I guess if I was to do similar and setup a Web Server on a separate box I would get the same issue?