Post reply

XP SP2 - known problem with SQL Server

  • August 16, 2004 at 11:50 am

    #161403

    Hello,

    Anyone who knows what kind of problem are encountered using SQL Server with XP sp2?

    I have read an article about potential problem using SQL Server with XP sp2 at this URL:

    http://zdnet.com.com/2100-1104_2-5311280.html

    Thanks for any feedback.

    Carl

  • August 16, 2004 at 12:11 pm

    #519201

    SP2 disables the TCP and UDP ports by default to SQL Server. Name Piped only works for computer within same subnet.

    You need turn the ports on by configuring XP firewall to get SQL Server back to the network.

     

  • August 16, 2004 at 12:13 pm

    #519202

    Ok thanks a lot Allen.

  • August 17, 2004 at 11:16 am

    #519407

    It is my understanding that SP2 disables the network protocols, too.  You will need to enable them on the server using svrnetcn.exe as well as enabling the ports on the firewall.

    Don

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply