Search questions and share your knowledge with the world here on Questionpoint.
Home > SQL Server Reporting Services (SSRS) Interview Questions > Where is the Install for SQL 2000 Reporting Servic...

:: Categories ::

Interview Question in SQL Server Reporting Services (SSRS)


 

Interview Question :: Where is the Install for SQL 2000 Reporting Services


Hi,

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.
Answers to "Where is the Install for SQL 2000 Reporting Services"
RE: Where is the Install for SQL 2000 Reporting Services?

SQL Server

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.

Author's note

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.



Prerequisites

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.
 
Vote for this answer ::  
Update Alert Setting

Top Tags



- Sharepoint Developer Interview Questions - Java Interview Questions - J2EE Interview Questions - ASP.NET Interview Questions - MOSS 2007 Interview Questions - WPF Interview Questions - Microsoft CRM Interview Questions - Technical Interview Questions for Programmers
Home | Terms Of Service | Contact Us | Site Blog | Investors | Advertise With Us | Disclaimer | Privacy Policy | Questionpoint Widget
© Questionpoint 2008 User-posted content, unless source quoted, is licensed under a Creative Commons Public Domain License