Microsoft KB Archive/919224: Difference between revisions
(importing KB archive) |
m (Text replacement - "&" to "&") |
||
Line 56: | Line 56: | ||
<br /> | <br /> | ||
Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)<br /> | Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)<br /> | ||
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server& | For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476<br /> | ||
<br /> | <br /> | ||
ADDITIONAL INFORMATION:<br /> | ADDITIONAL INFORMATION:<br /> |
Latest revision as of 14:18, 21 July 2020
Article ID: 919224
Article Last Modified on 11/20/2007
APPLIES TO
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Standard X64 Edition
- Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
- Microsoft SQL Server 2005 Developer Edition
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Enterprise X64 Edition
- Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
BUG #: 434935 (SQLBUDT)
SYMPTOMS
You install a Microsoft SQL Server 2005 hotfix package on a computer that has a 64-bit processor. When you connect to SQL Server 2005 Integration Services (SSIS) by using SQL Server Management Studio, you receive an error message that resembles the following:
Additionally, when you try to create or to edit a maintenance plan, you receive one of the following error messages:
Error message 1
Error message 2
This problem occurs if one of the following conditions is true:
- The SQL Server 2005 Integration Services hotfix package is installed. However, the SQL Server 2005 Tools hotfix package is not installed.
- You install the SQL Server 2005 Tools hotfix package before you install the SQL Server 2005 Integration Services hotfix package.
- You are running two instances of SQL Server 2005 on the computer. Additionally, the versions of both instances of SQL Server are earlier versions than Microsoft SQL Server 2005 Service Pack 2 (SP2).
- The computer is running an instance of SQL Server 2005 with SP2. Additionally, you install a post-SP2 hotfix on this instance. Then you install a second instance of SQL Server 2005. On the second instance, you install SQL Server 2005 SP2.
CAUSE
This problem occurs because the installer unregisters the 32-bit Dts.dll file when the installer installs the 64-bit Dts.dll file. The 64-bit Dts.dll file is installed together with SQL Server 2005 SP2. Additionally, the 64-bit Dts.dll file may be installed together with any SSIS hotfix package that contains the 64-bit Dts.dll file.
RESOLUTION
To resolve this problem, use one of the following methods, depending on the version of each instance of SQL Server 2005.
Method 1
If the versions of the instances of SQL Server 2005 are not earlier than SQL Server 2005 SP2, run the following command at a command prompt to register the 32-bit Dts.dll file:
%windir%\syswow64\regsvr32 "%ProgramFiles(x86)%\Microsoft SQL Server\90\dts\binn\dts.dll"
Method 2
If the version of an instance of SQL Server 2005 is earlier than SQL Server 2005 SP2, use one of the following methods:
- To resolve this problem, obtain the latest service pack for Microsoft SQL Server 2005. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
913089 How to obtain the latest service pack for SQL Server 2005
- Install the hotfix packages in the following order:
- SQL Server 2005 Database Engine
- SQL Server 2005 Analysis Services
- SQL Server 2005 Integration Services
- SQL Server 2005 Notification Services
- SQL Server 2005 Reporting Services
- SQL Server 2005 Tools
STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.
MORE INFORMATION
You can view the Application log in Event Viewer to determine the order in which the hotfix packages were installed. If the order of installation differs from the following order, reinstall the hotfix packages in the following order:
- Product: Microsoft SQL Server 2005 - Update 'Hotfix 2153 for SQL Server Database Services 2005 (KB918222)' installed successfully.
- Product: Microsoft SQL Server 2005 Analysis Services - Update 'Hotfix 2153 for SQL Server Analysis Services 2005 (KB918222)' installed successfully.
- Product: Microsoft SQL Server 2005 Integration Services - Update 'Hotfix 2153 for SQL Server Integration Services 2005 (KB918222)' installed successfully.
- Product: Microsoft SQL Server 2005 Notification Services - Update 'Hotfix 2153 for SQL Server Notification Services 2005 (KB918222)' installed successfully.
- Product: Microsoft SQL Server 2005 Reporting Services - Update 'Hotfix 2153 for SQL Server Reporting Services 2005 (KB918222)' installed successfully.
- Product: Microsoft SQL Server 2005 Tools - Update 'Hotfix 2153 for SQL Server Tools and Workstation Components 2005 (KB918222)' installed successfully.
Note The source of these events is MsiInstaller.
Keywords: kbtshoot kbbug kbexpertiseadvanced kbexpertiseinter kbsql2005setup kbsql2005ssis KB919224