Post reply

Connection to SQL Server via IP not possible

  • November 18, 2009 at 1:24 am

    #142998

    Hello everybody,

    at the moment I'm having a problem I have never experienced before.

    I created an ODBC connection to a clients DB Server with the hostname as server. Works perfectly.

    But when I change the hostname to the actuall IP it is not working anymore because I cant create the connection.

    A Ping on the hostname returns the same IP I entered so its not like its routing wrong. NS Lookup on the IP gives back the hostname.

    But I just cant create a connection via IP. hostname only. But I need to connect to the SQL-Server through IP.

    Hope anybody can give me a hint,

    regards, Stephan

  • November 18, 2009 at 8:42 am

    #1080960

    has the server got an instance name?

    i.e. D-DB01\CORP ?

    If so the connection will need to be example:

    10.250.15.26\CORP

    or using the Port so

    10.250.15.26,1433 or 10.250.15.26,2080 (depending on your port config)

    also could be an alias issue please see this post also...

    Oraculum

  • November 18, 2009 at 10:56 am

    #1081076

    Are you able to connect in Management Studio using the IP?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • November 19, 2009 at 1:22 am

    #1081381

    Yes, the server has an instance, but thats not the problem.

    I can connect via the external IP on the SQL Server itself with the Management Studio. Unfortunatly I don't have a Management Studio on the other Machine. Only the ODBC Connection. But no aliases in use.

    Thanks for your responses so far.

    Regards, grobi

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

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