The specified file was not found

[Corobori]

I have got an XP machine where I have installed a SQL Server for my
testing.

I recently started working on a vb.net project requiring MSDE. After
executing the Setup, made using Install Shield, including the
installation of an instance of MSDE I can't start the Query Analyzer on
my "normal" SQL server or any instance, I am having a message saying
"the specified file can not be found". I have to do a system restore to
recover this functionality.

Here is a pic http://www.corobori.com/sos/picSQLMSDE.jpg

Jean-Luc
www.corobori.com

[Erland Sommarskog]

Corobori (jl****@corobori.com) writes:

I have got an XP machine where I have installed a SQL Server for my
testing.

I recently started working on a vb.net project requiring MSDE. After
executing the Setup, made using Install Shield, including the
installation of an instance of MSDE I can't start the Query Analyzer on
my "normal" SQL server or any instance, I am having a message saying
"the specified file can not be found". I have to do a system restore to
recover this functionality.

Here is a pic http://www.corobori.com/sos/picSQLMSDE.jpg

So if I understand this correctly: you cannot connect to your default
instance at all.

First check in SQL Service Manager whether it is running at all.

Then check in Server Network Utility which protocols is is 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 dissabled", 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 jog along.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp

[kbilkhoo]

I also am getting the same problem after installing MSDE. I cannot open
Query Analyzer from SQL Enterprise Manager.

[kbilkhoo]

I also am getting the same problem after installing MSDE. I cannot open
Query Analyzer from SQL Enterprise Manager.

[Erland Sommarskog]

kbilkhoo (ku*************@xansa.com) writes:

I also am getting the same problem after installing MSDE. I cannot open
Query Analyzer from SQL Enterprise Manager.

Can you start it through the SQL Server program group? I have no idea
how EM finds QA, but maybe some registry hacking can give some clues.
Another workaround is to use "External Tools" and QA down there.
--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp