Post reply

Query Analyzer not starting up in XP

  • September 23, 2004 at 8:06 am

    #86459

    Hi,

    QA has stopped working under XP, I get the hourglass, then nothing. I have tried reinstalling twice, but still no results.

    I cant see anything in the system logs ??

    Any ideas ?

  • September 23, 2004 at 12:01 pm

    #524230

    Have you recently installed XP SP3? If so, it 'turns on' the internal firewall and blocks TCP 1433 which is the default for SQL Server.

    -SQLBill

  • September 23, 2004 at 3:22 pm

    #524263

    SQLBill,

    XP SP3 or SP2 ?

    Yelena

     

    Regards,Yelena Varsha

  • September 24, 2004 at 6:13 am

    #524313

    SP3 is not out, so SP2.. but maybe he means SP3 for sqlserver but I'm pretty sure it's for win xp sp2

  • September 24, 2004 at 7:02 am

    #524320

    Hi,

    I'm afraid its just XP SP1 for my sins. There is no internal firewall activated. However, telneting to the port seems to fail, so I think we are onto something.

    I'll keep you all posted.

    Regards

    Kevin

  • September 24, 2004 at 7:44 am

    #524331

    OSQL works fine..

  • September 24, 2004 at 10:26 am

    #524373

    Sorry about my typo....it should have been SP2. XP SP2 turns on the Windows Firewall and blocks several ports of which two are TCP 1433 and UDP 1434.

    Are you getting any errors? In SQL Server Error log or the Windows Event Viewer logs?

    If this is a connection problem, try PINGing the server. Open a command prompt window and type PING sql server name. If that fails try PING sql server ip address.

    If the IP works and the name doesn't, your issue is with the DNS (domain name server).

    -SQLBill

Viewing 7 posts - 1 through 6 (of 6 total)

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