MSDE not accepting connection

I recently installed MSDE SP3 on a laptop. Everything works fine,
except when I unplug the laptop from my network.
If I boot up my laptop when I am not connected to a network, I can't
connect to MSDE. I've tried TCP/IP and Named Pipes. When I plug in my
network cable, MSDE starts accepting connections.
The error is: SQL Server does not exist or access denied
I'm using Query Analyzer for testing the connection.
I can ping 127.0.0.1, so the loopback adapter is running OK.
I have no firewall software running on the computer.
I have installed MSDE with DISABLENETWORKPROTOCOLS=0 and
SECURITYMODE=SQL.
I'm running XP sp1 with all critical updates from windowsupdate.
Any help appreciated.
Finn Bjornsen
Enable the Shared Memory protocol for MSDE.
Jim
"Finn Bjornsen" <finnbi@.talent.dk> wrote in message
news:e9f3a153.0404220036.39d45ae3@.posting.google.c om...
> I recently installed MSDE SP3 on a laptop. Everything works fine,
> except when I unplug the laptop from my network.
> If I boot up my laptop when I am not connected to a network, I can't
> connect to MSDE. I've tried TCP/IP and Named Pipes. When I plug in my
> network cable, MSDE starts accepting connections.
> The error is: SQL Server does not exist or access denied
> I'm using Query Analyzer for testing the connection.
> I can ping 127.0.0.1, so the loopback adapter is running OK.
> I have no firewall software running on the computer.
> I have installed MSDE with DISABLENETWORKPROTOCOLS=0 and
> SECURITYMODE=SQL.
> I'm running XP sp1 with all critical updates from windowsupdate.
> Any help appreciated.
> Finn Bjornsen
|||Thanks for your advice.
Shared Memory Protocol is enabled on the client (Query Analyzer).
I don't think there is a problem with the client. It's most like a
problem with the server (MSDE) or the operating system (Windows XP)
Regards
Finn Bjornsen
|||Hi Finn,
I also had similar problem and posted the question ('Problem installing pubs
db in MSDE') before seeing your posting. So I was just watching your post
and replies.
My problem was solved by using both computer name and instance name
separated by a back-slash as:
<ComputerName>\<InstanceName>
Try it and see.
ThanQ...
"Finn Bjornsen" <finnbi@.talent.dk> wrote in message
news:e9f3a153.0404222212.55fd1301@.posting.google.c om...
> Thanks for your advice.
> Shared Memory Protocol is enabled on the client (Query Analyzer).
> I don't think there is a problem with the client. It's most like a
> problem with the server (MSDE) or the operating system (Windows XP)
> Regards
> Finn Bjornsen
|||I use a default instance.
Tried using 127.0.0.1\
Didn't work. Still not able to connect.
It can't be true. MSDE has be able to function on a laptop even though
the network cable has been unplugged.

MSDE icon not in systray

Hi,
I've just reinstalled MSDE release A on my machine. When I boot up the icon
in the systray is not there but it shows that it is running in task manager
does anyone know why tis is happening at what I can do to have the icon back
in the systray?
Thanks
hi,
"bcb963" <bcb963@.discussions.microsoft.com> ha scritto nel messaggio
news:497190C5-F881-45A8-9A10-2709126CB18E@.microsoft.com
> Hi,
> I've just reinstalled MSDE release A on my machine. When I boot up
> the icon in the systray is not there but it shows that it is running
> in task manager does anyone know why tis is happening at what I can
> do to have the icon back in the systray?
> Thanks
in the Starup folder, create a link pointing to
"C:\Programmi\Microsoft SQL Server\80\Tools\Binn\sqlmangr.exe" /n
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply