Post reply

SSMS Connection via IP issue

  • November 5, 2014 at 2:37 pm

    #292186

    Just installed new Instance INST02 on Sql server Cluster (2008 R2).

    For Test tried to connect (from inside box where RDPed to) using SSMS to sql server new instance:

    1.Srv_CluName\INST02- works

    2.Srv_CluName, Port#- works

    3.Srv_CluIP\INST02 or Srv_CluIP, Port#- connection failed for Windows Authentication,

    But works for Sql Server Authentication 

    Error: Timeout expired. The timeout elapse prior to completion of the operation or the server is not responding

    Checked (curiosity sake) 1-st (default= old) instance that is Active on another cluster node-

    same case- no connection via IP with Windows Authentication (but fine with sql server one)

    Any clue- what to check or fix?

    Thanks

  • November 10, 2014 at 3:58 am

    #1757386

    where have you looked to obtain the clustered instance IP address?

    You may list the VIPs using the following

    Get-ClusterResource | ?{$_.ResourceType -EQ "IP Address"} |

    Get-ClusterParameter network,address,subnetmask | ft ClusterObject,Name,Value

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • November 10, 2014 at 4:24 pm

    #1757586

    I am afraid it's not an IP issue- as I mentioned connection via IP works for sql server account (i.e. IP is correct). I mean I created test sql server account, like User "test" and connected to sql server (using SSMS) like 1.2.3.4, 1568 or 1.2.3.4\INST02- both are OK. But it does not work for any Domain account-this is a problem. Just to repeat, that using Cluster server name works for Domain accounts (and sql account) Mystery

  • November 11, 2014 at 9:08 am

    #1757714

    Yuri55 (11/10/2014)

    I am afraid it's not an IP issue

    I havent said it is yet!!

    I've asked you to list out the IPs from the cluster group!!

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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