Re: Win XP Home and MSDE: Port 1443 Not Found
From: Mica Cooper (mica_cooper_at_microcore.net)
Date: 12/30/04
- Next message: Frank: "Access Denied on trying to connect"
- Previous message: dkalling: "Making a copy of an SQL 7 database into an MSDE environment"
- In reply to: Mike Epprecht (SQL MVP): "RE: Win XP Home and MSDE: Port 1443 Not Found"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 29 Dec 2004 20:13:36 -0600
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
"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.
>>
>>
>>
- Next message: Frank: "Access Denied on trying to connect"
- Previous message: dkalling: "Making a copy of an SQL 7 database into an MSDE environment"
- In reply to: Mike Epprecht (SQL MVP): "RE: Win XP Home and MSDE: Port 1443 Not Found"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|