|
|
Posted by Erland Sommarskog on 10/01/39 11:18
Corobori (jlpraz@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, esquel@sommarskog.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
Navigation:
[Reply to this message]
|