Post reply

CONNECTIVITY TO NAMED INSTANCE

  • April 13, 2012 at 3:12 pm

    #272590

    Hi,

    Thanks for reading my question.

    I have a named instance running on one of my development boxes.

    I am able to connect to it from my computer (that means SQL Server Browser Service is running...) using SSMS.

    But one of my developers is using my eclipse to connect and he is not able to connect..

    He tried to connect to the default instance on the same machine...that was successful...

    Any ideas..?

    Thanks!

    Siva.

  • April 13, 2012 at 3:26 pm

    #1473552

    maybe this will help http://www.connectionstrings.com/sql-server-2008

    I would think they would need to specify "servername,port" in their connection string.

    Bob
    -----------------------------------------------------------------------------
    How to post to get the best help[/url]

  • April 13, 2012 at 3:30 pm

    #1473557

    Thanks Bob...

    I was thinking that it is not necessary to mention the port name for named instance...SQL Server Browser service would take care of it internally..

    Is this correct..?

  • April 13, 2012 at 5:25 pm

    #1473587

    Depends. I've seen instances where the firewall was configured for the traffic necessary for the SQL Server to communicate but not the traffic the browser service needed to communicate. If the port number being added to the connection string solves the problem, you might ask your firewall folks to look at the traffic and enable the port and protocol used by the browser. I don't remember the exact settings, but my old and feeble brain brings back something about UDP and port 1434. Your Admins should be able to sniff it for sure.

    And then again, I might be wrong ...
    David Webb

  • April 13, 2012 at 5:37 pm

    #1473589

    Thanks David...

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

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