?
Solved

MSDE "The System Cannot Find The File Specificed"

Posted on 2011-03-19
1
Medium Priority
?
223 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 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.
Suggested Courses

621 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