|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Cannot open folder in SSIS after installing the cumulative hotfixI have installed the Cumulative hotfix package (build 2153) for SQL Server 2005 SP1. This works fine on a 32bit machine. On a x64- based operating system I have problems. I followed the install order as instructed in the KB Article 918222. The only thing what was special on this 64 box was that I deinstalled it and reinstalled it. OK. My problem now is that when I connect to SSIS with SQL Server Management Studio and I want to browse the folders, I receive following error message: Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) Addiditonal information: -> Library not registered.(Exception from HRESULT: 0x8002801D (TYPE_E_LIBNOTREGISTERED)) (Microsoft.SQLServer.DTSRuntimeWrap) When I connect from the 32bit machine to the 64bit machine with management Studio, I can display the folders (running packages and stored packages) without any problems. Any idea why this can happen and what I can do against it? Regards, Marc Hi, Roger,
Thanks for your reply. From your description, I understand that: After you correctly installed the hotfix package (build 2153) for SQL Server 2005 SP1 on your x64-based OS. You were unable to browse the folders under the SSIS tree node on the 64bit OS; however you could browse the folders on the remote 32bit OS. The error message was: " Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum) Addiditonal information: -> Library not registered.(Exception from HRESULT: 0x8002801D: (TYPE_E_LIBNOTREGISTERED)) (Microsoft.SQLServer.DTSRuntimeWrap)" If I have misunderstood, please let me know. From my research, I recommend you try to reinstall the SQL 2005 Tools on the server at first: 1. Remove the SQL 2005 Tools by Windows Installer Clean Up. You can download the Windows Installer Clean Up from this link: http://download.microsoft.com/download/e/9/d/e9d80355-7ab4-45b8-80e8-983a48d 5e1bd/msicuu2.exe 2. Install SQL Server 2005 Client Tools from the setup CD. 3. Install SQL Server 2005 SP1 for the tools. 4. Install the hotfix for the tools. If the issue persists, I would like to get the following information from you for further research: 1. What is your x64 OS edition ? 2. Could you compress the SSIS logs under the hotfix directory and send the compressed file to me (chang***@microsoft.com) ? The default hotfix directory locates in "C:\Windows\Hotfix\". If you have any other questions or concerns, please feel free to let me know. It's my pleasure to be of assistance. +++++++++++++++++++++++++++ Charles Wang Microsoft Online Partner Support +++++++++++++++++++++++++++ When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== Business-Critical Phone Support (BCPS) provides you with technical phone support at no charge during critical LAN outages or "business down" situations. This benefit is available 24 hours a day, 7 days a week to all Microsoft technology partners in the United States and Canada. This and other support options are available here: BCPS: https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469 Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/ If you are outside the United States, please visit our International Support page: http://support.microsoft.com/default.aspx?scid=%2finternational.aspx. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights. Hi, Marc,
Appreciate your update and response. I am glad to hear that the problem has been fixed. If you have any other questions or concerns, please do not hesitate to contact us. It is always our pleasure to be of assistance. Have a nice day! +++++++++++++++++++++++++++ Charles Wang Microsoft Online Partner Support +++++++++++++++++++++++++++ When responding to posts, please "Reply to Group" via your newsreader so that others may learn and benefit from your issue. ===================================================== Business-Critical Phone Support (BCPS) provides you with technical phone support at no charge during critical LAN outages or "business down" situations. This benefit is available 24 hours a day, 7 days a week to all Microsoft technology partners in the United States and Canada. This and other support options are available here: BCPS: https://partner.microsoft.com/US/technicalsupport/supportoverview/40010469 Others: https://partner.microsoft.com/US/technicalsupport/supportoverview/ If you are outside the United States, please visit our International Support page: http://support.microsoft.com/default.aspx?scid=%2finternational.aspx. ===================================================== This posting is provided "AS IS" with no warranties, and confers no rights.  |
|||||||||||||||||||||||
Other interesting topics