I have configured hostname aliases for 3 different instances (2 2008r2 & 1 2012) on the same physical server. After configuring, ON THE SERVER, 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,