Solved

MSDE "The System Cannot Find The File Specificed"

Posted on 2011-03-19
1
207 Views
Last Modified: 2012-05-11
Hello,

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.
0
Comment
Question by:Pawel_Kowalski
1 Comment
 
LVL 3

Accepted Solution

by:
rkharko earned 500 total points
ID: 35173781
Check in Server Network Utility which protocols is it listening
to. Then check in Client Network Utility which protocols clients are
using. Be careful to check the box "Used shared memory" in the lower
left corner.

My guess is that you have "shared memory disabled", and one of server
and client only has named pipes disabled, and the named pipe somehow
got messed up the MSDE installation. Since shared memory is much
preferred to local connections, enable this and restart Sql server.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question