Remote SQL Connection

  • Respected All

    My sql server is installed as named instance and configured on dynamic sql server port.

    How is it possible to connect sql server from remote machine without specifying port no .

    meaning If I right in ssms connection box like this publicip\instancename and give username and password , it is connecting

    but from another remote machine it is not connecting without port no. But If I connect using

    publicip\instancename , portno

    It is connecting

    Thanks

    Ghanshyam

  • I could be mistaken, but so far as I know, the whole idea of using something other than the default port number is to make it so you have to use the correct port in the connection. That's the whole idea.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • Are you allowing UDP 1434 through? Or is the SQL Browser working? Those are used to resolve the port.

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

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