I was trying to install visual studio 2005 and as part of it I wanted to install sql express as well. It installed the rest okay but not the sql express. Going through the log file I figured out that there was some incompatible beta version installed and hence had to be removed. In the log file I got the following error messages. Going through the forum suggestion I was trying to use msiexec /x to deinstall each of them but got the error message that "The setup has encountered an unexpected error in datastore. The action is Write_CommitFlag. The error is unable to write property into cache: flagCommit. Unable to write property into cache: "flagCommit" XmiRW Error: Failure loading xmlrw.dll CheckAllProcedures. returned 2". After this error message when I check the sql server configuration manager, I still see the old instances running.
I followed up another forum suggestion where I completely installed the old CTP and used the tool provided in the DVD(sqlbuw) to uninstall it but it only removes the one instance and leaves the rest on the system.
I will really appreciate help...
ERRRR:...
icrosoft SQL Server 2005 Setup beginning at Sun Nov 19 16:49:19 2006
Process ID : 5736
c:87450d2367f159d42610acad33156dbcsetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2006/10/19 16:49:18
Complete: LoadResourcesAction at: 2006/10/19 16:49:18, returned true
Running: ParseBootstrapOptionsAction at: 2006/10/19 16:49:18
Loaded DLL:c:87450d2367f159d42610acad33156dbcxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2006/10/19 16:49:19, returned true
Running: ValidateWinNTAction at: 2006/10/19 16:49:19
Complete: ValidateWinNTAction at: 2006/10/19 16:49:19, returned true
Running: ValidateMinOSAction at: 2006/10/19 16:49:19
Complete: ValidateMinOSAction at: 2006/10/19 16:49:19, returned true
Running: PerformSCCAction at: 2006/10/19 16:49:19
Complete: PerformSCCAction at: 2006/10/19 16:49:19, returned true
Running: ActivateLoggingAction at: 2006/10/19 16:49:19
Complete: ActivateLoggingAction at: 2006/10/19 16:49:19, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__5736" returned false.
Running: PerformSCCAction2 at: 2006/10/19 16:49:19
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Product "{2373A92B-1C1C-4E71-B494-5CA97F96AA19}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 CTP"
Product "{CD080F4B-BF2C-4A0E-B923-CDA7F6EAB1C9}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 CTP"
Product "{481DFF26-7C67-4085-9A27-758283EA494A}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 CTP"
Product "{982DB00A-9C4E-436B-8707-18E113BAA44C}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Analysis Services CTP"
Product "{63A5DC0D-1EDD-4D69-8F31-87FAEB1F7084}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Notification Services CTP"
Product "{E0A41F96-7231-4AE8-A654-EEB34F935462}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Data Transformation Services CTP"
Product "{90032DD0-ABEE-4424-AC1E-B076BDD4E350}" versioned 9.00.1116 is not compatible with current builds of SQL Server.Expected at least version: 9.00.1399.06
The Product Name is "Microsoft SQL Server 2005 Tools CTP"
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.2435
Error: Action "PerformSCCAction2" threw an exception during execution.
Return Code: 70032
Message displayed to user
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.
Delay load of action "UploadDrWatsonLogAction" returned nothing. No action will occur as a result.
Message pump returning: 70032
When trying to install SQL Server 2005 Express, it hangs up on "Detecting Installed IIS". This happens if I have IIS installed, and if I do not. My computer is running XP Media Edition. I found a similar question asked by flashg on these forums, but there was no answer to the problem. There were a few other people who posted the same problem.
Is there any fix to this? I am writing software that I planned on using SQL Server Express to store its data with. But if SQL Server is going to cause problems on my customer's computers then I cannot use it.
This is the end of the log file for my SQL Server installation:
MSI (c) (00:20) [20:47:22:140]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2 Action 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS Action start 20:47:22: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. MSI (c) (00:04) [20:47:22:140]: Invoking remote custom action. DLL: C:DOCUME~1KYLEOL~1LOCALS~1TempMSI1AA.tmp, Entrypoint: CheckIIS <Func Name='LaunchFunction'> Function=CheckIIS MSI (c) (00!60) [20:47:22:155]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'. <Func Name='SetCAContext'> <EndFunc Name='SetCAContext' Return='T' GetLastError='203'> Doing Action: CheckIIS PerfTime Start: CheckIIS : Wed Oct 18 20:47:22 2006 <Func Name='CheckIIS'> Action 20:47:22: CheckIIS. Detecting Installed IIS MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'. MSI (c) (00!60) [20:47:22:171]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'. Skipping RS Feature Dependency Check <Func Name='GetXMLAttributeValue'> Error to find XML node /configuration/system.web/compilation <EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'> Failed to get ModuleID_RS_Server when getting the ASP Temp directory.
It is not in the add and remove programs. I did what was told and stopped all processes of SQL, I had SQL 2000 running, now I am getting: The setup has encounted an unexpected error in datastore. The action is Write_CommitFlag. The error is Unable to write property into cache: "flagCommit" XmRW Error: Failure loading xmlw.dll CheckAllProcedures[] return 2, I get this when running msiexe /x {the number for the beta}
Could someone please help me, I need to have this install to take courses this weekend, Want to complete the install today, which is Friday.
I've developed a desktop application for a company. It uses click once deployment and has a few prereqs: .NET Framework 2.0, j# .NET redistributable, windows installer 3.1 and SQL Server 2005 express edition.
Most of the time the application downloads and installs fine. However, one user has a problem. I'm fairly certain it's machine / OS related and I wonder if there is a way to get around it.
The user has a Windows 2000 machine, Pentium III, with 512 MB of RAM.
On their first try, they received an error while installing SQL Server 2005 Express. The error code the user found in the install log was 70095. Apparently the user found some information directing them to install the current MDAC 2.8 SP 1. After rebooting and trying the install again, it errored out. The new error code is 1706. Below is the install log.
As I said, I'm faily certain it's an OS issue, but I do hope there is a way around the issue other than trying to get the user to upgrade. If you need any other information, please let me know and I'll try to get it from the user.
Thanks,
AaronThe following properties have been set: Property: [AdminUser] = true {boolean} Property: [ProcessorArchitecture] = Intel {string} Property: [VersionNT] = 5.0.4 {version} Running checks for package '.NET Framework 2.0', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpDotNetFXdotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' Reading value 'Version' of registry key 'HKLMSoftwareMicrosoftInternet Explorer' Read string value '6.0.2800.1106' Setting value '6.0.2800.1106 {string}' for property 'IEVersion' The following properties have been set for package '.NET Framework 2.0': Property: [DotNetInstalled] = 1 {int} Property: [IEVersion] = 6.0.2800.1106 {string} Running checks for command 'DotNetFXinstmsia.exe' Result of running operator 'ValueExists' on property 'VersionNT': true Result of checks for command 'DotNetFXinstmsia.exe' is 'Bypass' Running checks for command 'DotNetFXWindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.3': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.0': true Result of checks for command 'DotNetFXWindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' Running checks for command 'DotNetFXdotnetfx.exe' Result of running operator 'ValueNotEqualTo' on property 'DotNetInstalled' and value '0': true Result of checks for command 'DotNetFXdotnetfx.exe' is 'Bypass' '.NET Framework 2.0' RunCheck result: No Install Needed Running checks for package 'Microsoft Visual J# .NET Redistributable Package 2.0', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpVJSharpRDPvjsrdpchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'VJSRDPInstalled' Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpVJSharpRDPdotnetchk.exe" Process exited with code 1 Setting value '1 {int}' for property 'DotNetInstalled' The following properties have been set for package 'Microsoft Visual J# .NET Redistributable Package 2.0': Property: [DotNetInstalled] = 1 {int} Property: [VJSRDPInstalled] = 1 {int} Running checks for command 'VJSharpRDPvjredist.exe' Result of running operator 'ValueNotEqualTo' on property 'VJSRDPInstalled' and value '0': true Result of checks for command 'VJSharpRDPvjredist.exe' is 'Bypass' 'Microsoft Visual J# .NET Redistributable Package 2.0' RunCheck result: No Install Needed Running checks for package 'Windows Installer 3.1', phase BuildList The following properties have been set for package 'Windows Installer 3.1': Running checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionMsi' and value '3.1': true Result of checks for command 'WindowsInstaller3_1WindowsInstaller-KB893803-v2-x86.exe' is 'Bypass' 'Windows Installer 3.1' RunCheck result: No Install Needed Running checks for package 'SQL Server 2005 Express Edition', phase BuildList Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpressSqlExpressChk.exe" Process exited with code 1 Setting value '1 {int}' for property 'SQLExpressInstalled' The following properties have been set for package 'SQL Server 2005 Express Edition': Property: [SQLExpressInstalled] = 1 {int} Running checks for command 'SqlExpresssqlexpr32.exe' Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install' Running checks for command 'SqlExpresssqlexpr32.exe' Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.1': true Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Bypass' 'SQL Server 2005 Express Edition' RunCheck result: Install Needed EULA for components 'SQL Server 2005 Express Edition' was accepted. Copying files to temporary directory "C:DOCUME~1craigpLOCALS~1TempVSD8.tmp" Downloading files to "C:DOCUME~1craigpLOCALS~1TempVSD8.tmp" (12/14/2006 11:16:32 PM) Downloading 'SqlExpresssqlexpr32.exe' from 'http://go.microsoft.com/fwlink/?LinkId=37280&clcid=0x409' to 'C:DOCUME~1craigpLOCALS~1TempVSD8.tmp' Download completed at 12/14/2006 11:17:02 PM Verifying file integrity of C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe WinVerifyTrust returned 0 File trusted Running checks for package 'SQL Server 2005 Express Edition', phase BeforePackage Running external check with command line "C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpressSqlExpressChk.exe" Process exited with code 1 Setting value '1 {int}' for property 'SQLExpressInstalled' The following properties have been set for package 'SQL Server 2005 Express Edition': Property: [SQLExpressInstalled] = 1 {int} Running checks for command 'SqlExpresssqlexpr32.exe' Result of running operator 'ValueEqualTo' on property 'SQLExpressInstalled' and value '0': false Result of running operator 'VersionGreaterThanOrEqualTo' on property 'VersionNT' and value '5.1': false Result of running operator 'ValueEqualTo' on property 'AdminUser' and value 'false': false Result of running operator 'ValueExists' on property 'Version9x': false Result of running operator 'VersionLessThan' on property 'VersionNT' and value '5.0.4': false Result of running operator 'ValueNotEqualTo' on property 'ProcessorArchitecture' and value 'Intel': false Result of checks for command 'SqlExpresssqlexpr32.exe' is 'Install' 'SQL Server 2005 Express Edition' RunCheck result: Install Needed Verifying file integrity of C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe WinVerifyTrust returned 0 File trusted Installing using command line '"C:DOCUME~1craigpLOCALS~1TempVSD8.tmpSqlExpresssqlexpr32.exe" -q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1' Process exited with code 1706 Status of package 'SQL Server 2005 Express Edition' after install is 'InstallFailed'
I've downloaded & installed Visual Web developer Express and SQL Server Express and now I'm trying to install the Reporting Add-In available here: http://msdn.microsoft.com/vstudio/express/downloads/default.aspx
It downloads just fine and, just as the installation progress bar is almost done and the status text says 'Registering Product', I get the following error message:
"There is a problem with this windows installer package. A program run as part of the setup did not finish as expected. Contact your support personell or package vendor"
Running VWD shows the ReportViewer control now appears in the 'data' group. I can add it to a form, but I cannot create a new report, as clicking on 'Design a new report' under the ReportView Tasks popup menu does nothing.
I am installing Visual Studio 2005 Professional Edition. Everything goes well until the installation of SQL Server Express occurs. SQL Express installation progresses fine until very end of the installation. At that point it becomes stuck.
The installation says "Current component is installing" and is stuck on that message. The installer does not seem to be frozen as the picutres changes. However CPU usage for the setup processes is 0.
I have disabled all virus scanning software already.
Sorry if this seems to be very basic question. But after 5 hours I am thinking may be I am missing something.
I had always setup the dbs in server environment and I had never any issues but on my new Vaio Laptop with XP. Last time it was rather easy and I can not remember such issues. I downloaded (MSDE 2000) Release A from Microsoft and setting it up.
I set it up with the with the same parameters using an .ini file, I used Notepad to create a file named MyParameters.ini with these contents:
I find that my Visual studio is showing the instance at "Vaio/MSSQL" where Vaio is my Laptop. The setup created a folder in D:MSDEMSSQL$MSSQL and not in the target directory MSDE!!
Also my enterprise manager can not find it at all.
Also In visual studio I dont seem to be able to connect using my sa_password.
I am trying to install SQL server 6.5 for my SMS server. The installation stops with the message "could not connect to SQL server". There was evaluation version of SQL server 6.5 previously in the same server. I doubt that it was completely removed as when I try the upgrade option instead of install option, I get a message " early beta version of SQL server 6.5 detected". I am unable to use the deinstall option in the setup as it is dimmed. How do I completely remove all the files and registry entries so that I can do a fresh install?
I have run sql server 2000 and analysis manager on my laptop for a few months with no probs. On Monday I tried to connect to my computer server from sql server ent manager and it said "no datasource found." and something else about MS ODBC drivers being invalid. Analysis services still worked fine. I tired to connect and add servers and it just would not recognise anything so became software I could not use at all. I then uninstalled all sql server products on my computer. I thought a fresh reinstall would do the job. However now when I try to install sql server I get an error in the installation. It says that it cannot connect to the datasource and installation fails. It tells me to look in a sqlstp log and the bottom of this log is below
15:50:25 Begin Action: DialogShowSdUninstall 15:50:28 ShowDlgUninstall returned : 1 15:50:28 End Action DialogShowSdUninstall 15:50:28 Dialog 0x80000000 returned: 1 15:50:28 End Action ShowDialogsHlpr 15:50:28 ShowDialogsGetDialog returned: nCurrent=0x0,index=0 15:50:28 End Action ShowDialogs 15:50:29 Action CleanUpInstall: 15:50:29 StatsGenerate returned: 2 15:50:29 StatsGenerate (0xc0200805,0x2,0xf000000,0x400,1033,303,0x2,0x1,0 ,0,0 15:50:29 StatsGenerate -1,rj) 15:50:29 Installation Failed.
I havent shown the rest of the log because there is a lot of it. If needed I can copy in the rest.
The rest of the installation up to this point seems fine. HOwever it doesnt install the unistall files so I cannot uninstall SQL Server now. There is 105 MB of the program on my computer which I can only delete although I havent done this yet.
Why wont sql server let me install? It is a really annoying problem because it worked fine last Friday and then on Monday it went wrong and I cannot remember doing anything to make this happen. All MS updates are up-to-date. Any help is greatly appreciated
In order to deploy a corporate application on WM 5 devices, I've built an autorun.exe that performs some calls to wceload.exe to install cab files.
Everything is installing correctly, except SQL Mobile 3.0 (and its replication library). Here is the files the autorun.exe installs : compact framework 2.0 SP1 (NETCFv2.wm.armv4i.cab) french strings (System_SR_FR.cab) Sql mobile 3.0 (sqlce30.ppc.wce5.armv4i.CAB) Sql Mobile 3.0 replication (sqlce30.repl.ppc.wce5.armv4i.CAB) and also app cabs (app.cab, app2.cab, etc...)
The command line I execute in the autorun.exe is this one :
wceload.exe fullpath_to_cab_file.cab /silent
when I run this command line, I get no error (exit code of wceload.exe is 0). Bu when I run the application (a C# app) I get an error that one the assembly cannot be loaded. A further investigations later, I discovered that if I install sql mobile (the two cab files) by clicking on the cab on the device through files explorer, not only I get no error while installing, but also the application works correctly.
So I have two questions : 1. what can be possible reasons that make the autorun.exe fails to install Sql Mobile ? 2. In a more general way, how can I correctly handle wceload errors ?
FYI, I don't care about certificates, since the chosen device is a device where the security has been turned off. Another precision : the final users won't have access to a computer to deploy the app. That's why I choose to use an autorun.exe file.
I am having trouble getting the Critical Update for SQL Server 2005 Service Pack 2 (KB 934458) to install successfully. Message simply states the updates was unsuccessful. After that I am unable to connect to SQL Server via SSMS. Only rebooting the computer allows me to reconnect. Then Automatic updates won't leave me alone and wants to try it again. Hmmmmm.
I then tried to download (SQLServer2005-KB934458-x86-ENU.exe) and try it again. While running the update I noticed it was now referred to as "Microsoft SQL Server 2005 Service Pack 2 Cumulative Hotfix 3054". Are these the same thing? Any hoot, it still fails to install. As each component failed, for what looks to be the same reason (See below), I allowed the installation wizard to report it's findings back to Microsoft.
Oh and one other observation. It appears as though Microsoft had a similar issue when they release SS2k5 SP1. They issed a workaround. See http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B918357. If this is the same problem, why wouldn' t they try to fix it before releasing SP2?
Any way back to my current issue, clicking on the View Summary at the Installation Complete dialog reveals the following. Can someone help?
Thanks!!!
Time: 04/06/2007 10:04:01.859 KB Number: KB934458 Machine: PEPE OS Version: Microsoft Windows XP Professional Service Pack 2 (Build 2600) Package Language: 1033 (ENU) Package Platform: x86 Package SP Level: 2 Package Version: 3054 Command-line parameters specified: Cluster Installation: No
********************************************************************************** Prerequisites Check & Status SQLSupport: Passed
********************************************************************************** Products Detected Language Level Patch Level Platform Edition SQL Server Database Services 2005 (MSSQLSERVER) ENU SP2 2005.090.3050.00 x86 DEVELOPER SQL Server Analysis Services 2005 (MSSQLSERVER) ENU SP2 2005.090.3050.00 x86 DEVELOPER SQL Server Reporting Services 2005 (MSSQLSERVER) ENU SP2 9.00.3050.00 x86 DEVELOPER SQL Server Notification Services 2005 ENU SP2 9.00.3050.00 x86 DEVELOPER SQL Server Integration Services 2005 ENU SP2 9.00.3050.00 x86 DEVELOPER SQL Server Tools and Workstation Components 2005 ENU SP2 9.2.3050 x86 DEVELOPER
********************************************************************************** Processes Locking Files Process Name Feature Type User Name PID
********************************************************************************** Product Installation Status Product : SQL Server Database Services 2005 (MSSQLSERVER) Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB934458_sqlrun_sql.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Analysis Services 2005 (MSSQLSERVER) Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixOLAP9_Hotfix_KB934458_sqlrun_as.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Reporting Services 2005 (MSSQLSERVER) Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixRS9_Hotfix_KB934458_sqlrun_rs.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Notification Services 2005 Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixNS9_Hotfix_KB934458_sqlrun_ns.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Integration Services 2005 Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixDTS9_Hotfix_KB934458_sqlrun_dts.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ---------------------------------------------------------------------------------- Product : SQL Server Tools and Workstation Components 2005 Product Version (Previous): 3050 Product Version (Final) : Status : Failure Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQLTools9_Hotfix_KB934458_sqlrun_tools.msp.log Error Number : 1635 Error Description : Unable to install Windows Installer MSP file ----------------------------------------------------------------------------------
********************************************************************************** Summary One or more products failed to install, see above for details Exit Code Returned: 1635
-------------------------------------- End of View Summary ---------------------------------------
For information purposes I went ahead and included below the tail end of the first failing process where it looks to go cattywhompus. The end of the log file (highlighted in yellow above) looks like this:
...
MSI (s) (10C) [09:51:23:343]: Opening existing patch 'C:WINDOWSInstaller2a6c7048.msp'. MSI (s) (10C) [09:51:23:343]: Note: 1: 2203 2: C:WINDOWSInstaller2a6c7048.msp 3: -2147287038 MSI (s) (10C) [09:51:23:343]: Couldn't find local patch 'C:WINDOWSInstaller2a6c7048.msp'. Looking for it at its source. MSI (s) (10C) [09:51:23:343]: Resolving Patch source. MSI (s) (10C) [09:51:23:343]: User policy value 'SearchOrder' is 'nmu' MSI (s) (10C) [09:51:23:343]: User policy value 'DisableMedia' is 0 MSI (s) (10C) [09:51:23:343]: Machine policy value 'AllowLockdownMedia' is 0 MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Media enabled only if package is safe. MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Looking for sourcelist for product {4A35EF4A-D868-4B15-A84D-3E8925AA9558} MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Adding {4A35EF4A-D868-4B15-A84D-3E8925AA9558}; to potential sourcelist list (pcode;disk;relpath). MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Now checking product {4A35EF4A-D868-4B15-A84D-3E8925AA9558} MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Media is enabled for product. MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Attempting to use LastUsedSource from source list. MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Trying source d:e2ba478890840dab90ccafHotFixSQLFiles. MSI (s) (10C) [09:51:23:343]: Note: 1: 2203 2: d:e2ba478890840dab90ccafHotFixSQLFilessqlrun_sql.msp 3: -2147287037 MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Source is invalid due to missing/inaccessible package. MSI (s) (10C) [09:51:23:343]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Processing net source list. MSI (s) (10C) [09:51:23:343]: Note: 1: 1706 2: -2147483647 3: sqlrun_sql.msp MSI (s) (10C) [09:51:23:343]: SOURCEMGMT: Processing media source list. MSI (s) (10C) [09:51:23:359]: SOURCEMGMT: Resolved source to: 'sqlrun_sql.msp' MSI (s) (10C) [09:53:21:359]: Note: 1: 1314 2: sqlrun_sql.msp MSI (s) (10C) [09:53:21:359]: Unable to create a temp copy of patch 'sqlrun_sql.msp'. MSI (s) (10C) [09:53:21:390]: Note: 1: 1708 MSI (s) (10C) [09:53:21:390]: Note: 1: 2729 MSI (s) (10C) [09:53:21:406]: Note: 1: 2729 MSI (s) (10C) [09:53:21:406]: Product: Microsoft SQL Server 2005 -- Installation failed.
MSI (s) (10C) [09:53:21:437]: MainEngineThread is returning 1635 This patch package could not be opened. Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer patch package. C:WINDOWSInstaller9b7a85.msi MSI (c) (C0:90) [09:53:21:437]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (C0:90) [09:53:21:437]: MainEngineThread is returning 1635 === Verbose logging stopped: 4/6/2007 9:53:21 ===
Above are the errors that i get when im tryin to install SQL 2005 i think its the DATA base side of it i managed to install the Configuration tools and things just cant install the Data base side where u can actually do something with it.
Hi. I am taking a certification class for which I recieved MSDE 2000 SQL server to use. I had a version that came with my textbook installed, and uninstalled it to use this one. Now I can no longer install either version, when I try it gives me a "instance name specified is not valid" error message when I start the installation, then kills it. Anyone have any ideas?
I am trying to install SQL Server 2005. I just installed Microsoft Visual Studio 2005(.NET). I got an option in my Start -> Programs for Microsoft SQL Server 2005. But I don't see how to bring up the query analyzer. It just has options for Configuration Tools ->SQL Server Configuration Manager,SQL Server Error and Usage Reporting, SQL Server Surface Area Configuration.
Did I install it wrong by chance? Do I need to do something else now? Do I need to configure it? If yes, how do I do that? Could anyone lead me in the right direction please? Thanks!
I have no idea how to proceed since I've never installed this before. Could anyone please help me install or do whatever needs to be done to it so I can bring up the query analyzer/user interface and be able to use SQL?
i am having some trouble installing SQl server Reporting Services.well, in order to install the reporting services i have to installServicePack 3a.so through my installation of package 3a i am encoutering some trouble.i was able to comlete the first part of the installation i receivethis error message: Instance name specified is invalidso, my question is: once you have SQL Server installed, where can yougo to find the name of the instanceand once i find it, can i rename it?i originally installed SQL Server a while ago. during the setup, i donot recall a particular name i might have given it.
When trying to install SP4, I do not receive any notification of the install i.e. click on setup and then nothing. Checked *.out log and receive the following:
2006-08-08 10:40:57 - ? [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 3616 2006-08-08 10:40:57 - ? [101] SQL Server 1LTZ0Q version 8.00.194 (0 connection limit) 2006-08-08 10:40:57 - ? [102] SQL Server ODBC driver version 3.81.9031 2006-08-08 10:40:57 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local) 2006-08-08 10:40:57 - ? [310] 2 processor(s) and 1016 MB RAM detected 2006-08-08 10:40:57 - ? [339] Local computer is 1LTZ0Q running Windows NT 5.0 (2195) Service Pack 4 2006-08-08 10:40:57 - ? [129] SQLSERVERAGENT starting under Windows NT service control 2006-08-08 10:40:57 - + [260] Unable to start mail session (reason: No mail profile defined) 2006-08-08 10:40:57 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
Novice - Where to set up the mail profile and CPU idle condition?
I am having trouble installing SQL Server 2005 on a new machine at a hosted company. I am only installing the minimum, SQL Databaes Services. It errors out at the end and says see log. I have installed SQl 2005 10 times with no problem at other locations. The service won't even start it says error 3 path unkown. If I look for the path it shows in the service it hasn't been created, the files and directories were not created at that directory location. I tried to install bot as a Domain Admin and Local Admin accounts.
Here THe summary Log., Core(local) and Core Log files below.
Microsoft SQL Server 2005 9.00.1399.06 ============================== OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 1 (Build 3790) Time : Tue Mar 20 02:48:40 2007
Machine : CATCSAP021211 Product : Microsoft SQL Server Setup Support Files (English) Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_SQLSupport_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft SQL Server Native Client Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_SQLNCLI_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft Office 2003 Web Components Product Version : 11.0.6558.0 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_OWC11_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft SQL Server VSS Writer Product Version : 9.00.1399.06 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_SqlWriter_1.log -------------------------------------------------------------------------------- Machine : CATCSAP021211 Product : Microsoft SQL Server 2005 Backward compatibility Product Version : 8.05.1054 Install : Successful Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0016_CATCSAP021211_BackwardsCompat_1.log --------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Microsoft SQL Server 2005 Setup beginning at Mon Mar 19 19:49:04 2007 Process ID : 1300 C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe Version: 2005.90.1399.0 Running: LoadResourcesAction at: 2007/2/19 19:49:4 Complete: LoadResourcesAction at: 2007/2/19 19:49:4, returned true Running: ParseBootstrapOptionsAction at: 2007/2/19 19:49:4 Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapxmlrw.dll Version:2.0.3604.0 Complete: ParseBootstrapOptionsAction at: 2007/2/19 19:49:4, returned true Running: ValidateWinNTAction at: 2007/2/19 19:49:4 Complete: ValidateWinNTAction at: 2007/2/19 19:49:4, returned true Running: ValidateMinOSAction at: 2007/2/19 19:49:4 Complete: ValidateMinOSAction at: 2007/2/19 19:49:4, returned true Running: PerformSCCAction at: 2007/2/19 19:49:4 Complete: PerformSCCAction at: 2007/2/19 19:49:4, returned true Running: ActivateLoggingAction at: 2007/2/19 19:49:4 Complete: ActivateLoggingAction at: 2007/2/19 19:49:4, returned true Running: DetectPatchedBootstrapAction at: 2007/2/19 19:49:4 Complete: DetectPatchedBootstrapAction at: 2007/2/19 19:49:4, returned true Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions: Condition "EventCondition: __STP_LaunchPatchedBootstrap__1300" returned false. Action "BeginBootstrapLogicStage" will be skipped due to the following restrictions: Condition "Setup is running locally." returned true. Running: PerformDotNetCheck2 at: 2007/2/19 19:49:4 Complete: PerformDotNetCheck2 at: 2007/2/19 19:49:4, returned true Running: InvokeSqlSetupDllAction at: 2007/2/19 19:49:4 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 [CATCSAP021211] 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 = CATCSAP021211, Article = WMIServiceWin32OSWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceWin32CompSystemWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceWin32ProcessorWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceReadRegWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceWin32DirectoryWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = WMIServiceCIMDataWorking, Result = 0 (0x0) Machine = CATCSAP021211, Article = XMLDomDocument, Result = 0 (0x0) Machine = CATCSAP021211, Article = Processor, Result = 0 (0x0) Machine = CATCSAP021211, Article = PhysicalMemory, Result = 0 (0x0) Machine = CATCSAP021211, Article = DiskFreeSpace, Result = 0 (0x0) Machine = CATCSAP021211, Article = OSVersion, Result = 0 (0x0) Machine = CATCSAP021211, Article = OSServicePack, Result = 0 (0x0) Machine = CATCSAP021211, Article = OSType, Result = 0 (0x0) Machine = CATCSAP021211, Article = iisDep, Result = 0 (0x0) Machine = CATCSAP021211, Article = AdminShare, Result = 0 (0x0) Machine = CATCSAP021211, Article = PendingReboot, Result = 0 (0x0) Machine = CATCSAP021211, Article = PerfMon, Result = 0 (0x0) Machine = CATCSAP021211, Article = IEVersion, Result = 0 (0x0) Machine = CATCSAP021211, Article = DriveWriteAccess, Result = 0 (0x0) Machine = CATCSAP021211, Article = COMPlus, Result = 0 (0x0) Machine = CATCSAP021211, Article = ASPNETVersionRegistration, Result = 0 (0x0) Machine = CATCSAP021211, Article = MDAC25Version, Result = 0 (0x0) ******************************************* Setup Consistency Check Report for Machine: CATCSAP021211 ******************************************* Article: WMI Service Requirement, Result: CheckPassed Article: MSXML Requirement, Result: CheckPassed Article: Operating System Minimum Level Requirement, Result: CheckPassed Article: Operating System Service Pack Level Requirement, Result: CheckPassed Article: SQL Compatibility With Operating System, Result: CheckPassed Article: Minimum Hardware Requirement, Result: CheckPassed Article: IIS Feature Requirement, Result: CheckPassed Article: Pending Reboot Requirement, Result: CheckPassed Article: Performance Monitor Counter Requirement, Result: CheckPassed Article: Default Installation Path Permission Requirement, Result: CheckPassed Article: Internet Explorer Requirement, Result: CheckPassed Article: Check COM+ Catalogue, Result: CheckPassed Article: ASP.Net Registration Requirement, Result: CheckPassed Article: Minimum MDAC Version Requirement, Result: CheckPassed <Func Name='PerformDetections'> 0 <EndFunc Name='PerformDetections' Return='0' GetLastError='0'> <Func Name='DisplaySCCWizard'> CSetupBootstrapWizard returned 1 <EndFunc Name='DisplaySCCWizard' Return='0' GetLastError='183'> Loaded DLL:C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlsval.dll Version:2005.90.1399.0 <EndFunc Name='DwLaunchMsiExec' Return='0' GetLastError='0'> Complete: InvokeSqlSetupDllAction at: 2007/2/19 19:51:1, returned true Running: SetPackageInstallStateAction at: 2007/2/19 19:51:1 Complete: SetPackageInstallStateAction at: 2007/2/19 19:51:1, returned true Running: DeterminePackageTransformsAction at: 2007/2/19 19:51:1 Complete: DeterminePackageTransformsAction at: 2007/2/19 19:51:3, returned true Running: ValidateSetupPropertiesAction at: 2007/2/19 19:51:3 Complete: ValidateSetupPropertiesAction at: 2007/2/19 19:51:3, returned true Running: OpenPipeAction at: 2007/2/19 19:51:3 Complete: OpenPipeAction at: 2007/2/19 19:51:3, returned false Error: Action "OpenPipeAction" failed during execution. Running: CreatePipeAction at: 2007/2/19 19:51:3 Complete: CreatePipeAction at: 2007/2/19 19:51:3, 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: 2007/2/19 19:51:3 Complete: PopulateMutatorDbAction at: 2007/2/19 19:51:3, returned true Running: GenerateRequestsAction at: 2007/2/19 19:51:3 SQL_Engine = 3 SQL_Data_Files = 3 SQL_Replication = 3 SQL_FullText = 3 SQL_SharedTools = 3 SQL_BC_DEP = 3 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 = 3 SQL_WarehouseDevWorkbench = 3 SDK = 3 SQLXML = 3 Tools_Legacy = 3 TOOLS_BC_DEP = 3 SQL_Documentation = 3 SQL_BooksOnline = 3 SQL_DatabaseSamples = -1 SQL_AdventureWorksSamples = -1 SQL_AdventureWorksDWSamples = -1 SQL_AdventureWorksASSamples = -1 SQL_Samples = -1 Complete: GenerateRequestsAction at: 2007/2/19 19:51:4, returned true Running: CreateProgressWindowAction at: 2007/2/19 19:51:4 Complete: CreateProgressWindowAction at: 2007/2/19 19:51:4, returned true Running: ScheduleActionAction at: 2007/2/19 19:51:4 Complete: ScheduleActionAction at: 2007/2/19 19:51:4, 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: 2007/2/19 19:51:4 Installing: sqlsupport on target: CATCSAP021211 Complete: InstallSqlAction.11 at: 2007/2/19 19:51:5, returned true Running: InstallSqlAction.12 at: 2007/2/19 19:51:5 Installing: sqlncli on target: CATCSAP021211 Complete: InstallSqlAction.12 at: 2007/2/19 19:51:6, returned true Running: InstallSqlAction.18 at: 2007/2/19 19:51:6 Installing: owc11 on target: CATCSAP021211 Complete: InstallSqlAction.18 at: 2007/2/19 19:51:13, returned true Running: InstallSqlAction.21 at: 2007/2/19 19:51:13 Installing: sqlwriter on target: CATCSAP021211 Complete: InstallSqlAction.21 at: 2007/2/19 19:51:18, returned true Running: InstallSqlAction.22 at: 2007/2/19 19:51:18 Installing: bcRedist on target: CATCSAP021211 Complete: InstallSqlAction.22 at: 2007/2/19 19:51:28, returned true Running: InstallSqlAction.9 at: 2007/2/19 19:51:28 Installing: msxml6 on target: CATCSAP021211 Error: MsiOpenDatabase failed with 110 Failed to install package The installation source for this product is not available. Verify that the source exists and that you can access it. Error: MsiOpenDatabase failed with 110 for MSI {5A710547-B58E-488B-828D-CA9A25A0533C} Setting package return code to: 1612 Complete: InstallSqlAction.9 at: 2007/2/19 19:51:28, returned false Error: Action "InstallSqlAction.9" failed during execution. Error information reported during run: Target collection includes the local machine. Invoking installPackage() on local machine. Running: InstallToolsAction.11 at: 2007/2/19 19:51:28 Installing: sqlsupport on target: CATCSAP021211 Complete: InstallToolsAction.11 at: 2007/2/19 19:51:33, returned true Running: InstallToolsAction.12 at: 2007/2/19 19:51:33 Installing: sqlncli on target: CATCSAP021211 Complete: InstallToolsAction.12 at: 2007/2/19 19:51:34, returned true Running: InstallToolsAction.13 at: 2007/2/19 19:51:34 Installing: PPESku on target: CATCSAP021211 Complete: InstallToolsAction.13 at: 2007/2/19 19:53:48, returned true Running: InstallToolsAction.18 at: 2007/2/19 19:53:48 Installing: owc11 on target: CATCSAP021211 Complete: InstallToolsAction.18 at: 2007/2/19 19:53:51, returned true Running: InstallToolsAction.20 at: 2007/2/19 19:53:51 Installing: BOL on target: CATCSAP021211 Complete: InstallToolsAction.20 at: 2007/2/19 19:55:37, returned true Running: InstallToolsAction.22 at: 2007/2/19 19:55:37 Installing: bcRedist on target: CATCSAP021211 Complete: InstallToolsAction.22 at: 2007/2/19 19:55:40, returned true Error: Action "InstallToolsAction.9" failed during execution. Error information reported during run: Action: "InstallToolsAction.9" will be marked as failed due to the following condition: Condition "Package "9" either passed when it was last installed, or it has not been executed yet" returned false. Condition context: Prereq package will be failed due to the previous installation attempt returning: 1612 Installation of package: "msxml6" failed due to a precondition. Action "InstallSqlAction" will return false due to the following preconditions: Condition "Action: InstallSqlAction.9 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.10 at: 2007/2/19 19:55:40 Installing: sqlxml4 on target: CATCSAP021211 Complete: InstallToolsAction.10 at: 2007/2/19 19:55:44, returned true 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. Action "InstallToolsAction" will return false due to the following preconditions: Condition "Action: InstallToolsAction.9 has finished and failed." returned true. Installation of package: "tools" failed due to a precondition. Step "InstallToolsAction" was not able to run. 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: 2007/2/19 19:55:44 Error: Action "ReportChainingResults" threw an exception during execution. One or more packages failed to install. Refer to logs for error details. : 1612 Error Code: 0x8007064c (1612) Windows Error Text: The installation source for this product is not available. Verify that the source exists and that you can access it.
Source File Name: sqlchainingsqlchainingactions.cpp Compiler Timestamp: Thu Sep 1 22:23:05 2005 Function Name: sqls::ReportChainingResults::perform Source Line Number: 3097
I was having trouble with SQL server 2005 and reporting services. Finally I had to un-install and then re-install, had trouble with uninstalling initially. I couldn't use Add/Remove to remove Microsoft SQL Server 2005 until I found this command: "%ProgramFiles%Microsoft SQL Server90Setup BootstrapARPWrapper.exe" /Remove from http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354408&SiteID=1
So I was able to remove (from what I know) all traces of SQL 2005 and its configuration tools. However when I reinstall it, I only have the configuration tools installed. Going to Start>>Microsoft SQL Server 2005 - configuration tools is all i have. Going to Add Remove Programs I can see Microsoft SQL Server 2005 along with Microsoft SQL Server Native Client.
When I use windows exploerer the only folders I see in c:Program FilesMicrosoft SQL Server are: 80, 90, InetPub, MSSQL.1, MSSQL.2, MSSQL.3
when I install SP2 everything but PRODUCT INSTANCE Database Services MSSQLSERVER
install correctly.
After that nothing changes.
My questions are; do I really have SQL Sever installed so that I can create and edit queries, reports, etc. And if I do how do I access it? It seems like something is left over telling the installer that I already have SQL already installed but not the configurations tools. So it just installs them.
"None of the selected features can be installed or upgraded. Setup cannot proceed because no effective change is being made to the machine..."
this shows when trying to install SQL Server 'Management Tools', under Client Components, in the Tools install section, although i manually select 'Entire feature will be installed' (initially, all features are ticked off with a red X).
this error message shows up regardless of which feature i choose to install. it wouldn't even install books online.
I'm new to SQL Server and am now learning how to operate SQL Server Express 2005.
I'm getting the following error when attempting to install Visual Web Developer 2005 SP1.
"The upgrade patch cannot be installed by the Windows Installer service because the program to be upgraded may be missing, or the upgrade patch may update a different version of the program. Verify that the program to be upgraded exists on your computer and that you have the correct upgrade patch"
My machine runs on XP Pro SP2, .NET Framework 3.5.
Currently, what i have got on the computer are as follows Microsoft SQL Server 2005: SQL Server Management Studio Express, SQL Server Configuration Manager.
I downloaded the 2 CD ISO Format from msdn to install SQL Server 2005 English Developer Edition on my XP SP2 box.
I currently have SQL 2000 running. So Sql Server 2005 Dev Edition is to run side by side in a named instance.
From CD1, I launched default.hta and could not install Database Services. The log mentioned could not find a 'valid copy of xxx.msi' where xxx is VSS writer, Database Services or SQL XML4 etc...
I tried 3 times and each time it damaged my SQL2000 beyond repair.
Hi, I have installed SQL Server 2005(Express edition) and Visual Basic 2005(Express edition) along with the SQL ServerBusiness Intelligence Development Studio and SQL Server Management Studio Express. However when I open BIDS, VS2005 opens instead and there are only 2 templates for new projects. I dont find the other templates for creating new projects that should be present in BIDS . Could some one please tell me how to get the other new project templates??
Actually I should have said #22 but this is beyond the point. It seems the errors pop up and then go away for no reason, then appear again.
I had Sql Server Express with Advanced Features set up all right as far as I can see. It is the connection issue that is causing the headache.
Currently when I try to make a connection with an Sql database I get an error in Visual Studio:
Generating user instance in Sql Server is disabled. Use sp_configure 'user instances enabled' to generate user instances.
So I go to Sql Server, log in, open a new query and type:
sp_configure 'user instances enabled' GO
I get a table where I can see that
name minimum maximum config_value run_value user instances enabled 0 1 1 1
Are they enabled? I think, yes. I go back to Vsisual Studio and get the same error. It is possible that I will have to log out in order for all this security garbage to take effect and I will try it but in the meantime, how can I set more than one instance.
I want to complain that these new security provisions that came apparently with SP2 and Vista are totally unnesessary for my applications. I do not have any high security info to worry about, e.g. social security numbers, etc. I would not mind to turn all this stuff off if it is possible at all.
I've created an sql database in VB express, created some tables, and entered some data in those tables. My problem now lies with actually using that data. What i'd like to do is have a Sub use the database's data and fill in a series of variables. Right now i have the Sub using an Excel file to assign the information, looks like this:
Public Sub CharStatDefault() 'loads each character's default stats
CharSheet = xlBook.Worksheets(2)
P.initialize()
For excelInt = 1 To 22
P.C(excelInt).Initialize()
With P.C(excelInt)
.Vit = CharSheet.Range("AC" & excelInt).Value
.Phy = CharSheet.Range("AD" & excelInt).Value
.Mag = CharSheet.Range("AE" & excelInt).Value
.Off = CharSheet.Range("AF" & excelInt).Value
.Def = CharSheet.Range("AG" & excelInt).Value
.Agl = CharSheet.Range("AH" & excelInt).Value
End Sub
So basically i want to change the CharSheet.Range("XX" & excelInt).Value to something that utilizes the data from my database.
I am trying to connect to SQL Server Express using the following VB code from an aspx.vb page: ' Create and open a connection to the database Dim conn As New SqlConnection("Data Source=YOUR-FE632222CE\SQLEXPRESS;Initial Catalog=scotfree;Integrated Security=SSPI") conn.Open() This code fails on conn.Open() however giving me the following exception:System.InvalidOperationException: Instance failure.Stack trace:[InvalidOperationException: Instance failure.] System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner, Boolean& failoverDemandDone, String host, String failoverPartner, String protocol, SqlInternalConnectionTds connHandler, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean aliasLookup) +1804 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +501 System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28 System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429 System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70 System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +512 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89 System.Data.SqlClient.SqlConnection.Open() +160 Default3.OnLoad(EventArgs e) in C:Documents and SettingsLiamMy DocumentsVisual Studio 2005WebSitesTestDefault3.aspx.vb:15 System.Web.UI.Control.LoadRecursive() +49 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +3743The strange thing is that I replicated the code in C# and it works fine. Any ideas.
Hello, I'm using Visual Studio 2003 and I need to be able to connect to an SQL Server 2005 Express database on the same machine using ASP.NET pages, but I'm having difficulty getting the pages to make a connection. I'm new to ASP.NET and I'm probably making some totally elemental mistake. I'd appreciate any assistance anyone can offer. I have pasted in part of the codebehind file for a web form (asterisking out the database name) and the error report that appears in the browser when I call the page.using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Data.SqlClient;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;namespace WebApplication2{ /// <summary> /// Summary description for WebForm1. /// </summary> public class WebForm1 : System.Web.UI.Page { private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here string strConnection="Integrated Security=SSPI;Persist Security Info=False;"; strConnection +="initial catalog = ******;server=WILL-000993DB49\SQLEXPRESS;"; SqlConnection objConnection = new SqlConnection(strConnection); objConnection.Open(); objConnection.Close(); } #region Web Form Designer generated code override protected void OnInit(EventArgs e) { // // CODEGEN: This call is required by the ASP.NET Web Form Designer. // InitializeComponent(); base.OnInit(e); } /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.Load += new System.EventHandler(this.Page_Load); } #endregion }} Server Error in '/WebApplication2' Application.
Cannot open database "******" requested by the login. The login failed.Login failed for user 'WILL-000993DB49ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database "******" requested by the login. The login failed.Login failed for user 'WILL-000993DB49ASPNET'.
Source Error:
Line 24: strConnection +="initial catalog = ******;server=WILL-000993DB49\SQLEXPRESS;";Line 25: SqlConnection objConnection = new SqlConnection(strConnection);Line 26: objConnection.Open();Line 27: objConnection.Close();Line 28:
Hi I have Visual Studio 2005 with SP1 installed, and I want to install the Management Studio. I tried many times installing that and I always got the same problem, which is when I try to create a database in VS I just don’t get trough as I used to. A message appears saying that I’ve to enable some estance. So to resolve the problem I saw if is everything ok with the SQL Server, which seemed to be fine, but I couldn’t start the Report service. Now I just formatted the computer and I’m afraid to happen all over again. May be the version with only the Management would be fine, I don’t know if it adds something beside of that.
Hi All, I have just installed Microsoft SQL Server Management Studio Express.. Once I did this first it was working fine, but now their is this error each time I try to connect the object explorer.. the error is as follows :-Could not load file or assembly 'System.Data, Version=2.0.0.0, Culture=neutral publickeyToken=b77a5c561934e089' or one of its dependencies. Signature specified is zero-sized. (Exception from HRESULT: 0x80131237). Could anybody help me with getting rid of this error. I have no clue what to do?
Hi there, i have sometimes trouble to write data to a table in a sql server expr. database.
i have a vb.net application that writes every 2 minutes data to a table. sometimes (no regulary phenomen) the error appears after some hours, sometimes after some days. then i cannot write data in the table. it seems that the database sleeps or is offline.
before i write the data i check if the connection is open and i can write data. if i cannot write the data i try several times and often after the third try i can write the data.
i have checked everything (no power save's on or other power off modes)
i have also test it with SqlClient.SqlConnection.ClearAllPools()
and many other things to find the bug, but no success at the moment.
it seems that the database or the table is away ?? or sleeps for some seconds ?!? i have no idea.
