Issues that you may encounter when you install a named instance of one or more SQL Server 2005 components and you specify different installation locations for one or more of the components

Article translations Article translations
Article ID: 933945 - View products that this article applies to.
Expand all | Collapse all

On This Page

SYMPTOMS

Consider the following scenario:
  • You install a named instance of one or more of the following Microsoft SQL Server 2005 components:
    • SQL Server Database Services
    • SQL Server Analysis Services
  • On the "Components to Install" page, you specify different installation locations for one or more of the components as follows:
    • You specify that Database Services is to be installed in a folder that is named "MSSQLServer."
    • You specify that Analysis Services is to be installed in a folder that is named "MSSQLServerOLAPService."
    Note The names of these folders are case sensitive.
In this scenario, you may encounter the following symptoms.

Symptom 1

Specific .ini files for the components that are mentioned earlier contain information as follows:
  • If you install Database Services, information that resembles the following is contained in the Perf-InstanceNamesqlctr.ini file:
    [info]
    drivername=MSSQL$InstanceName
    trusted=
    symbolfile=Drive:\MSSQL$InstanceName\MSSQL.X\MSSQL\Binn\sqlctr.h
  • If you install Analysis Services, information that resembles the following is contained in the Perf-InstanceNamemsmdctr.ini file:
    [info]
    drivername=MSOLAP$InstanceName
    symbolfile=Drive:\MSOLAP$InstanceName\MSSQL.X\OLAP\bin\msmdctr.h

Symptom 2

During the installation of SQL Server 2005, you receive the following error message:
The setup has encountered an unexpected error while installing performance counters. The error is: The specified driver is invalid.

Symptom 3

After you click Ignore when you receive the error message that is mentioned in Symptom 2, SQL Server Setup finishes its operation successfully. However, the following error message is logged in the SQLSetup0001_ComputerName_SQL.log file:
Error Code: 2001
MSI (s) (44!C4) [Time]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The specified driver is invalid.

Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The specified driver is invalid.

<Failure Type='Ignored'>

Symptom 4

If you install SQL Server 2005 Service Pack 1 (SP1) or SQL Server 2005 Service Pack 2 (SP2) afterward, you experience the following issues.

SQL Server 2005 SP1

  • When you install SQL Server 2005 SP1, you receive the following error message:
    A recently applied update, KB913090, failed to install.
  • The following error message is logged in the SQL9_Hotfix_KB913090.log file:
    Date and Time Failed to read registry key: Debug
    Date and Time MSP returned 1603: A fatal error occurred during installation.
    Date and Time Successfully opened registry key: Software\Policies\Microsoft\Windows\Installer
    Date and Time Failed to read registry key: Debug
    Date and Time Unable to install MSP file: \\ComputerName\f$\64b4ce0abc66d8453d93b0a1fa\HotFixSQL\Files\sqlrun_sql.msp
    Date and Time The following exception occurred: Unable to install Windows Installer MSP file Date and Time File: \depot\sqlvault\setupmain\setup\sqlse\sqlsedll\copyengine.cpp Line: 856
  • The following error message is logged in the SQL9_Hotfix_KB913090_sqlrun_sql.msp.log file:
    MSI (s) (C8:A0) [11:15:21:752]: Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:\WINDOWS\Hotfix\SQL9\Logs\SQL9_Hotfix_KB913090_sqlrun_sql.msp.log.
    MSI (s) (C8:A0) [Time]: Note: 1: 1729
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:A0) [Time]: Transforming table Error.
    MSI (s) (C8:A0) [Time]: Note: 1: 2262 2: Error 3: -2147287038
    MSI (s) (C8:A0) [Time]: Product: Microsoft SQL Server 2005 -- Configuration failed.
    MSI (s) (C8:A0) [Time]: Attempting to delete file C:\WINDOWS\Installer\46000.msp
    MSI (s) (C8:A0) [Time]: Unable to delete the file. LastError = 32 MSI (s) (C8:A0) [11:15:21:922]: Cleaning up uninstalled install packages, if any exist
    MSI (s) (C8:A0) [Time]: MainEngineThread is returning 1603
    MSI (s) (C8:F8) [Time]: Destroying RemoteAPI object.
    MSI (s) (C8:98) [Time]: Custom Action Manager thread ending.
    === Logging stopped: Date and Time ===
    MSI (c) (D8:04) [Time]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
    MSI (c) (D8:04) [Time]: MainEngineThread is returning 1603
    === Verbose logging stopped: Date and Time ===

SQL Server 2005 SP2

  • When you install SQL Server 2005 SP2, you receive the following error message:
    A recently applied update, KB921896, failed to install.
    Then, you continue the installation. Finally, Database Services and Analysis Services are not installed.
  • The following error message is logged in the Summary.txt file:
    Product : Database Services (SQL2005)
    Product Version (Previous): 1399
    Product Version (Final) :
    Status : Failure
    Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
    Error Number : 29528
    Error Description : MSP Error: 29528 The setup has encountered an unexpected error while Installing performance counters. The error is: The specified driver is invalid.
  • The following information is logged in the Hotfix.log file:
    Date and Time Installing file: sqlrun_sql.msp
    Date and Time Copy Engine: Creating MSP install log file at: C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Hotfix\SQL9_Hotfix_KB921896_sqlrun_sql.msp.log
    Date and Time MSP Error: 29528 The setup has encountered an unexpected error while Installing performance counters. The error is: The specified driver is invalid.
    Date and Time MSP returned 1603: A fatal error occurred during installation.
    Date and Time Copy Engine: Error, unable to install MSP file: e:\ddf143eddce69fe41b19cf97ff46\HotFixSQL\Files\sqlrun_sql.msp
    Date and Time The following exception occurred: Unable to install Windows Installer MSP file Date:
    Date and Time File: \depot\sqlvault\stable\setupmainl1\setup\sqlse\sqlsedll\copyengine.cpp Line: 800
  • The following error message is logged in the SQL9_Hotfix_KB921896_sqlrun_sql.msp file:
    <Func Name='Do_sqlPerfmon2'>
    <EndFunc Name='Do_sqlPerfmon2' Return='2001' GetLastError='2'>
    PerfTime Stop: Do_sqlPerfmon2 : Tue Mar 27 14:49:19 2007
    Gathering darwin properties for failure handling.
    MSI (s) (70!34) [Time]: Transforming table Error.
    MSI (s) (70!34) [Time]: Note: 1: 2262 2: Error 3: -2147287038
    Error Code: 2001
    MSI (s) (70!34) [Time]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The specified driver is invalid.
    Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The specified driver is invalid.
    <EndFunc Name='LaunchFunction' Return='2001' GetLastError='0'>
    MSI (s) (70:B8) [Time]: User policy value 'DisableRollback' is 0
    MSI (s) (70:B8) [Time]: Machine policy value 'DisableRollback' is 0
    Action ended Time: InstallFinalize. Return value 3

CAUSE

The Setup program performs a find-and-replace operation on the following files:
  • Perf-InstanceNamesqlctr.ini
  • Perf-InstanceNamemsmdctr.ini file
The find-and-replace operation is case sensitive. If the folder that you specify to install the component has the same name as the service name of the default instance of the component, many strings in the file will be replaced. Therefore, you receive the error message.

WORKAROUND

To work around this problem, do not install these components in the following folders:
  • A folder that is named "MSSQLServer"
  • A folder that is named "MSSQLServerOLAPService"

MORE INFORMATION

"MSSQLServer" is the default service name of the Database Services component. "MSSQLServerOLAPService" is the default service name of the Analysis Services component. These default service names are reserved for SQL Server 2005. You should not use these names as folder names.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

Properties

Article ID: 933945 - Last Review: May 10, 2007 - Revision: 2.1
APPLIES TO
  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Analysis Services
Keywords: 
kbsql2005setup kbexpertiseadvanced kbtshoot kbprb KB933945

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com