Instance failure. (System.Data) After configuring hostname alias

• daigia_dzadzich

  SSC Veteran

  Points: 283

  More actions

  October 30, 2014 at 12:38 pm

  #294815

  Hi,

  I have configured hostname aliases for 3 different instances (2 2008r2 & 1 2012) on the same physical server. After configuring, ON THE SAME SQLSERVER, i'm able to connect to all instances using either virtual hostname alias or physical-hostname\instance. However, when i'm sitting at my desk or some other computers, i'm unable to connect to only hostname\instance of sql2012.

  Here is the error when connecting through SSMS:

  Cannot connect to servername\instance. Instance failure. (System.Data).

  Any helps/ideas are appreciated.

  Thanks in advance,

  -Chris

• daigia_dzadzich

  SSC Veteran

  Points: 283

  More actions

  November 4, 2014 at 2:28 pm

  #1756615

  Any ideas/responses? The issue is still standing & so sporadic, so i can't deploy the configuration to production 🙁