Menu

Sqldeveloper connect to sqlserver with instance Name

2018-11-03
2019-04-01
  • Ricardo Tamagnini

    i'm trying to connect to a sqlserver with intance Name like "hostname\instance_name" and i got error "unknown server name" can you help me ?

    thanks
    RT

     
  • FENG SIAN

    FENG SIAN - 2018-11-06

    Dude, are you 100% sure that the hostname exists? Give a "ping hostname" a shot.

     
  • Garu

    Garu - 2019-02-04

    The connection string should be something like this:
    jdbc:jtds:sqlserver://{HOSTNAME};instance={INSTANCE_NAME];...{rest of parameters}

    jTDS does not support the naming convention "hostname\instance_name" like the Microsoft JDBC drivers does.

     
  • Bernd Eckenfels

    Bernd Eckenfels - 2019-04-01

    ... and if you specify the correct port you dont need to specify the instance name, it just slows down resolving and need the SQL Browser service which is no longer available by default.

     

Log in to post a comment.