MSDE remote connection failure

Hi all,

I installed a MSDE on a Windows XP SP2 and configured it for accepting remote connections. But It shows the "SQL Server doesnot exist or connection denied" message whenever I try to connect to this server. For more information I am adding more facts

* It is an MSDE and not a WMSDE
* Firewall is turned off
* Server process is listening on 0.0.0.0:1433
* TCP/IP and Named Pipes are enabled using server network utility
* LoginMode=2 is set for mixed mode authentication in the registry
* Tried restaring the Process and even windows after the changes.

Please help me !!

Thanks in advanceHi friends,
I got the issue fixed. :angel:

I dont know how it works but it worked.

On the client side; using the client network utility, I added an alias to my server.

My server's instance name was SLIMSHADY\SSIT and it was listening on 8001(I changed it thru the registry) in mixed mode authentication.

It wasted my 4-5 hours of playing with the registry and googling. The final attempt succeeded in which I created an alias to the server Indicating its exact port number and Instance name.

Then I tried connecting using this alias .... IT WORKED !!

I DONT KNOW HOW IT WORKS BUT IT WORKED IN MY CASE

HAPPY COMPUTING

MSDE remote connection failure

Hi all,

I installed a MSDE on a Windows XP SP2 and configured it for accepting remote connections. But It shows the "SQL Server doesnot exist or connection denied" message whenever I try to connect to this server. For more information I am adding more facts

* It is an MSDE and not a WMSDE
* Firewall is turned off
* Server process is listening on 0.0.0.0:1433
* TCP/IP and Named Pipes are enabled using server network utility
* LoginMode=2 is set for mixed mode authentication in the registry
* Tried restaring the Process and even windows after the changes.

Please help me !!

Thanks in advanceHi friends,
I got the issue fixed. :angel:

I dont know how it works but it worked.

On the client side; using the client network utility, I added an alias to my server.

My server's instance name was SLIMSHADY\SSIT and it was listening on 8001(I changed it thru the registry) in mixed mode authentication.

It wasted my 4-5 hours of playing with the registry and googling. The final attempt succeeded in which I created an alias to the server Indicating its exact port number and Instance name.

Then I tried connecting using this alias .... IT WORKED !!

I DONT KNOW HOW IT WORKS BUT IT WORKED IN MY CASE

HAPPY COMPUTING

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.