MSDE "The System Cannot Find The File Specificed"
Posted on 2011-03-19
I have an installation of MS SQL 2000 MSDE running on windows 2003 R2. The instance seems to work fine on the server locally. But when I try to connect to this instance on a client machine (XP) I get the following error "the system cannot find the file specified".
Today I did notice in the event log of the server that windows was disabling TCP/UDP connectivity for MSDE because I didn't have the latest service pack. I did fix that by upgrading to SP4 on the server but I still have the sample problem on the client.
Any help in figuring out whats going on would be appreciated.