1 / 54

安装与配置 SQL Server 6.5

安装与配置 SQL Server 6.5. 全国高等学校计算机联合考试 (CCT) 天津考区 一级考试. 内 容. SQL Server 概述 SQL Server 系统安装 SQL Server 实用程序 SQL Server 服务的启动 SQL Enterprise Manager 使用 数据库管理以及 SQL 语句的使用. SQL Server 概述. Microsoft SQL Server 是为满足分布式客户服务需要而设计的一个可扩充的、高性能的数据库管理系统。

lavey
Download Presentation

安装与配置 SQL Server 6.5

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. 安装与配置SQL Server 6.5 全国高等学校计算机联合考试(CCT) 天津考区 一级考试

  2. 内 容 SQL Server 概述 SQL Server 系统安装 SQL Server 实用程序 SQL Server 服务的启动 SQL Enterprise Manager使用 数据库管理以及SQL 语句的使用

  3. SQL Server 概述 • Microsoft SQL Server是为满足分布式客户服务需要而设计的一个可扩充的、高性能的数据库管理系统。 • 它集成了Windows NT线程和调度服务、性能监视器和事件查看器。这样，用户对网络和SQL Server只需做一次Windows NT 登录，简化了用户帐号管理。

  4. Install SQL Server Installing SQL Server for Windows NT is simple. The installation is similar to the installation of nearly all Microsoft Windows products, and it'll appear familiar to you if you've installed a Windows application. You must run the setup program using an NT account that has Administrative privileges, such as the NT Administrator account.

  5. Installation Steps • To perform the installation, follow these steps: 1. Choose Run from the Start menu. 2. Type the drive letter of your CD-ROM drive, followed by setup in the run combo list box. The setup program displays one or more message boxes after checking whether you're working from an Administrative account and whether SQL Server already is installed.

  6. Installation Steps

  7. Installation Steps • 3. When you continue, you'll be prompted to enter a Name, Company, and Product ID in the Enter Name and Organization dialog box. Then click Continue.

  8. Installation Steps

  9. Installation Steps • 4. A second dialog box appears, asking you to confirm the name and company. If you want to change the name, click Change. If not, click Continue.

  10. Installation Steps

  11. Installation Steps • 5. The SQL Server 6.5 Options dialog box appears. The Install SQL Server and Utilities option is automatically selected.when you first install SQL Server, only the Install SQL Server and Utilities, Upgrade SQL Server, and Install Utilities Only options are available. Install SQL Server and Utilities installs all the SQL Server software, including the 32-bit version of the client utilities on the server. Click Continue.

  12. Installation Steps

  13. Remove SQL Server

  14. Installation Steps • 6. In the Choose Licensing Mode dialog box, you must enter the way in which you've bought licenses for the use of SQL Server, as well as the number of clients that may connect to the server. The next figure shows the entry of a server-based license that will permit a maximum of 20 connections. After you click Continue, an additional dialog box appears that requires you to confirm that you've bought the number of client licenses that you've entered.

  15. Installation Steps ③ ② ⑤ ① ④ ⑥

  16. Installation Steps • 7. In the SQL Server Installation Path dialog box that appears, confirm or change the drive and directory path for SQL Server files and click Continue. Drive C is the default.

  17. Installation Steps

  18. Installation Steps • 8. The MASTER Device Creation dialog box that appears allows you to confirm or change the entries for the MASTER device drive, directory, and the size of the MASTER device.

  19. Installation Steps

  20. Installation Steps • 9. The SQL Server Books Online dialog box appears, enabling you to define whether you want to install the online documentation to run from the hard disk or the CD. You should install the documentation on a hard drive of the server, unless you're short on disk space.

  21. Installation Steps

  22. Installation Steps • 10. The Installation Options dialog box appears, enabling you to define the Character Set, Sort Order, and Additional Network Support. important

  23. Installation Steps

  24. Installation Steps • Above of the figure, Select Auto Start SQL Server at Boot Time to automatically start SQL Server when the system is restarted. You should also select Auto Start SQL Executive at Boot Time to start the Executive processes when the server is booted.

  25. Installation Steps • 11. Click Continue. Enter a Windows NT account and password to be used by SQL Executive Service in the SQL Executive Log On Account dialog box

  26. Installation Steps

  27. Installation Steps • 12. Click Continue. A File Copy in Progress dialog box appears, showing the progress of server files as they're copied from the distribution. As the installation proceeds, additional feedback is displayed on your monitor telling you that SQL Server is installing SQL Server.

  28. Installation Steps wait

  29. Installation Steps

  30. SQL Server 6.5 program items

  31. SQL Server 实用程序 SQL Service Manager用来启动、暂停、继续和停止SQL Server服务（SQL Server,SQL Executive和MS DTC) SQL Security Manager用于管理多个SQL Server的用户帐号，SQL Server的安全性是与Windows NT集成的。 SQL Enterprise Manager为实施系统管理任务提供图形界面。可以配置服务器，管理数据库和数据库对象、配置和管理复制以及调度事件。 SQL Query

  32. Starting SQL Server with SQL Service Manager • You can use the SQL Service Manager to start MSSQLServer on the Windows NT server system. To start MSSQLServer by using the SQL Service Manager, follow these steps: • 1. Click the SQL Service Manager icon in the SQL Server for Windows NT group.2. Click Start/Continue or double-click the green light.3. Either Close the SQL Service Manager or minimize it to an icon. Note that, even if you close the service manager, SQL Server will continue running.

  33. Starting SQL Server with SQL Service Manager

  34. Using Automatic Service Startup (NT) • Configure the SQL Server services system to start automatically each time the Windows NT server system is booted.

  35. Using Automatic Service Startup (NT) • 1. Open the Control Panel.2. Double-click Services.3. In the Services dialog box, scroll down the Service list box to find MSSQLServer.4. Select MSSQLServer. The Startup should be Manual. A manual service isn't automatically started.5. Click Startup to open the Service dialog box

  36. Using Automatic Service Startup (NT) 选择控制面板 中的services

  37. SQL Enterprise Manager • Run SQL Enterprise Manager from the Microsoft SQL Server 6.5 group Register Server • From the menu, choose Server, Register Server… • From the toolbar choose the Register Server button. • Click the right mouse button on the server name, and from the drop-down menu that appears choose Register Server.

  38. Register Server

  39. Register Server • In the Server box, type the server name of the SQL Server to be registered. Or choose the List Servers button and select the server from the Select Server dialog box that appears. • Select either Use Standard Security or Use Trusted Connection. This choice determines the type of security that will be used for the connection when SQL Enterprise Manager connects as a client to the SQL Server that is being registered. • The preferred option for security is to use a trusted connection, where Windows NT security validates the user. • If you selected Use Standard Security, in the Login ID box type the login ID of a valid administrative account for that server, and in the Password box type the password for that login ID. The SA account and password can be used. If you selected Use Trusted Connection, skip this step.

  40. Server options • From the menu, choose Server, SQL Server, Configure…

  41. Server Configure • From the Server menu, choose SQL Server, Configure. When the Server Configuration / Options dialog box is displayed, click the Configuration page • To change any of the settings for the server, type the required value in the Current column and then click Apply Now. Clicking this button makes the change but leaves the dialog box displayed. If you want to apply the changes and return to the main SQL Enterprise Manager window, click OK instead.

  42. Server Configure • The user connections option controls the maximum number of user processes that can connect to the server at one time. The logical limit is 32767, but the practical limits of server hardware will probably be exceeded before this limit is ever achieved. • The minimum fixed overhead for each user connection is about 40K. If the user connections option is set to a large value, you may have to allocate more memory to the SQL Server. • If users are reporting that they cannot connect, your user connections value may be set too low.

  43. To use Enterprise Manager to change the SA pwd • From the Manage menu, choose Login… • The Manage Logins dialog box appears • In the Login name box, scroll down the list box to find sa, Select the SA login name. • In the Password box, type the new password, and then choose Modify. • The Confirm Password dialog box appears. • In the Confirm New Password box, type the new password.

  44. To use SQL Enterprise Manager to change the SA password

  45. Configure SQL Enterprise • From the Tools menu, choose preference/ configure…

  46. SQL Query Tools • Open the Query window by choosing Tools, Query Analyzer, or by clicking the appropriate toolbar button.From the resulting dialog box, select the database with which you want to work. If you had highlighted a database prior to selecting the tool, that database will already be selected.

More Related