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?
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?
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.
********************************************************************************** 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
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
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?
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.
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
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.
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!??
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 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?
I upgraded the OS on my SQL 2005 SP2 to Windows 2003 SP2. Everything still works fine but now Windows Update says that I need SQL 2005 SP2 again. I checked the version of SQL on the server and it's still SP2. Did the Windows service pack somehow downgrade parts of my SQL installation? I know I can probably just reinstall the SQL service pack but I was just curious...
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.
We deploy an application that uses SQL Server Express 2005. One of our test engineers tried to use our setup on Windows XP SP 3. But the SQL server installer gave an error - unable to update msxml6r.dll. Is this a bug of the SQL Server installer or do we need to make use of a more recent version of msxml6?
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 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
Not sure if this gets fixed on a restart, but the Backward Compatibility upgrade/piece failed on service pack 1 install for SQL Server 2005. Here is the log output. Anyone experience this?
05/19/2006 08:58:27.648 ================================================================================ 05/19/2006 08:58:27.648 Hotfix package launched 05/19/2006 09:00:04.368 Attempting to install instance: SQL Server Native Client 05/19/2006 09:00:04.383 Attempting to install target: CLARITY 05/19/2006 09:00:04.383 Attempting to install file: sqlncli.msi 05/19/2006 09:00:04.399 Attempting to install file: \<server>s$917f50731dade382ab1bHotFixSqlncliFilessqlncli.msi 05/19/2006 09:00:04.399 Creating MSI install log file at: C:WINDOWSHotfixRedist9LogsRedist9_Hotfix_KB913090_sqlncli.msi.log 05/19/2006 09:00:04.415 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 05/19/2006 09:00:04.415 Failed to read registry key: Debug 05/19/2006 09:00:51.040 MSP returned 3010: A restart is required to complete the install. This message is indicative of a success. This does not include installs where the ForceReboot action is run. This error code is not available on Windows Installer version 1.0. 05/19/2006 09:00:51.118 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller 05/19/2006 09:00:51.118 Failed to read registry key: Debug 05/19/2006 09:00:51.118 Pending reboot, successfully installed file: \<server>s$917f50731dade382ab1bHotFixSqlncliFilessqlncli.msi 05/19/2006 09:00:51.134 Successfully installed target: <SERVER> 05/19/2006 09:00:51.134 Successfully installed instance: SQL Server Native Client 05/19/2006 09:00:51.134 05/19/2006 09:00:51.134 Product Status Summary: 05/19/2006 09:00:51.134 Product: SQL Server Native Client 05/19/2006 09:00:51.134 SQL Server Native Client (RTM ) - Reboot Required 05/19/2006 09:00:51.134 05/19/2006 09:00:51.134 Product: Setup Support Files 05/19/2006 09:00:51.134 Setup Support Files (RTM ) - Not Applied 05/19/2006 09:00:51.150 05/19/2006 09:00:51.150 Product: Database Services 05/19/2006 09:00:51.150 Database Services (RTM 1399 ENU) - Not Applied 05/19/2006 09:00:51.150 Reporting Services (RTM 1399 ENU) - Not Applied 05/19/2006 09:00:51.150 05/19/2006 09:00:51.150 Product: Notification Services 05/19/2006 09:00:51.150 Notification Services (RTM 1399 ENU) - Not Applied 05/19/2006 09:00:51.150 05/19/2006 09:00:51.150 Product: Integration Services 05/19/2006 09:00:51.150 Integration Services (RTM 1399 ENU) - Not Applied 05/19/2006 09:00:51.150 05/19/2006 09:00:51.150 Product: Client Components 05/19/2006 09:00:51.165 Client Components (RTM 1399 ENU) - Not Applied 05/19/2006 09:00:51.165 05/19/2006 09:00:51.165 Product: MSXML 6.0 Parser 05/19/2006 09:00:51.165 MSXML 6.0 Parser (RTM ) - Not Applied 05/19/2006 09:00:51.165 05/19/2006 09:00:51.165 Product: SQLXML4 05/19/2006 09:00:51.165 SQLXML4 (RTM ) - Not Applied 05/19/2006 09:00:51.165 05/19/2006 09:00:51.165 Product: Backward Compatibility 05/19/2006 09:00:51.165 Backward Compatibility (RTM ) - Not Applied 05/19/2006 09:00:51.181 05/19/2006 09:00:51.181 Product: Microsoft SQL Server VSS Writer 05/19/2006 09:00:51.181 Microsoft SQL Server VSS Writer (RTM ) - Not Applied 05/19/2006 09:00:51.181
Unfortunately I recived an error stating the "Installation package for the product SQL Server 2005 (64bit) cannto be found. Please locate a valid SQLRUN_SQL.MSI". Which I couldn't find anywhere., so....
I created a fresh instance on my 2005 server, held back on installing SP1, and ran the command line again. This time it worked.
My best guess is that the installation scripts check the version header on the MSI file during install and display a compatibilty error thus halting the install.
My question is, has anyone seen, overcome this problem. I can't believe that this is a bug like error as there would be posts about it all over the interweb.... which there isn't.
Any thoughts.
Mike.
(p.s) I know that I shouldn't really try to amend the collation on a sql server, but I have little choice at the moment :-(
Windows Update Web Page indicates I have BOTH a SUCCESS and FAILURE for SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) ?Is it possible for my machine to have TWO DIFFERENT MS SQL Server Express installations? Is the problem real or some small ghost issue? I do have a trial CD from Microsoft .. Visual Studio 2005 Team Suite.
Please note that this is what windows update indicates on the web page duplicate lines are on the web page .. not a copy and paste mistake.
SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update SQL Server 2005 Microsoft SQL Server 2005 Express Edition Service Pack 2 (KB 921896) Tuesday, March 13, 2007 Microsoft Update
LINK FOLLOWED Installation Failure Error Code: 0x652 Try to install the update again, or request help from one of the following resources
I include the logfile since it seems to convey useful informations to SQL Express experienced.
summary.txt logfile >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Time: 03/13/2007 12:28:02.906 KB Number: KB921896 Machine: somejunk 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 SP2 2005.090.3042.00 x86 EXPRESS Express Database Services (SQLExpress) ENU RTM x86 EXPRESS
