I am using Visual Studio 2005 Standard on XP Prof
Everything works well with installation except Sql Server Express was not installed.
I tried repairing/reinstalling -> would not install sql server expresss
I tried uninstalling and starting over (which was a hassle with all of the manual removals)
Still the same problem, everything works well but Sql Server Express will not install.
Any suggestions??
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.
Can I have both of them installed ? I work on applications sometimes on two different machines. One has Visual studio w/ sql 2005 developer edition, the other with express editions of both. Can I install sql express on my workstation that already has developer edition ?
I have installed SQL standard Edition in my computer for one project. We want to kick off a new project, and intend to use SQL Express, Will anybody advise me whether I can install SQL express when SQL Standard Edition is there? or I need to remove SQL standard Edition first and install SQL express?
My VS 2005 SQL Express Edition will not install because my hardware is, well a little old, AMD K5 processor. I was wonder if I could instead run the older MSDE 2000 and still access this database using VS 2005 C# Express Edition?
Hi: I have installed SQL 2005 Developer Edition and VS 2005. Do I need to also install SQL 2005 Express edition too?????
My version of VS2005 is proffesional. I cannot seem to find SQL 2005 Developer Edition in the Server Explorer of VS2005. So I am wondering if I need to install SQL 2005 Express. Before I had SQL 2000 and MSDE installed with VS2003 and there was no problem.
We are trying to install the Standard Edition of SQL Server 2005. We already have SQL Express installed. Standard won't install and Express won't uninstall.
We have tried every suggestion we can find and some we made up. When we try to install Standard, we get to the bit where you choose what you want to install and the only thing available is workstation components.
There are so many cases of this on the Internat that I can't believe MS have not solved the issue. And I am stunned that they want to charge us more money to talk to us about how to fix something we just paid them an arm and a leg for!
What do I need to tell you to get some idea of where to go next with this?
Hi, This is my first post. I am trying to install SQL express on my PC but it keeps on having this error: "encountered an unexpected error in datastore. The action is setdialogs..."
I have searched far and wide for a solution to this problem. Some solutions worked for others, but none worked for me so far. I don't have a previously installed sql version on my laptop. But just to check, I followed the steps in using msiinv.exe to detect any previously installed software. I am pretty sure that there was no sql server entry in the output file.
I have all the requirements, installed (.net framework 2.0,etc). I have all the latest Windows updates (except XP SP3). My laptop is well above the minimum requirements for sql express ( Core 2 processor, 2 gigs ram, 7Gigs free space).
I have the Protected Storage service running (which I found out was required to install sql server). I even followed the directions to fix Cryptograhical services.
I am runninng out of options here.
Thank you for your replies.
Here's my log: [code] Microsoft SQL Server 2005 Setup beginning at Fri May 30 11:20:48 2008 Process ID : 564 c:487084033731d74b14setup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2008/4/30 11:20:48 Complete: LoadResourcesAction at: 2008/4/30 11:20:48, returned true Running: ParseBootstrapOptionsAction at: 2008/4/30 11:20:48 Loaded DLL:c:487084033731d74b14xmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2008/4/30 11:20:48, 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 Jun 14 16:30:14 2006 Function Name: writeEncryptedString Source Line Number: 124 ---------------------------------------------------------- writeEncryptedString() failed Source File Name: utillibpersisthelpers.cpp Compiler Timestamp: Wed Jun 14 16:30:14 2006 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 Jun 14 16:28:04 2006 Function Name: sqls::CryptSameUserSameMachine:rotectData Source Line Number: 50
2 Could not skip Component update due to datastore exception. Source File Name: datastorecachedpropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "564"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.InstallMediaPath Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Running: ValidateWinNTAction at: 2008/4/30 11:20:48 Complete: ValidateWinNTAction at: 2008/4/30 11:20:48, returned true Running: ValidateMinOSAction at: 2008/4/30 11:20:48 Complete: ValidateMinOSAction at: 2008/4/30 11:20:48, returned true Running: PerformSCCAction at: 2008/4/30 11:20:48 Complete: PerformSCCAction at: 2008/4/30 11:20:48, returned true Running: ActivateLoggingAction at: 2008/4/30 11:20:48 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 Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupStateScope.primaryLogFiles Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupStateScope" 00E4CFC0Unable 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 Jun 14 16:28:01 2006 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 Jun 14 16:27:59 2006 Function Name: CachedPropertyCollection::findProperty Source Line Number: 130 ---------------------------------------------------------- Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "564"} in cache Source File Name: datastorepropertycollection.cpp Compiler Timestamp: Wed Jun 14 16:28:01 2006 Function Name: SetupBootstrapOptionsScope.HostSetup Source Line Number: 44 ---------------------------------------------------------- No collector registered for scope: "SetupBootstrapOptionsScope" Message pump returning: 2
Hi. I've recently installed (not sure about the exact order): .NET 2.0 Redist Package .NET 2.0 Framework SDK Visual C# 2005 EE Visual C++ 2005 EE Platform SDK (Windows Server 2003 R2) Directx 9 SDK
I just want to start my way up with C# initially. I've been watching some lessons and I'm trying to use some SQL features of Visual Studio EE. Whenever I try to create a SQL item in my project list, I get the following error message box:
Connections to SQL server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component, or download from the URL:... I got the SQL 2005 Express from MS' website, only to get this during (everything set to default) installation:
An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
Greetz All. XP Pro SP2. For days I've been trying to install SQL SERVER 2005 EXPRESS EDITION. Installation gets to around 95% and stops, citing error 2950. I've applied MS Workaround and provided Full Rights to folder NetworkService (I have no folder named Protect), to no avail. Any and all help most welcome. Relevant logs follow.
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Wed Apr 09 19:59:03 2008 Machine : GEMINI Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_SQLSupport_1.log Machine : GEMINI Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_SQLNCLI_1.log Machine : GEMINI Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_SqlWriter_1.log Machine : GEMINI Product : MSXML 6.0 Parser (KB933579) Product Version : 6.10.1200.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_MSXML6_1.log Machine : GEMINI 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 : GEMINI Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_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 SQL Server Setup failed. %ProgramFiles%Microsoft SQL Server90Setup bootstrapLOGSummary.txt. Time : Wed Apr 09 23:15:10 2008 List of log files: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_Core(Local).log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_SQLSupport_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_SQLNCLI_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_SqlWriter_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_MSXML6_1.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_SQL.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_Datastore.xml C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_.NET Framework 2.0.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_SNAC.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_Core.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_Support.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_SCC.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_WI.log C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG ------------------------------------------------------------------------------------------------ Microsoft SQL Server 2005 Setup beginning at Wed Apr 09 19:59:03 2008 Process ID : 2148 C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.3042.0 Running: LoadResourcesAction at: 2008/3/9 19:59:3 Complete: LoadResourcesAction at: 2008/3/9 19:59:3, returned true Running: ParseBootstrapOptionsAction at: 2008/3/9 19:59:3 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3609.0 Complete: ParseBootstrapOptionsAction at: 2008/3/9 19:59:3, returned true Running: ValidateWinNTAction at: 2008/3/9 19:59:3 Complete: ValidateWinNTAction at: 2008/3/9 19:59:3, returned true Running: ValidateMinOSAction at: 2008/3/9 19:59:3 Complete: ValidateMinOSAction at: 2008/3/9 19:59:3, returned true Running: PerformSCCAction at: 2008/3/9 19:59:3 Complete: PerformSCCAction at: 2008/3/9 19:59:3, returned true Running: ActivateLoggingAction at: 2008/3/9 19:59:3 Complete: ActivateLoggingAction at: 2008/3/9 19:59:3, returned true Running: DetectPatchedBootstrapAction at: 2008/3/9 19:59:3 Complete: DetectPatchedBootstrapAction at: 2008/3/9 19:59:3, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__2148" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2008/3/9 19:59:3 Complete: PerformDotNetCheck2 at: 2008/3/9 19:59:3, returned true Running: InvokeSqlSetupDllAction at: 2008/3/9 19:59:3 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 [GEMINI] 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 = GEMINI, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = GEMINI, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = GEMINI, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = GEMINI, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = GEMINI, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = GEMINI, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = GEMINI, Article = XMLDomDocument, Result = 0 (0x0) Machine = GEMINI, Article = Processor, Result = 0 (0x0) Machine = GEMINI, Article = PhysicalMemory, Result = 0 (0x0) Machine = GEMINI, Article = DiskFreeSpace, Result = 0 (0x0) Machine = GEMINI, Article = OSVersion, Result = 0 (0x0) Machine = GEMINI, Article = OSServicePack, Result = 0 (0x0) Machine = GEMINI, Article = OSType, Result = 0 (0x0) Machine = GEMINI, Article = AdminShare, Result = 0 (0x0) Machine = GEMINI, Article = PendingReboot, Result = 0 (0x0) Machine = GEMINI, Article = IEVersion, Result = 0 (0x0) Machine = GEMINI, Article = DriveWriteAccess, Result = 0 (0x0) Machine = GEMINI, Article = COMPlus, Result = 0 (0x0) Machine = GEMINI, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = GEMINI, Article = MDAC25Version, Result = 0 (0x0) Machine = GEMINI, Article = SKUUpgrade, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: GEMINI ******************************************* 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: Pending Reboot 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/3/9 20:0:44, returned true Running: SetPackageInstallStateAction at: 2008/3/9 20:0:44 Complete: SetPackageInstallStateAction at: 2008/3/9 20:0:45, returned true Running: DeterminePackageTransformsAction at: 2008/3/9 20:0:45 Complete: DeterminePackageTransformsAction at: 2008/3/9 20:0:45, returned true Running: ValidateSetupPropertiesAction at: 2008/3/9 20:0:45 Complete: ValidateSetupPropertiesAction at: 2008/3/9 20:0:45, returned true Running: OpenPipeAction at: 2008/3/9 20:0:45 Complete: OpenPipeAction at: 2008/3/9 20:0:45, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2008/3/9 20:0:45 Complete: CreatePipeAction at: 2008/3/9 20:0:45, 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/3/9 20:0:45 Complete: PopulateMutatorDbAction at: 2008/3/9 20:0:45, returned true Running: GenerateRequestsAction at: 2008/3/9 20:0:45 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/3/9 20:0:47, returned true Running: CreateProgressWindowAction at: 2008/3/9 20:0:47 Complete: CreateProgressWindowAction at: 2008/3/9 20:0:47, returned true Running: ScheduleActionAction at: 2008/3/9 20:0:47 Complete: ScheduleActionAction at: 2008/3/9 20:0:48, 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/3/9 20:0:48 Installing: sqlsupport on target: GEMINI Complete: InstallSqlAction.11 at: 2008/3/9 20:2:8, returned true Running: InstallSqlAction.12 at: 2008/3/9 20:2:9 Installing: sqlncli on target: GEMINI Complete: InstallSqlAction.12 at: 2008/3/9 20:3:30, 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/3/9 20:3:30 Installing: sqlwriter on target: GEMINI Complete: InstallSqlAction.21 at: 2008/3/9 20:3:36, 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/3/9 20:3:36 Installing: msxml6 on target: GEMINI Complete: InstallSqlAction.9 at: 2008/3/9 20:3:39, 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/3/9 20:3:39 Installing: sql on target: GEMINI Failed to install package Fatal error during installation. Setting package return code to: 29503 Complete: InstallSqlAction at: 2008/3/9 20:51:2, 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/3/9 20:51:3 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1067 Error Code: 0x8007042b (1067) Windows Error Text: The process terminated unexpectedly. ------------------------------------------------------------------------------------------------ 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
Error: Failed to add file :"C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_GEMINI_.NET Framework 2.0.log" to cab file : "C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSqlSetup0005.cab" Error Code : 2 Running: UploadDrWatsonLogAction at: 2008/3/9 23:15:31 Message pump returning: 1067 2008-04-09 20:49:34.32 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.1 (Build 2600: Service Pack 2) 2008-04-09 20:49:34.32 Server (c) 2005 Microsoft Corporation. 2008-04-09 20:49:34.32 Server All rights reserved. 2008-04-09 20:49:34.32 Server Server process ID is 2788. 2008-04-09 20:49:34.32 Server Authentication mode is MIXED. 2008-04-09 20:49:34.32 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'. 2008-04-09 20:49:34.32 Server This instance of SQL Server last reported using a process ID of 2524 at 4/9/2008 8:42:12 PM (local) 4/9/2008 10:42:12 AM (UTC). This is an informational message only; no user action is required. 2008-04-09 20:49:34.32 Server Registry startup parameters: 2008-04-09 20:49:34.32 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf 2008-04-09 20:49:34.32 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG 2008-04-09 20:49:34.32 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf 2008-04-09 20:49:34.32 Server Command Line Startup Parameters: 2008-04-09 20:49:34.32 Server -m SqlSetup 2008-04-09 20:49:34.32 Server SqlSetup 2008-04-09 20:49:34.32 Server -Q 2008-04-09 20:49:34.32 Server -q SQL_Latin1_General_CP1_CI_AS 2008-04-09 20:49:34.32 Server -T 4022 2008-04-09 20:49:34.32 Server -T 3659 2008-04-09 20:49:34.32 Server -T 3610 2008-04-09 20:49:34.32 Server -T 4010 2008-04-09 20:49:34.34 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required. 2008-04-09 20:49:34.34 Server Detected 2 CPUs. This is an informational message; no user action is required. 2008-04-09 20:49:34.51 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. 2008-04-09 20:49:34.56 Server The time stamp counter of CPU on scheduler id 1 is not synchronized with other CPUs. 2008-04-09 20:49:34.57 Server Database Mirroring Transport is disabled in the endpoint configuration. 2008-04-09 20:49:34.57 spid4s Warning ****************** 2008-04-09 20:49:34.57 spid4s SQL Server started in single-user mode. This an informational message only. No user action is required. 2008-04-09 20:49:34.57 spid4s Starting up database 'master'. 2008-04-09 20:49:34.78 spid4s SQL Trace ID 1 was started by login "sa". 2008-04-09 20:49:34.84 spid4s Starting up database 'mssqlsystemresource'. 2008-04-09 20:49:34.89 spid4s The resource database build version is 9.00.3042. This is an informational message only. No user action is required. 2008-04-09 20:49:35.06 spid4s Error: 15209, Severity: 16, State: 1. 2008-04-09 20:49:35.06 spid4s An error occurred during encryption. 2008-04-09 20:49:35.06 spid4s SQL Trace was stopped due to server shutdown. Trace ID = '1'. This is an informational message only; no user action is required.
I have been through many Forums and newsgroups but I just end up in a loop.
Im trying to install the basic Microsoft SQL Server 2005 Express Edition. Without advanced services, toolkit and management studio.
First of all it incorrectly says I do not have the recommended specifications but I cant work out what I am missing. I have 20GB free HDD space. 1.2Ghz CPU, 512MB RAM, Windows XP Pro SP2. This meets the Minimum and Recommended. All the other system checks have green ticks so I just igore the warning about recommended specs and continue to install.
The options I change from the default settings are: 'Default Instance', Built in system account: Local Service, 'Mixed mode' with a password.
It installs the following parts successfully: MSXML6 SQL Setup support files SQL native Client SQL VSS Writer
As soon as it tries to install 'SQL server Database Services' it attempts to start MSSQLSERVER but fails. I try to start it manually and again it fails. I notice that the Service is looking for the file: "C:Program FilesMicrosoft SQL ServerMSSQLBinnsqlservr.exe -sMSSQLSERVER" However the only 2 folders that exist in "C:Program FilesMicrosoft SQL Server" are "90" and "80", the "MSSQL" folder doesnt even exist.
The SQLSetup0001_PCNAME_SQL.log reports: MSI (s) (50:C0) [11:48:46:170]: Note: 1: 1708 MSI (s) (50:C0) [11:48:46:180]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed. MSI (s) (50:C0) [11:48:46:220]: Cleaning up uninstalled install packages, if any exist MSI (s) (50:C0) [11:48:46:220]: MainEngineThread is returning 1603 MSI (s) (50:E0) [11:48:46:220]: Destroying RemoteAPI object. MSI (s) (50:08) [11:48:46:220]: Custom Action Manager thread ending. === Logging stopped: 02/11/2007 11:48:46 === MSI (c) (84:6C) [11:48:46:230]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (84:6C) [11:48:46:230]: MainEngineThread is returning 1603 === Verbose logging stopped: 02/11/2007 11:48:46 ===
Bootstrap Contains: Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_PCNAME_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
None of these logs seem to point to any solutions. Id be grateful if anyone can suggest something.
hi Champion, My machine is already having vs2003 with sqlserver 2000. Now when I have installed vs2005 that time I have not loaded sqlserver 2005 express edition. But now when am trying to install the same i.e sqlserver 2005 express edition its unable to install/update this database. the error coming as "None of the selected features can be installed or upgraded. Setup cannot proceed since no effective change is being made to the machine. To continue click Back, and then select features to install. To exit sql server setup, click cancel" pls help
and *cannot* get SQL Server 2005 Tools Express Edition CTP to uninstall. I get the following dialog box:
"The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is:Unable to write property into cache flagCommit Unable to write property into cache: "flagCommit" XmlRW Error: Failure loading xmlrw.dll CheckAllProcedures() returned 2."
I recently (yesterday) installed a fresh copy of Windows XP with Service Pack 2 applied.
I proceeded with Visual Studio 2005 Express Editions installation straight away.
But I cannot install Microsoft SQL Server 2005 Express Edition x86.
I choose to install Microsoft SQL Server 2005 Express Edition x86 component along with every component of visual studio but it simply would not install.
In the end, after the installation of each complete is complete, I simply get an error message saying that Microsoft SQL Server 2005 Express Edition x86 failed to install.
SQL_SUCCESS_WITH_INFO (1) in OdbcConnection::connect sqlstate=01000, level=-1, state=-1, native_error=444, msg=The driver returned invalid (or failed to return) SQL_DRIVER_ODBC_VER: sqlstate=01000, level=-1, state=-1, native_error=5701, msg=[Microsoft][SQL Native Client][SQL Server]Changed database context to 'master'. sqlstate=01000, level=-1, state=-1, native_error=5703, msg=[Microsoft][SQL Native Client][SQL Server]Changed language setting to us_english.
SQL_ERROR (-1) in OdbcConnectionHandle::set_attr sqlstate=IM001, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Driver does not support this function
SQL_ERROR (-1) in OdbcConnectionHandle::get_attr sqlstate=IM001, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Driver does not support this function
SQL_ERROR (-1) in OdbcHandle::release sqlstate=HY010, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Function sequence error
SQL_ERROR (-1) in OdbcHandle::release sqlstate=HY010, level=-1, state=-1, native_error=0, msg=[Microsoft][ODBC Driver Manager] Function sequence error
Error Code: 0x8007ea74 (60020) Windows Error Text: Source File Name: libodbc_handle.h Compiler Timestamp: Wed Oct 26 16:37:41 2005 Function Name: OdbcConnectionHandle::set_attr@connect Source Line Number: 168
Connecting to SQL Server ExecuteSqlCommands Originial error was 8007ea74 (60020) ipt SqlScriptHlpr
Error Code: 60020 MSI (s) (D0!0C) [18:24:47:187]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29521. SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][ODBC Driver Manager] Driver does not support this function. Refer to the server error logs and Setup logs for detailed error information.
Hi, I am trying to install Outlook 2007 and business contact manager which requiers SQL Server 2005 Express Edition. I did install the Outlook but When it want to install the SQL server for business contact manager it fails to install. It installs the SQL native after that when it wants to install the SQL 2005 it fails here is the error:
TITLE: Microsoft SQL Server 2005 Setup ------------------------------
SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]CREATE DATABASE failed. Some file names listed could not be created. Check related errors.. Refer to the server error logs and Setup logs for detailed error information.
I am trying to install SQL Server 2005 Express Edition onto my PC on the D: drive. I do not have write privelleges to the C Drive. All I want to do is point the executable to install to another drive like D: or E: etc. Is this possible with SQL Server 2005 Express Edition setup executable file.
Just to let you know I have changed the template.ini file in the source folder to reflect the following (I tried both with and without quotes)
I am trying to setup Sql server 2005 express edition but ı getting an error message that cannot install. The Logfile is below.
Thanks...
Cagri
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Home Edition (Build 6000) Time : Tue Sep 04 22:44:28 2007
Machine : QUIETUS-PC Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : QUIETUS-PC Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : QUIETUS-PC Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : QUIETUS-PC Product : SQL Server Database Services Error : SQL Server Setup failed to execute a command for server configuration. The error was [Microsoft][SQL Native Client][SQL Server]Windows NT user or group 'QUIETUS-PCSQLServer2005MSSQLUser$QUIETUS-PC$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information. -------------------------------------------------------------------------------- Machine : QUIETUS-PC Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_QUIETUS-PC_SQL.log Last Action : InstallFinalize Error String : SQL Server Setup failed to execute a command for server configuration. The error was {Microsoft}{SQL Native Client}{SQL Server}Windows NT user or group 'QUIETUS-PCSQLServer2005MSSQLUser$QUIETUS-PC$SQLEXPRESS' not found. Check the name again.. Refer to the server error logs and Setup logs for detailed error information. Error Number : 29521
I'm trying to upgrade my management studio to the full version, I uninstalled Express edition and started the install for the full version, but I get an error stating "you cannot install this component because it is already installed". I had a word with one of the guys in the office and he said the only way he's ever been able to get round this is by flattening the entire PC and starting again. Obviously I want to avoid that!
hello all during the instaletion i get an error message that SQL server can not start the service, after that the programm rolls instalation back.do someone knows what's going on?i use win xp pro.thank u for ur help.
In the last step of installing the SQL Server 2005 Express edition I get the following error:
Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:38:35 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:38:35 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls:ervice:tart Source Line Number: 301
Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS
Error Code: 1814 MSI (s) (80!08) [19:39:58:265]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. .
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:39:58 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:39:58 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqls:ervice:tart Source Line Number: 301
I recently downloaded and attempted to install this express edition. I currently have the SQL Server Standard 2005 installed on my cpu but is dedicated to the Business Manger for my Outlook 2007. Normally I suppose this is not an issue but the edition does not have the reporting feature, hence the reason for downloading this new edition. My system meets all required specs but when I get to the last step of configuration, I get an error message. The error message occurs while configuring the OWC11 and Reporting. After the rest is configured it then tells me that the program failed to install.I am running Microsoft Office 2007 with exception of Access, which is ver. 2000. I have all programs running in compatibiltiy mode since others in the office are still running Office 2000. Any suggestions would be welcome.
Error 1706. Setup cannot find the required files. Check your connection to the network or CD-Rom drive. For other potential solutions to this problem, see C:Program FilesMicrosoft OfficeOffice 111033SETUP.CHM.
SQL Server 2005 full version is installed on a server computer. I installed MS VS 2005 Express edition on the server. As VS 2005 Express edition can only access to SQL Server 2005 Express edition, so a SQL Server 2005 Express edition has to be installed on the server. I wonder if both SQL Server 2005 full version and Express edition can be installed in the same computer.
I tried to install 'SQL Server 2005 Express Edition with Advanced Services'. First, I uninstalled the old version thru Add/Delete Programs in the Control Panel.
My first problem was I didn't have IIS installed on my computer, but, I could not find it in the downloads section.
Then the installation aborted because old version databases were in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData. But, it would not let me delete them, saying that they were being used, even though nothing was running at the time that I tried to delete them.
I get the following error message each time I try to install SQL Server 2005 Express Edition with Advanced Services SP2:
Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.
This problem is described in: http://support.microsoft.com/kb/920201 and each of the IIS 7 components specified in this article have been installed.
When I continue with: http://support.microsoft.com/kb/934162, the script 'adsutil.vbs' cannot be executed because it does not exist anywhere on my drive.
My question is, what is the 'adsutil.vbs' script and how do I get a hold of it? Are these contortions really necessary to get SQL server working or has MS provided a patch for this nasty problem?
My system:
VISTA Home Premium, x64 Intel Quad CPU, 2.4GHz 4Gig RAM 500Gig hard disk
Past one week I have been struggling to install SQL server express edition on my laptop which is preinstalled with Vista Basic. After it commences installation, it says the .net 2.0 on the system in corrupted.
Please let me know how to proceed ASAP... i have a project due for submission this week!
I am continually prompted to download & install this SP by the windows update utility but it always fails to install it. I have XP SP2. No error msg is provided. I do not have ACT! installed. I do have Oracle 10g Expr. Ed installed. Competitive jealousy?
I found this online:
Important notes about the cumulative hotfix package €¢ You must enable the SQL Server Management Object (SMO) extended stored procedures and the SQL Server Distributed Management Object (SQL-DMO) extended stored procedures before you install the cumulative hotfix package.
Where does one enable SMO & SQL-DMO?
I looked in the summary log file in the Hotfix directory and it says that the problem is that SQL Express cant be started. See below.
I went into the SQL Configuration Mgr and tried to start it and it fails to start. No reason given. Now what?
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Time: 11/22/2007 09:44:37.546 KB Number: KB921896 Machine: TOSHIBA-ROGER OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3042 Command-line parameters specified: /quiet /allinstances Cluster Installation: No
********************************************************************************** Prerequisites Check & Status SQLSupport: Passed
********************************************************************************** Products Detected Language Level Patch Level Platform Edition Express Database Services (SQLEXPRESS) ENU RTM 2005.090.1399.00 x86 EXPRESS Express Database Services (SQLExpress) ENU RTM x86 EXPRESS
********************************************************************************** Products Disqualified & Reason Product Reason Express Database Services (SQLEXPRESS) Unable to start service
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID
********************************************************************************** Product Installation Status Product : Express Database Services (SQLEXPRESS) Product Version (Previous): 1399 Product Version (Final) : Status : Not Applied Log File : SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_Replication,SQL_SharedTools Error Number : 11042 Error Description : Unable to start service ---------------------------------------------------------------------------------- Product : Express Database Services (SQLExpress) Product Version (Previous): Product Version (Final) : Status : Not Applied Log File : SQL Express Features : Client_Components,Connectivity,SDK Error Number : 0 Error Description : ----------------------------------------------------------------------------------
********************************************************************************** Summary Unable to start service Exit Code Returned: 11042 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
i've tried to install sql server 2005 express edition several times but when it get to the 'database services' it gives the following error:
SQL Server Setup could not connect to the database service configuration. The error was: [Microsoft][SQL Native Client][SQL Server]Login failed for user 'sa'.
I installed, uninstalled, deleted, editted my registry etc and I finally goto to this error while trying to install VS2005 (released) on a Windows 2000 PC (that had Beta2 and RC1 installed & uninstalled):