Monday, March 19, 2012

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.

No comments:

Post a Comment