Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P22: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | Configuring SQL Server 2008 Chapter 3 87 In Figure 3.1 you can see the installation screen for a default instance showing the instance ID. You can also see that two named instances are already installed PLUTO SQL1 and PLUTO SQL2. You don t have to have a default instance installed to install or use named instances. Figure 3.1 Installation Screen for Default Instance with Two Named Instances Already Installed If you take a look at the directory structure after the installation in Figure 3.2 you ll see separate directories for each instance as well as each installation of Analysis Services and Reporting Services. There are also three directories called 80 90 and 100 which contain components that are shared across all instances such as the Management Tools. 80 and 90 hold SQL Server 2000 and SQL Server 2005 components for backward compatibility and 100 contains the SQL Server 2008 shared components including SQL Server Integration Services if it s installed. SQL Server Integration Services is not instance aware so you can only have one installation on a server. 88 Chapter 3 Configuring SQL Server 2008 Figure 3.2 Directory Structure for Three Instances with Analysis Services and Reporting Services The default instance will listen on TCP port 1433 by default and named instances use dynamic port allocation. The SQL Browser Service listens on UDP port 1434 and is responsible for determining the correct port when you try to connect. If the SQL Browser Service isn t running you will need to specify a unique TCP port for each instance to listen on using SQL Server Configuration Manager which is detailed in the next section. Once you know which port your instance listens on you can specify it in your connection string. For example if you configured PLUTO SQL1 to listen on port 53000 you would connect using PLUTO SQL1 53000. You don t normally have to do this because the SQL Browser Service is installed and runs automatically but it is sometimes disabled to tighten security. .
