I have 2 SQL named instances on a SQL Server, trying to add aliases for both so that application teams can use the alias names in their connection strings.
There are 2 IP Addresses assigned for the server. 10.10.1.1, 10.10.1.2
I've assigned 10.10.1.1 to ServerName\Instance1 and 10.10.1.2 to ServerName\Instance2. Ports for the instances are 1433 and 1435 respectively
I have created 2 aliases from the SQL Server Configuration Manager: Test1, Test2
A DNS entry has also been created with IP Address specified for each alias.
Connections work only with Test1. I or the application team is unable to connect to Test2 instance.
How do I fix this?