Cannot Install SQL Server Express, Keep Getting Errors
Nov 28, 2005I am trying to install SQL Server 2005 Express, but it fails.
View 6 RepliesI am trying to install SQL Server 2005 Express, but it fails.
View 6 RepliesI can't get the download to work...i've tried regular sql server express 2005, the express for sp2 and the express with advanced services. I keep getting this message after the native client and support files are installed.."This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem."Then right after that message is says... "Failed to load SQLSpars.dll"
View 1 Replies View RelatedHello,
View 4 Replies View RelatedI am using installshield to distribute SQL Server 2005 Express. I have the SQLEXPR.EXE file and I want to run it in /qb mode so the user can see the pretty dialogs pop up but not have to click anything.
View 6 Replies View RelatedI can't get the download to work...i've tried regular sql server express 2005, the express for sp2 and the express with advanced services. I keep getting this message after the native client and support files are installed.."This application has failed to start because XOLEHLP.dll was not found. Re-installing the application may fix this problem."Then right after that message is says... "Failed to load SQLSpars.dll"
View 1 Replies View RelatedI 'm getting this error on expanding the + nodes in SQL Server Management Studio Express Object Explorer:i.e. Database -> System Databases -> Any DB selected and expanding the Tables node When I click on the nodes for Tables for any of my databases, I see it saying expanding..., but then a message box errors pops up. It was working fine until after my lunch hour when I attempted to create some new tables.Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)Additional Information:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)Could not continue scan with NOLOCK due to data movement. (Microsoft SQL Server, Error: 601)
View 2 Replies View RelatedTrying to install SQL Server 2005 x64 Enterprise Edition during the "Workstation components, etc." part of the install, the install stops and gives me this error.
----------------------
Microsoft SQL Server 2005 Setup
Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024893
Error message: The system cannot find the path specified.
Error description: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the path specified.
[Abort] [Ignore] [Retry]
----------------------
This install is being attempted on 3 seperate servers all running Windows Server 2003 R2 Enterprise x64 Edition (Service Pack 2).
Futher notes:
Distributed Transaction Coordinator services is setup and running (started).
I checked to make sure there are no MSMQ components in the COM+ Application struture in Component Services.
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)
Hi,
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.
Thanks,
Bill
Hi,
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.
.
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlShutDownRANUInstance
PerfTime Start: Do_sqlShutDownRANUInstance : Sat Mar 08 21:39:12 2008
<Func Name='Do_sqlShutDownRANUInstance'>
Service SQLEXPRESS with parameters '' is being started at Sat Mar 08 21:39:12 2008
Unable to start service (3)
Error Code: 0x80070003 (3)
Windows Error Text: The system cannot find the path specified.
Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
Function Name: sqls:ervice:tart
Source Line Number: 316
---- Context -----------------------------------------------
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.
.
Hi all,
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.
Thanks,
Scott Chang
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've been having horrific problems installing and working with SQL Server Express 2005. I installed SSE with the Visual Web Developer tool so I assumed that the instance would synch up; but it didn't (see log contents at end) so I opened up permissions wide open to all users, and even that didn't help. I don't know for sure but I suspect that the problem probably relates to my deleting SQL Server entries from the registry and all directories and files related to it on disk. After going through the process of uninstalling and reinstalling Express 2005 numerous times, I became frustrated and decided to pull out all stops.
After reading and following all MSDN instructions and every blog and forum I could possibly locate on the subject, I could never resolve the problem of not reaching my database. I enabled all pipes and TCP/IP, etc. in the Configuration Manager, in both instances I had created; had run all command-line procedures recommended; and used cleanup programs that I could find, before reinstalling. I couldn't even get success in doing a test connection. I did get to a point where my ASP returned the message that it had connected but that the user didn't have permissions.
I think I'm destined to working with Access, which is a shame since I have encouraged students in a Web development class I teach to work with the more powerful SQL Server products. They've had success with SQL Server, so I'm setting a bad example.
Thanks in advance for help any of you can suggest.
Microsoft SQL Server 2005 Setup beginning at Sun Feb 05 23:48:08 2006Process ID : 2036c:6645bd818fccc8ef0bad80e6a12f5bsetup.exe Version: 2005.90.1399.0Running: LoadResourcesAction at: 2006/1/5 23:48:6Complete: LoadResourcesAction at: 2006/1/5 23:48:6, returned trueRunning: ParseBootstrapOptionsAction at: 2006/1/5 23:48:6Loaded DLL:c:6645bd818fccc8ef0bad80e6a12f5bxmlrw.dll Version:2.0.3604.0Complete: ParseBootstrapOptionsAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateWinNTAction at: 2006/1/5 23:48:8Complete: ValidateWinNTAction at: 2006/1/5 23:48:8, returned trueRunning: ValidateMinOSAction at: 2006/1/5 23:48:8Complete: ValidateMinOSAction at: 2006/1/5 23:48:8, returned trueRunning: PerformSCCAction at: 2006/1/5 23:48:8Complete: PerformSCCAction at: 2006/1/5 23:48:8, returned trueRunning: ActivateLoggingAction at: 2006/1/5 23:48:8Complete: ActivateLoggingAction at: 2006/1/5 23:48:8, returned trueRunning: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8Complete: DetectPatchedBootstrapAction at: 2006/1/5 23:48:8, returned trueAction "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2036" returned false.Running: PerformSCCAction2 at: 2006/1/5 23:48:8Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435Complete: PerformSCCAction2 at: 2006/1/5 23:48:9, returned trueRunning: PerformDotNetCheck at: 2006/1/5 23:48:9Complete: PerformDotNetCheck at: 2006/1/5 23:48:9, returned trueRunning: ComponentUpdateAction at: 2006/1/5 23:48:9Complete: ComponentUpdateAction at: 2006/1/5 23:48:30, returned trueRunning: DetectLocalBootstrapAction at: 2006/1/5 23:48:30Complete: DetectLocalBootstrapAction at: 2006/1/5 23:48:30, returned trueRunning: LaunchLocalBootstrapAction at: 2006/1/5 23:48:30
I am trying to debug a classic ASP application using Visual Web Developer Express and SQL Server Express editions. When my application tries to execute a stored procedure, I get the following error:
Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available.
Is there a way for me to trace queries that are getting executed in SQL Server Express so I can see which stored procedure is failing? I seem to remember being able to do this with SQL Server 2000. Any other ideas on how to debug SQL Server errors like these using SQL Server Express?
TIA for the help.
Michael
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
View 4 Replies View Relatedi 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
--------------------------------------------------------------------------------
any advice?? i have no clue ....
thanks!
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?
View 3 Replies View Related
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
= = =
Thanks
Thomas
Please help!
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.
The install fails and here is the log:
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
Please help.
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
--------------------------------------------------------------------------------
Hi all,
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 !
Any idea's ?
Thanks in advance.
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 :
http://msdn2.microsoft.com/en-gb/express/bb410792.aspx
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.
Any help appreciated
Hello,
I've been trying to install SQL Server express edition all day and it errors out every time. I've tried it on two different servers and I get the same errors. Here's what the error log says:
2007-04-20 16:37:52.77 Server Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
Feb 9 2007 22:47:07
Copyright (c) 1988-2005 Microsoft Corporation
Express Edition on Windows NT 5.2 (Build 3790: Service Pack 2, v.2825)
2007-04-20 16:37:52.77 Server (c) 2005 Microsoft Corporation.
2007-04-20 16:37:52.77 Server All rights reserved.
2007-04-20 16:37:52.77 Server Server process ID is 1356.
2007-04-20 16:37:52.77 Server Authentication mode is MIXED.
2007-04-20 16:37:52.77 Server Logging SQL Server messages in file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-04-20 16:37:52.77 Server This instance of SQL Server last reported using a process ID of 1964 at 4/20/2007 4:37:47 PM (local) 4/20/2007 8:37:47 PM (UTC). This is an informational message only; no user action is required.
2007-04-20 16:37:52.77 Server Registry startup parameters:
2007-04-20 16:37:52.77 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-04-20 16:37:52.77 Server -e c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-04-20 16:37:52.77 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-04-20 16:37:52.77 Server Command Line Startup Parameters:
2007-04-20 16:37:52.77 Server -d c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf
2007-04-20 16:37:52.77 Server -l c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf
2007-04-20 16:37:52.77 Server -m SqlSetup
2007-04-20 16:37:52.77 Server SqlSetup
2007-04-20 16:37:52.77 Server -Q
2007-04-20 16:37:52.77 Server -q SQL_Latin1_General_CP1_CI_AS
2007-04-20 16:37:52.77 Server -T 4022
2007-04-20 16:37:52.77 Server -T 3659
2007-04-20 16:37:52.77 Server -T 3610
2007-04-20 16:37:52.77 Server -T 4010
2007-04-20 16:37:52.79 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-04-20 16:37:52.79 Server Detected 1 CPUs. This is an informational message; no user action is required.
2007-04-20 16:37:52.88 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2007-04-20 16:37:52.92 Server Database Mirroring Transport is disabled in the endpoint configuration.
2007-04-20 16:37:52.93 spid5s Warning ******************
2007-04-20 16:37:52.93 spid5s SQL Server started in single-user mode. This an informational message only. No user action is required.
2007-04-20 16:37:52.93 spid5s Starting up database 'master'.
2007-04-20 16:37:52.93 spid5s Error: 17207, Severity: 16, State: 1.
2007-04-20 16:37:52.93 spid5s FCB:pen: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf'. Diagnose and correct the operating system error, and retry the operation.
2007-04-20 16:37:52.97 spid5s Error: 17204, Severity: 16, State: 1.
2007-04-20 16:37:52.97 spid5s FCB:pen failed: Could not open file c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf for file number 1. OS error: 5(Access is denied.).
2007-04-20 16:37:52.98 spid5s Error: 5120, Severity: 16, State: 101.
2007-04-20 16:37:52.98 spid5s Unable to open the physical file "c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf". Operating system error 5: "5(Access is denied.)".
2007-04-20 16:37:53.05 spid5s Error: 17207, Severity: 16, State: 1.
2007-04-20 16:37:53.05 spid5s FCB:pen: Operating system error 5(Access is denied.) occurred while creating or opening file 'c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2007-04-20 16:37:53.05 spid5s Error: 17204, Severity: 16, State: 1.
2007-04-20 16:37:53.05 spid5s FCB:pen failed: Could not open file c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf for file number 2. OS error: 5(Access is denied.).
2007-04-20 16:37:53.05 spid5s Error: 5120, Severity: 16, State: 101.
2007-04-20 16:37:53.05 spid5s Unable to open the physical file "c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf". Operating system error 5: "5(Access is denied.)".
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.
View 4 Replies View RelatedI'm new to database configuration so bear with me...
How do you silently install SQL Server Express?
Also, I need the server name to be MY_COMPANY_NAME instead of SQLEXPRESS.
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.
Any idea what I need to do to get this to work?
Carlo
I've read that SQL Express will only use one CPU, can you install on a machine with 4 CPU's and have it only use one?
View 4 Replies View RelatedHere's the summary:
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:
<Func Name='LaunchFunction'>
Function=Do_sqlMofcomp
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlMofcomp
PerfTime Start: Do_sqlMofcomp : Tue May 15 12:26:33 2007
<Func Name='InstallMOF'>
MOF data compiled from c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlwep-xp.mof
<EndFunc Name='InstallMOF' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlMofcomp : Tue May 15 12:26:33 2007
MSI (s) (24:00) [12:26:33:756]: Executing op: ActionStart(Name=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:33:757]: Executing op: CustomActionSchedule(Action=Rollback_sqlMofcomp.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_sqlMofcomp,CustomActionData=010Installing WMI registration50000\.
ootMicrosoftSqlServerServerEventsSQLEXPRESSc:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlwep-xp.mof)
MSI (s) (24:00) [12:26:33:758]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
MSI (s) (24:00) [12:26:33:791]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerServerEvents(A;CI;CCDCLCSWRPWPRCWD;;;BA))
MSI (s) (24:30) [12:26:33:794]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3B2A.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Tue May 15 12:26:33 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerServerEvents
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)
<Func Name='SecureWMINamespace'>
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Tue May 15 12:26:33 2007
MSI (s) (24:00) [12:26:33:843]: Executing op: ActionStart(Name=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing WMI registration,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:33:843]: Executing op: CustomActionSchedule(Action=Do_WMISecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_WMISecurity,CustomActionData=100Installing WMI registration0\.
ootMicrosoftSqlServerComputerManagement(A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD))
MSI (s) (24:14) [12:26:33:846]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3B69.tmp, Entrypoint: Do_WMISecurity
<Func Name='LaunchFunction'>
Function=Do_WMISecurity
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_WMISecurity
PerfTime Start: Do_WMISecurity : Tue May 15 12:26:33 2007
<Func Name='Do_WMISecurity'>
Configuring ACL for WMI namespace \.
ootMicrosoftSqlServerComputerManagement
ACL: (A;CI;CCDCLCSWRPWPRCWD;;;BA)(A;CI;CC;;;WD)
<Func Name='SecureWMINamespace'>
<EndFunc Name='SecureWMINamespace' Return='0' GetLastError='0'>
<EndFunc Name='Do_WMISecurity' Return='0' GetLastError='0'>
PerfTime Stop: Do_WMISecurity : Tue May 15 12:26:33 2007
MSI (s) (24:00) [12:26:33:890]: Executing op: ActionStart(Name=StartServices,Description=Starting services,Template=Service: [1])
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:33:890]: Executing op: ProgressTotal(Total=4,Type=1,ByteEquivalent=1300000)
MSI (s) (24:00) [12:26:33:891]: Executing op: ServiceControl(,Name=SQLWriter,Action=1,Wait=0,)
MSI (s) (24:00) [12:26:33:961]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:33:962]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200c:DataMSSQL.1MSSQLDatamssqlsystemresource1.mdfc:DataMSSQL.1MSSQLDatamssqlsystemresource.mdf0)
MSI (s) (24:00) [12:26:33:963]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:34:163]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200c:DataMSSQL.1MSSQLDatamssqlsystemresource1.mdfc:DataMSSQL.1MSSQLDatamssqlsystemresource.mdf0)
MSI (s) (24:F0) [12:26:34:166]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3CA2.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Tue May 15 12:26:34 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Tue May 15 12:26:34 2007
MSI (s) (24:00) [12:26:34:200]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:34:296]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200c:DataMSSQL.1MSSQLDatamssqlsystemresource1.ldfc:DataMSSQL.1MSSQLDatamssqlsystemresource.ldf0)
MSI (s) (24:00) [12:26:34:297]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:34:320]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200c:DataMSSQL.1MSSQLDatamssqlsystemresource1.ldfc:DataMSSQL.1MSSQLDatamssqlsystemresource.ldf0)
MSI (s) (24:74) [12:26:34:323]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3D3F.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Tue May 15 12:26:34 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Tue May 15 12:26:34 2007
MSI (s) (24:00) [12:26:34:355]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:34:356]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200c:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource1.ldfc:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource.ldf0)
MSI (s) (24:00) [12:26:34:357]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:34:384]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200c:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource1.ldfc:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource.ldf0)
MSI (s) (24:54) [12:26:34:387]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3D7F.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Tue May 15 12:26:34 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Tue May 15 12:26:34 2007
MSI (s) (24:00) [12:26:34:421]: Executing op: ActionStart(Name=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:34:422]: Executing op: CustomActionSchedule(Action=Rollback_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlFileRename,CustomActionData=100Renaming Files200c:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource1.mdfc:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource.mdf0)
MSI (s) (24:00) [12:26:34:423]: Executing op: ActionStart(Name=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Renaming Files,)
MSI (s) (24:00) [12:26:34:480]: Executing op: CustomActionSchedule(Action=Do_sqlFileRename.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlFileRename,CustomActionData=110Renaming Files200c:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource1.mdfc:DataMSSQL.1MSSQLTemplate Datamssqlsystemresource.mdf0)
MSI (s) (24:B0) [12:26:34:483]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3DDD.tmp, Entrypoint: Do_sqlFileRename
<Func Name='LaunchFunction'>
Function=Do_sqlFileRename
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlFileRename
PerfTime Start: Do_sqlFileRename : Tue May 15 12:26:34 2007
<Func Name='Do_sqlFileRename'>
<EndFunc Name='Do_sqlFileRename' Return='0' GetLastError='0'>
PerfTime Stop: Do_sqlFileRename : Tue May 15 12:26:34 2007
MSI (s) (24:00) [12:26:34:498]: Executing op: ActionStart(Name=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Stopping SQL Service: [1])
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (24:00) [12:26:34:499]: Executing op: CustomActionSchedule(Action=Rollback_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1345,Source=BinaryData,Target=Rollback_sqlScript,CustomActionData=100Configuring Microsoft SQL Server81054800lpc:RJMHOME2SQLEXPRESS)
MSI (s) (24:00) [12:26:34:500]: Executing op: ActionStart(Name=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Configuring Microsoft SQL Server,Template=Starting SQL Service: [1])
MSI (s) (24:00) [12:26:34:542]: Executing op: CustomActionSchedule(Action=Do_sqlScript.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=9217,Source=BinaryData,Target=**********,CustomActionData=**********)
MSI (s) (24:CC) [12:26:34:546]: Invoking remote custom action. DLL: C:WindowsInstallerMSI3E1D.tmp, Entrypoint: Do_sqlScript
<Func Name='LaunchFunction'>
Function=Do_sqlScript
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='203'>
Doing Action: Do_sqlScript
PerfTime Start: Do_sqlScript : Tue May 15 12:26:34 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:34 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
---- Context -----------------------------------------------
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
---- Context -----------------------------------------------
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
---- Context -----------------------------------------------
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.
Fails on SQL Server Database services with "The SQL server service failed to start". Can't start manually either.
View 3 Replies View RelatedThe 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.
Any thoughts?
Hi, there!
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