Remote connection to MSDE

I'm trying to connect to the SharePoint MSDE database from Windows XP
SP2 machine over Ethernet LAN. I was getting server not found or access
denied, until I enabled TCP/IP via svrnetcn.exe. Now, I'm getting
OK
Connection failed:
SQLState: '01000'
SQL Server Error: 10061
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen
(Connect()).
Connection failed:
SQLState: '08001'
SQL Server Error: 17
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not
exist or access denied.
Any ideas?
I just did an netstat -an and I don't see the server listening on 1433.
What am I not doing?
|||Ok, here's what i've discovered:
The svrnetcn tool has no effect. I make a change and check the logs,
but nothing happens. What would be causing this?
|||Did you restart after enabling TCP/IP? Is it a default
instance or a named instance? Can you connect locally when
on the machine with MSDE?
-Sue
On 25 Jan 2006 14:21:43 -0800, "laurin1" <laurin1@.osai.com>
wrote:

>I just did an netstat -an and I don't see the server listening on 1433.
>What am I not doing?
|||Yes. It's a named instance (SHAREPOINT). I can connect locally.
|||Make sure you aren't having firewall issues.
Can you ping the MSDE box from the other box?
Check the listening port for the MSDE instance - when you
start up MSDE, it logs what protocols, ports it is listening
on in the error log.
Try to telnet to the port it's listening on.
Verify the login being used.
And if those don't get you anywhere, you can find additional
troubleshooting steps in the following article:
INF: Potential Causes of the "SQL Server Does Not Exist or
Access Denied" Error Message
http://support.microsoft.com/?id=328306
-Sue
On 26 Jan 2006 05:41:03 -0800, "laurin1" <laurin1@.osai.com>
wrote:

>Yes. It's a named instance (SHAREPOINT). I can connect locally.
|||I just found out that this is WMSDE, not MSDE, which can only be
connected to remotely. No matter what changes I make, the server will
not listen on 1433.
|||If it is indeed WMSDE, it only supports local connections so it will never
listen on a port. WMSDE is an OS component that can only be connected to by
selected Microsoft software running locally.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"laurin1" <laurin1@.osai.com> wrote in message
news:1138379664.059706.236830@.g14g2000cwa.googlegr oups.com...
>I just found out that this is WMSDE, not MSDE, which can only be
> connected to remotely. No matter what changes I make, the server will
> not listen on 1433.
>