We are creating an offline version of all of our web apps and SQL server
databases for a fully disconnected training / demo session.

IIS 5 Web Server Hosting Multiple Websites -> Copied to laptop server

4 Separate SQL Server Database Servers -> Copied to laptop server


All to be copied to single laptop server for training demo and run
disconnected on single machine.


Because of our setup, it would be ideal if on this disconnected laptop, we
could allow multiple aliases or names directing to this single SQL server.
So that

SELECT * FROM Svr1.db1.dbo.myTable

SELECT * FROM Svr2.db2.dbo.myTable2

Both work where db1 and db2 are databases that will both exist on the same
server (SQL 2000).


Can a SQL server have multiple names or aliases?
Or create a remote server connection to itself as a different name?


Thanks,
-Steve

OK, found my solution.

SQL 2000 allows multiple instances of SQL Server to be installed.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsqlmag2k/
html/MultipleInstances.asp

Installed 4 instances of SQL server on the stand alone server. Then in the
client network utility on the stand alone server, I setup an alias pointing
to each of the instances with an alias name the same as the live server.

-Steve