**********************************************************************************
Processes Locking Files
Process Name Feature Type User Name PID
**********************************************************************************
Product Installation Status
Product : Express Database Services (SQLEXPRESS)
Product Version (Previous): 1399
Product Version (Final) :
Status : Failure
Log File : D:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE
SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools
Error Number : 1332
Error Description : *** Shared String ID 1332 Not Found ***
----------------------------------------------------------------------------------
**********************************************************************************
Summary
One or more products failed to install, see above for details
Exit Code Returned: 1332
I am having trouble installing Microsoft SQL Server 2005 Service Pack 2 (KB 921896). When I go to Microsoft Update Home, it is the only update listed as available for my computer and I am trying to download and install it, but every time I do it fails with the error message:
€śSome updates were not installed
The following updates were not installed:
Microsoft SQL Server 2005 Service Pack 2 (KB 921896)"
This has been going on since the beginning of December, and I have a strange feeling that there are updates that I am not getting because this one keeps failing. I have other Windows XP machines with SQL Server 2005 and they have consistently been getting updates fine. This seems to be the only one. (please note that I have not been keeping track of the KB numbers of every update so it is possible that my other machines have not encountered this specific update.) I have also tried killing all of the services associated with SQL thinking that it couldn't update the program while running, but that did not solve the problem.
Any suggestions on why this won't install? Thank you in advance.
When updating automaticallly, this update always fail, I have put the configuration manager /server browser : the only one that was disabled, on manual (I have not the automatic option for this one) but nothing works, what can I do ? This is a new laptop I have got (XP pro) and I am going through the process of updating many things, only this one fails, any help appreciated.
I've been trying to install the following update: Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896). I always recieve the following error: 2B22,
On my backup server running Symantec BackupExec 11D, I wanted to install Service Pack 2 for SQL Server 2005 Express. I started performing the update using "Windows Update", but cancelled the upgrade process just before it started to install (right after the downloading/verifying download phase of Windows update).
Now when I try to find the SP2 update using Windows Update, it doesnt show up on the update website. Rebooting the server doesnt help. I manually downloaded the file for SQL 2005 Express SP2 and tried installing it, but it says "the component is already installed" and I have to exit the process.
BackupExec 11D is running fine as of now, and it might not face problems later.. but I am not sure. Is there any way to uninstall SP2 and re-install it again!??
Hi dear Devs! I have a problem and now I am not sure, what I should do. "Microsoft Update" Service warned me, that a new critical update is ready for download. It was the update "SQL Server 2005 Express Edition Service Pack 2", I did that. Untill here no problem. The update "SQL Server 2005 Service Pack 2" was ready for download too. I have both versions on my computer "SQL Server 2005 Express Edition" and "SQL Server 2005 Developer Edition". The Express Edition came together with the install of "Visual Studio 2005 Team Suite", two days later I have installed the "SQL Server 2005 Developer Edition". Now to my problem, the "SQL Server 2005 Service Pack 2" installation failed in one point, the name of it is "Microsoft SQL Server Native Client". The whole installation was not interrupted, it told me only at end of this updating that this point wasn't successful - I saw it in the "Summary.txt". While the install I saw that this "Microsoft SQL Server Native Client" was twice in the list of the Service Pack 2 Update. Both of these points had the identical name. In short words, I saw that the SP2 wanted made an update at "Microsoft SQL Server Native Client" twice. I thought, it is because these two editions of "SQL Server 2005" on my computer. But the result is, that the SP2 couldn't update the second 'Native Client'. I checked it in the 'Software' section in 'Control Panel' and I have really two installations of this "Microsoft SQL Server Native Client". My question is, is that normal, is that because I have two "SQL Server 2005" Editions on my computer? And what can I do with this failed part of the SP2. Can someone help me with this failed 'Native Client' SP2 update? I were really happy, if someone could give me the best solution to fix this problem. Thank you very much for your help and answers
I have Windows XP Professional Version 2002 Service Pack2.
I Have:
Microsoft SQL Server Management Studio 9.00.2047.00 Microsoft Analysis Services Client Tools 2005.090.2047.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 7.0.5730.11 Microsoft .NET Framework 2.0.50727.42 Operating System 5.1.2600
Service Pack is failing to Install CLIENT COMPONENTS; message is:
Product : Client Components Product Version (Previous): 2047 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB921896_sqlrun_tools.msp.log Error Number : 29549 Error Description : MSP Error: 29549 Failed to install and configure assemblies c:Program FilesMicrosoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024894 Error message: The system cannot find the file specified. Error description: Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the file specified.
This situation, I am guessing, also preventing me to run import/export from the SQLServer Client.
I am continually prompted to download & install this SP by the windows update utility but it always fails to install it. I have XP SP2. No error msg is provided. I do not have ACT! installed. I do have Oracle 10g Expr. Ed installed. Competitive jealousy?
I found this online:
Important notes about the cumulative hotfix package €˘ You must enable the SQL Server Management Object (SMO) extended stored procedures and the SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you install the cumulative hotfix package.
Where does one enable SMO & SQL-DMO?
I looked in the summary log file in the Hotfix directory and it says that the problem is that SQL Express cant be started. See below.
I went into the SQL Configuration Mgr and tried to start it and it fails to start. No reason given. Now what?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Time: 11/22/2007 09:44:37.546 KB Number: KB921896 Machine: TOSHIBA-ROGER OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: /quiet /allinstances Cluster Installation: No
********************************************************************************** Prerequisites Check & Status SQLSupport: Passed
********************************************************************************** Products Detected Language Level Patch Level Platform Edition Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS Express Database Services (SQLExpress) ENU RTM x86 EXPRESS
********************************************************************************** Products Disqualified & Reason Product Reason Express Database Services (SQLEXPRESS) Unable to start service
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID
********************************************************************************** Product Installation Status Product : Express Database Services (SQLEXPRESS) Product Version (Previous): 1399 Product Version (Final) : Status : Not Applied Log File : SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools Error Number : 11042 Error Description : Unable to start service ---------------------------------------------------------------------------------- Product : Express Database Services (SQLExpress) Product Version (Previous): Product Version (Final) : Status : Not Applied Log File : SQL Express Features : Client_Components,Connectivity,SDK Error Number : 0 Error Description : ----------------------------------------------------------------------------------
********************************************************************************** Summary Unable to start service Exit Code Returned: 11042 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Hi, I understand from previous threads that installing SQL Server 2005 Service Pack 2 on the desktop client can speed up the response rate of the Visual Studio 2005 Business Intelligence Tools.
However after logging on as an administrator and installing Service Pack 2, Service Pack 2 returned no errors. However after launching Visual Studio and clicking on the about dialog box the version reported was still €śRTM.050727-4200€? where I was expecting to see €śSP.050727-7600€?.
I understood that I applied the same service pack to my copy of SQL Server on my laptop and the upgrade worked successfully.
Hi, for some reason, when I've installed visual studio 2005, I didn't install also SQL server. Than I've updated VS with Service Pack 1 (thank god, I was trying unsucesfully for about 2 weeks :/ ).
Than I want to install MSSQL 2005 and an error came up:
Message displayed to user SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme. SQL Server Setup has detected that the following required component is not installed: Microsoft Windows Installer 3.1. To proceed, download and install the Windows Installer 3.1 Redistributable from http://go.microsoft.com/fwlink/?LinkId=50380 , and then run SQL Server Setup again.
1. The http link leads to main page of MS Download Centre. 2. I have Installer 3.1. (version of file c:windowssystem32msiexec.exe said so) 3. I really do not have any beta version of any mentioned SW. I never had.
So I think the issue could be, that installer is checking for not updated version of Visual Studio. (I was searching through net/msdn and seems no one had this problem (maybe wrong keywords, though) ).
I'm running setup.exe from CD1.
Uninstalling of VS Service Pack 1 is not an option. I really don't want to spent another week by installing it. Please tell that there is some another way :) . Thanks a lot.
Microsoft SQL Server 2005 Setup beginning at Wed Mar 14 18:23:08 2007 Process ID : 2336 Y:setup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/2/14 18:23:8 Complete: LoadResourcesAction at: 2007/2/14 18:23:8, returned true Running: ParseBootstrapOptionsAction at: 2007/2/14 18:23:8 Loaded DLL:Y:xmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/2/14 18:23:8, returned true Running: ValidateWinNTAction at: 2007/2/14 18:23:8 Complete: ValidateWinNTAction at: 2007/2/14 18:23:8, returned true Running: ValidateMinOSAction at: 2007/2/14 18:23:8 Complete: ValidateMinOSAction at: 2007/2/14 18:23:8, returned true Running: PerformSCCAction at: 2007/2/14 18:23:8 Complete: PerformSCCAction at: 2007/2/14 18:23:8, returned true Running: ActivateLoggingAction at: 2007/2/14 18:23:8 Complete: ActivateLoggingAction at: 2007/2/14 18:23:8, returned true Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result. Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2336" returned false. Running: PerformSCCAction2 at: 2007/2/14 18:23:8 Error: Action "PerformSCCAction2" threw an exception during execution. Return Code: 87 Message displayed to user SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme. SQL Server Setup has detected that the following required component is not installed: Microsoft Windows Installer 3.1. To proceed, download and install the Windows Installer 3.1 Redistributable from http://go.microsoft.com/fwlink/?LinkId=50380 , and then run SQL Server Setup again.
Class not registered. Running: UploadDrWatsonLogAction at: 2007/2/14 18:23:9 Message pump returning: 87
Can someone help me out to uninstall service pack 5a on SQL server 6.5? We have few problems with this new service pack. Stored procedures could not delete temporary tables created in them. Can I load the backup databases from this service pack(5a) to service pack 4 servers?
After going through "Add and Remove Programs" and removing all components of SQL Server 2005 Standard Edition on my desktop I get an error telling me there is a copy already installed and to remove it before continuing. Well nothing shows up under "Add and Remove Programs"; Windows cleanup shows none of the SQL Server components; a check of the register (HOTKEYS.../unistall) have no SQL Server entries; under services all SQL Server services are disabled and not running.
I have followed all the steps in http://support.microsoft.com/kb/909967 (Describes how to uninstall an instance of SQL Server 2005 manually).
Anyone out there got a solution? (Visual Studio 2005 eval is loaded on the box)
I'm the following encountering WMI error message when invoking SQL2005 setup.
The SQL Server System Configuration Checker cannot be executed due to WMI configuration on the machine CAPRICORN Error:2147942405 (0x80070005).
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=setup.rll&EvtID=70342
I'ver found other postings related to WMI errors and tried the WMI fix batch, but to no avail. I noted the error code I have is 2147942405 which is different from other postings. And from examining setup log generated, this seems to be security related, but cannot find much help combing thru msdn/google, etc
SCCOpenPerformer Added machine: CAPRICORN RegisterAddCheckArticleCallbackFunction registered callback function
Calling add article callback function for article: WMIServiceWin32OSWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32OSWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 2 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: OSLanguage Property type: 2 Value: 2 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_OperatingSystem Property name: SystemDirectory Property type: 2
Calling add article callback function for article: WMIServiceWin32CompSystemWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32CompSystemWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_ComputerSystem Property name: NumberOfProcessors Property type: 2
Calling add article callback function for article: WMIServiceWin32ProcessorWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32ProcessorWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_PROPERTY Namespace: cimv2 Class name: Win32_Processor Property name: CpuStatus Property type: 2
Calling add article callback function for article: WMIServiceReadRegWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceReadRegWorking Article type: 4, ARTICLE_WMI_TYPE_VALUES Number of value: 1 Value: 1 Type: ARTICLE_WMI_TYPE_REGISTRY DefKey: 0x80000002 Subkey name: SOFTWAREMicrosoftWindowsCurrentVersion Value name: ProgramFilesDir Registry type: 4
Calling add article callback function for article: WMIServiceWin32DirectoryWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceWin32DirectoryWorking Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: Select * from Win32_Directory where name='C:\'
Calling add article callback function for article: WMIServiceCIMDataWorking Callback function returned TRUE Adding Article... Article Id: WMIServiceCIMDataWorking Article type: 3, ARTICLE_WMI_TYPE_CLASS Namespace: cimv2 WQL Query: Select * from CIM_DataFile where name='C:\'
Calling add article callback function for article: XMLDomDocument Callback function returned TRUE Adding Article... Article Id: XMLDomDocument Article type: 1, ARTICLE_TYPE_GENERIC_FUNCTION RegisterCallbackFunction registered callback function Callback filter = 0x6
Performing check on local machine CAPRICORN Connecting to CAPRICORN machine ConnectServer returned 0 (0x0) ConnectServer returned 0 (0x0) Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Creating class instance Win32_ComputerSystem CreateInstanceEnum Win32_ComputerSystem returned 0 (0x0) Enumerating the first class of Win32_ComputerSystem EnumClass of Win32_ComputerSystem returned 2147942405 (0x80070005) Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005) Creating class instance Win32_OperatingSystem CreateInstanceEnum Win32_OperatingSystem returned 0 (0x0) Enumerating the first class of Win32_OperatingSystem EnumClass of Win32_OperatingSystem returned 2147942405 (0x80070005) Creating class instance Win32_Processor CreateInstanceEnum Win32_Processor returned 0 (0x0) Enumerating the first class of Win32_Processor EnumClass of Win32_Processor returned 2147942405 (0x80070005) Openning namespace \rootdefault GetNamespace \rootdefault returned 0 (0x0) Getting method EnumValues in StdRegProv class GetMethod returned 0 (0x0) Executing method EnumValues in StdRegProv class ExecMethod returned 2147942405 (0x80070005)
Processing article WMIServiceWin32OSWorking Scc Error: 50026 (0xc36a) Error code: 2147942405 (0x80070005) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceWin32CompSystemWorking Scc Error: 50026 (0xc36a) Error code: 2147942405 (0x80070005) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceWin32ProcessorWorking Scc Error: 50026 (0xc36a) Error code: 2147942405 (0x80070005) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceReadRegWorking Scc Error: 50024 (0xc368) Error code: 2147942405 (0x80070005) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceWin32DirectoryWorking Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 50022 (0xc366) Error code: 70347 (0x112cb) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article WMIServiceCIMDataWorking Openning namespace \rootcimv2 GetNamespace \rootcimv2 returned 0 (0x0) Scc Error: 50022 (0xc366) Error code: 70347 (0x112cb) Calling callback function for reason: 0x2 Callback function returned TRUE
Processing article XMLDomDocument Scc Error: 0 (0x0) Error code: 0 (0x0) Calling callback function for reason: 0x4 Callback function returned TRUE SccPerformer closed.
I downloaded the sp2a from MS website. However after running the SP it shows version 9.00.3042.00 When I applied the KB933508 it brings up the version as 9.00.3050.00
Is there a problem. Per this site, some time ago, the version we need to be on ideally, is 9.00.3042.01
In which case which patch do I need to download and apply?
I needed to re-install the entire sql server 2005, I used add/remove program. everything went normal, except reporting service. I deleted the entire upper sql server directory, rebooted the box, however, it still shows up in services, even though the path does not exist. I tried to reinstall it again, but it complains about name already exists. I cannot change the name, but I am not able to find how I can remove it and reinstall it properly.
Last Action    : DetectInstanceClash Error String   : An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name. Error Number   : 28086
I participate in the SQL Server Integration Services and Reporting Services forums and I have seen many outstanding issues users would like to see fixed. Is there a SQL Server 2005 Service Pack 3 being developed and if so when would it become available?
SP2 is still present i Windows Update but i also have the Critical Update for SQL Server 2005 Service Pack 2 (KB 934458) fix, that i can't install when i try ..
I think i have the some problems as the people in this thread http://forums.microsoft.com/msdn/showpost.aspx?postid=1249824&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=9 but i am a bit unsure since the database say it is SP2 ..
Is there any offical stuff from MS about this? Maybe some hotfix to run or at least some blog or something where someone has writen about it?
Is there no "passive" install mode for SP1 (gui but no user input required)? I can run unattended using the /quiet switch but this gives me absolutely no feedback as to progress or success/failure of the install. It also returns to the command prompt immediately whilst kicking of msiexec in the background, meaning I can't trap any errorlevel. How are we supposed to check success or failure in applying the SP for unattended installs? For rolling this out across an enterprise we need something, usually hotfix.exe has a passive install mode.
SQL Server 2005 Service Pack 2 has been released to the web. Many of the questions asked on this forum will be solved by applying Service Pack 2. Please take the time to read about the many benefits this service pack provides.
SQL Server 2005 Service Pack 2: http://www.microsoft.com/sql/sp2.mspx
SQL Server 2005 Service Pack 2 blogs: http://blogs.msdn.com/sqlrem/archive/tags/SQL+Server+2005+-+SP2/default.aspx
I'm just installed the sqlserver 2005 sp2 without installing service pack 1. Can i install service pack 1 after installing sp2? or is it sp2 includes all the sp1 updates?
I know that this has been covered a few times and I have made sure that permissions are correct on all the files, however I'm still failing on SQL9_Hotfix_KB918222
I would like to post the SQL9_Hotfix_KB913090_sqlrun_sql.msp.log but either its too big for the forum to handle or the forum is having some problems.
I would be more than happy to send it to anyone interested in helping out
Hi, I would like to know which downlaod should I do from the Download page of SQL SERVER 2005 SP I can see there are 3 downloads but have no clue which one I should be downloading. ALl of them are about 300 Mb in size.
I have been receiving the update notice from MS about SQL 2005 Express Service Pack 2. I download it and install. It states successful installs but I get another message requesting the same update. It is Ground Hogs day and Deja Vu all over again.
Question:
Where do I find out if it actually installed?
How do I stop getting the messages from MS to download and install SQL 2005 Express Service Pack 2? I shut the the automatic update but if I turn it on a few days later. I get the same message.
Is there a separate service pack 2 for SQL Server Reporting Services 2005? I know there is a SP2 for SQL Server 2005 that was just released. I'm asking because SRS 2000 had a service pack separate from the SQL Server service pack.
I downloaded Web Matrix. Very nice. My VB experience makes this very intuitive. But I see in order to do dB development, I also need to download MS SQL, which is labeled MSDE in as step 3 in the Web Matrix download operation. As I follow the link forward I see that there are three distinct components:
Sql2kasp3.exe Sql2kdesksp3.exe Sql2ksp3.exe
Are all three of these required?
Also I see there is a beta version of the SQL Server 2005 Express Edition: http://lab.msdn.microsoft.com/express/sql/ here. Would this be a viable alternative.
When doing the service pack 1 install on a client side the machine is locking up on a specific file. The tech who tried it out doesn't remember the exact file name but he thinks it ended with an .msb or .msp
I checked in the C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFiles directory and none of the files have been updated.
I am installing the SQL Server 2005 SP1 "SQLServer2005SP1-KB913090-x86-ENU.exe" on my server and everything successfully installed except the Integration Services. Below is the error I received.
Couple questions I guess. Are others getting the same thing? Is there a way to fix this so it will install like a work around? Last what will this affect by this not installing correctly?
