MSDE remote connection failure

[tuxthepenguin]

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 advance

[tuxthepenguin]

Hi 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