Multiple Instance FAQ
How do I install multiple instances of Analysis Services?
Answer:
Unlike SQL Server, Analysis Services does not support multiple instances on a single server. It is not possible to run both OLAP Services 7.0 and Analysis Services 2000 on the same computer.
When I install multiple instances of SQL Server, where are the tools installed for each instance?
Answer:
SQL Server 2000 always installs the tools on a system drive such as the common directory in Windows NT, so you will have only one set of tools, which will be common to all instances. This set of tools works with SQL Server 7.0 servers as well as SQL Server 2000 servers, and replaces the SQL Server 7.0 tools that may already be installed on the computer.
Does the port number for an instance have to be configured during setup?
Answer:
No. During setup, you have the option of either entering the port number or allowing the server to choose the port number.
When running both SQL Server 7.0 and SQL Server 2000 on the same computer, is there any way to get the two instances to share the same user databases?
Answer:
No. The same database files cannot be used for both SQL Server 7.0 and SQL Server 2000. SQL Server 7.0 databases can be upgraded to SQL Server 2000 databases, but after the database files are upgraded, they cannot be used by the SQL Server 7.0 instance. This database upgrade is done automatically when a SQL Server 7.0 database is attached or restored to a SQL Server 2000 server. There is no way to downgrade the database files from SQL Server 2000 to SQL Server 7.0 files.