单选题You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client comp

题目
单选题
You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However, client computers cannot connect to the SQL Server instance. You need to identify the most likely cause of the connection issues. What should you do first?（）
A

Ensure that port 1433 is open in your firewall. 

B

Ensure that port 443 is open in your firewall. 

C

Ensure that client computers connect by using Shared Memory protocol. 

D

Ensure that the server is not paused.

相似考题

1.You are the administrator of two Microsoft Windows 2000 computers. One computer is running Internet Information Services (IIS), and the other is running SQL Server 2000. Company partners need to connect by means of the Internet and query data stored on the SQL Server computer. Some of these partners have computers that do not use Microsoft operating systems or Web browsers.You need to configure the IIS and SQL Server 2000 computers to allow access to data by means of the IIS virtual directory. IIS uses Basic Authentication to allow access to the virtual directory.Only company partners should have access to the SQL Server computer by means of the Internet. The partners should not be allowed to make ad hoc queries. You want to be able to audit successful and failed logins to the SQL Server computer.You want to allow the partners access to the SQL Server computer while keeping your security scheme as simple as possible. Which two actions should you take? (Each correct answer represents part of the solution. Choose two.)A．Configure the IIS virtual directory to allow URL queries.B．Configure the IIS virtual directory to allow template queries.C．Create a new Windows user account. Create a corresponding Windows Authenticated login on the SQL Server computer. Configure the IIS virtual directory to always use this login when connecting to the SQL Server computer.D．Create a Windows Authenticated login on the SQL Server computer for the IIS Internet Guest Account. Configure the IIS virtual directory to always use the Internet Guest Account when connecting to the SQL Server computer.E．Create a Windows Authenticated login for each company partner on the SQL Server computer. Configure the IIS virtual directory to use Windows Integrated Authentication when connecting to the SQL Server computer.

2.You are the administrator of several SQL Server 2000 computers. You want to retrieve information from an archived inventory database. You have a full tape backup of the database. The backup’s header information shows that the backup uses the SQL_Latin1_General_CR437_BIN collation.However, the existing SQL server computers in your office are configured to use theSQL_Latin1_General_CP1_CI_AS collation.You do not want to join tables in the inventory database with tables in other databases. You need to restore the inventory database to a SQL Server 2000 computer by using the least amount of administrative effort.What should you do?A．Use the rebuildm utility to rebuild the system database on an existing SQL server computer. Configure all the databases on that server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the server.B．Restore the inventory database to an existing SQL server computer. Accept the SQL_Latin1_General_CR437_BIN collation for that database.C．Install a new named instance of SQL Server 2000 on an existing SQL Server 2000 computer. Configure the named instance to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the named instance.D．Install SQL Server 2000 on a new computer. Configure the new server to use the SQL_Latin1_General_CR437_BIN collation. Restore the inventory database to the new server.

3. You are the administrator of Company.com's Windows 2000 Network. The routed TCP/IP network that you administer consists of 10 Windows 2000 Server computers and 75 Windows 2000 Professional computers. All computers are members of a single Windows 2000 domain named Company.com. TCP/IP is the only network protocol used at Company's office. You have recently installed 10 new Windows 2000 Professional computers and you want to enable the new computers to use host names to connect to shared resources on the network. You configure a TCP/IP address and a gateway address on each new computer. You want to complete the configuration to allow the computers to communicate on the network.  What should you do?（）A、Configure a DNS suffix.B、Configure a subnet mask.C、Configure an LMHOSTS file.D、Configure an Interface metric.E、Configure at least one DNS address.

4.You are the administrator of Microsoft Windows 2000 computer. You are preparing to install SQL Server 2000 on the computer.Your company contains a variety of client computers that will connect to the SQL server 2000 computer by using a specific Net-Library, as shown in the following table.You need to allow the client computers to connect to the SQL Server 2000 computer. You also want to minimize the number of configuration changes required on the client computers.Which three actions should you take? (Each correct answer presents part of the solution. Choose three)A. Install SQL Server 2000 as a named instance.B. Install SQL Server 2000 as the default instance.C. Configure the new instance for Mixed Mode Authentication.D. Configure the new instance for Windows Authentication.E. Configure the server to use the Named Pipes, IPX/SPX, and TCP/IP Net-Libraries.F. Configure the server to use the Multiprotocol Net-Library.

更多“You configure a new SQL Server 2005 computer to use TCP/IP w”相关问题

  • 第1题：

    You are the administrator of a Windows 2000 network. You install Windows 2000 Professional on a new computer and configure the TCP/IP settings to have a static IP address. While testing network connectivity from the new computer, you discover an error in the DNS server address that is configured in the TCP/IP settings. You configure the correct DNS server address, which is 10.1.1.5. However, you are still unable to successfully connect to network resources by name. You run the IPconfig/all command. The results indicate that the DNS server address is now configured as 0.0.0.0 You need to ensure that the computer can connect to network resources by name. What should you do?（）

    • A、Stop and restart the DNS Client service.
    • B、Add 10.1.1.5 to the DNS server list on the TCP/IP Advanced Properties tab.
    • C、Add an A （host） record for the computer to the DNS server’s zone file.
    • D、Configure your DHCP server to have a DNS server address of 10.1.1.5.

    正确答案:A

  • 第2题：

    Your routed TCP/IP network consists of 10 Windows 2000 Server computers and 75 Windows 2000 Professional computers. Your network uses TCP/IP as the only network protocol. You are installing 10 new Windows 2000 Professional computers. You want to enable the new computers to use NetBIOS names to connect to all shared resources as the network. You configure a TCP/IP address and a subnet mask on each new computer. Which 2 additional TCP/IP properties should you configure on each new computer？（）

    • A、The bindings.
    • B、A DNS address.
    • C、A Gateway address.
    • D、A WINS server address.
    • E、A DHCP server address.

    正确答案:C,D

  • 第3题：

    The network at Company Ltd. consists of one Windows NT Server 4.0 domain and 35 Windows 2000Professional computers. The Company network consists of five interconnected TCP/IP subnets. All of thecomputers use TCP/IP as the only network protocol.You are adding 15 Windows 2000 Professional computers to the network. You want to enable theWindows 2000 Professional computers to resolve NetBIOS names to TCP/IP addresses.What should you do？ （）

    • A、Install a DHCP server. Configure each computer to use DHCP. 
    • B、Install a WINS server. Configure each computer to use WINS. 
    • C、Create a Lmhosts.sam file on each computer. Add an entry containing the TCP/IP address and  NetBIOS name for each computer on the network. 
    • D、Create a Hosts.sam file on each computer. Add an entry containing the TCP/IP address and NetBIOS name for each computer on the network. 

    正确答案:B

  • 第4题：

    You want to configure your Windows 2000 Professional computer to remotely access your company's Windows 2000 Routing and Remote Access server. You configure a VPN connection. For security purposes, you configure the VPN connection to use MS-CHAP v2 only and to require encryption. You also configure TCP/IP to obtain an IP address automatically, to enable IPSec, and to set IPSec to Secure Server.  When you try to connect, you receive the following error message, "The encryption attempt failed because no valid certificate was found."  What should you do to connect to the server? （）

    • A、Enable the VPN connection to use MS-CHAP.
    • B、Change the data encryption setting toOptional Encryption.
    • C、Specify a TCP/IP address in theNetworkproperties.
    • D、Change the IPSec policy setting toClient.

    正确答案:D

  • 第5题：

    You configure a W2kPro with static IP. You found an error in DNS server address. You configure DNS address to 10.1.1.5. But the W2kPro is still unable to connect to the network resource by name. You run ipconfig /all and see that DNS server address is：0.0.0.0 What do you do？ （）

    • A、Stop and Restart DNS client service.
    • B、Add 10.1.1.5 to DNS server list on TCP/IP advanced properties tab.  
    • C、Add A （host） record for the computer to the DNS server zone file.  
    • D、Configure DHCP server to have a DNS server address of 10.1.1.5

    正确答案:A

  • 第6题：

    Network topology exhibit: You are the administrator at ExamSheet.net.  You use TCP/IP as the only protocol on your network. The network is configured as in the network topology exhibit. All existing computers and devices use 255.255.240.0 as the subnet mask. You install Windows 2000 Professional on a computer named ExamSheet2. You configure ExamSheet2 to have a TCP/IP address of 10.10.20.234, a default gateway of 10.10.20.1, a subnet mask of 255.255.0.0 and a WINS server address of 10.10.13.10. You cannot connect to  shared resources on ExamSheetB by using its UNC name. You want ExamSheet2 to be able to connect to ExamSheetB. What should you do? （）

    • A、Install a WINS server on the same segment as Company2
    • B、Install and configure a DNS server and configure Company2 to use the DNS Server service.
    • C、Configure Company2 with a default gateway address 10.10.13.1.
    • D、Configure Company2 with a default gateway address of 10.10.30.1.
    • E、Configure Company2 with a TCP/IP address of 10.10.20.234.

    正确答案:E

  • 第7题：

    You install Windows 2000 Professional on your portable computer. You create a new dial up connection to connect to your company’s remote access server. You connect to the remote access server by using the dial up connection. You can connect to the servers on the same segment as the remote access server. You cannot access the shared resources that are on the remote segments from the remote access server. What should you do？ （）

    • A、Configure the company remote access server to accept multilink connections.
    • B、Configure the TCP/IP program for the dial up connection to disable IP header compression.
    • C、Configure the TCP/IP properties for the dial up connection to use the default gateway on theremote network.
    • D、Grant your user account dial in permission on the company remote access server.

    正确答案:C

  • 第8题：

    You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）

    • A、You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 
    • B、You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 
    • C、You should upgrade the SQL Server 2005 application to use SQL Server 2008. 
    • D、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 

    正确答案:A

  • 第9题：

    单选题
    You are the network administrator for Company.  Your network consists of one Windows NT Server 4.0 domain and 35 Windows 2000 Professional computers. The network consists of five interconnected TCP/IP subnets. All of the computers use TCP/IP as the only network protocol. You are adding 15 Windows 2000 Professional computers  to the network.   You configure each of the new computers to use DHCP. The computers can communicate with each other but are unable to communicate outside their own subnet.    You run the ipconfig command to examine the UP address on one of the new computers. The IP address is 169.254.101.72   You want to enable the Windows 2000 Professional computers to communicate outside their own subnet.   What should you do?（）
    A

    Install a DHCP server.

    B

    Install a WINS server. Configure each computer to use WINS.

    C

    Create an Lmhost file on each computer.

    D

    Create a Hosts file on each computer.


    正确答案： C
    解析： 暂无解析

  • 第10题：

    单选题
    You are the network administrator for ExamSheet. Your network consists of one Windows NT Server 4.0 domain and 35 Windows 2000 Professional computers. The network consists of five interconnected TCP/IP subnets. All of the computers use TCP/IP as the only network protocol. You are adding 15 Windows 2000 Professional computers to the network. You configure each of the new computers to use DHCP. The computers can communicate with each other but are unable to communicate outside their own subnet. You run the ipconfig command to examine the IP address on one of the new computers. The IP address is 169.254.101.72 You want to enable the Windows 2000 Professional computers to communicate outside their own subnet. What should you do？（）
    A

    Install a DHCP server.

    B

    Install a WINS server. Configure each computer to use WINS.

    C

    Create an Lmhost file on each computer.

    D

    Create a Hosts file on each computer.


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （）
    A

    You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 

    B

    You should upgrade the SQL Server 2005 application to use SQL Server 2008 

    C

    You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 

    D

    You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 


    正确答案： A
    解析： 暂无解析

  • 第12题：

    多选题
    You are the administrator of Company.com’s Windows 2000 Network.  Your routed TCP/IP network consists of 10 Windows 2000 Server computers and 75 Windows 2000 Professional computers. All computers are in the Company.com domain. Your network uses TCP/IP as the only network protocol. You are installing 10 new Windows 2000 Professional computers. You want to enable the new computers to use host names to connect to shared resources on the network. You configure a TCP/IP address, a gateway address and a subnet mask on each new computer.   You want to complete the configuration to allow the computers to communicate on the network.  What should you do?（）
    A

    Configure a HOSTS file.

    B

    Configure a LMHOSTS file.

    C

    Configure a WINS server database.

    D

    Configure a DHCP server address.

    E

    Configure at least one DNS address.


    正确答案： A,D
    解析： 暂无解析

  • 第13题：

    You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server.  Which two protocols can you use to achieve this goal？（）

    • A、Named Pipes
    • B、TCP/IP
    • C、Shared Memory
    • D、Virtual Interface Adapter （VIA）
    • E、Multiprotocol

    正确答案:A,B

  • 第14题：

    You are the administrator of Company.com’s Windows 2000 Network.  Your routed TCP/IP network consists of 10 Windows 2000 Server computers and 75 Windows 2000 Professional computers. All computers are in the Company.com domain. Your network uses TCP/IP as the only network protocol. You are installing 10 new Windows 2000 Professional computers. You want to enable the new computers to use host names to connect to shared resources on the network. You configure a TCP/IP address, a gateway address and a subnet mask on each new computer.   You want to complete the configuration to allow the computers to communicate on the network.  What should you do?（）

    • A、Configure a HOSTS file.
    • B、Configure a LMHOSTS file.
    • C、Configure a WINS server database.
    • D、Configure a DHCP server address.
    • E、Configure at least one DNS address.

    正确答案:A,E

  • 第15题：

    You are the network administrator for Company. Company has recently upgraded its network to a 100Mbps standard and you are now in the process of removing all the old adapter and installing a new Token Ring network adapter into the Windows 2000 Professional computer. On the first computer you install the new hardware and configure the static TCP/IP protocol settings to be the same as they were for the previously installed network adapter. When you restart the computer, however, you cannot access the network. You try to ping your network adapter's TCP/IP address locally. You receive the following error message: "Request timed out." You want to enable the computer to communicate on the new network. What should you do? （）

    • A、Enable DHCP in the TCP/IP properties.
    • B、Replace the Token Ring network adapter with an Ethernet network adapter.
    • C、Configure a different TCP/IP address on the same subnet.
    • D、Configure a valid DNS Server in the TCP/IP properties.

    正确答案:B

  • 第16题：

    You configure a new SQL Server 2005 computer to use TCP/IP with all default settings. Your corporate policy requires that each server use a firewall. You find that you can connect to the SQL Server instance from the local computer. However， client computers cannot connect to the SQL Server instance.You need to identify the most likely cause of the connection issues. What should you do first？（）

    • A、Ensure that port 1433 is open in your firewall.
    • B、Ensure that port 443 is open in your firewall.
    • C、Ensure that client computers connect by using Shared Memory protocol.
    • D、Ensure that the server is not paused.

    正确答案:A

  • 第17题：

    ou work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now for a new application, a SQL Server 2008 instance has to be installed on an existing server. The server contains a default SQL Server 2005 instance. Your company CIO wants their corresponding certified third-party applications can access to both database instances. The company assigns this task to you. You must achieve this by using as little database administrative effort as possible, and never change the existing application environments. What should you do? （） 

    • A、You should install SQL Server 2008 as the default instance, and configure the new application to use the default instance 
    • B、You should upgrade the SQL Server 2005 application to use SQL Server 2008 
    • C、You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance 
    • D、You should install SQL Server 2008 as a named instance, and make the new application use the new instance. 

    正确答案:D

  • 第18题：

    You are preparing for a new installation of SQL Server 2005. You need to select the protocols that client computers might use to connect to the server. Which two protocols can you use to achieve this goal?（）

    • A、 Named Pipes 
    • B、 TCP/IP 
    • C、 Shared Memory 
    • D、 Virtual Interface Adapter (VIA) 
    • E、 Multiprotocol 

    正确答案:A,B

  • 第19题：

    You configure a new file server that runs Windows Server 2008. Users access shared files on the file server. Users report that they are unable to access the shared files. The TCP/IP properties for the file server are configured as shown in the following exhibit.（exhibit not there again wtf!） You need to ensure that users are able to access the shared files. How should you configure the TCP/IP properties in the file server？（）

    • A、Configure a static IP address
    • B、Configure the default gateway
    • C、Configure the DNS server address
    • D、Add the domain to the DNS suffix on the network interface

    正确答案:A

  • 第20题：

    多选题
    Your routed TCP/IP network consists of 10 Windows 2000 Server computers and 75 Windows 2000 Professional computers. Your network uses TCP/IP as the only network protocol. You are installing 10 new Windows 2000 Professional computers. You want to enable the new computers to use NetBIOS names to connect to all shared resources as the network. You configure a TCP/IP address and a subnet mask on each new computer. Which 2 additional TCP/IP properties should you configure on each new computer？（）
    A

    The bindings.

    B

    A DNS address.

    C

    A Gateway address.

    D

    A WINS server address.

    E

    A DHCP server address.


    正确答案： C,E
    解析： 暂无解析

  • 第21题：

    单选题
    You work in a company which uses SQL Server 2008. You are the administrator of the company database. In your company there is a server which contains a default SQL Server 2005 instance. For a new application, you have to install a SQL Server 2008 instance on the server. Your company CIO assigns a task to you. You must make sure that the respective certified third-party applications have access to both database instances. You have to achieve this goal without changing the existing application environments. So what should you do to achieve this by using as little database administrative effort as possible?（）
    A

    You should install SQL Server 2008 as a named instance, and make the new application to use the new instance. 

    B

    You should install SQL Server 2008 as the default instance, and make the new application to use the default instance. 

    C

    You should upgrade the SQL Server 2005 application to use SQL Server 2008. 

    D

    You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance. 


    正确答案： B
    解析： 暂无解析

  • 第22题：

    单选题
    You configure a W2kPro with static IP. You found an error in DNS server address. You configure DNS address to 10.1.1.5. But the W2kPro is still unable to connect to the network resource by name. You run ipconfig /all and see that DNS server address is：0.0.0.0 What do you do？ （）
    A

    Stop and Restart DNS client service.

    B

    Add 10.1.1.5 to DNS server list on TCP/IP advanced properties tab.  

    C

    Add A （host） record for the computer to the DNS server zone file.  

    D

    Configure DHCP server to have a DNS server address of 10.1.1.5


    正确答案： D
    解析： 暂无解析

  • 第23题：

    单选题
    You need to design the consolidation plan for SQL1， SQL2， and SQL3. You need to identify the appropriate combination of SQL Server instances and SQL Server 2005 computers that are needed to fulfill the company’s consolidation plans and security requirements.Which combination should you use？（）
    A

    one SQL Server 2005 computer with one instance

    B

    two SQL Server 2005 computers， each with two instances

    C

    two SQL Server computers， one with one instance and one with three instances

    D

    one SQL Server 2005 computer with two instances


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    You are the administrator of a Windows 2000 network. You install Windows 2000 Professional on a new computer and configure the TCP/IP settings to have a static IP address. While testing network connectivity from the new computer, you discover an error in the DNS server address that is configured in the TCP/IP settings. You configure the correct DNS server address, which is 10.1.1.5. However, you are still unable to successfully connect to network resources by name. You run the IPconfig/all command. The results indicate that the DNS server address is now configured as 0.0.0.0 You need to ensure that the computer can connect to network resources by name. What should you do?（）
    A

    Stop and restart the DNS Client service.

    B

    Add 10.1.1.5 to the DNS server list on the TCP/IP Advanced Properties tab.

    C

    Add an A （host） record for the computer to the DNS server’s zone file.

    D

    Configure your DHCP server to have a DNS server address of 10.1.1.5.


    正确答案： C
    解析： 暂无解析

相关内容