Mike,
Thanks..Found info about resolving the problem but not how...
"In cases where your application needs to use TCP/IP or named pipes to
access the network, we recommend that you set up access on an as needed
basis. We also recommend that for TCP/IP, you use a static port assignment.
For applications that use a named instance of MSDE with dynamic TCP port
selection enabled, you can open the UDP port 1434 and the TCP/IP port as
appropriate."
So how do you open the UDP and TCP/IP as appropriate? Please note that the
firewall is off already.
Mica
[quoted text, click to view] "Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:D932DD14-EE5C-4938-8B31-6A69C388211C@microsoft.com...
> Hi
>
> Check the MSDE is running.
>
> If XP SP2 is installed, open the port.
>
http://www.microsoft.com/sql/techinfo/administration/2000/security/winxpsp2faq.asp >
> Regards
> Mike
>
> "Mica Cooper" wrote:
>
>> I am traveling on a borrowed laptop and am stuck with XP Home. I
>> installed
>> SQL
>> Server 2000 MSDE and tried to connect and failed. Using "netstat -an" I
>> failed to find port 1443 open (or the corresponding UDP). I am trying to
>> connect using a JDBC connector and it seems to be failing due to this.
>> Enterprise Manager connects just fine.
>>
>> Does XP Home and MSDE combo have some reason for failing to publish port
>> 1443?
>>
>> What do I need to do to get 1443 up and running...else I have wasted 20
>> days
>> of an overseas consulting trip.
>>
>> I did a default install. Any help is greatly appreciated.
>>
>> Thanks,
>> Mica
>> PS. I also posted to sqlserver.setup the same question as I didn't know
>> which group to post to.
>>
>>
>>
