I€™ve been having a hard time trying to install SQL Server 2005 Express edition. I€™ve never used SQL Server before, so I don€™t really know what I€™m doing.
During the System Configuration Check step, the Performance Monitor Counter Requirement errored-out, with the following message: The System Configuration Check for Performance Monitor Counter registry value has failed. For details, see How To: Increment the Counter Registry Key for Setup in SQL Server 2005. I searched the Microsoft website, and found this topic under ms143215, I don€™t know if this is the same as a Knowledge Base article.
This article tells me I have to manually set the increment for the counter registry key.
It says I need to use Regedit, which I€™m rather hesitant to do, knowing how much damage could be done with 1 wrong key-stroke.
Anyways, it tells me to navigate to this location:
HKEY_LOCAL_MACHINESOFTWAREMicrosoftWindows NTCurrentVersionPerflib
€œLastCounter€? = 0x00002342 (9026)
€œLastHelp€? = 0x00002329 (9001)
The above are the values I found.
Then it tells me I have to navigate to this location:
Then it tells me I need to replace the values in the above fields, with the corresponding fields from the above location. The problem is, the values in the above key are long strings of text, without any kind of search facility, there€™s no way I can find the 2 fields mentioned above.
Downloading and installing VS 2008 Express also created a Miscrosoft SQL Server folder. How do I install the SQL Server 2005 Express?The following is what I found from the HELP menu bar of the VS 2008 Express. Where can I find the sqlexpr.exe? TIA,Jeffrey
To install SQL Server Express To begin installation, double-click sqlexpr.exe. Note: SQL Server Express is available as a self-extracting executable file (sqlexpr.exe) from both the Visual Studio 2005 CD and the SQL Server Express Web site. SQLEXPR.EXE installs on x86-based computers and to the 32-bit subsystem (WOW64). For more information, see Hardware and Software Requirements (SQL Server Express)
I had some issues on my server and had to uninstall .Net Framework 2.0, SQL Server 2005 Express, and SQL Express Toolkit. I installed SQL Server 2005 Express and it seemed to be ok.
Then my problems all started when I tried to install SQL Express Toolkit because I needed to install DTS Wizard again, and it errors out and wouldn't let me install it. So I uninstalled everything that's listed above again.
I then tried to install SQL Server 2005 Express again, and on the second from last screen, while its listing all the components and configuring them, I get the following error as it's configuring the last component... which was the SQL Server Database Services.
TITLE: Microsoft SQL Server 2005 Setup ----------------------------------------------------------- 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."
I tried to re-install the SQL Server Express another 7 times wth no luck.
If anyone can point me in the right direction I'd really appreciate it.
I'm getting an error while trying to install SQL Server Express 2005 Express Edition. I'm attaching the log of the installation process here. Please throw some light on the same.
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 (3) The system cannot find the path specified.
Setting status of unmanaged components and removing unmanaged resources
Error Code: 3
MSI (s) (D0!64) [21:39:17:257]: Product: Microsoft SQL Server 2005 -- 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 (3) The system cannot find the path specified.
.
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 (3) The system cannot find the path specified.
I downloaded the SSEUtilSetup.EXE and extracted the SSEUtil.exe to a folder of C:drive of my PC that is Windows XP Pro. I plan to learn the CLR programming via user-instance of SQL Server Express. I need to have SQL Server Express Utility installed. Please help and tell me how I can install SSEUtil.exe in my PC and how I use it to interact with SQL Server Express.
I installed VS 2008 Express with an option to download SQL Server 2005 Express. I noticed there is a '90' folder under my Microsoft SQL Server folder. I assumed this the folder for SQL Server 2005 Express. How do I set up my SQL Server2005 Express, so that I can use some sample databases for my VS 2008 Express? Any difference for SQL Server 2005 Express between VS 2008 Expressdownload and SQL Server 2005 Express download? TIA,Jeffrey
I'm using the disk that came with my Visual Web Developer for Dummies book. It installed on my XP Home machine, but when installing on my XP Pro machine, the fourth step, SQL Server Express, it fails. I cleaned up my hard drive (about ten gigs of free space), I followed the steps here http://msdn.microsoft.com/vstudio/support/readme/default.aspx to uninstall everything dot net related. Rebooted, checked my control panel, etc. Tried to install. It just fails. No error message.Can anyone give me an idea of where to start?Thanks
i tried hard to install sql server 2005 express today but it always failed.
system: XP german / SP 3
failure: it just says that the databaseservices could not be installed and the details are in the log. if i check the log it does not contain anything about the database services. it only says that the native client could not be installed (which is okay because i seem to have a newer one) .. here is the log:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 3 (Build 2600) Time : Tue May 20 23:43:48 2008
Machine : MICHAL Product : Unterstützungsdateien für das Microsoft SQL Server-Setup (Englisch) Product Version : 9.00.3042.00 Install : Successful Log File : c:ProgrammeMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_MICHAL_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : MICHAL Product : SQL Native Client Error : Für das Produkt Microsoft SQL Server Native Client wurde kein Installationspaket gefunden. Wiederholen Sie die Installation und verwenden Sie dabei eine gültige Kopie des Installationspakets "sqlncli.msi". -------------------------------------------------------------------------------- Machine : MICHAL Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Failed Log File : c:ProgrammeMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_MICHAL_SQLNCLI_1.log Last Action : InstallFinalize Error String : Für das Produkt Microsoft SQL Server Native Client wurde kein Installationspaket gefunden. Wiederholen Sie die Installation und verwenden Sie dabei eine gültige Kopie des Installationspakets "sqlncli.msi". Error Number : 1706 -------------------------------------------------------------------------------- Machine : MICHAL Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : c:ProgrammeMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_MICHAL_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : MICHAL Product : MSXML 6.0 Parser Product Version : 6.10.1129.0 Install : Successful Log File : c:ProgrammeMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_MICHAL_MSXML6_1.log --------------------------------------------------------------------------------
Hi, I installed VB express, can't recall if SQL Server Express was installed with VB or not at the same time, but I do have SQL Express installed. All I see is Microsoft SQL Server 2005 --> Configuration tools and --> Documentation and Tutorials. I must be missing something so I can create, view, alter and delete tables. The install gave no signs of installation problems. Any ideas what went wrong?
My system had a beta version of Visual Studio 2005 Express on it which I uninstalled. Apparently not correctly, as I can not install SQL Server 2005 Express. I have tried to removal procedures which either give me an error message or I cannot find the items in the Add/Remove program list that are requested. That is, it looks like the system should accept SQL Server 2005 Express, but it does not.
I have successfully installed Visual C++ 2005 Express. I have no clue as to what to do next and there is no documentation on what to do. I have looked at the various postings here, tried several of them, to no avail.
When I search the registry there are some 70 entries that have the string €œSQLEXPRESS€? in the entry. I am unsure if these are related to my previous beta install or related to the system (a475c HP Pavilion) needs. I am reluctant to start removing those entries.
So now what do I do? Is this really that difficult? And what if I decided to buy Visual Studio 2006, whenever it may be introduced? Will I not be able to install it?
Here is the log file that was generated yesterday, my latest attempt.
= = =
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600) Time : Sun Nov 05 17:32:58 2006
HOME-HP-XP : 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 failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Sun Nov 05 17:33:51 2006
List of log files: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_HOME-HP-XP_Core.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_HOME-HP-XP_Datastore.xml C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
I want to install SQL Server 2005 Express Adv. I saw that you had to un-install the beta version prior. So I did. When I go to install SQL Server 2005 Express Adv, I get a message saying that SQL Server detected the previous Beta version, goto add/remove programs blah...blah...blah. Nothing was listed in a/r programs. I ran an uninstall microsoft had on their web site, and I got a message saying nothing was deteceted. I deleted all folders related.
Somehow when I initially ran the unistall, not all components were removed. I am baffled. Any assistance would be greatly appreciated.
Microsoft SQL Server 2005 Setup beginning at Wed May 10 22:18:34 2006 Process ID : 2708 e:c10e7008821f194f5b98setup.exe Version: 2005.90.2047.0 Running: LoadResourcesAction at: 2006/4/10 22:18:34 Complete: LoadResourcesAction at: 2006/4/10 22:18:34, returned true Running: ParseBootstrapOptionsAction at: 2006/4/10 22:18:34 Loaded DLL:e:c10e7008821f194f5b98xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2006/4/10 22:18:34, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Oct 26 16:38:20 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Oct 26 16:38:20 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Wed Oct 26 16:37:25 2005 Function Name: sqls::CryptSameUserSameMachine::ProtectData Source Line Number: 50
2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:20 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2708"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2006/4/10 22:18:34 Complete: ValidateWinNTAction at: 2006/4/10 22:18:34, returned true Running: ValidateMinOSAction at: 2006/4/10 22:18:34 Complete: ValidateMinOSAction at: 2006/4/10 22:18:34, returned true Running: PerformSCCAction at: 2006/4/10 22:18:34 Complete: PerformSCCAction at: 2006/4/10 22:18:34, returned true Running: ActivateLoggingAction at: 2006/4/10 22:18:34 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:20 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00D2CFC0Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44
Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:20 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2708"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Oct 26 16:37:21 2005 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
I'm attempting an new installation on an Athlon 64 3300 system running XP Pro using the default install options. Get the message "SQL Server service failed to start..." and the installer starts Rolling Back the installation leaving me with a bunch of log files that mean nothing to me.
I'm not savvy enough to solve this one. Can anyone help?
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Thu Oct 19 20:09:10 2006
Machine : SR1365CL Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_SR1365CL_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : SR1365CL Product : Microsoft SQL Server Native Client Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_SR1365CL_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : SR1365CL Product : Microsoft SQL Server VSS Writer Product Version : 9.00.2047.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_SR1365CL_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : SR1365CL Product : MSXML 6.0 Parser Product Version : 6.00.3883.8 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_SR1365CL_MSXML6_1.log -------------------------------------------------------------------------------- Machine : SR1365CL Product : SQL Server Database Services Error : 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." -------------------------------------------------------------------------------- Machine : SR1365CL Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_SR1365CL_SQL.log Last Action : InstallFinalize Error String : 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 (1067) The process terminated unexpectedly. Error Number : 29503 --------------------------------------------------------------------------------
I've been trying all day to install SQL Server Express edition on my development machine, I 've uninstalled other Express Editions that I have previously installed, at least none show in add/remove programs. When i try to run the setup program i get the message that i have incompatible programs still installed. I don't know what they would be. None are listed in the program list as I have said. I tried to run the uninstallbeta program on the SQL Server Express page, but I keep getting an error that the "framedyn.dll" cannot be found, reinstalling the application may help! lol !
I have tried to run an app that requires sql server. It installs sql server express SP2 as part of its install package, but it doesn't work for some reason (works for other people I know).
This was the message I got:
"An error has occuredwhile establishing a connection to the server.When connecting to SQL Server 2005 this failure may be caused by teh fact that under the default settings SQL Server does not allow remote connections (Provider SQl Network interfaces, Error 26, error locating server /instance specified"
The owner of the original software suggested I try and download it from microsoft which I did, from here :
It all appeared fine, the download downloaded and the install started as it should. The system config check is all ticks, but towards the end there is a set up progress page which has the following items:
Product
SQL setup support files shows setup completed
SQL Native Client
When it gets to this bit it displays a pop up that says An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'
This has happened on a couple of occasions. Bearing in mind that I think this file is in the setup that I downloaded from microsoft I am at a loss.
After this it tries to finish the other items on the set up progress page which are
SQL VSS Writer SQL Server Database Services Workstation components
SQL VSS Writer shows as set up correctly, the others fail.
The next button highlights , then the installation finishes, but SQL Server is not properly installed.
Hi,When i try to install Sql server 2005 Express i get the following error: http://kirkov.dk/img/sql_error.jpgAnyone know a solution for this problem? Thanks.
I am attempting to install SQL Server 2005 Express Edition. After repeated tries, I have yet to succeed. I have already done or confirmed the following:
- .NET framework 2.0 is installed. - All previously existing SQL components have been uninstalled using the Install Clean-up Tool. - All previously existing registry entries for SQL Express have been removed. - My virus scanner (Norton 2006) has been disabled.
Taking these steps enabled me to get to the point in the install where the installer attempts to start the SQL service. At this point, I receive the error:
--------- Machine : DEBASER1 Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_DEBASER1_SQL.log Last Action : InstallFinalize Error String : 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 (3) The system cannot find the path specified. Error Number : 29503 ----------------------------------------------------------------------
I also noticed that the service exe does not seem to be present in the Program FilesMicrosoft SQl Server folder or any of it's subfolders.
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Professional (Build 6000) Time : Tue May 15 12:24:12 2007
Machine : RJMHOME2 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : RJMHOME2 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : RJMHOME2 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : RJMHOME2 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : RJMHOME2 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : RJMHOME2 Product : SQL Server Database Services Error : 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." -------------------------------------------------------------------------------- Machine : RJMHOME2 Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_RJMHOME2_SQL.log Last Action : InstallFinalize Error String : 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 (2) The system cannot find the file specified. Error Number : 29503 --------------------------------------------------------------------------------
And here is part of the SQL.log file around the error:
Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS
Error Code: 2 MSI (s) (24!1C) [12:26:45:369]: 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 (2) The system cannot find the file specified. .
MSI (c) (04:4C) [12:26:37:880]: Entering MsiProvideComponentFromDescriptor. Descriptor: ']gAVn-}f(ZXfeAR6.jiHandWritingFiles>RMn1s[Rh9@Iqc3L`JQB,, PathBuf: 2CE77F0, pcchPathBuf: 2CE77EC, pcchArgsOffset: 2CE774C MSI (c) (04:4C) [12:26:37:880]: Machine policy value 'DisableUserInstalls' is 0 MSI (c) (04:4C) [12:26:37:889]: MsiProvideComponentFromDescriptor is returning: 0 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 (2) The system cannot find the file specified. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Tue May 15 12:26:45 2007 Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue May 15 12:26:45 2007 Service failed unexpectedly (2) Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls:ervice:tart Source Line Number: 301
Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS
Error Code: 2 MSI (s) (24!1C) [12:26:47:322]: 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 (2) The system cannot find the file specified. .
MSI (c) (04:4C) [12:26:46:556]: Entering MsiProvideComponentFromDescriptor. Descriptor: ']gAVn-}f(ZXfeAR6.jiHandWritingFiles>RMn1s[Rh9@Iqc3L`JQB,, PathBuf: 2CE77F0, pcchPathBuf: 2CE77EC, pcchArgsOffset: 2CE774C MSI (c) (04:4C) [12:26:46:558]: MsiProvideComponentFromDescriptor is returning: 0 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 (2) The system cannot find the file specified. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Tue May 15 12:26:47 2007 Service MSSQL$SQLEXPRESS with parameters '-m SqlSetup -Q -qSQL_Latin1_General_CP1_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Tue May 15 12:26:47 2007 Service failed unexpectedly (2) Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls:ervice:tart Source Line Number: 301
Setting status of unmanaged components and removing unmanaged resources Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS
Error Code: 2 MSI (s) (24:68) [12:27:00:359]: I/O on thread 4804 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 1820 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 4840 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 5020 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 5272 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 4780 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 5128 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 6080 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 468 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 5596 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 5632 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 1356 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 5800 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 1072 could not be cancelled. Error: 1168 MSI (s) (24:68) [12:27:00:359]: I/O on thread 5836 could not be cancelled. Error: 1168 MSI (s) (24!1C) [12:27:00:360]: 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 (2) The system cannot find the file specified. .
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 (2) The system cannot find the file specified. . <Failure Type='Fatal' Error='2'> <EndFunc Name='LaunchFunction' Return='2' GetLastError='203'>
I'm trying to install sql server 2005 and to be honest, I've had an absolute gutful.
I All i want to do is use it to develop my asp.net applications but everytime i set a profile variable or access the "security" tab in my asp.net web site administration tool, I get sql errors.
I've googled the *** out of my issue and have come to no helpful conclusion. I've been through the surface configuration to 'allow remote connections' even though i'm ON THE LOCAL MACHINE and it still errors and tells me its not accepting remote connections.
I've formatted windows to make sure, and tried again- same error, not to mention the frustration of having to manually extract the contents of the .exe file that i downloaded (From no other then microsoft.com).
will somebody please shed some light on this piece of junk program so i can do my development without tearing my hair out.
The reason that I would like to install SQL Server Express on an external hard drive is for portability. I am developing a database that I will be working on in the office and at home. At the current time, I do not have a laptop at the office (and I don't want to use my personal laptop for this project). I need a way to develop and test the database both at home and at the office.
I was wondering if anyone knows if this crazy idea would work. I am also thinking of doing the same with Visual Studio Express. Since there are no licensing violations to speak of for these software packages, it would seem like this could work.
I tried to install SSE 2005 and I got the following message:
SQL Server Setup unexpectedly failed. For more information, review the Setup summary log file in...
The log file has the content below. Can someone help me to fix this problem, please?
I have no idea about what is going on!
Thank you for the help!
Microsoft SQL Server 2005 Setup beginning at Sun Jul 23 12:52:54 2006 Process ID : 2420 c:97830b63babac24aedb48a81be43976asetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2006/6/23 12:52:53 Complete: LoadResourcesAction at: 2006/6/23 12:52:53, returned true Running: ParseBootstrapOptionsAction at: 2006/6/23 12:52:53 Loaded DLL:c:97830b63babac24aedb48a81be43976axmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2006/6/23 12:52:54, returned false Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run: Could not parse command line due to datastore exception. Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Fri Jul 29 01:13:55 2005 Function Name: writeEncryptedString Source Line Number: 123 ---------------------------------------------------------- Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp Compiler Timestamp: Mon Jun 13 14:30:00 2005 Function Name: sqls::CryptSameUserSameMachine::ProtectData Source Line Number: 50
2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "2420"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2006/6/23 12:52:54 Complete: ValidateWinNTAction at: 2006/6/23 12:52:54, returned true Running: ValidateMinOSAction at: 2006/6/23 12:52:54 Complete: ValidateMinOSAction at: 2006/6/23 12:52:54, returned true Running: PerformSCCAction at: 2006/6/23 12:52:54 Complete: PerformSCCAction at: 2006/6/23 12:52:54, returned true Running: ActivateLoggingAction at: 2006/6/23 12:52:54 Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run: Datastore exception while trying to write logging properties. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00E2CFC4Unable to proceed with setup, there was a command line parsing error. : 2 Error Code: 0x80070002 (2) Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44
Class not registered. Failed to create CAB file due to datastore exception Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:49 2005 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "2420"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Fri Jul 29 01:13:50 2005 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
I get the fault message Error 29503 during the installation when the installation program wan't to start the SQL server Nothing I do can get the installation to pass this point. I can how ever start the server from the RUN command with "C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlservr.exe" When I have to cancel since the server don't start the installation make a rollback and remove the SQLservr.exe etc.
I have a new laptop and want to install the SQL server express instead of MSDE2000 I have been using The laptop is protected by SafeGuard easy but that it has been all the time even when MSDE2000 was installed. I paste the information on the laptop and also the content on one of the log files that I have seen in other threads that You want to have the info from.
I have seen that it is a error mess regarding .NET 2.0, but this service is installed and report no faults in other applications. I don't have ISS, and I don't need it.
My laptop OS Name Microsoft Windows XP Professional Version 5.1.2600 Service Pack 2 Build 2600 OS Manufacturer Microsoft Corporation System Manufacturer LENOVO System Model 64585KG System Type X86-based PC Processor x86 Family 6 Model 15 Stepping 11 GenuineIntel ~2394 Mhz BIOS Version/Date LENOVO 7LETA7WW (2.07 ), 2007-12-06 SMBIOS Version 2.4 Hardware Abstraction Layer Version = "5.1.2600.2180 (xpsp_sp2_rtm.040803-2158)" Total Physical Memory 3 072,00 MB Available Physical Memory 2,05 GB Total Virtual Memory 2,00 GB Available Virtual Memory 1,96 GB Page File Space 4,83 GB
File SQLSetup0001_"PC_NAME"_Core(Local).log
Microsoft SQL Server 2005 Setup beginning at Mon Mar 31 15:53:13 2008 Process ID : 5480 c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2008/2/31 15:53:13 Complete: LoadResourcesAction at: 2008/2/31 15:53:13, returned true Running: ParseBootstrapOptionsAction at: 2008/2/31 15:53:13 Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2008/2/31 15:53:13, returned true Running: ValidateWinNTAction at: 2008/2/31 15:53:13 Complete: ValidateWinNTAction at: 2008/2/31 15:53:13, returned true Running: ValidateMinOSAction at: 2008/2/31 15:53:13 Complete: ValidateMinOSAction at: 2008/2/31 15:53:13, returned true Running: PerformSCCAction at: 2008/2/31 15:53:13 Complete: PerformSCCAction at: 2008/2/31 15:53:13, returned true Running: ActivateLoggingAction at: 2008/2/31 15:53:13 Complete: ActivateLoggingAction at: 2008/2/31 15:53:13, returned true Running: DetectPatchedBootstrapAction at: 2008/2/31 15:53:13 Complete: DetectPatchedBootstrapAction at: 2008/2/31 15:53:13, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__5480" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2008/2/31 15:53:13 Complete: PerformDotNetCheck2 at: 2008/2/31 15:53:13, returned true Running: InvokeSqlSetupDllAction at: 2008/2/31 15:53:13 Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.3042.0 <Func Name='DwLaunchMsiExec'> Examining 'sqlspars' globals to initialize 'SetupStateScope' Opening 'MachineConfigScope' for [SALL10014041] Trying to find Product Code from command line or passed transform If possible, determine install id and type Trying to find Instance Name from command line. No Instance Name provided on the command line If possible, determine action Machine = SALL10014041, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = SALL10014041, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = SALL10014041, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = SALL10014041, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = SALL10014041, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = SALL10014041, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = SALL10014041, Article = XMLDomDocument, Result = 0 (0x0) Machine = SALL10014041, Article = Processor, Result = 0 (0x0) Machine = SALL10014041, Article = PhysicalMemory, Result = 0 (0x0) Machine = SALL10014041, Article = DiskFreeSpace, Result = 0 (0x0) Machine = SALL10014041, Article = OSVersion, Result = 0 (0x0) Machine = SALL10014041, Article = OSServicePack, Result = 0 (0x0) Machine = SALL10014041, Article = OSType, Result = 0 (0x0) Machine = SALL10014041, Article = iisDep, Result = 70348 (0x112cc) Machine = SALL10014041, Article = AdminShare, Result = 0 (0x0) Machine = SALL10014041, Article = PendingReboot, Result = 0 (0x0) Machine = SALL10014041, Article = PerfMon, Result = 0 (0x0) Machine = SALL10014041, Article = IEVersion, Result = 0 (0x0) Machine = SALL10014041, Article = DriveWriteAccess, Result = 0 (0x0) Machine = SALL10014041, Article = COMPlus, Result = 0 (0x0) Machine = SALL10014041, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = SALL10014041, Article = MDAC25Version, Result = 0 (0x0) Machine = SALL10014041, Article = SKUUpgrade, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: SALL10014041 ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: IIS Feature Requirement, Result: Warning Description: IIS is not installed, therefore Report Server feature will be disabled Action: Install IIS in order for Report Server feature to be enabled Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed Article: Edition Upgrade Check, Result: CheckPassed <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> <Func Name='DisplaySCCWizard'> CSetupBootstrapWizard returned 1 <EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'> Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.3042.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2008/2/31 15:54:30, returned true Running: SetPackageInstallStateAction at: 2008/2/31 15:54:30 Complete: SetPackageInstallStateAction at: 2008/2/31 15:54:30, returned true Running: DeterminePackageTransformsAction at: 2008/2/31 15:54:30 Complete: DeterminePackageTransformsAction at: 2008/2/31 15:54:30, returned true Running: ValidateSetupPropertiesAction at: 2008/2/31 15:54:30 Complete: ValidateSetupPropertiesAction at: 2008/2/31 15:54:30, returned true Running: OpenPipeAction at: 2008/2/31 15:54:30 Complete: OpenPipeAction at: 2008/2/31 15:54:30, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2008/2/31 15:54:30 Complete: CreatePipeAction at: 2008/2/31 15:54:30, returned false Error: Action "CreatePipeAction" failed during execution. Action "RunRemoteSetupAction" will be skipped due to the following restrictions: Condition "Action: CreatePipeAction has finished and passed." returned false. Running: PopulateMutatorDbAction at: 2008/2/31 15:54:30 Complete: PopulateMutatorDbAction at: 2008/2/31 15:54:30, returned true Running: GenerateRequestsAction at: 2008/2/31 15:54:30 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = -1 SQL_FullText = -1 SQL_SharedTools = 3 SQL_BC_DEP = -1 Analysis_Server = -1 AnalysisDataFiles = -1 AnalysisSharedTools = -1 RS_Server = -1 RS_Web_Interface = -1 RS_SharedTools = -1 Notification_Services = -1 NS_Engine = -1 NS_Client = -1 SQL_DTS = -1 Client_Components = -1 Connectivity = -1 SQL_Tools90 = -1 SQL_WarehouseDevWorkbench = -1 SDK = -1 SQLXML = -1 Tools_Legacy = -1 TOOLS_BC_DEP = -1 SQL_SSMSEE = -1 SQL_Documentation = -1 SQL_BooksOnline = -1 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = -1 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = -1 Complete: GenerateRequestsAction at: 2008/2/31 15:54:31, returned true Running: CreateProgressWindowAction at: 2008/2/31 15:54:31 Complete: CreateProgressWindowAction at: 2008/2/31 15:54:31, returned true Running: ScheduleActionAction at: 2008/2/31 15:54:31 Complete: ScheduleActionAction at: 2008/2/31 15:54:32, returned true Skipped: InstallASAction.11 Skipped: Action "InstallASAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.18 Skipped: Action "InstallASAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.22 Skipped: Action "InstallASAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "as", install will be skipped as a result. Skipped: InstallASAction.9 Skipped: Action "InstallASAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "as", install will be skipped as a result. Skipped: InstallDTSAction Skipped: Action "InstallDTSAction" was not run. Information reported during analysis: No install request found for package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.11 Skipped: Action "InstallDTSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.12 Skipped: Action "InstallDTSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.18 Skipped: Action "InstallDTSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.22 Skipped: Action "InstallDTSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "dts", install will be skipped as a result. Skipped: InstallDTSAction.9 Skipped: Action "InstallDTSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "dts", install will be skipped as a result. Skipped: InstallNSAction Skipped: Action "InstallNSAction" was not run. Information reported during analysis: No install request found for package: "ns", install will be skipped as a result. Skipped: InstallNSAction.11 Skipped: Action "InstallNSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.12 Skipped: Action "InstallNSAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.18 Skipped: Action "InstallNSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.22 Skipped: Action "InstallNSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "ns", install will be skipped as a result. Skipped: InstallNSAction.9 Skipped: Action "InstallNSAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "ns", install will be skipped as a result. Skipped: InstallRSAction.11 Skipped: Action "InstallRSAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.18 Skipped: Action "InstallRSAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "rs", install will be skipped as a result. Skipped: InstallRSAction.22 Skipped: Action "InstallRSAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "rs", install will be skipped as a result. Running: InstallSqlAction.11 at: 2008/2/31 15:54:32 Installing: sqlsupport on target: SALL10014041 Complete: InstallSqlAction.11 at: 2008/2/31 15:54:50, returned true Running: InstallSqlAction.12 at: 2008/2/31 15:54:51 Installing: sqlncli on target: SALL10014041 Complete: InstallSqlAction.12 at: 2008/2/31 15:55:11, returned true Skipped: InstallSqlAction.18 Skipped: Action "InstallSqlAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "sql", install will be skipped as a result. Running: InstallSqlAction.21 at: 2008/2/31 15:55:11 Installing: sqlwriter on target: SALL10014041 Complete: InstallSqlAction.21 at: 2008/2/31 15:55:14, returned true Skipped: InstallSqlAction.22 Skipped: Action "InstallSqlAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "sql", install will be skipped as a result. Running: InstallSqlAction.9 at: 2008/2/31 15:55:14 Installing: msxml6 on target: SALL10014041 Complete: InstallSqlAction.9 at: 2008/2/31 15:55:17, returned true Skipped: InstallToolsAction.11 Skipped: Action "InstallToolsAction.11" was not run. Information reported during analysis: No install request found for package: "sqlsupport", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.12 Skipped: Action "InstallToolsAction.12" was not run. Information reported during analysis: No install request found for package: "sqlncli", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.13 Skipped: Action "InstallToolsAction.13" was not run. Information reported during analysis: No install request found for package: "PPESku", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.18 Skipped: Action "InstallToolsAction.18" was not run. Information reported during analysis: No install request found for package: "owc11", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.20 Skipped: Action "InstallToolsAction.20" was not run. Information reported during analysis: No install request found for package: "BOL", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.22 Skipped: Action "InstallToolsAction.22" was not run. Information reported during analysis: No install request found for package: "bcRedist", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.23 Skipped: Action "InstallToolsAction.23" was not run. Information reported during analysis: No install request found for package: "ssmsee", referred by package: "tools", install will be skipped as a result. Skipped: InstallToolsAction.9 Skipped: Action "InstallToolsAction.9" was not run. Information reported during analysis: No install request found for package: "msxml6", referred by package: "tools", install will be skipped as a result. Skipped: InstallNSAction.10 Skipped: Action "InstallNSAction.10" was not run. Information reported during analysis: No install request found for package: "sqlxml4", referred by package: "ns", install will be skipped as a result. Running: InstallSqlAction at: 2008/2/31 15:55:17 Installing: sql on target: SALL10014041 Failed to install package Fatal error during installation. Setting package return code to: 29503 Complete: InstallSqlAction at: 2008/2/31 16:3:48, returned false Error: Action "InstallSqlAction" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Skipped: InstallToolsAction.10 Skipped: Action "InstallToolsAction.10" was not run. Information reported during analysis: No install request found for package: "sqlxml4", referred by package: "tools", install will be skipped as a result. Skipped: InstallASAction Skipped: Action "InstallASAction" was not run. Information reported during analysis: No install request found for package: "as", install will be skipped as a result. Skipped: InstallRSAction Skipped: Action "InstallRSAction" was not run. Information reported during analysis: No install request found for package: "rs", install will be skipped as a result. Skipped: InstallToolsAction Skipped: Action "InstallToolsAction" was not run. Information reported during analysis: No install request found for package: "tools", install will be skipped as a result. Skipped: RepairForBackwardsCompatRedistAction Skipped: Action "RepairForBackwardsCompatRedistAction" was not run. Information reported during analysis: Action: "RepairForBackwardsCompatRedistAction" will be skipped due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Error: Action "UninstallForMSDE2000Action" failed during execution. Error information reported during run: Action: "UninstallForMSDE2000Action" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchMSDE2000" failed due to a precondition. Error: Action "UninstallForSQLAction" failed during execution. Error information reported during run: Action: "UninstallForSQLAction" will be marked as failed due to the following condition: Condition "sql was successfully upgraded." returned false. Condition context: sql failed to upgrade and so the uninstall of the upgraded product will not occur. Installation of package: "patchLibertySql" failed due to a precondition. Skipped: UninstallForRS2000Action Skipped: Action "UninstallForRS2000Action" was not run. Information reported during analysis: Action: "UninstallForRS2000Action" will be skipped due to the following condition: Condition "Action: InstallRSAction was skipped." returned true. Error: Action "ExposeVistaClusteredResources" failed during execution. Error information reported during run: Action: "ExposeVistaClusteredResources" will be marked as failed due to the following condition: Condition "The Clustered SQL Server instance that hosts is installed." returned false. Running: ReportChainingResults at: 2008/2/31 16:3:48 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : -2146885628 Error Code: -2146885628 Windows Error Text: Cannot find object or property.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Nov 16 20:31:57 2006 Function Name: sqls::ReportChainingResults:erform Source Line Number: 3521
---- Context ----------------------------------------------- sqls::HostSetupPackageInstallerSynch:ostCommit sqls::HighlyAvailablePackage:reInstall led due to cancel code received from cancel source: 29539
Whole installation works fine until it comes to "Selected components are being configured" and there it shows:
MSXML6 - Setup FAILED. refer to the Setup log for details.
SQL Setup support files - Setup FINISHED.
SQL Native Client - Setup FINISHED.
SQL VSS Writter - - Setup FINISHED.
SQL Server Database Services - Setup FAILED. refer to the Setup log for details
And that's it. I cannot install SQL Server 2005 express.
I guess the problem is MSXML6 it cannot install because there is a newer version already there but I cannot uninstall it. How can I solve this problem ??
Hi, This is my first post and I would appreciate some help. I downloaded VWD + Sql Server (Express versions) for some development on a standalone laptop with Windows XP Home. I downloaded the CD image, created a CD and installed on the laptop - VWD + MSDN + Sql server. The installation went OK and I was productively developing until the disk crashed!
I got new laptop with Windows XP Pro SP2 - I replied to the set up prompts for XP Pro when the machine was first started. I then tried installed VWD+MSDN+Sql Server (29/11). Sql Server failed - I think the error in the ERRORLOG file was 15209. I didn't know that at the time, but did research on the web coming across this site and many others. In this research, I found many references to many problems re install of Sql Server. I noticed on the laptop, there was another version of Framework (1.1) and the Sql Server folder had 80, 90, MSSQL.1 and MSSQL.2. Could they have been installed by Windows XP ? MS Office and Norton Security are also on this new laptop. Anyway, I thought the problem was to do with the extra folders etc., so I uninstalled all the stuff via Add/Remove so that I could do a new install - I did the uninstalls in the recommended order. I decided not to delete the folder for Sql Server (Program FilesMicrosoft SQL Server...) - there wasn't a lot in it. Anyway, I did the install again and I have the same error - 15209 - just after "Starting up database 'mssqlsystemresource' ".
I have seen documents that relate directly to this error and they refer to 'c:Documents and SettingsNetwork ServiceApplication DataMicrosoftProtect'. I have 'c:Documents and Settings' but no 'Network Service' etc. (hidden or otherwise). I intend to do the development completely locally on the standalone machine and then port it elsewhere. There will be no remote access.
Do I have to have any network settings in XP Pro for Sql Server to install? I've also seen references to MS DTC and Encryption - do I have to do anything about them? It took a while to get going on the previous machine but, eventually, it was going well, I even had Sql Server Mgt Studio and Books Online set up and I was putting lots of data in a database. Now it's very frustrating since I've just spent days and days trying just to get the software installed.
Thanks in advance to any knowledgeable person who can help, Garnet
I am installing SQL Server Express into Siemens Simatic Microbox PC .I know that minimun speed processor is 450MhzThe processor is a Mobile Intel Celeron 400Mhz, with 256MB RAM, so I have got the next error in Log file:Processing article ProcessorOpenning namespace \rootcimv2GetNamespace \rootcimv2 returned 0 (0x0)Scc Error: 50022 (0xc366)Error code: 70009 (0x11179)Calling callback function for reason: 0x2Callback function returned TRUEProcessing article PhysicalMemoryOpenning namespace \rootcimv2GetNamespace \rootcimv2 returned 0 (0x0)Scc Error: 50022 (0xc366)Error code: 70009 (0x11179)Calling callback function for reason: 0x2Callback function returned TRUECan I jump this hardware check and errors? How can I continue the installation?Thanks...
I'm experiencing a problem installing SQL Server Express 2005. I thought I had the same problem as Tom from a recent thread but his error file is quite different from mine. The Visual Basic Express package properly installed everything except SQL Server. I've run it many times, but the service fails to start. I also downloaded the separate installation package for SQL Server Express and ran it several times, which also failed. It gets to a point where the services are installed, but when I try to manually start the SQL service it says that the service started and then stopped. The event viewer shows this error:
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 (1067) The process terminated unexpectedly.
The error log is:
2006-05-02 16:10:58.07 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
2006-05-02 16:10:58.08 Server (c) 2005 Microsoft Corporation. 2006-05-02 16:10:58.08 Server All rights reserved. 2006-05-02 16:10:58.09 Server Server process ID is 816. 2006-05-02 16:10:58.09 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'. 2006-05-02 16:10:58.09 Server This instance of SQL Server last reported using a process ID of 2748 at 5/2/2006 4:10:29 PM (local) 5/2/2006 9:10:29 PM (UTC). This is an informational message only; no user action is required. 2006-05-02 16:10:58.15 Server Registry startup parameters: 2006-05-02 16:10:58.15 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf 2006-05-02 16:10:58.15 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG 2006-05-02 16:10:58.16 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf 2006-05-02 16:10:58.28 Server Error: 17311, Severity: 16, State: 1. 2006-05-02 16:10:58.28 Server SQL Server is terminating because of fatal exception c000001d. This error may be caused by an unhandled Win32 or C++ exception, or by an access violation encountered during exception handling. Check the SQL error log for any related stack dumps or messages. This exception forces SQL Server to shutdown. To recover from this error, restart the server (unless SQLAgent is configured to auto restart). 2006-05-02 16:10:58.30 Server Using 'dbghelp.dll' version '4.0.5' 2006-05-02 16:10:58.36 Server **Dump thread - spid = 0, PSS = 0x00000000, EC = 0x00000000 2006-05-02 16:10:58.36 Server ***Stack Dump being sent to c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGSQLDump0005.txt 2006-05-02 16:10:58.36 Server * ******************************************************************************* 2006-05-02 16:10:58.36 Server * 2006-05-02 16:10:58.36 Server * BEGIN STACK DUMP: 2006-05-02 16:10:58.36 Server * 05/02/06 16:10:58 spid 0 2006-05-02 16:10:58.36 Server * 2006-05-02 16:10:58.36 Server * ex_handle_except encountered exception C000001D - Server terminating 2006-05-02 16:10:58.36 Server * 2006-05-02 16:10:58.36 Server * 2006-05-02 16:10:58.36 Server * MODULE BASE END SIZE 2006-05-02 16:10:58.36 Server * sqlservr 01000000 02BCEFFF 01bcf000 2006-05-02 16:10:58.36 Server * ntdll 7C900000 7C9AFFFF 000b0000 2006-05-02 16:10:58.36 Server * kernel32 7C800000 7C8F3FFF 000f4000 2006-05-02 16:10:58.36 Server * MSVCR80 78130000 781CAFFF 0009b000 2006-05-02 16:10:58.36 Server * msvcrt 77C10000 77C67FFF 00058000 2006-05-02 16:10:58.37 Server * MSVCP80 7C420000 7C4A6FFF 00087000 2006-05-02 16:10:58.37 Server * ADVAPI32 77DD0000 77E6AFFF 0009b000 2006-05-02 16:10:58.37 Server * RPCRT4 77E70000 77F00FFF 00091000 2006-05-02 16:10:58.37 Server * USER32 77D40000 77DCFFFF 00090000 2006-05-02 16:10:58.37 Server * GDI32 77F10000 77F56FFF 00047000 2006-05-02 16:10:58.37 Server * CRYPT32 77A80000 77B13FFF 00094000 2006-05-02 16:10:58.37 Server * MSASN1 77B20000 77B31FFF 00012000 2006-05-02 16:10:58.37 Server * Secur32 77FE0000 77FF0FFF 00011000 2006-05-02 16:10:58.37 Server * MSWSOCK 71A50000 71A8EFFF 0003f000 2006-05-02 16:10:58.37 Server * WS2_32 71AB0000 71AC6FFF 00017000 2006-05-02 16:10:58.37 Server * WS2HELP 71AA0000 71AA7FFF 00008000 2006-05-02 16:10:58.37 Server * USERENV 769C0000 76A72FFF 000b3000 2006-05-02 16:10:58.37 Server * opends60 333E0000 333E6FFF 00007000 2006-05-02 16:10:58.37 Server * NETAPI32 5B860000 5B8B3FFF 00054000 2006-05-02 16:10:58.37 Server * SHELL32 7C9C0000 7D1D4FFF 00815000 2006-05-02 16:10:58.37 Server * SHLWAPI 77F60000 77FD5FFF 00076000 2006-05-02 16:10:58.37 Server * OCMAPIHK 10000000 1000CFFF 0000d000 2006-05-02 16:10:58.37 Server * comctl32 773D0000 774D1FFF 00102000 2006-05-02 16:10:58.37 Server * comctl32 5D090000 5D126FFF 00097000 2006-05-02 16:10:58.37 Server * psapi 76BF0000 76BFAFFF 0000b000 2006-05-02 16:10:58.37 Server * instapi 48060000 48069FFF 0000a000 2006-05-02 16:10:58.37 Server * sqlevn70 4F610000 4F7A3FFF 00194000 2006-05-02 16:10:58.37 Server * dbghelp 03000000 03112FFF 00113000 2006-05-02 16:10:58.37 Server * 2006-05-02 16:10:58.37 Server * Edi: 0075C528: 000E1068 00000000 00000000 00000000 0075C548 00000000 2006-05-02 16:10:58.37 Server * Esi: 00000000: 2006-05-02 16:10:58.37 Server * Eax: 0075C40C: 000042AC 00000000 00000000 7C81EB33 00000000 0000000C 2006-05-02 16:10:58.37 Server * Ebx: 0000003F: 2006-05-02 16:10:58.38 Server * Ecx: 0075CA7C: 00000000 0001001F 00000000 00000000 00000000 00000000 2006-05-02 16:10:58.38 Server * Edx: 0000003D: 2006-05-02 16:10:58.38 Server * Eip: 7C81EB33: 10C2C95E 0FFF8500 FED0E68E FC558BFF 0F0C5589 7D8B16B7 2006-05-02 16:10:58.38 Server * Ebp: 0075C45C: 0075C4A0 02187744 000042AC 00000000 00000000 00000000 2006-05-02 16:10:58.38 Server * SegCs: 0000001B: 2006-05-02 16:10:58.38 Server * EFlags: 00080246: 2006-05-02 16:10:58.38 Server * Esp: 0075C408: 00000000 000042AC 00000000 00000000 7C81EB33 00000000 2006-05-02 16:10:58.38 Server * SegSs: 00000023: 2006-05-02 16:10:58.38 Server * ******************************************************************************* 2006-05-02 16:10:58.38 Server * ------------------------------------------------------------------------------- 2006-05-02 16:10:58.38 Server * Short Stack Dump 2006-05-02 16:10:58.50 Server 7C81EB33 Module(kernel32+0001EB33) 2006-05-02 16:10:58.50 Server 02187744 Module(sqlservr+01187744) 2006-05-02 16:10:58.51 Server 0218B600 Module(sqlservr+0118B600) 2006-05-02 16:10:58.51 Server 0218B1AD Module(sqlservr+0118B1AD) 2006-05-02 16:10:58.51 Server 023F4109 Module(sqlservr+013F4109) 2006-05-02 16:10:58.51 Server 7C862CD3 Module(kernel32+00062CD3) 2006-05-02 16:10:58.57 Server 7C83AA6B Module(kernel32+0003AA6B) 2006-05-02 16:10:58.60 Server Stack Signature for the dump is 0xDF483EDE 2006-05-02 16:10:59.33 Server External dump process return code 0x20000001. External dump process returned no errors.
I have tried several times to install SSEE and SSEE with Advanced Services. Each time it fails early in the installation. I am running XP SP2 with 1GB memory. There was no previous install of SSEE. The error reads, "SQL Server Setup unexpectedly fialed. For more information, review the Setup summary log file...". The log file follows:
Microsoft SQL Server 2005 Setup beginning at Thu May 04 20:58:25 2006
I am having real problems trying to install the 64 bit version of the management studio express on to my vista 64 bit operating system.
I have managed to load SQL express but I cannot for the life of me get this package to install.
I went to the standard site where you get Visual basic etc and downloaded the 64 bit version as per the double astrix link at the bottom and got a chinese version!!
"The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 29506"
Is there anyone out there that can point me to a package for the 64 bit version of Microsoft SQL Server Management Studio Express that's in English and actually installs??
I have a server version of SQL Server, but I need a local SQL Server Express version as well for dev.
When I install express and the full set of SQL Server management tools, I can see my Express instance in configuration manager, but Management Studio says the instance is broken. I have tried both SA and windows authentication. I turned on all the protocols in both server and client, but no luck.
The error returned is Error 26 Error locating server instance specified, but I am selecting the instance from the dropdown box, so it is not a typo. I have tried quite a few variations with no success.
I have tried to download SQL Server 2005 Express from Disc 2 of Office Ultimate 2007 several times and it keeps failing. I have received the following information in the log. What do I do to resolve this problem.
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Tue Apr 22 15:39:58 2008
Machine : WHEELER-LAPTOP Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_WHEELER-LAPTOP_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : WHEELER-LAPTOP Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_WHEELER-LAPTOP_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : WHEELER-LAPTOP Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_WHEELER-LAPTOP_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : WHEELER-LAPTOP Product : MSXML 6.0 Parser (KB933579) Product Version : 6.10.1200.0 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_WHEELER-LAPTOP_MSXML6_1.log -------------------------------------------------------------------------------- Machine : WHEELER-LAPTOP Product : SQL Server Database Services Error : SQL Server Setup cannot write system databases to c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData, because it contains files from a previous installation. To continue, move the databases from the specified folder, or specify a different installation folder. Then run SQL Server Setup again. -------------------------------------------------------------------------------- Machine : WHEELER-LAPTOP Product : SQL Server Database Services Error : SQL Server Setup cannot write system databases to c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData, because it contains files from a previous installation. To continue, move the databases from the specified folder, or specify a different installation folder. Then run SQL Server Setup again. -------------------------------------------------------------------------------- Machine : WHEELER-LAPTOP Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.1.2047.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_WHEELER-LAPTOP_SQL.log Last Action : DetectExistingData Error String : SQL Server Setup cannot write system databases to c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData, because it contains files from a previous installation. To continue, move the databases from the specified folder, or specify a different installation folder. Then run SQL Server Setup again. Error Number : 28111 --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.