Where is the Install for SQL 2000 Reporting Services?
Im looking to re-install my Reporting Services for SQL 2000 and I cannot find the installation executable within the SQL CD. Does anyone have any idea where it is? Is it even included with SQL 2000? Or is it on a separate CD? Thanks.
- Di'tagapayoLv 71 decade agoFavorite Answer
2000 features a number of enhancements, such as multiple installations and distributed partitions, which will make your admin chores easier. However, to take advantage of the new capabilities, you first need to consider several installation issues. This article will explain how to properly install or upgrade to SQL Server 2000.
New in SQL Server 2000
SQL Server 2000 allows you to have multiple installations, called instances, on one machine. Each instance has its own name, services, registry entries, etc. You can install two types of instances:
* Default instance
* Named instance
A default instance is the name of your computer or the default. You can have only one default instance per computer. A named instance is any instance on a SQL Server other than the default instance. You can identify a named instance with the following format: computer_name\instance_name. All instance names can include a maximum of 16 characters and can contain any combination of letters and numbers, in addition to an underscore or an ampersand. SQL 2000 allows as many as 16 instances on a machine.
If you already have a SQL Server 7.0 installation on your computer, you have the option of keeping that as the default instance and creating a named instance for the SQL 2000 installation.
Before rushing into your installation, it is important to become familiar with the system requirements. These requirements are fairly complex and depend on a number of factors, so I recommend that you take a good look at Microsoft's Web page on SQL Server 2000 System Requirements.
Some requirements are especially important if you already have an installation of SQL Server on your system. Once you've met these requirements, you can move on to the actual installation.
* If your previous installation is SQL Server 6.5 and you want to run SQL Server 2000, you must apply Service Pack 5 (SP5) or higher to your SQL Server 6.5 installation. You must do this prior to installing SQL 2000.
* You can't run SQL 6.5 concurrently with SQL 2000. You must use the MSSQL VSwitch utility provided by Microsoft.
* You can run SQL Server 7.0 concurrently with SQL 2000 as long as you specify SQL 7.0 as the default instance.
* You should back up all databases prior to installation if you're upgrading.
Installing SQL Server 2000
The process of installing SQL Server 2000 is not going to boggle your mind. It's a simple wizard that usually allows you to finish the install in less than 30 minutes. To demonstrate, let's walk through an installation.