Post reply

Have to enter the port to connect via management studio

  • August 19, 2012 at 8:20 pm

    #265481

    A strange problem has cropped up in our enviornment that I'm kind of scratching my head about. Why all of a sudden would users who connect via Management Studio or Query tools have to enter the port to connect to SQL Server? Ideas of what to look at?

  • August 19, 2012 at 11:19 pm

    #1527439

    I think SQL Server Browser service has stopped.

  • August 20, 2012 at 2:06 am

    #1527461

    i go with suresh.

    Regards
    Durai Nagarajan

  • August 20, 2012 at 5:13 am

    #1527515

    If SQL Server Browser Services is stopped then you have to specify the port number when connecting to that SQL Server instance.

  • August 20, 2012 at 5:18 am

    #1527519

    No, checked for that. The Browser services is running on all systems where this is occurring.

  • August 20, 2012 at 5:58 am

    #1527534

    is "named pipes" enabled in sql configuration manager

    Regards
    Durai Nagarajan

  • August 21, 2012 at 12:26 am

    #1527945

    If you specifically set the Network Protocol in the 'Connection Properties' of SSMS to be 'TCP/IP', do you still need the port?

    If you connect via sqlcmd, do you need the port?

    Do you have any aliases set up in Configuration Manager?

  • August 28, 2012 at 12:55 pm

    #1531030

    check for UDP port 1434 not being blocked by a firewall.

  • August 28, 2012 at 1:37 pm

    #1531049

    Thanks for the responses. I will pass it along. It appears to be a security issue only happening to laptop users coming in via the VPN.

Viewing 9 posts - 1 through 8 (of 8 total)

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