>>just last saturday i was fine connecting foxpro and java to SQLSERVER 2000
>>
>>the connection was broken this monday and cannot reconnect anymore
>>because of missing VNSAPI32.DLL
>>search our network for this file but cannot find it.
>>sqlserver agent is stopped. services is stopped
>>please help if anybody has any idea what is going on.
>
>This DLL is used by Banyan VINES Network. Are you using that kind of network?

no. we don't. wonder why this DLL appear even though no Banyan was in it.
maybe somehow the technology was incorporated somehow by microsoft and the referencing to Banyan wasn't removed.

Reply to you from Visual Foxpro Forum similar thread:

thanks sergey for replying. appreciate it.

it is on a win2k advanced server.
but the solution has been found.

it is because the Windows Login password was changed without first changing the SQLServer password authentication to similar one.

when on reboot, the SQLSERVER will not run. Now it is working fine.
We were without the SQL Database for 3 days. It is a lesson learned. :)