SQL Server: Service Pack 3 Or 2005 Express Edition
Jan 4, 2005
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.
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 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
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
Hi i tried to install the Microsoft SQL Server 2005 Express Edition Service Pack 2 but was unable to do so. I got an error message saying: Error Code: 0x2B22
I went through what the message said, but i was unable to solve the problem. Below is the summary of the problem. Please help me solve it.
Time: 05/19/2007 12:32:24.781 KB Number: KB921896 Machine: DET-NB0631262 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 SP2 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
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.
From the Windows update site and also via automatic download of updates, the following update fails every time...The SQL it is trying to update works fine. The following updates were not installed: Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2 (KB 921896)
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,
I installed SQL Server Express on my local pc using the default settings. I also have SQL Server 2005 installed on the same machine. With the SQL Browser service running, I am unable to connect to the SQL Server Express database.
I receive error: Cannot connect to MyComputerNameSQLEXPRESS.
Additional information: An error has occurred while establishing a connection to the server. When connecting to the SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server)
Any ideas why I'd be receiving an error about remote connections when the connection I'm trying to make is local? - Incidentally, I have configured the SQL 2005 Server to have TCP enabled, Named Pipes enabled, and Shared enabled.
If anyone knows how to solve this issue, please also respond to: bbarry@yahoo.com
Will Microsoft SQL Server 2005 Express Edition Service Pack 1 work with Microsoft SQL Server 2005 Express Edition with Advanced Services or is there going to be another version of Service Pack 1?
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!??
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 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.
We had a disaster last week (SAN Corruption) and it hit a bunch of my sql serves. I have been able to recover all but one. The one I am having a problem with is a NAMED Instance that I obviously don't know the original SP level on. When I try to restore MSDB it won't let me because of a version conflict Is there any way to tell what the SP Level is either from a system DB .mdf or LDF file or from a backup file without restoreing? Right now I'm installing SQL Server to a test server and I'm going to try and restore the system dbs at each patch level.. seems like there must be a better way!!
In the last step of installing the SQL Server 2005 Express edition I get the following error:
Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:38:35 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:38:35 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqlservicetart Source Line Number: 301
Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS
Error Code: 1814 MSI (s) (80!08) [19:39:58:265]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. .
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:39:58 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:39:58 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqlservicetart Source Line Number: 301
Please do not tell me to go to the MS site coz I did not see any helpful step by step how to install this service pack to my SQL Personal Edition. So please anyone, SQL Guru, post here how to install the SP3 for PERSONAL EDITION - not the DESKTOP Engine. Thank you so much...
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?
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.
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
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.
I've installed Visual Basic 2005 express edition & tried to connect to SQL Server 2005 express edition. I noticed that VB2005 Express Edition doesn't have any OLEDB provider for SQL Server. The only OLEDB Provider is for M.Access. Is this correct? if so, what should i do if i want to connect SQL Server 2005 express edition with VB2005 express edition by using OLEDB connection type?
I really appreciate any respond from you guys.. Thank's and waiting for the good news..
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?
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
I have been unable to create a replication from an SQL Server 2005 standard edition database to remote SQL Server 2005 Express Edition. The remote express edition is on a Virtual Private Server we are leasing from a hosting company. The name of the remote DB is similar to vs572.si-vs572.com. I can connect to this with SQL server authentication through Management Studio and also with SSIS. But, I have been unable to create a push subscription (I have tried a test push subscription with the same publication to a local SQL Express server here in our office and this works fine).
Here is the error message: SQL Server Replication requires the actual server name to make a connection to the server. Connections through server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'VS572SQLEXPRESS'.
The hosting company had originally installed a shared SQL server which would not support replication. They then installed SQL Express edition and I was hoping this would allow us to run a replication.
I tried to connect to VS572SQLEXPRESS with out any luck. I check the remote connections, made sure replication was installed, etc., but no luck.