Post reply

Problem connecting to server

  • March 23, 2006 at 8:48 am

    #112521

    I have a scenario where i have only read access on a database. If i try connecting to thsi server using IP address and my id i am nto able to. Can anyone explain what could be teh reason and how to resolve it. Any help will be greatly appreciated.TIA

  • March 23, 2006 at 9:03 am

    #628379

    What are you trying to connect with, EM, QA, ODBC?  Are you getting any sort of message back?  Can you ping the IP?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • March 23, 2006 at 9:10 am

    #628382

    I can ping the ip . I tried connecting from isql it didnt work . i tried from QA using IP address with my id and that didnt work either with isql i get this

    DB-Library: Unable to connect: SQL Server is unavailable or does not exist.  Una

    ble to connect: SQL Server does not exist or network access denied.

    Net-Library error 2: ConnectionOpen (Connect()).

     

    any thoughts/ideas?

  • March 23, 2006 at 9:21 am

    #628385

    check that the port 1433 is open. try to change the protocol to named pipes and use fully qualified computer name with named pipes. Ping port is different from SQL server port. Also check with your DBA that SQL Server is up on the server

    Regards,Yelena Varsha

  • March 23, 2006 at 9:29 am

    #628390

    The port used for this server is 1434 and i created a named pipes client n/w utility for thsi IP address. Still no luck. This is a prodn server so sql is up and running i could connect from EM using the server name like abc... but when i use Ip thats when it fails. any other suggestion. Thanks for all the help

  • March 23, 2006 at 9:39 am

    #628393

    Is there a reason why you cannot just use the host name?

    John Rowan

    ======================================================
    ======================================================
    Forum Etiquette: How to post data/code on a forum to get the best help[/url] - by Jeff Moden

  • March 23, 2006 at 9:43 am

    #628398

    Yes there is

  • March 23, 2006 at 11:09 am

    #628421

    I can not connect using Named Pipes with IP address, I don't think it is supported. I also don't think Named Pipes use 1434, it is for TCP/IP.

    Named Pipes work over the port 445.

    Please, see

    http://msdn2.microsoft.com/en-us/library/ms189307.aspx

    Creating a Valid Connection String Using Named Pipes  

    Regards,Yelena Varsha

  • March 24, 2006 at 11:15 am

    #628705

    Go to Client Network Utility and create an Alias using proper port number or use IP, 1434

  • March 24, 2006 at 12:06 pm

    #628716

    Are you sure it's using 1434?

    Normally, SQL Server uses:

    TCP 1433

    UDP 1434

    -SQLBill

  • March 24, 2006 at 12:13 pm

    #628719

    SQL Bill,

    He is trying to use named pipes with IP address. I don't think this combination should work at all! It did not work for me as a test. He has to use Named Pipes with the name and TCP/IP with IP address. But you are correct about the port, he has to re-check it. 

    Regards,Yelena Varsha

  • March 24, 2006 at 12:39 pm

    #628728

    Port 1434 came from ishaan99's email

Viewing 12 posts - 1 through 12 (of 12 total)

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