You are the administrator of your company network. You have to install a SQL Server 2008 instance for a new application on an existing server. The server contains a default SQL Server 2005 instance. You must make sure that certified third-party applications have access to their respective database instances. You have to ensure that when you take measures to achieve this, the existing application environments will not be changed, and you should use as little database administrative effort as possible. So what should you do?
A.
You should upgrade the SQL Server 2005 application to use SQL Server 2008.
B.
You should upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
C.
You should install SQL Server 2008 as a named instance. Configure the new application to use the new instance.
D.
You should install SQL Server 2008 as the default instance. Configure the new application to use the default instance.