"If there are more than one instances running on the same machine, in that case either you have to start SQL Server Browser service or provide the port number along with IP (or server name) and instance name, to access any other instance than default.
If SQL Server Browser service is stopped and IP along with port number is not provided then connection will be refused.
If SQL Server instance is configured using dynamic ports then browser service is required to connect to correct port number."