You are the database administrator of your company. The network contains a firewall to secure the corporatenetwork. You are upgrading a SQL Server 2005 server to SQL Server 2008. However, the upgrade fails, and thefollowing error message is displayed:
SQL Server Setup could not connect to the database service for serverconfiguration.
You need to ensure that the upgrade process completes successfully without displaying this error message. What should you do?
A.
Open User Datagram Protocol (UDP) port 1434 on the firewall.
B.
Stop the process that is using TCP port 1433, and run SQL Server Setup.
C.
Enable the Microsoft Distributed Transaction Coordinator (MSDTC) service on the SQL server.
D.
Ensure that the SQL Server Browser service is running on the SQL server.
Explanation:
You should stop the process that is using TCP port 1433 and run SQL Server Setup. The error message given inthis scenario occurs when TCP port 1433 is not available during an upgrade to SQL Server 2008. To successfullyupgrade the SQL server, you should terminate the process that is using TCP port 1433 and run SQL ServerSetup. To view detailed information about the error message, you should examine the Setup log files. In SQLServer 2008, the Setup log files are located in the
<drive> :Program FilesMicrosoft SQL Server100SetupBootstrapLOG folder and its subordinate folders. Detail and summary log files, containing information abouterrors that occurred when running SQL Server Setup, are stored within the <drive> :Program FilesMicrosoftSQL Server100Setup BootstrapLOG folder. You should not open User Datagram Protocol (UDP) port 1434 on the firewall because this will not ensure that theupgrade process completes successfully without displaying the error message. UDP port 1434 must be openedwhen you want to use the SQL Browser service. The SQL Browser service allows users to connect to theDatabase Engine instances that are configured to listen on ports other than port 1433. You should not enable the Microsoft Distributed Transaction Coordinator (MSDTC) service on the SQL serverbecause this will not ensure that the upgrade process completes successfully without displaying the errormessage. MSDTC is used to administer distributed transactions. MSDTC is required on the server on which youare installing SQL Server for applications to enlist SQL Server resources in a distributed transaction. You should not ensure that the SQL Server Browser service is running on the SQL Server because this will notensure that the upgrade process completes successfully without displaying the error message. The SQL ServerBrowser service allows users to connect to the Database Engine instances that are configured to listen on portsother than port 1433.Objective:
Installing and Configuring SQL Server 2008Sub-Objective:
Install SQL Server 2008 and related services.References:
MSDN > MSDN Library > Troubleshooting an Installation of SQL Server