Enterprise Beans

Contact Us

Steps and Procedure to Install MSSQL Server 2000


Applications use two components to access a database:

  • An application programming interface (API) or Uniform Resource Locator (URL).

    A database API defines how to code an application to connect to a database and pass commands to the database. An object model API is usually language independent and defines a set of objects, properties, and interfaces

    A Uniform Resource Locator is a string, or stream, that an Internet application can use to access resources on the Internet or an intranet.

  • Database language.

    A database language defines the syntax of the commands sent to the database. The commands sent through the API allow the application to access and modify data. They also allow the application to create and modify objects in the database. All commands are subject to the permissions granted to the user. SQL Server 2000 supports two languages:

    • Internet applications running on IIS can use XPath queries with mapping schemas.

    • The Transact-SQL language.

 Steps to install MSSQL Server 2000

  1. First install the MS SQL Server 2000 by clicking the setup file
  2. Now click the Next button
  3. Now select the option Local Computer and click the Next button
  4. Now choose the option Create a new instance of SQL Server, or install Client Tools and then click the Next button
  5. Now in the Name text field type your name and in the Company text field type your company name or your name. Now click the Next button
  6. Now click the Yes button
  7. Now in the text fields type the serial number and then click the Next button
  8. Now select the option Server and Client Tools and then click the Next button
  9. Now select the Default and then click the Next button
  10. Now select the option Typical and click the Next button. If you need to change the location to install this MSSQL Server 2000 then you can change the location by clicking the Browse... button
  11. Now select the option Use the same account for each service. Auto start SQL Server Service. Also select the option Use the Local System account and then click the Next button
  12. Now select the option Mixed Mode (Windows Authentication and SQL Server Authentication). Type the password in the Enter password text field and also again enter the same password in the Confirm password text field. For example, I am using franklin in the Enter password text field. And then click the Next button
  13. Now click the Next button. Now installation process will begin.
  14. Now click the Finish button

 Click for Next Topic