Simulating Multiple Connections

As I was giving a demo of the new multi-query capabilities the other day, I was asked how I had four Instances installed on one small, underpowered laptop. In fact, I don't - I have one instance of SQL Server 2005 and one Instance of SQL Server  2008 installed.

What I've done is to create two "aliases" to the same Instances I already have. You can do the same - all you have to do is open the Configuration Manager and navigate to the "SQL Native Client Configuration" node. From there click the "Aliases" object and then right-click in the open pane. Select "New Alias..." and then enter a unique name and select a protocol, address and the same Instance name you have installed. I usually pick a different connection method (such as TCP/IP or Named Pipes) than I connect with normally (Shared Memory), so that I can test network issues anyway.

Comments (0)

Skip to main content