I have 2 instances of SQL Servers: SQL Server 2008 and SQL Server Express 2012 on the same computer.
I'm trying to configure them both to use TCP/IP and I've noticed that changing the port number for one of the servers effects the port number of the second.
How should I configure both:
- using same IP and different port (currently getting connection refused)?
- using 2 different IP addresses (like 10.0.0.1 and 10.0.0.2) on default port (trying this seems to direct everything to the first server...)?