You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows 2000 Server. The Domain.com network contains a SQL Server 2000 database server named Certkiller -DB01 that runs on Windows 2000 Server. Certkiller -DB01 contains a database named CK_Sales.
Domain.com intends migrating Certkiller -DB01 to SQL Server 2005 in the near future. To prepare for the migration, you decide to install SQL Server 2005 Express on a server named Certkiller -SR23. Certkiller -SR31 was used for previously used by application developer and contains Microsoft Visual Studio 2003, .NET Framework 1.2 and Internet Explorer 5.5. You verify that Certkiller -SR23 exceeds the minimum recommended hardware requirements for SQL Server 2005. What should you do next? (Each correct answer provides part of the solution. Choose THREE.)
A.
Upgrade Certkiller -SR23 to Windows Sever 2003 and install Service Pack 1 for Windows Sever 2003.
B.
Install Service Pack 4 for Windows 2000 Sever on Certkiller -SR23.
C.
Upgrade the .NET Framework 1.2 to .NET Framework 2.0 on Certkiller -SR23.
D.
Uninstall the .NET Framework 1.2 and install the .NET Framework 2.0 on Certkiller -SR23.
E.
Upgrade Internet Explorer 5.5 to Internet Explorer 6.0 and install Service Pack 1 for Internet Explorer 6.0 on Certkiller -SR23.
F.
Upgrade Microsoft Visual Studio 2003 to Microsoft Visual Studio 2005 and install Service Pack 1 for Microsoft Visual Studio 2005 on Certkiller -SR23.
Explanation:
SQL Server 2005 requires Service Pack 4 for Windows 2000 Sever, Internet Explorer 6.0 with Service Pack 1 and the .NET Framework 2.0. The .NET Framework 2.0 is automatically installed with other versions of SQL Server 2005 but is not automatically installed with SQL Server 2005 Express. You can upgrade .NET Framework 1.0 and upgrade .NET Framework 1.1 to .NET Framework 2.0 but .NET Framework 1.2 must be uninstalled first.
Incorrect Answers:
A: You do not need to upgrade Certkiller -SR31 to Windows Sever 2003 Service Pack 1 as SQL Server 2005 Express can be installed on a Windows 2000 Server once you install Service Pack 4 for Windows 2000 Server.
C: You can upgrade .NET Framework 1.0 and upgrade .NET Framework 1.1 to .NET Framework 2.0 but .NET Framework 1.2 must be uninstalled first.
F: SQL Server 2005 Express does not require any version of Microsoft Visual Studio.
Reference:
Microsoft SQL Server 2005 Books Online (2006), Index: installing SQL Server Express, before installing