VS2008: Installing SQL Express As Prerequisite Fails With Error 1706
Feb 12, 2008
Using the new Visual Studio 2008 I created a setup project for a small program, and added SQL Express 2005 SP2 to the list of prerequisites.
I checked the box so the setup project will contain all necessary files in a sub directory of the setup project.
My setup starts nice (on windows vista) prompts me to install SQL Express, setup of SQL Express runs for some time, I get an UAC prompt, then setup fails with error 1706.
The last lines of the setup log file:
Installing using command 'C:UserswilfiAppDataLocalTempVSDE5B7.tmpSqlExpresssqlexpr32.exe' and parameters '-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1'
Process exited with code 1706
Status of package 'SQL Server 2005 Express Edition SP2 (x86)' after install is 'InstallFailed'
I really would like to install SQL Express as part of the setup project, can someone help me with this problem?
I have VS2008 installed which has installed SQLEXPRESS. But it seems not all of it.
I want to be able to create tables and generally mess about with SQLEXPRESS without VS2008, is it safe to install Sql Express from this site that will hopefully? install all the management tools? Will this action compromise the VS2008 installation? Will I need to uninstall all the SQL Server stuff that is currently installed?
I am a complete noob when it comes to SQL Express having done all my SQL using Access.
I have prepared an installer with 2 prerequisites for my project using Bootstrapper. It checks .NET framework 2.0 and then SQL Express 2005. The isntaller works fine on XP sp2 and windows server 2003 but when I tested it on Vista, it is giving me an exception. I checked the log file and found this in the log file. "Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': true Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Fail' 'SQL Server 2005 Express Edition' RunCheck result: Fail A prerequisite failed for Package "SQL Server 2005 Express Edition" Package failed with message "This version of SQL Server 2005 Express Edition is not supported for the current processor architecture."
I am using sql server 2005 express edition with SP2. I think it is failing to use sqlexpr32.exe here. Is there any problem of this exe running on vista? Please help..."
I Had VS20005 and SQL 2005 Working perfectly. For some errors, I did formatted my PC and installed VS2008. After doing that, I am trying to install MSSQL2005, when installation be in "Integration development environment with 2005" Phase, An error appears, and the installation stopped. What I have to Do to solve this? Note: I ahve XPSP2 32 bit installed.
I just upgraded ACT database and it needs SQL Server. I just keep getting "SQL Server Setup Failed". I downloaded SQL from Microsoft, went to install and get the same error. It then refers to a summary txt log which I have had a look at but to be quite honest means nothing to me.
I have a problem installing BIDS. On a XP machine with Visual Studio 2003 and Visual Studio 2008 installed, i tried to install SQL Server 2005 DE with SSIS and Client Tools. All works fine, but the devenv.exe where BIDS start menu shortcut points to doesnt exist. In SQL Server installation dialog, i tried uninstalling BIDS (168 MB disk space will get free'd...) then again installing BIDS (...needs 168 MB disk space...), a lot of harddisk activity, but all the same. I searched for devenv.exe on drive c:, only two hits: The VS2003 and VS2008 files. I tried uninstalling VS2008, VS2003, .net3.5, .net3.0, .net2.0 and SS2005, then installing SS2005 with BIDS, again BIDS start menu shortcut points to nowhere. No devenv.exe on drive c: Now i used system recovery to go back to the point before uninstalling all the stuff, so i can do all my work beside BIDS/SSIS, seaching for a solution...
I thought about installing VS2005 prof., but the license is lost because i upgraded to VS2008.
Note: The VS2008 is installed without installing the SQL Server coming along with VS2008.
Suppose I check "SQL Server 2005 Express Edition" as one of the prerequisites for a custom app in a Windows Setup project.
From reading whatever docs I could get my hands on, it's still not clear to me how to control the installation of SQL Server Express with respect to things like instance name, service account, etc, etc.
In other words, this is stuff that's normally the domain of template.ini. However, there's no clear indication of where I should put template.ini so that the install of "prerequisite" SQL Server Express will see it and configure accordingly...
Thanks in advance to anyone who can help solve this...
Hi I've recently upgraded 4 sql servers to sp5a and have just found that BCP fails on all of them with a DR Watson error. I did reinstall the Nt sp after installing sql server sp5a. Can anyone help ? Thanks
I've created a number of tables, views, sproc, and functions whose names begin with "sys_", but when I tried to create a multi-statement table-valued function with this type of name, I got:
Server: Msg 1706, Level 16, State 2, Procedure sys_tmp, Line 9 System table 'sys_test' was not created, because ad hoc updates to system catalogs are not enabled.
I had a quick look in this forum for 1706 (and on Google) but couldn't find anything. Does anyone know for certain if this is a bug in SQL2K?
Thanks, Jos
Here's a test script: /* ---------------------------------------------------------------------------------------------------- T-SQL code to test creation of three types of function where the function name begins with "sys_". Jos Potts, 02-Nov-2006 ---------------------------------------------------------------------------------------------------- */
PRINT @@VERSION go
PRINT 'Scalar function with name "sys_" creates ok...' go
CREATE FUNCTION sys_test () RETURNS INT AS BEGIN RETURN 1 END go
DROP FUNCTION sys_test go
PRINT '' go
PRINT 'In-line table-valued function with name "sys_" creates ok...' go
CREATE FUNCTION sys_test () RETURNS TABLE AS RETURN SELECT 1 c go
DROP FUNCTION sys_test go
PRINT '' go
PRINT 'Multi-statement table-valued function with name "sys_" generates error 1706...' go
CREATE FUNCTION sys_tmp () RETURNS @t TABLE (c INT) AS BEGIN
And here€™s the output from running the test script in Query Analyser on our server: Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Scalar function with name "sys_" creates ok...
In-line table-valued function with name "sys_" creates ok...
Multi-statement table-valued function with name "sys_" generates error 1706... Server: Msg 1706, Level 16, State 2, Procedure sys_tmp, Line 11 System table 'sys_tmp' was not created, because ad hoc updates to system catalogs are not enabled. Server: Msg 3701, Level 11, State 5, Line 2 Cannot drop the function 'sys_test', because it does not exist in the system catalog.
A simple question. I installed successfully Visual Studio 2008 Standard edition on my VISTA Ultimate 32bits machine. During install process, I also checked SQL Server Express 2005 item.
Which version of SQL Server Express 2005 did it install? Are we talking about SP2? If so, can I install without problem a more complete SP2 package using following links
SQL Server 2005 Express Edition with Advanced Services SP2 http://go.microsoft.com/fwlink/?LinkId=65109 Microsoft SQL Server 2005 Express Edition Toolkit http://go.microsoft.com/fwlink/?LinkId=65111
without screwing the now existing SQL Server Express setup VS2008 installed?
Installed Server 2008 (64bit) Installed VS2008 (+SQL 2005 Express, by default)
I've always installed SQL 2005 Dev (including the SQL Management Studio) before installing VS. Now I am trying to install just the management studio on this machine without success.
I tried installing the SQL workstation tools package from the SQL 2005 DVD but the installer detects the tools installed by SQL express (osql, etc.., but no management studio GUI) and the installer refuses to install anything else. I also tried downloading the separate installer for SQL management studio but it doesn't like something also: first thing the installer does is display this mesage:
"Installation of this product failed because it is not supported on this operating system For more information on supported configurations, see the product documentation."
Any way to do this without having to reinstall VS?
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600) Time : Sat Jul 15 12:51:21 2006
Machine : JIMMY Product : File di supporto dell'installazione di Microsoft SQL Server (Italiano) Product Version : 9.00.1399.06 Install : Successful Log File : C:programmiMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_JIMMY_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : JIMMY Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:programmiMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_JIMMY_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : JIMMY Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:programmiMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_JIMMY_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : JIMMY Product : Parser MSXML 6.0 Product Version : 6.00.3883.15 Install : Successful Log File : C:programmiMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_JIMMY_MSXML6_1.log -------------------------------------------------------------------------------- Machine : JIMMY Product : File di supporto dell'installazione di Microsoft SQL Server (Italiano) Product Version : 9.00.1399.06 Install : Successful Log File : C:programmiMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_JIMMY_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : JIMMY Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:programmiMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_JIMMY_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : JIMMY Product : Parser MSXML 6.0 Product Version : 6.00.3883.15 Install : Successful Log File : C:programmiMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_JIMMY_MSXML6_2.log -------------------------------------------------------------------------------- Machine : JIMMY Product : Servizi di database SQL Server Error : Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045. -------------------------------------------------------------------------------- Machine : JIMMY Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.00.1399.06 Install : Failed Log File : C:programmiMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0001_JIMMY_SQL.log Last Action : InstallFinalize Error String : Errore durante l'installazione dell'assembly 'Microsoft.SqlServer.SmoEnum,Version="9.0.242.0",Culture="neutral",processorArchitecture="MSIL",PublicKeyToken="89845dcd8080cc91",FileVersion="9.0.1399.0"'. Firma o catalogo non verificabili o non validi. HRESULT: 0x80131045. interfaccia assembly: IAssemblyCacheItem, funzione: Commit, componente: {FD5D8A34-6302-4B57-A51D-65A834A1EF6F} Error Number : 1937 --------------------------------------------------------------------------------
I've Successfully Installed Visual Web Developer Express Edition but when i tried to install SQL Server 2005 Express Edition I get this message: TITLE: Microsoft SQL Server 2005 Setup ------------------------------
An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name.
------------------------------
so i downloaded the Visual Studio Auto-Uninstall and everything goes well until i accept the Agreement then i get this: <?xml-stylesheet type="text/xsl" href="C:DOCUME~1SamLOCALS~1TempIXP000.TMPissues.xslt"?> <Issues><Issue><Name>Uninstall Visual Studio components</Name><Id>{BB69B4AB-619E-487f-B0C2-5ACD1AE5A9A0}</Id><Description>You have Visual Studio 2005 components installed.</Description><AffectedProducts>Visual Studio 2005 components from editions but RTM such as: Express, Standard, Professional, Team System, WinFX Runtime Components, etc..</AffectedProducts><DetailsUrlId>Href_{BB69B4AB-619E-487f-B0C2-5ACD1AE5A9A0}</DetailsUrlId><HaveFix>1</HaveFix><Severity>low</Severity></Issue></Issues> samtylr
I have run into a snag trying to install SQL Express 2005. I'm installing it on a highend Win XP Pro PC with 1 GB of RAM. I'm providing you with my summary.txt file from my installation. As you can see, the last 2 entries failed to commit because it could not open the registry key.
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600) Time : Wed May 09 09:21:08 2007
Machine : 74-1R8J081 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0019_74-1R8J081_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : 74-1R8J081 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0019_74-1R8J081_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : 74-1R8J081 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0019_74-1R8J081_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : 74-1R8J081 Product : MSXML 6.0 Parser Product Version : 6.10.1129.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0019_74-1R8J081_MSXML6_1.log -------------------------------------------------------------------------------- Machine : 74-1R8J081 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0019_74-1R8J081_SQLSupport_2.log -------------------------------------------------------------------------------- Machine : 74-1R8J081 Product : Microsoft SQL Server Native Client Product Version : 9.00.3042.00 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0019_74-1R8J081_SQLNCLI_2.log -------------------------------------------------------------------------------- Machine : 74-1R8J081 Product : MSXML 6.0 Parser Product Version : 6.10.1129.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0019_74-1R8J081_MSXML6_2.log -------------------------------------------------------------------------------- Machine : 74-1R8J081 Product : SQL Server Database Services Error : Could not open key: HKEY_LOCAL_MACHINESoftwareClassesSQLActiveScriptHostCLSID. Verify that you have sufficient access to that key, or contact your support personnel. -------------------------------------------------------------------------------- Machine : 74-1R8J081 Product : Microsoft SQL Server 2005 Express Edition Product Version : 9.2.3042.00 Install : Failed Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0019_74-1R8J081_SQL.log Last Action : InstallFinalize Error String : Could not open key: HKEY_LOCAL_MACHINESoftwareClassesSQLActiveScriptHostCLSID. System error 5. Verify that you have sufficient access to that key, or contact your support personnel. Error Number : 1402 --------------------------------------------------------------------------------
I went into RegEdit and reviewed the permissions and I have Full Control for this particular entry. Does anyone know how I can resolve this issue?
I'm having trouble loging into sql...then I remebered when I first installed it on my XP pro machine the system config check showed everything passed except the following:
System Configuration Check
-
- COM Plus Catalog Requirement (Warning)
Messages
COM Plus Catalog Requirement
If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.
I am gettierror whle installing the SQL Server Express.
Product: Microsoft SQL Server 2005 Express Edition -- Error 29513. SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:Program FilesMicrosoft SQL Server90Sharedsqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
I have tried installing SQL Express using the latest download. I've also intalled the latest Windows Installer (3.1) but I have the following error message (taken from log). All contributions gratefully accepted
As the subject says, I am getting an error installing SQL Express 2005 SP1 on XP Home/SP2. I have never had a previous version of SQL server installed. I have never had Visual Studio installed. I have tried extracting the setup files and running from a different directory. I have tried installing the advanced package as well with the same results.
When I run the setup, the Client and support files are successfully installed. It then goes on to the system analysis, where I get one warning about my hardware but I have checked the help file and my system appears to meet the system requirements. After I click Next from this window is where I get the error, "Error writing to file: Access is denied. . Verify that you have access to that directory."
After looking into the log files I see this,
Error Code: 0x80070005 (5) Windows Error Text: Access is denied. Source File Name: t:yukonsqlsetupdarwinsqlcastubstreamca.cpp Compiler Timestamp: Wed Dec 21 16:49:23 2005 Function Name: streamBinaryToDisk Source Line Number: 238 Error 1304. Error writing to file: Access is denied. . Verify that you have access to that directory.
Does anyone know what is wrong? I have installed this on many W2K machines at work as well as installed the full version of SQL Server 2005. I have never seen these errors on any of those machines. This is the first XP machine I have ever tried to install on so I am not sure if this is an OS problem or not.
I've been trying to install SQL Server Express 2005 on my machine at home (XP Pro). However, when I get done, I get the following error when I restart my computer (at the login screen): "Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name.). Please uninstall the re-run setup to correct this problem."
I have uninstalled and reinstalled a number of times, with always thesame result. I had Visual Studio Orcas Beta 2 installed, so I thought that might have had something to do with it. I uninstalled everything development related on the machine (including all versions of the .NET Framework), and am still getting the same error. I tried installing along with Visual Studio 2005 (since it can be installed through the VS installer), same error.
I haven't been able to find any helpful information on this error. It seems everyone else is seeing it when they try to open Management Studio or some other program, but I am seeing it on system start.
Anyone have any thoughts? I'd really like to get this working. Thanks.
I was running the setup program and it popped up an error message:
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 looked at ERRORLOG and it says:
2008-05-07 04:00:11.67 spid4s Starting up database 'msdb'. 2008-05-07 04:00:11.74 Server Error: 17190, Severity: 16, State: 1. 2008-05-07 04:00:11.74 Server FallBack certificate initialization failed with error code: 1. 2008-05-07 04:00:11.74 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
I am getting an error when trying to install SQL Server 2005 express. I initially had SQL Server 2000 installed which I uninstalled before installing 2005 express edition. I am getting the following error log.....please help
=== Verbose logging started: 12/15/2007 23:14:46 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (70:64) [23:14:46:515]: Resetting cached policy values MSI (c) (70:64) [23:14:46:515]: Machine policy value 'Debug' is 0 MSI (c) (70:64) [23:14:46:515]: ******* RunEngine: ******* Product: h:cc6704e5af0e1720a26dec7cc3SetupSqlWriter.msi ******* Action: ******* CommandLine: ********** MSI (c) (70:64) [23:14:46:515]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (70:64) [23:14:46:515]: Grabbed execution mutex. MSI (c) (70:64) [23:14:46:531]: Cloaking enabled. MSI (c) (70:64) [23:14:46:531]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (70:64) [23:14:46:531]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (70:14) [23:14:46:546]: Grabbed execution mutex. MSI (s) (70:B4) [23:14:46:546]: Resetting cached policy values MSI (s) (70:B4) [23:14:46:546]: Machine policy value 'Debug' is 0 MSI (s) (70:B4) [23:14:46:546]: ******* RunEngine: ******* Product: h:cc6704e5af0e1720a26dec7cc3SetupSqlWriter.msi ******* Action:
I received an error installing the SP2 for SQL Server Express 2005 SP2. Here is what the summary says. Can anyone help me. Also I am running a Blackberry Enterprise Server on this machine.
Time: 11/09/2007 22:11:21.703 KB Number: KB921896 Machine: XXXXXX OS Version: Microsoft Windows Server 2003 family, Enterprise Edition Service Pack 2 (Build 3790) 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 (MSSQLSERVER) ENU RTM 2005.090.1399.00 x86 EXPRESS ********************************************************************************** Products Disqualified & Reason Product Reason ********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID ********************************************************************************** Product Installation Status Product : Express Database Services (MSSQLSERVER) Product Version (Previous): 1399 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9Express_Hotfix_KB921896_SQLEXPR.EXE SQL Express Features : SQL_Data_Files,SQL_Engine,SQL_SharedTools Error Number : 70036 Error Description : Unable to install Windows Installer MSI file ---------------------------------------------------------------------------------- ********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 70036
Product: Microsoft SQL Server 2005 Express Edition -- Error 1923. Service 'SQL Server ()' () could not be installed. Verify that you have sufficient privileges to install system services.
I've tried uninstalling through control panel and various cleanup tools and tried reinstalling with no luck.
I'm logged on with a user that has full admin rights.
I am trying to install sql server 2005 express edition.But i get an error stating that
sql server setup unexpectedly failed. For more information review the detup summary log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGsummary.txt
Summary.txt looks like this.It has only these 3 lines of information nothing else other this, which i have seen in many posts.
Microsoft SQL Server 2005 9.00.3042.00 ============================== OS Version : Microsoft Windows XP Home Edition Service Pack 2 (Build 2600) Time : Tue Apr 03 22:36:33 2007
I am using windows xp. Probably many of you might have had this problem.Could anyone please provide me with some help.Thanks in advance.
I'm getting this error when installing SQL Express 2005 on a non-English version of Vista.
"SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, passowrd, and domain, or specify a built-in system account."
Using Wise I get this error only when installing on a non-English version of Windows Vista, I can get the install to complete if I remove nt/authority. I've tried changing the non-English versions of Vista localization to English but I still get the same error.
I encountered an error when attempting to install Visual Basic Express Edition RTM. During the setup, I selected MSDN Express Edition and SQL Server 2005 Express Edition. Specifically, the SQL Server 2005 EE part of the installation failed. Here's the error I received:
Visual Basic 2005 Express Edition Setup Error occurred during setup Visual Basic 2005 Express Edition has been successfully installed. The following component failed to install: Microsoft SQL Server 2005 Express Edition x86
I had not installed any betas on this particular PC; however, I had already installed Visual Studio 2005 Pro and SQL Server 2005 Developer Edition.
(I selected SQL Server EE during the VBEE install because the VBEE readme said that the VSEE Editions (except for VWD) only work with SQL Server EE--so I figured I had to install SQL Server EE if I wanted to do any database work with VBEE. Is that the case?)
The following two log files were the only ones containing any error messages. How should I proceed?
C:Program Filesmicrosoft sql server90setup bootstraplogfilesSQLSetup0003_US05046_Core.log: Microsoft SQL Server 2005 Setup beginning at Mon Dec 19 14:40:32 2005 Process ID : 5824 c:211395ac6e4ed715363fsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2005/11/19 14:40:31 Complete: LoadResourcesAction at: 2005/11/19 14:40:31, returned true Running: ParseBootstrapOptionsAction at: 2005/11/19 14:40:31 Loaded DLL:c:211395ac6e4ed715363fxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2005/11/19 14:40:32, returned true Running: ValidateWinNTAction at: 2005/11/19 14:40:32 Complete: ValidateWinNTAction at: 2005/11/19 14:40:32, returned true Running: ValidateMinOSAction at: 2005/11/19 14:40:32 Complete: ValidateMinOSAction at: 2005/11/19 14:40:32, returned true Running: PerformSCCAction at: 2005/11/19 14:40:32 Complete: PerformSCCAction at: 2005/11/19 14:40:32, returned true Running: ActivateLoggingAction at: 2005/11/19 14:40:32 Complete: ActivateLoggingAction at: 2005/11/19 14:40:32, returned true Running: DetectPatchedBootstrapAction at: 2005/11/19 14:40:32 Complete: DetectPatchedBootstrapAction at: 2005/11/19 14:40:32, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__5824" returned false. Running: PerformSCCAction2 at: 2005/11/19 14:40:32 Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435 Loaded DLL:C:WINNTsystem32msi.dll Version:3.1.4000.2435 Complete: PerformSCCAction2 at: 2005/11/19 14:40:33, returned true Running: PerformDotNetCheck at: 2005/11/19 14:40:33 Complete: PerformDotNetCheck at: 2005/11/19 14:40:33, returned true Running: ComponentUpdateAction at: 2005/11/19 14:40:33 Complete: ComponentUpdateAction at: 2005/11/19 14:41:6, returned true Running: DetectLocalBootstrapAction at: 2005/11/19 14:41:6 Complete: DetectLocalBootstrapAction at: 2005/11/19 14:41:6, returned true Running: LaunchLocalBootstrapAction at: 2005/11/19 14:41:6 Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run: "c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1706 Aborting queue processing as nested installer has completed Message pump returning: 1706
C:Program Filesmicrosoft sql server90setup bootstraplogfilesSQLSetup0003_US05046_Core(Local).log: Microsoft SQL Server 2005 Setup beginning at Mon Dec 19 14:41:10 2005 Process ID : 5476 c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2005/11/19 14:41:9 Complete: LoadResourcesAction at: 2005/11/19 14:41:9, returned true Running: ParseBootstrapOptionsAction at: 2005/11/19 14:41:9 Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2005/11/19 14:41:9, returned true Running: ValidateWinNTAction at: 2005/11/19 14:41:9 Complete: ValidateWinNTAction at: 2005/11/19 14:41:9, returned true Running: ValidateMinOSAction at: 2005/11/19 14:41:9 Complete: ValidateMinOSAction at: 2005/11/19 14:41:9, returned true Running: PerformSCCAction at: 2005/11/19 14:41:9 Complete: PerformSCCAction at: 2005/11/19 14:41:9, returned true Running: ActivateLoggingAction at: 2005/11/19 14:41:9 Complete: ActivateLoggingAction at: 2005/11/19 14:41:10, returned true Running: DetectPatchedBootstrapAction at: 2005/11/19 14:41:10 Complete: DetectPatchedBootstrapAction at: 2005/11/19 14:41:10, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__5476" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2005/11/19 14:41:10 Complete: PerformDotNetCheck2 at: 2005/11/19 14:41:12, returned true Running: InvokeSqlSetupDllAction at: 2005/11/19 14:41:12 Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlspars.dll Version:2005.90.1399.0 <Func Name='DwLaunchMsiExec'> Examining 'sqlspars' globals to initialize 'SetupStateScope' Opening 'MachineConfigScope' for [US05046] 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 = US05046, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = US05046, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = US05046, Article = XMLDomDocument, Result = 0 (0x0) Machine = US05046, Article = Processor, Result = 0 (0x0) Machine = US05046, Article = PhysicalMemory, Result = 0 (0x0) Machine = US05046, Article = DiskFreeSpace, Result = 0 (0x0) Machine = US05046, Article = OSVersion, Result = 0 (0x0) Machine = US05046, Article = OSServicePack, Result = 0 (0x0) Machine = US05046, Article = OSType, Result = 0 (0x0) Machine = US05046, Article = AdminShare, Result = 0 (0x0) Machine = US05046, Article = PendingReboot, Result = 0 (0x0) Machine = US05046, Article = IEVersion, Result = 0 (0x0) Machine = US05046, Article = DriveWriteAccess, Result = 0 (0x0) Machine = US05046, Article = COMPlus, Result = 0 (0x0) Machine = US05046, Article = ASPNETVersionRegistration, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: US05046 ******************************************* 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 <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> Loaded DLL:c:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2005/11/19 14:42:59, returned true Running: SetPackageInstallStateAction at: 2005/11/19 14:42:59 Complete: SetPackageInstallStateAction at: 2005/11/19 14:43:1, returned true Running: DeterminePackageTransformsAction at: 2005/11/19 14:43:1 Complete: DeterminePackageTransformsAction at: 2005/11/19 14:43:5, returned true Running: ValidateSetupPropertiesAction at: 2005/11/19 14:43:5 Complete: ValidateSetupPropertiesAction at: 2005/11/19 14:43:5, returned true Running: OpenPipeAction at: 2005/11/19 14:43:5 Complete: OpenPipeAction at: 2005/11/19 14:43:5, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2005/11/19 14:43:5 Complete: CreatePipeAction at: 2005/11/19 14:43:5, 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: 2005/11/19 14:43:5 Complete: PopulateMutatorDbAction at: 2005/11/19 14:43:5, returned true Running: GenerateRequestsAction at: 2005/11/19 14:43:5 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = 3 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 = 3 Connectivity = 3 SQL_Tools90 = -1 SQL_WarehouseDevWorkbench = -1 SDK = 3 SQLXML = -1 Tools_Legacy = -1 TOOLS_BC_DEP = -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: 2005/11/19 14:43:11, returned true Running: CreateProgressWindowAction at: 2005/11/19 14:43:11 Complete: CreateProgressWindowAction at: 2005/11/19 14:43:12, returned false Error: Action "CreateProgressWindowAction" failed during execution. Running: ScheduleActionAction at: 2005/11/19 14:43:12 Complete: ScheduleActionAction at: 2005/11/19 14:43:13, 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: 2005/11/19 14:43:14 Installing: sqlsupport on target: US05046 Complete: InstallSqlAction.11 at: 2005/11/19 14:43:26, returned true Running: InstallSqlAction.12 at: 2005/11/19 14:43:26 Installing: sqlncli on target: US05046 Complete: InstallSqlAction.12 at: 2005/11/19 14:43:40, 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: 2005/11/19 14:43:40 Installing: sqlwriter on target: US05046 Failed to install package Fatal error during installation. Setting package return code to: 1706 Complete: InstallSqlAction.21 at: 2005/11/19 14:43:50, returned false Error: Action "InstallSqlAction.21" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. 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: 2005/11/19 14:43:50 Installing: msxml6 on target: US05046 Complete: InstallSqlAction.9 at: 2005/11/19 14:43:54, returned true Running: InstallToolsAction.11 at: 2005/11/19 14:43:54 Installing: sqlsupport on target: US05046 Complete: InstallToolsAction.11 at: 2005/11/19 14:44:2, returned true Running: InstallToolsAction.12 at: 2005/11/19 14:44:2 Installing: sqlncli on target: US05046 Complete: InstallToolsAction.12 at: 2005/11/19 14:44:11, returned true 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. Running: InstallToolsAction.9 at: 2005/11/19 14:44:11 Installing: msxml6 on target: US05046 Complete: InstallToolsAction.9 at: 2005/11/19 14:44:15, returned true Action "InstallSqlAction" will return false due to the following preconditions: Condition "Action: InstallSqlAction.21 has finished and failed." returned true. Installation of package: "sql" failed due to a precondition. Step "InstallSqlAction" was not able to run. 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: InstallToolsAction at: 2005/11/19 14:44:15 Installing: tools on target: US05046 Complete: InstallToolsAction at: 2005/11/19 14:44:26, returned true 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: 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: 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: 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. Running: ReportChainingResults at: 2005/11/19 14:44:27 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1706 Error Code: 0x800706aa (1706) Windows Error Text: The endpoint format is invalid.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Sep 1 22:23:05 2005 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3097
First of all I apologize for my very poor English.
I tried to install SQL Server 2005 Express Edition (I also Installed Visual Studio Express Edition) and the intallation program don' t finish correctly:
I opened the archive C:Archivos de programaMicrosoft SQL Server90Setup BootstrapLOGSummary.txt: SQL Server 2005 installation program has detected incompatible Visual Studio Beta, .Net Framework or SQL Server components.
In Spanish: El programa de instalación de SQL Server 2005 ha detectado componentes beta de Visual Studio, .NET Framework o SQL Server incompatibles
I had installed Beta versions of Visual Studio Express and SQL Express but I had uninstall all previous components before installing new version.
I tried tu use the tool to uninstall all Beta versions but the error persists.
Have you got any solution for this? Need you any more information? Please feel free to contact me for any sugestion.
Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:
Error reading from file C:...SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..
Solved my own problem. Once I moved the msi to C: the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:xxxxxxxxSQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.
I am attempting to install SQL Server 2005 express with SP2 on Vista Business - as a requirement for a new software package. The installation fails at the point of installing performace counters - the errors are below. I have been unable to find any support entry for this error:
The error message: The setup has encountered an unexpected error while Installing performance counters. The error is: Access is denied. From the Summary Log: Last Action : InstallFinalize Error String : The setup has encountered an unexpected error while Installing performance counters. The error is: Access is denied. Error Number : 29528 From SQLSetup00001 Log: MSI (s) (40:E4) [22:03:08:261]: Note: 1: 1708 MSI (s) (40:E4) [22:03:08:261]: Product: Microsoft SQL Server 2005 Express Edition -- Installation failed. MSI (s) (40:E4) [22:03:08:262]: Windows Installer installed the product. Product Name: Microsoft SQL Server 2005 Express Edition. Product Version: 9.2.3042.00. Product Language: 1033. Installation success or error status: 1603. Thanks in advance,
we're getting an error that says "C:....rptproj' cannot be opened because its project type (.rptprroj) is not supported by this version of Visual Studio. To open it, please use a version that supports this type of project." when trying to open RS projects created in VS2005 with VS2008.
We concluded from the specs on VS2008 that the DB Version of VS2008 wouldnt be necessary for RS projects. Were we wrong? Is there some other add in that we need, perhaps BIDS? Is there some conversion step that we need to follow?
