Post reply

Peculiar problem

  • August 10, 2011 at 3:24 am

    #390159

    For one SQL Server instance, I am unable to connect when I provide port number but able to connect without it when I try from client side.

    To be more clear.

    When I enter name like this : servername\instance1,1652 ,I not able to connect from client

    servername\instance1 , I am able to connect from client.

    However, when I logon to the server, I am able to connect to instance with port number specified.

    Please share your inputs regarding this, I haven't faced this issue before, What are the items we need to check.

  • August 10, 2011 at 3:36 am

    #1366439

    Is your SQL server browser running?

    Ryan
    //All our dreams can come true, if we have the courage to pursue them//

  • August 10, 2011 at 5:14 am

    #1366468

    it could be there is an alias defined , have a check.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • August 10, 2011 at 5:29 am

    #1366473

    whats the error you get when the connection fails. How are you trying to connect to the server. via SSMS or thru code ?

    Firewalls ?

    Jayanth Kurup[/url]

  • August 10, 2011 at 5:30 am

    #1366474

    Also check

    1) Protocols

    2) Firewall settings

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

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