SQL Server Express Won't Install With Default Service Name
Jun 30, 2006
Anyone else had this problem?
I think I had a beta installed at some point. After a dozen attempts, I got SQL Server Express to install, but I had to change from the default service name (SQLExpress). When trying to configure the .NET samples that come with Visual Studio 2005, the ConfigSamples.exe does not recognize that I have SQL Server Express installed. I suspect this is due to my non-default service name. I have verifed that there is not a service installed (at least according the Services Admin Tool) that is named SQLExpress.
I just dropped over $600 for a personal copy of 2005 Professional, and I would just like to view the samples. Someone take pity on my poor soul and help out. I promise to help you help me and show much appreciation.
Hello, I'm installing MOSS 2007 as stand alone which includes SQL Server 2005 Express edition. My install is failing during the DB install. The server is Windows Server 2003, Enterprise Edition SP 2.
The error I'm receiving states "Setup has encountered an unexpected error while updating security settings on HTTP Services".
Here are snippets including the "return value 3" found in the log "SQLSetup0001_COHNTFS15_SQL.log".
Snippet 1: <Func Name='LaunchFunction'> Function=Do_sqlPerfmon2 <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_sqlPerfmon2 PerfTime Start: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008 <Func Name='Do_sqlPerfmon2'> <EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'> PerfTime Stop: Do_sqlPerfmon2 : Thu May 01 08:36:14 2008 MSI (s) (D8:EC) [08:36:14:535]: Executing op: ActionStart(Name=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Setting SQL Server Authentication Mode,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (D8:EC) [08:36:14:535]: Executing op: CustomActionSchedule(Action=Do_PropSetLoginModeNT.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_PropSetLoginModeNT,CustomActionData=010Setting SQL Server Authentication Mode50000MSSQL.1) MSI (s) (D8:40) [08:36:14:535]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI538.tmp, Entrypoint: Do_PropSetLoginModeNT <Func Name='LaunchFunction'> Function=Do_PropSetLoginModeNT <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_PropSetLoginModeNT PerfTime Start: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008 <Func Name='Do_PropSetLoginModeNT'> Switching server to NT integrated security <EndFunc Name='Do_PropSetLoginModeNT' Return='0' GetLastError='0'> PerfTime Stop: Do_PropSetLoginModeNT : Thu May 01 08:36:14 2008 MSI (s) (D8:EC) [08:36:14:566]: Executing op: ActionStart(Name=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Updating security settings on HTTP services,) <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (D8:EC) [08:36:14:566]: Executing op: CustomActionSchedule(Action=Do_HttpServiceSecurity.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_HttpServiceSecurity,CustomActionData=100Updating security settings on HTTP services100000) MSI (s) (D84) [08:36:14:566]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI539.tmp, Entrypoint: Do_HttpServiceSecurity <Func Name='LaunchFunction'> Function=Do_HttpServiceSecurity <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='0'> Doing Action: Do_HttpServiceSecurity PerfTime Start: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008 <Func Name='Do_HttpServiceSecurity'> Error updating HTTPFilter service security (5)
<EndFunc Name='Do_HttpServiceSecurity' Return='1603' GetLastError='0'> PerfTime Stop: Do_HttpServiceSecurity : Thu May 01 08:36:14 2008 Gathering darwin properties for failure handling. Error Code: 1603 MSI (s) (D8!20) [08:36:14:785]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.
Error 29528. The setup has encountered an unexpected error while Updating security settings on HTTP services. The error is: Fatal error during installation.
<Failure Type='Fatal' Error='1603'> <EndFunc Name='LaunchFunction' Return='1603' GetLastError='0'> MSI (s) (D8:EC) [08:36:14:800]: User policy value 'DisableRollback' is 0 MSI (s) (D8:EC) [08:36:14:800]: Machine policy value 'DisableRollback' is 0 Action ended 8:36:14: InstallFinalize. Return value 3.
Snippet 2: <Func Name='LaunchFunction'> Function=Set_CommitFlag <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='F' GetLastError='0'> Doing Action: Set_CommitFlag PerfTime Start: Set_CommitFlag : Thu May 01 08:36:22 2008 <Func Name='Set_CommitFlag'> Set_CommitFlag called successfully.Rollbacked <EndFunc Name='Set_CommitFlag' Return='0' GetLastError='0'> PerfTime Stop: Set_CommitFlag : Thu May 01 08:36:22 2008 <EndFunc Name='LaunchFunction' Return='0' GetLastError='0'> MSI (s) (D8:EC) [08:36:22:988]: Executing op: ActionStart(Name=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing temporary files,) MSI (s) (D8:EC) [08:36:22:988]: Executing op: CustomActionRollback(Action=RollbackSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=RollbackSupportFiles,) MSI (s) (D8:7C) [08:36:22:988]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI54B.tmp, Entrypoint: RollbackSupportFiles MSI (s) (D8:EC) [08:36:23:004]: Executing op: End(Checksum=0,ProgressTotalHDWord=0,ProgressTotalLDWord=0) MSI (s) (D8:EC) [08:36:23:004]: Error in rollback skipped. Return: 5 MSI (s) (D8:EC) [08:36:23:004]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.AdomdClient,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:004]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Instapi,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:019]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:019]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlTDiagM,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:019]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:035]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:035]: Entering MsiProvideAssembly. AssemblyName: MSClusterLib,Version="1.0.0.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="1.0.0.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:035]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.MgdSqlDumper,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:050]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:050]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Rmo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:050]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:066]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:066]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices.DeploymentEngine,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:066]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.AnalysisServices,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:082]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:082]: Entering MsiProvideAssembly. AssemblyName: Microsoft.DataWarehouse.Interfaces,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:082]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:097]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:097]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.RegSvrEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:097]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.BatchParser,Version="9.0.242.0",Culture="neutral",processorArchitecture="x86",PublicKeyToken="89845dcd8080cc91",FileVersion="2005.90.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:113]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:113]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ServiceBrokerEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:113]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:129]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:129]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.WmiEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:129]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:144]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:144]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.ConnectionInfo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:144]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:160]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:160]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SqlEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:160]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:207]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:207]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.SString,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:207]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:222]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:222]: Entering MsiProvideAssembly. AssemblyName: Microsoft.SqlServer.Smo,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.2047.0", AppContext: , InstallMode: -4 MSI (s) (D8:EC) [08:36:23:222]: Pathbuf: 0, pcchPathBuf: 0 MSI (s) (D8:EC) [08:36:23:238]: MsiProvideAssembly is returning: 1607 MSI (s) (D8:EC) [08:36:23:238]: No System Restore sequence number for this installation. MSI (s) (D8:EC) [08:36:23:238]: Unlocking Server MSI (s) (D8:EC) [08:36:23:238]: PROPERTY CHANGE: Deleting UpdateStarted property. Its current value is '1'. Action ended 8:36:23: INSTALL. Return value 3.
last few lines of log: Property(S): RSVirtualDirectoryManager = Reports$OFFICESERVERS Property(S): SOURCEDIR = d:a1847ef4f3beaf9c2353Setup Property(S): SourcedirProduct = {2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} Property(S): InstallNgenTicks = 110000 Property(S): SQLBROWSERACCOUNT = NT AUTHORITYNETWORK SERVICE Property(S): SQLBROWSERSCMACCOUNT = NT AUTHORITYNetworkService Property(S): SQLSCMACCOUNT = NT AUTHORITYNetworkService Property(S): DebugClsid.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 = {B266876E-56D9-493C-9322-0C01155F1C52} Property(S): ProductToBeRegistered = 1 MSI (s) (D8:EC) [08:36:23:441]: Note: 1: 1708 MSI (s) (D8:EC) [08:36:23:441]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed.
MSI (s) (D8:EC) [08:36:23:457]: Cleaning up uninstalled install packages, if any exist MSI (s) (D8:EC) [08:36:23:457]: MainEngineThread is returning 1603 MSI (s) (D84) [08:36:23:566]: Destroying RemoteAPI object. MSI (s) (D8:E0) [08:36:23:566]: Custom Action Manager thread ending. === Logging stopped: 5/1/2008 8:36:23 === MSI (c) (104) [08:36:23:597]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (104) [08:36:23:597]: MainEngineThread is returning 1603 === Verbose logging stopped: 5/1/2008 8:36:23 ===
I'm suspecting it's a permission error, but I can't verify this. Any thoughts? Thanks in advance.
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 <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
In the last step of installing the SQL Server 2005 Express edition I get the following error:
Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:38:35 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:38:35 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqlservicetart Source Line Number: 301
Do_sqlScript SqlScriptHlpr Start service MSSQL$SQLEXPRESS
Error Code: 1814 MSI (s) (80!08) [19:39:58:265]: Product: Microsoft SQL Server 2005 Express Edition -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. .
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (1814) The specified resource name cannot be found in the image file. . <Func Name='GetCAContext'> <EndFunc Name='GetCAContext' Return='T' GetLastError='203'> Doing Action: Do_sqlScript PerfTime Start: Do_sqlScript : Thu Jun 21 19:39:58 2007 Service MSSQL$SQLEXPRESS with parameters '-d"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamaster.mdf" -l"c:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLTemplate Datamastlog.ldf" -m SqlSetup -Q -qLatin1_General_CI_AS -T4022 -T3659 -T3610 -T4010' is being started at Thu Jun 21 19:39:58 2007 Service failed unexpectedly (1814) Error Code: 0x80070716 (1814) Windows Error Text: The specified resource name cannot be found in the image file. Source File Name: sqlsetuplibservice.cpp Compiler Timestamp: Wed Jun 14 16:29:04 2006 Function Name: sqlservicetart Source Line Number: 301
hello, i´d like to work with (first learn) all features of the SQL Server Express Advanced Service and Visual Basic 2005 (incl. Connect SQL Server databases from Visual Studio/ VB2005). Before I´ll make a mistake with the install (the numerous versions make me confused) I´d like to ask you which is the correct way to install both: 1) Should I first install SQLServer Express Advanced Service and then Visual Studio (Visual Basic without SQLServerExpress - if it´s possible switch off this compound) ?? or 2) Install Visual Studio Express (I´ve got the DVD from Microsoft) with (or without ?) the SQLServerExpress Edition and then upgrade to the SQLServer Express Advanced Service by starting the SSE Advanced-Service setup-file ?? thank you very much in advance
I have compile my application into a Smart Device CAB and also including SQLCE CAB file for SQL.
I have users who choose to install SQLCE into Storage Cards instead and causes the application not to function, when asked which destination to install.
I've done some search and found out about "wceload.exe /noaskdest" but I'm using NSIS to compile into a single .exe file, and its calling "CEAppMgr.exe"
How can I force SQLCE to install into its default directory without asking user?
I am currently hardening our SQL 2012 (with AlwaysOn Availability Groups) environment. Both the SQL service and agent account are using service accounts (only domain user). SQL browser service is disabled. Permissions to all roles are handled by using domain groups.
Currently a lot of (default) NT Service accounts are listed (some with sysadmin privileges). Are there accounts that can be removed?
I installed SQL Server 2005 flawlessly yesterday. When login as "sa" through SQL Server Management Studio, I get an error message saying it cannot connect to my PC.
I checked the MSSQL Server Service. It is not started and cannot be started because it's looking for a path that does not exist!.
The folder in question is missing. C:Program FilesMicrosoft SQL ServerMSSQL
The following folders do exist: C:Program FilesMicrosoft SQL ServerMSSQL.1 C:Program FilesMicrosoft SQL ServerMSSQL.2
I initially suspected this problem was cause by a previous MSDE 2000 installation.
I uninstalled SQL Server 2005 & MSDE 2000. I re-installed SQL Server 2005. Same problem. I executed http://support.microsoft.com/default.aspx/kb/320873 to make sure all registries are removed and manually deleted C:Program FilesMicrosoft SQL Server€™s content
Re-installed SQL Server 2005. Same problem.
I do not know what do in order to get SQL Server 2005 up & running.
Downloading and installing VS 2008 Express also created a Miscrosoft SQL Server folder. How do I install the SQL Server 2005 Express?The following is what I found from the HELP menu bar of the VS 2008 Express. Where can I find the sqlexpr.exe? TIA,Jeffrey
To install SQL Server Express To begin installation, double-click sqlexpr.exe. Note: SQL Server Express is available as a self-extracting executable file (sqlexpr.exe) from both the Visual Studio 2005 CD and the SQL Server Express Web site. SQLEXPR.EXE installs on x86-based computers and to the 32-bit subsystem (WOW64). For more information, see Hardware and Software Requirements (SQL Server Express)
I had some issues on my server and had to uninstall .Net Framework 2.0, SQL Server 2005 Express, and SQL Express Toolkit. I installed SQL Server 2005 Express and it seemed to be ok.
Then my problems all started when I tried to install SQL Express Toolkit because I needed to install DTS Wizard again, and it errors out and wouldn't let me install it. So I uninstalled everything that's listed above again.
I then tried to install SQL Server 2005 Express again, and on the second from last screen, while its listing all the components and configuring them, I get the following error as it's configuring the last component... which was the SQL Server Database Services.
TITLE: Microsoft SQL Server 2005 Setup ----------------------------------------------------------- The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
I tried to re-install the SQL Server Express another 7 times wth no luck.
If anyone can point me in the right direction I'd really appreciate it.
I'm getting an error while trying to install SQL Server Express 2005 Express Edition. I'm attaching the log of the installation process here. Please throw some light on the same.
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (3) The system cannot find the path specified.
Setting status of unmanaged components and removing unmanaged resources
Error Code: 3
MSI (s) (D0!64) [21:39:17:257]: Product: Microsoft SQL Server 2005 -- Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (3) The system cannot find the path specified.
.
Error 29503. The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually." The error is (3) The system cannot find the path specified.
I downloaded the SSEUtilSetup.EXE and extracted the SSEUtil.exe to a folder of C:drive of my PC that is Windows XP Pro. I plan to learn the CLR programming via user-instance of SQL Server Express. I need to have SQL Server Express Utility installed. Please help and tell me how I can install SSEUtil.exe in my PC and how I use it to interact with SQL Server Express.
ver: SQL-DMO Version: 8.00.760I have the option to automatically start SQL Server on startup, butwhen it does start up, the SQL Server Service Manager does not havethe green arrow indicating that it is active. When I double-click itto display the SQL Server Service Manager, it shows the name of theserver, but no services in the drop-down box.When I start Enterprise Manager I see an instance of MSDE wheresomeone installed an MSDE application. That is active. But I have to"connect" to the localhost. The instance name is the name of the MSDEapplication. I would like it to connect to the localhost on startup.Any ideas on how to correct this problem?Thanks,RBollinger
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
Has anyone had a problem when installing service pack 2 or 3 on SQL Server 7.0? I'm stuck at MDAC upgrade every time, had to 'end task'. Did select @@version afterwards, still on the old version. I didn't try service pack 1 yet.
I found the following page titled "Can't install SQL server service pack 1", but I'm unable to access. http://www.swynk.com/archive3/4500/45001235457.asp
Any help will be appreciated. Please email me directly. Thanks in advance.
Hi dear Devs! I have a problem and now I am not sure, what I should do. "Microsoft Update" Service warned me, that a new critical update is ready for download. It was the update "SQL Server 2005 Express Edition Service Pack 2", I did that. Untill here no problem. The update "SQL Server 2005 Service Pack 2" was ready for download too. I have both versions on my computer "SQL Server 2005 Express Edition" and "SQL Server 2005 Developer Edition". The Express Edition came together with the install of "Visual Studio 2005 Team Suite", two days later I have installed the "SQL Server 2005 Developer Edition". Now to my problem, the "SQL Server 2005 Service Pack 2" installation failed in one point, the name of it is "Microsoft SQL Server Native Client". The whole installation was not interrupted, it told me only at end of this updating that this point wasn't successful - I saw it in the "Summary.txt". While the install I saw that this "Microsoft SQL Server Native Client" was twice in the list of the Service Pack 2 Update. Both of these points had the identical name. In short words, I saw that the SP2 wanted made an update at "Microsoft SQL Server Native Client" twice. I thought, it is because these two editions of "SQL Server 2005" on my computer. But the result is, that the SP2 couldn't update the second 'Native Client'. I checked it in the 'Software' section in 'Control Panel' and I have really two installations of this "Microsoft SQL Server Native Client". My question is, is that normal, is that because I have two "SQL Server 2005" Editions on my computer? And what can I do with this failed part of the SP2. Can someone help me with this failed 'Native Client' SP2 update? I were really happy, if someone could give me the best solution to fix this problem. Thank you very much for your help and answers
I'm trying to install Service Pack 4 to our default instance of SQL Server 2000 with SP3a, on a Windows 2003 Server, which also has a named instance of SQL Server 2005 on it and a named instance of SQL Server 2000 with SP4.
The installation appears to be running just fine, but MUCH too quickly. The last window appears stating something along the lines of 'Updating Active X components'. I'm expecting the scripts to run to update my system stored procedures, etc., but that never occurs. The installer just quits.
No errors in the Windows logs, nor in SQL, and no C:WindowsSQLSP.log file.
I tried the installation again, but this time used a different copy of the service pack 4 installer, with the same results, and again no SQLSP.log file.
Since I was going to remove the named instance of SQL Server 2000 anyway, I verified that my SP4 installer was good by uninstalling the named instance of SQL Server (the one with SP4 already), reinstalling a named instance of SQL Server 2000, and reapplying SP4 to this named instance. Everything went flawlessly.
I then tried reapplying SP4 to the default instance of SQL Server 2000, and this time a SQLSP.log file was finally generated. In the error log, the last entries are:
19:10:03 C:PROGRA~1COMMON~1MICROS~1SQLDEB~1SQLDBR~1.EXE sqldbreg2.exe -RegServer 19:10:04 An error occurred while setting the registry value for: SoftwareMicrosoftMSSQLServerMSSQLServer 19:10:04 Could not restore AuditLevel registry key 19:10:04 Action CleanUpInstall: 19:10:04 Installation Failed.
I confirmed that the service accounts that are running SQL Server both have local administrative access to the server (which may or may not matter), and that they are both sysadmin, so I don't think it's a permissions issue to the registry. I've also verified that the account I was using to run the SP installation also has local admin access on that box.
So, I compared my HKLMSoftwareMicrosoftMSSQLServerMSSQLServer registry entry from our production server to the one on the test server, I see that our test server's entry is completely empty. On production there are numerous subkeys, such as CurrentVersion and RPCNetLib.
I'm planning on copying the registry entries from production to test. Should this be sufficient, or are there other things I should look out for?
Can Anyone explain why my Report Service does not start up during installation of reporting services.
ASPNET account has full permissions. A previous Reporting Services beta was installed (and working) before.
Here's the event explanation: Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities. ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files ---> System.Exception: The configuration file contains an element that is not valid. The Permissions element is not a configuration file element. at Microsoft.ReportingServices.Diagnostics.RSConfigur ation.ThrowInvalidFormat(String element) at Microsoft.ReportingServices.Diagnostics.Extensions Configuration.ParseExtensionElement(XmlNode child, Extension& extension) at Microsoft.ReportingServices.Diagnostics.Extensions Configuration.ParseDeliveryExtensions(XmlNode child, ExtensionArray array) at Microsoft.ReportingServices.Diagnostics.Extensions Configuration.ParseExtensions(XmlNode child, ExtensionArray array) at Microsoft.ReportingServices.Diagnostics.Extensions Configuration.ParseXML(XmlNode node) at Microsoft.ReportingServices.Diagnostics.RSConfigur ation.ParseDocument() at Microsoft.ReportingServices.Diagnostics.RSConfigur ation.Load(Boolean searchMultipleLocations, Boolean trapLoadFailures) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Diagnostics.RSConfigur ation.Load(Boolean searchMultipleLocations, Boolean trapLoadFailures) at Microsoft.ReportingServices.Diagnostics.RSConfigur ation.Construct(String configFileName, Boolean searchMultipleLocations, Boolean trapLoadFailures) at Microsoft.ReportingServices.Diagnostics.RSConfigur ation..ctor(String configFileName, String additionalSearch, Boolean searchMultipleLocations, Boolean trapLoadFailures) at Microsoft.ReportingServices.Diagnostics.RSConfigur ationManager..ctor(String configFileName, String additionalSearch, Boolean searchMultipleLocations, Boolean trapLoadFailures) at Microsoft.ReportingServices.Diagnostics.RSConfigur ationManager..ctor(String configFileName, String additionalSearch) at Microsoft.ReportingServices.Library.Global.get_Con figurationManager() at Microsoft.ReportingServices.Library.ServiceAppDoma inController.Start() at Microsoft.ReportingServices.NTService.ReportServic e.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMai nCallback(Object state)
For more information, see Help and Support Center at
I'm a newbie and I have a problem that i can't solve despite sitting here all day trying to wortk it out.
I have installed SQL Server Express 2005 along with the associated toolkit. Previous to that i installed MS Visulal studio 2005, .NET 2.0 and MSDN.
The problemn is that it appears despite installing everything i don't have SQLExpress services running on my PC. I have admin rights, it installed okay but there is nothing to connect to.
When i run "sqlcmd.exe -s (local)SQLExpress -E" from the command prompt i get the following message:
HResult 0x2, Level 16, State 1 Named Pipes Provider: Could not open a connection to SQL Server [2]. Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establi shing a connection to the server. When connecting to SQL Server 2005, this failu re may be caused by the fact that under the default settings SQL Server does not allow remote connections.. Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
When i run SQL Server Configuration there is no "SQLExpress" service present under "SQL Server 2005 Servcies" in SQL Server Configuration dialog; just a message saying:
"there are no items to show in this view"
When i run Surface Area Configuration i get the following message:
TITLE: Surface Area Configuration ------------------------------
No SQL Server 2005 components were found on the specified computer. Either no components are installed, or you are not an administrator on this computer. (SQLSAC)
------------------------------ BUTTONS:
OK ------------------------------
If you can shed any light on this id be extreamly grateful as i'd been here for hours before stumbling across the toolkit (why this wasn't bundled i don't know) only to realise once i had it that the SQLExpress service isn't running :(
I have done a full Sql Server install on a server and the SSIS service is not available. Normally when I load Sql Server I get €œSQL Server Integration Services" as a service that I can start. On this machine it is not listed after the install. I don't get any errors through out the install.
I have had visual C# Express edition for a while, and had successfully used SQL Server 2005 express successfully since it was first released. I downloaded the new version with advanced services, created a new instance, and tried to use it. VC# wont connect cause it is still trying to connect to my old instance which no longer exists. Could someone please tell me how to make my new instance the one to log on to?
If I install a new named instance of SQL Server 2008 R2 on a machine that already has 3 named instances that are upgraded to service pack 3, will the install of the new instance overwrite any of the current SP3 files? Will I have to re-apply SP 3 to the existing instances?
I'm using the disk that came with my Visual Web Developer for Dummies book. It installed on my XP Home machine, but when installing on my XP Pro machine, the fourth step, SQL Server Express, it fails. I cleaned up my hard drive (about ten gigs of free space), I followed the steps here http://msdn.microsoft.com/vstudio/support/readme/default.aspx to uninstall everything dot net related. Rebooted, checked my control panel, etc. Tried to install. It just fails. No error message.Can anyone give me an idea of where to start?Thanks
i tried hard to install sql server 2005 express today but it always failed.
system: XP german / SP 3
failure: it just says that the databaseservices could not be installed and the details are in the log. if i check the log it does not contain anything about the database services. it only says that the native client could not be installed (which is okay because i seem to have a newer one) .. here is the log:
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 3 (Build 2600) Time : Tue May 20 23:43:48 2008
Machine : MICHAL Product : Unterstützungsdateien für das Microsoft SQL Server-Setup (Englisch) Product Version : 9.00.3042.00 Install : Successful Log File : c:ProgrammeMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_MICHAL_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : MICHAL Product : SQL Native Client Error : Für das Produkt Microsoft SQL Server Native Client wurde kein Installationspaket gefunden. Wiederholen Sie die Installation und verwenden Sie dabei eine gültige Kopie des Installationspakets "sqlncli.msi". -------------------------------------------------------------------------------- Machine : MICHAL Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Failed Log File : c:ProgrammeMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_MICHAL_SQLNCLI_1.log Last Action : InstallFinalize Error String : Für das Produkt Microsoft SQL Server Native Client wurde kein Installationspaket gefunden. Wiederholen Sie die Installation und verwenden Sie dabei eine gültige Kopie des Installationspakets "sqlncli.msi". Error Number : 1706 -------------------------------------------------------------------------------- Machine : MICHAL Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : c:ProgrammeMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_MICHAL_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : MICHAL Product : MSXML 6.0 Parser Product Version : 6.10.1129.0 Install : Successful Log File : c:ProgrammeMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0007_MICHAL_MSXML6_1.log --------------------------------------------------------------------------------
Hi, I installed VB express, can't recall if SQL Server Express was installed with VB or not at the same time, but I do have SQL Express installed. All I see is Microsoft SQL Server 2005 --> Configuration tools and --> Documentation and Tutorials. I must be missing something so I can create, view, alter and delete tables. The install gave no signs of installation problems. Any ideas what went wrong?
My system had a beta version of Visual Studio 2005 Express on it which I uninstalled. Apparently not correctly, as I can not install SQL Server 2005 Express. I have tried to removal procedures which either give me an error message or I cannot find the items in the Add/Remove program list that are requested. That is, it looks like the system should accept SQL Server 2005 Express, but it does not.
I have successfully installed Visual C++ 2005 Express. I have no clue as to what to do next and there is no documentation on what to do. I have looked at the various postings here, tried several of them, to no avail.
When I search the registry there are some 70 entries that have the string €œSQLEXPRESS€? in the entry. I am unsure if these are related to my previous beta install or related to the system (a475c HP Pavilion) needs. I am reluctant to start removing those entries.
So now what do I do? Is this really that difficult? And what if I decided to buy Visual Studio 2006, whenever it may be introduced? Will I not be able to install it?
Here is the log file that was generated yesterday, my latest attempt.
= = =
Microsoft SQL Server 2005 9.00.2047.00 ============================== OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600) Time : Sun Nov 05 17:32:58 2006
HOME-HP-XP : SQL Server 2005 Setup has detected incompatible components from beta versions of Visual Studio, .NET Framework, or SQL Server 2005. Use Add or Remove Programs to remove these components, and then run SQL Server 2005 Setup again. For detailed instructions on uninstalling SQL Server 2005, see the SQL Server 2005 Readme.
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Sun Nov 05 17:33:51 2006
List of log files: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_HOME-HP-XP_Core.log C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0002_HOME-HP-XP_Datastore.xml C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
I want to install SQL Server 2005 Express Adv. I saw that you had to un-install the beta version prior. So I did. When I go to install SQL Server 2005 Express Adv, I get a message saying that SQL Server detected the previous Beta version, goto add/remove programs blah...blah...blah. Nothing was listed in a/r programs. I ran an uninstall microsoft had on their web site, and I got a message saying nothing was deteceted. I deleted all folders related.
Somehow when I initially ran the unistall, not all components were removed. I am baffled. Any assistance would be greatly appreciated.
