SQL Server Q&A

Symptoms
Consider the following scenario:On a Microsoft Windows-based computer, you apply Cumulative Update 3 for SQL Server 2008 Service Pack 1 by using a slipstream installation.For more information about this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
971491?(http://support.microsoft.com/kb/971491/) Cumulative update package 3 for SQL Server 2008 Service Pack 1You tryto uninstall this cumulative update after the slipstream installation.In this scenario, the Full-Text Search component is not completely rolled back to the SQL Server 2008 Service Pack 1 version.
To confirm whether you are encountering this issue, you can check the SQL Server Full-Text Key file (Sql_fulltext_keyfile.dll) in theSQL Server 2008 Installation folder. Typically, this file is located in the following folder:
%ProgramFiles%\Microsoft SQL Server\MSQL10.<Instance Name>\MSSQLIf this file has a file version that is greater than 10.00.2531.00, the Full-Text Search component is not completely rolled back to the SQL Server 2008 Service Pack 1 version.
Resolution
To work around this problem, follow these steps: In Control Panel, open Add or Remove Programs.
Note For Windows Vista or for Windows Server 2008, open Programs and Features.In the Currently installed programs list, click Microsoft SQL Server 2008, and then click Change/Remove.
Note For Windows Vista or Windows Server 2008, right-click Microsoft SQL Server 2008, and then click Change.In the SQL Server 2008 dialog box, click Remove.Select the appropriate instance or instances, and then click Next.In the Select Features window, select Full-Text Search from the Features list.Complete the Remove SQL Server 2008 wizard, as appropriate for your configuration.Click Start, point to All Programs, point to Microsoft SQL Server 2008, point to Configuration Tools, and then click SQL Server Installation Center.Click Installation, and then click New SQL Server stand-alone installation or add features to an existing installation.In the Browse For Folder dialog box, locate the SQL Server 2008 installationfolder that you want, and then click OK.In the SQL Server 2008 Setup window,click Next to move to the Installation Type phase.Click Add Features to an existing instance of SQL Server 2008, select the appropriate instance in the drop-down list, and then click Next to move to the Feature Selection phase.Select Full-Text Search from the Features list.Follow the steps in the Full-Text Search installation wizard.Note There is no workaround for cluster scenarios. To roll back the cumulative update, you must reinstall the clustered instance of SQL Server.

Symptoms
When you try to install a version of MicrosoftSQL Server 2005 that has been downloaded from the Microsoft Web site, you receive the following error message:

Could not find a package to install on the installation media.Additionally, error messages that resemble the following may be logged in the SQLSetupNumber_ServerName_Core(local).log file:

2005/9/30 10:5:19Error: Action “DeterminePackageTransformsAction” threw an exception during execution.
Failed to open package to determine installing product code : 110NotesThe SQLSetupNumber_ServerName _Core(local).log file is located in the C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files folder.Number is a placeholder for a number that increases for every installation of SQL Server 2005. The log file that has the largest value for Number in the file name is the log file for the most recent installation of SQL Server 2005.
Resolution
This problem occurs because a Sqlrun_*.msi file in the Setup folder on the SQL Server 2005 Setup media is corrupted. For example, the Sqlrun_NS.msi file is corrupted. Therefore, the Setup program cannot open the corrupted package during the installation and returns error code 110.

Symptoms
Microsoft SQL Server does not support the installation or use of SQL Server Failover Clustering on Microsoft Windows Server 2003-based server clusters or on Windows Server 2008-based server clusters if the server clusters have Terminal Server installed. This configuration was known as Application Mode in Microsoft Windows 2000. However, SQL Server 2000 instance installation is supported as a stand-alone instance for Windows Server 2003 or Windows Server 2008 Terminal Services Mode (Application Mode).
For Windows Server 2003 or Windows Server 2008 Terminal Server Remote Desktop for Administration Mode, SQL Server 2000 installation is fully supported as both a clustered instance and a stand-alone instance.
Note Cluster instances for the versions of SQL Server that are listed in the “Applies To” section are currently not supported on Windows Server 2003 or Windows Server 2008 Terminal Server Server Cluster installations.
Resolution
Terminal Server provides remote computers with access to Windows-based programs running on the following systems:Windows Server 2003 Standard Server Windows Server 2003 Enterprise Server Windows Server 2003 Datacenter ServerWindows Server 2008 Standard Server Windows Server 2008 Enterprise Server Windows Server 2008 Datacenter ServerWith Terminal Server, you can provide a single point of installation that gives multiple users access to any computer that is running one of the operating systems listed earlier. Users can run programs, save files, and use network resources, all from a remote location as if these resources were installed on their own computers. This functionality is now available on server clusters in Windows Server 2003.
Remote Desktop for Administration is another part of the Terminal Services technology that is offered in Windows Server 2003 or in Windows Server 2008. You can enable remote administration of servers with Remote Desktop for Administration on any computer that is running the Windows Server 2003 or Windows Server 2008 family of products, even if Terminal Server is not installed.
Note In Microsoft Windows 2000 Server, the Terminal Server component is named Terminal Services in Application Server mode. In Microsoft Windows 2000 Server, the Remote Desktop for Administration component is named Terminal Services in Remote Administration mode.
To determine whether the Terminal Server service is running on the computer, follow these steps:Open Control Panel.Double-click Add/Remove Programs.On the left side of the screen, double click Add/Remove Windows Components.Under Components, scroll down the list until you find Terminal Server. If Terminal Server is not selected, the service that is running is the “Remote Desktop” service and you can continue with your SQL Server installation. If Terminal Server is selected, you must clear the check box to remove the Terminal Server service in the application before you continue with the SQL Server installation.For more information about the supportability of SQL Server failover clusters on Windows Server 2003 clusters, click the following article number to view the article in the Microsoft Knowledge Base:
313037?(http://support.microsoft.com/kb/313037/) Upgrading SQL Server clusters to Windows Server 2003
Example log behavior if Terminal Server is installedIf Windows Server 2003 Terminal Server is installed and you try to install SQL Server, no log files exist in the %windir% folder. However, the log files are stored in the %userprofile%\Windows folder. When you check the log files and you compare the log to the system variables, you see results that are similar to the following in the Sqlstp.log file:

19:41:44 Begin Action: SetupInstall19:41:44 Reading Software\Microsoft\Windows\CurrentVersion\CommonFilesDir …19:41:44 CommonFilesDir=C:\Program Files\Common Files19:41:44 Windows Directory=C:\Documents and Settings\&lt;user_name&gt;\WINDOWS\ 19:41:44 Program Files=C:\Program Files\19:41:44 TEMPDIR=C:\DOCUME~1\<user_nam~1>\LOCALS~1\Temp\1\From system variables – USERPROFILE=C:\Documents and Settings\<user_name> windir=C:\WINDOWSNote This example does not apply to servers that are running Windows 2003 Service Pack 1 (SP1) or a later version. We recommend that youcheck manuallyfor a Windows directory in the %USERPROFILE% directory.

Symptoms
On a server that is running only one instance ofMicrosoft SQL Server 2008, you open the SQL Server Installation Center. Then, you remove the instance in Add or Remove Programs inWindows Server 2003 or in Program and FeaturesinWindows Server 2008. When you close the SQL Server Installation Center after you remove the instance, you may receive the following error message:

SQL Server Setup has encountered the following error:
Unable to generate a temporary class (result=1).
error CS0006: Metadata file ‘C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\CTP6\x64\Microsoft.SqlServer.Configuration.SqlServer_ConfigExtension.dll’ could not be found
error CS0006: Metadata file ‘C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\CTP6\x64\Microsoft.SqlServer.Configuration.SqlConfigBase.dll’ could not be found
error CS0006: Metadata file ‘C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\CTP6\x64\Microsoft.SqlServer.Chainer.Infrastructure.dll’ could not be found
error CS0006: Metadata file ‘C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\CTP6\x64\Microsoft.SqlServer.Configuration.Sco.dll’ could not be found
error CS0006: Metadata file ‘C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\CTP6\x64\Microsoft.SqlServer.Configuration.Sfc.dll’ could not be found
error CS0006: Metadata file ‘C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\CTP6\x64\Microsoft.SqlServer.Configuration.dll’ could not be found
error CS0006: Metadata file ‘C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\CTP6\x64\Microsoft.SqlServer.Configuration.SString.dll’ could not be found
Error code 0×84B10001.You may also receive this error message in the following scenario:A server is running an instance of a SQL Server 2008 failover cluster.There are no other instances ofSQL Server 2008 or of a SQL Server 2008 failover cluster running on the server.In the SQL Server Installation Center, you remove the last node of the instance of a SQL Server 2008 failover cluster.After you remove the last node, you may receive this error message when you close the SQL Server Installation Center.
Resolution
This problem occurs because the SQL Server Setup Wizard removes the files that are required by the SQL Server Installation Center. When you close SQL Server Installation Center, the SQL Server Installation Center may load these files. However, the SQL Server Installation Center cannot find these files.