Microsoft SQLServer installation example

Source: Internet
Author: User
Tags character set microsoft sql server sort
Please provide an example of installing SQL Server 4.0 on Windows NT Server 7.0 in Chinese?
2. How can I install SQL Server 7.0 in Chinese Windows 98?
3. How can I install the SQL Server 7.0 client?

[Microsoft SQL Server 7.0, hereinafter referred to as "SQL Server 7.0 」]

Please provide an example of installing SQL Server 4.0 on Windows NT Server 7.0 in Chinese?

1. Create an account for SQL Server 7.0:

Log on as a Domain Administrator, start the Domain User Manager, and select "Add user" in "user ".
) Enter the user information. For example, if the user name is SQLService, the user shall not change the password and the password is always correct (do not select the other two items ).
Add this user (domain SQL service) to the administrator Group. If the computer on which SQL Server is to be installed is not a domain controller, log on to the local computer as the local administrator and set the user to belong to the Admins group.
Set the user's power to "log on as a service" on the computer on which SQL Server is installed.
2. Install the SQL Server software:

Put autorun.exe on the SQLServer 7.0optical disk or the boot optical disk.
If you have installed Service Pack4 and Internet Explorer 4.0 Service Pack 1 in Windows NT 4.01, you can directly select "Install SQL Server 7.0 Components (Install SQL Server 7.0 component )"
Select "Install SQL Server 7.0 Components" and select "Database Server-Standard Edition 」.
In the Select Install Method dialog box, Select Local Install-Install to the Local Machine and click Next.
In the "Welcome" dialog box, click "Next.
In the "Software License Agreement" dialog box, click "Yes.
In the "User Information" dialog box, enter your name and company name, and click "Next.
The "Setup Type" dialog box appears. There are three installation types: Typical, Minimum, and Customer. Select Custom 」, in addition, the default program file and data file path of SQLServer 7.0 is msql7. You can click "Browse ...」 Button to modify. Click "Next" to continue the installation.
The Select Components dialog box appears. Select the project to be installed and click Next.
The "Character Set/Sort Order/Unicode Collation" dialog box appears. Set it by default and click "Next.
Note: the character set is simplified Chinese, and the sorting order is Dictionary. It is case sensitive (except NT). If SQL Server is used. if database X is converted to SQL 7.0, the character set and sorting order must be set to SQL Server 6. SQL Server where Database X is located 6. x settings are the same.
The "Network Libraries" dialog box appears. Select Named piped, TCP/IP Sockets, and Multi-Protocol by default, and click "Next.
In the Services Accounts dialog box, select Use the same account for each service. auto start SQL Server Service: SQL Server and SQL Server Agent use the same Account. In Service Settings, select User a Domain User Account 」, enter Username, Password, and Domain (such as the previously set SQLService), and click "Next.
The Start Copying Files dialog box appears, indicating that the installer has collected the required information. Click Next.
In the select Server mode dialog box, set "Per Server" or "Per Seat", and click "continue, click "I agree" on the "use right for each server" or "use right for each base" page, and then click "OK.
The installer copies the file to the computer.
Restart the computer after the installation is complete.
How can I install SQL Server 7.0 in Chinese Windows 98?

Put the autorun.exe file in the SQL Server 7.0 optical disk or the boot optical disk.
Click Install SQL Server 7.0 Components 」
Select "Install SQL Server 7.0 Components" and select "Database Server-Desktop Edition 」.
In the "Welcome" dialog box, click "Next.
In the "Software License Agreement" dialog box, click "Yes.
In the "User Information" dialog box, enter your name and company name, and click "Next.
The "Setup Type" dialog box appears. There are three installation types: Typical, Minimum, and Customer. Select "Custom". In addition, the program files and data files preset by SQLServer 7.0 are in msql7, you can click "Browse ...」 Button. Click "Next" to continue the installation.
The Select Components dialog box appears. Select the project to be installed and click Next.
The "Character Set/Sort Order/Unicode Collation" dialog box appears. Set it by default and click "Next.
Note: Character Set: Simplified Chinese characters, sorting order (dictionary order, case sensitive (excluding NT )).
In the "Network Libraries" dialog box, use the default settings, select TCP/IP Sockets and Multi-Protocol, and click "Next". The installer has collected installation information, click Next to copy the file to the computer.
Restart the computer after the installation is complete.
How can I install the SQL Server 7.0 client?

The installation process of the SQL Server 7.0 client tool is the same as that of SQL Server 7.0. For more information, see "examples of installing SQL Server 4.0 in Chinese Windows NT Server 7.0 ", select a custom installation method and cancel the Server Components option in the "Select Components" dialog box in Step 9.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.