全国高校计算机联合考试- 安装与配置SQL SERVER 6.5教程教案.pptVIP

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 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. Starting SQL Server with SQL Service Manager Using Automatic Service Startup (NT) Configure the SQL Server services system to start automatically each time the Windows NT server system is booted. 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 isnt automatically started.5. Click Startup to open the Service dialog box Using Automatic Service Startup (NT) 选择控制面板 中的services 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. Register Server 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 c