SQL Server 2005's Native Web Services
Mar 23, 2006Are SQL Server 2005's native Web services available in SQL Server 2005 Express Edition?
Thanks.
ADVERTISEMENT
Native Oracle SQL -&&> SQL Server 2005 CE .sdf File -&&> Using Visual Studio 2005?
May 23, 2007I've got a table adapter that connects using an oracle data connector. In the adapter, I'm using native oracle SQL such as:
select TO_DATE(SUBSTR(TO_CHAR(weird_oracle_field),0,12),'YYYYMMDDHH24MI') as dt_added from oracle_data_table
There's also a CASE statement in there with some other data transformations.
Anyway, I want to take the results of that Oracle query and put the dataset into a SQL Server Compact Edition database - within an application that I'm creating in Visual Studio 2005.
For whatever reason, I can't seem to do anything like that in 'bulk' and there aren't any data migration tools that work with anything other than "full" SQL Server versions. My client doesn't support SQL Server, but I can deploy my app with SQL CE. I need a 'local' copy of the database (for several reasons) and just can't seem to figure out how to make this work.
I'm really going nuts. I feel like I'm soooo close when I see the data I want in the table adapter - but I can't seem to actually *move* the data over!!
Can anyone help?
thanks,
Jon
SQL Server Admin 2014 :: Installation With Reporting Services - Native Errors
Jul 19, 2015When I try to install sql server 2014 on my machine,all the features were installed but except Reporting services-Native and error occurred as shown below.
Error details:
§ Error installing SQL Server Reporting Services
Updating permission setting for folder 'C:WindowsTemp' failed. The folder permission setting were supposed to be set to 'DA;OICI;0x1200af;;;S-1-5-80-4063824523-3130906261-2263067808-2545249320-213050741)'.
Error code: 0x84CF0003
SQL Server 2005 Native Client...
Jun 19, 2007Do I need to install SQL Server 2005 Native client drivers on the servers that contain applications that make connections to the new SS2005 db server? My understanding is that this driver is backward compatible with SS 2000... Can I have both installed on the same server, and then create and ODBC driver for either?
Thank-Dave
?? SQL Server 2005 Express SP2 Install Fails On Native Client ??
Jun 11, 2007Hello all,
I'm trying to install "SQL Server 2005 Express Edition SP2" on a newly installed XP Pro SP2 machine. I downloaded "SQLEXPR32.EXE" (38,220,656 bytes) from the Microsoft site.
At the beginning of the setup the installation program scans my system -- no problems or warnings. Everything looks fine and ready to go.
During installation I uncheck, "Hide advanced configuration options" simply because I want to change the default instance name. Aside from changing the default instance name I make no other changes to the default installation configuration.
The installation begins but when it tries to comes to the "SQL Native Client" portion of the installation I get the following error dialog message:
"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'."
Below I've included the setup log file of the SQL Native Client portion of the setup. I've looked through the log file but didn't see anything obviously wrong until the error occurs toward the end.
Does anyone have an idea of what might be causing this to happen? I've install SSE many times in the past with no problems.
Thanks
Code Snippet
=== Verbose logging started: 6/10/2007 23:03:13 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (C0:8C) [23:03:13:093]: Resetting cached policy values
MSI (c) (C0:8C) [23:03:13:093]: Machine policy value 'Debug' is 0
MSI (c) (C0:8C) [23:03:13:093]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (c) (C0:8C) [23:03:13:093]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (C0:8C) [23:03:13:093]: Grabbed execution mutex.
MSI (c) (C0:8C) [23:03:13:093]: Cloaking enabled.
MSI (c) (C0:8C) [23:03:13:093]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (C0:8C) [23:03:13:093]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (D0:94) [23:03:13:109]: Grabbed execution mutex.
MSI (s) (D0:B4) [23:03:13:109]: Resetting cached policy values
MSI (s) (D0:B4) [23:03:13:109]: Machine policy value 'Debug' is 0
MSI (s) (D0:B4) [23:03:13:109]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (s) (D0:B4) [23:03:13:109]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (D0:B4) [23:03:13:109]: End dialog not enabled
MSI (s) (D0:B4) [23:03:13:109]: Original package ==> C:WINDOWSInstaller1d32b7a.msi
MSI (s) (D0:B4) [23:03:13:109]: Package we're running from ==> C:WINDOWSInstaller1d32b7a.msi
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'.
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (D0:B4) [23:03:13:125]: MSCOREE already loaded, using loaded copy
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisablePatch' is 0
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'.
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (D0:B4) [23:03:13:125]: Transforms are not secure.
MSI (s) (D0:B4) [23:03:13:125]: Command Line: STPSETUPTHREADID=2000 STPSETUPPROCESSID=1472 EXTERNALCONTROL=1 ADDLOCAL=ALL SKIPPENDINGREBOOTCHECK=1 APPGUID={2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=1472
MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{8225F098-4183-422F-B208-3018904DFA0C}'.
MSI (s) (D0:B4) [23:03:13:125]: Product Code passed to Engine.Initialize: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'
MSI (s) (D0:B4) [23:03:13:125]: Product Code from property table before transforms: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'
MSI (s) (D0:B4) [23:03:13:125]: Product Code from property table after transforms: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'
MSI (s) (D0:B4) [23:03:13:125]: Product registered: entering maintenance mode
MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding ProductState property. Its value is '5'.
MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding ProductToBeRegistered property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:125]: Package name retrieved from configuration data: 'sqlncli.msi'
MSI (s) (D0:B4) [23:03:13:125]: Determined that existing product (either this product or the product being upgraded with a patch) is installed per-machine.
MSI (s) (D0:B4) [23:03:13:140]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (D0:B4) [23:03:13:140]: Machine policy value 'DisableMsi' is 0
MSI (s) (D0:B4) [23:03:13:140]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:140]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:140]: Product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} is admin assigned: LocalSystem owns the publish key.
MSI (s) (D0:B4) [23:03:13:140]: Product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} is managed.
MSI (s) (D0:B4) [23:03:13:140]: Running product '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}' with elevated privileges: Product is assigned.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '2000'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '1472'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding SKIPPENDINGREBOOTCHECK property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding APPGUID property. Its value is '{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '1472'.
MSI (s) (D0:B4) [23:03:13:140]: TRANSFORMS property is now:
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding PRODUCTLANGUAGE property. Its value is '1033'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '301'.
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoApplication Data
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoFavorites
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoNetHood
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoMy Documents
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoPrintHood
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoRecent
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoSendTo
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoTemplates
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoLocal SettingsApplication Data
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoMy DocumentsMy Pictures
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersDesktop
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuProgramsAdministrative Tools
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuProgramsStartup
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuPrograms
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart Menu
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoDesktop
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersTemplates
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:WINDOWSFonts
MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Tony'.
MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Installed property. Its value is '00:00:00'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller1d32b7a.msi'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'C:WINDOWSInstaller1d32b7a.msi'.
MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:13:187]: Machine policy value 'DisableRollback' is 0
MSI (s) (D0:B4) [23:03:13:187]: User policy value 'DisableRollback' is 0
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'.
=== Logging started: 6/10/2007 23:03:13 ===
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (s) (D0:B4) [23:03:13:187]: Doing action: INSTALL
MSI (s) (D0:B4) [23:03:13:187]: Running ExecuteSequence
MSI (s) (D0:B4) [23:03:13:187]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action start 23:03:13: INSTALL.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 23:03:13: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action ended 23:03:13: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 23:03:13: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 23:03:13: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 23:03:13: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 23:03:13: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 23:03:13: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: LaunchConditions
Action ended 23:03:13: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
Action start 23:03:13: LaunchConditions.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: FindRelatedProducts
Action ended 23:03:13: LaunchConditions. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: Skipping FindRelatedProducts action: not run in maintenance mode
Action start 23:03:13: FindRelatedProducts.
MSI (s) (D0:B4) [23:03:13:203]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false)
MSI (s) (D0:B4) [23:03:13:203]: Skipping action: CA_SetRefCountNewerFoundFlag (condition is false)
MSI (s) (D0:B4) [23:03:13:203]: Doing action: IsPendingRebootKey
Action ended 23:03:13: FindRelatedProducts. Return value 0.
MSI (s) (D0:44) [23:03:13:218]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIA9.tmp, Entrypoint: IsPendingReboot
MSI (s) (D0:3C) [23:03:13:218]: Generating random cookie.
MSI (s) (D0:3C) [23:03:13:234]: Created Custom Action Server with PID 2372 (0x944).
MSI (s) (D0:70) [23:03:13:312]: Running as a service.
MSI (s) (D0:70) [23:03:13:328]: Hello, I'm your 32bit Impersonated custom action server.
Action start 23:03:13: IsPendingRebootKey.
No PendingFileRenameOperations
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: CA_ErrorDifferentLang (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOW (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWAppendCustomPath (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH_ADD (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_ValidateAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RefCountAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_BackupAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RegisterAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RestoreAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Doing action: AppSearch
Action ended 23:03:13: IsPendingRebootKey. Return value 1.
Action start 23:03:13: AppSearch.
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding REDISTINSTALLEDVERSION property. Its value is '9.00.3042.00'.
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: SkipInstallCA (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: CA_ErrorPendingReboot (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: CCPSearch (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: RMCCPSearch (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Doing action: ValidateProductID
Action ended 23:03:13: AppSearch. Return value 1.
Action start 23:03:13: ValidateProductID.
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: Sqlmsirc_CheckLanguage.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Doing action: CostInitialize
Action ended 23:03:13: ValidateProductID. Return value 1.
MSI (s) (D0:B4) [23:03:13:359]: Machine policy value 'MaxPatchCacheSize' is 10
Action start 23:03:13: CostInitialize.
MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'D:'.
MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: MsiPatchHeaders
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: __MsiPatchFileList
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2228 2: 3: PatchPackage 4: SELECT `DiskId`, `PatchId`, `LastSequence` FROM `Media`, `PatchPackage` WHERE `Media`.`DiskId`=`PatchPackage`.`Media_` ORDER BY `DiskId`
MSI (s) (D0:B4) [23:03:13:359]: Doing action: FileCost
Action ended 23:03:13: CostInitialize. Return value 1.
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 23:03:13: FileCost.
MSI (s) (D0:B4) [23:03:13:359]: Doing action: IsolateComponents
Action ended 23:03:13: FileCost. Return value 1.
Action start 23:03:13: IsolateComponents.
MSI (s) (D0:B4) [23:03:13:375]: Doing action: CostFinalize
Action ended 23:03:13: IsolateComponents. Return value 0.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its value is 'C:Program FilesMicrosoft SQL Server90EULA'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying SystemFolder property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'C:WINDOWSsystem32'.
MSI (s) (D0:B4) [23:03:13:375]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:13:375]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'D:'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying SystemFolder property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'C:WINDOWSsystem32'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSINSTALLDIR property. Its value is 'C:Program FilesMicrosoft Visual Studio 8'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSINSTALLROOT property. Its value is 'C:Program FilesMicrosoft Visual Studio 8'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlShared property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding Ver.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDK.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDK'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDKLib.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKLib'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDKLibPlatformTarget.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKLibx86'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlInclude.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKInclude'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding Ver90.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its value is 'C:Program FilesMicrosoft SQL Server90'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its current value is 'C:Program FilesMicrosoft SQL Server90EULA'. Its new value: 'C:Program FilesMicrosoft SQL Server90EULA'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlVer property. Its value is 'C:Program FilesMicrosoft SQL Server90'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlTools property. Its value is 'C:Program FilesMicrosoft SQL Server90Tools'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlToolsBin property. Its value is 'C:Program FilesMicrosoft SQL Server90ToolsBinn'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxs'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsManifests'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPolicies'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxs'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPolicies'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsManifests'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSRetarget property. Its value is 'C:Program FilesMicrosoft SQL Server90ToolsBinn'.
MSI (s) (D0:B4) [23:03:13:375]: Target path resolution complete. Dumping Directory table...
MSI (s) (D0:B4) [23:03:13:375]: Note: target paths subject to change (via custom actions or browsing)
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: TARGETDIR , Object: D:
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder , Object: C:WINDOWS
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder , Object: C:WINDOWSsystem32
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: ProgramFilesFolder , Object: C:Program Files
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSINSTALLDIR , Object: C:Program FilesMicrosoft Visual Studio 8
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSINSTALLROOT , Object: C:Program FilesMicrosoft Visual Studio 8
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlShared , Object: C:Program FilesMicrosoft SQL Server
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: Ver.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDK.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDK
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDKLib.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKLib
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDKLibPlatformTarget.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKLibx86
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlInclude.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKInclude
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: Ver90.84118FFB_F307_45F3_B5BC_3A4F8261108D , Object: C:Program FilesMicrosoft SQL Server90
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D , Object: C:Program FilesMicrosoft SQL Server90EULA
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: INSTALLSQLSHAREDDIR , Object: C:Program FilesMicrosoft SQL Server
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlVer , Object: C:Program FilesMicrosoft SQL Server90
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlTools , Object: C:Program FilesMicrosoft SQL Server90Tools
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlToolsBin , Object: C:Program FilesMicrosoft SQL Server90ToolsBinn
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWS
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSsystem32
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxs
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsManifests
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPolicies
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWS
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSsystem32
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxs
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPolicies
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsManifests
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSRetarget , Object: C:Program FilesMicrosoft SQL Server90ToolsBinn
Action start 23:03:13: CostFinalize.
MSI (s) (D0:B4) [23:03:13:375]: Doing action: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD
Action ended 23:03:13: CostFinalize. Return value 1.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding ARPINSTALLLOCATION property. Its value is 'C:WINDOWSsystem32'.
Action start 23:03:13: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD.
MSI (s) (D0:B4) [23:03:13:375]: Doing action: IsDotNet20Installed
Action ended 23:03:13: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD. Return value 1.
MSI (s) (D0:50) [23:03:13:390]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAA.tmp, Entrypoint: IsDotNetFramework20Installed
Action start 23:03:13: IsDotNet20Installed.
Feature SQL_SNAC_CORE install action does not match 2.
Not all features are being removed.
MSI (s) (D0!90) [23:03:13:421]: PROPERTY CHANGE: Deleting EnableDotNetCheck property. Its current value is '0'.
MSI (s) (D0!90) [23:03:13:421]: PROPERTY CHANGE: Adding DOTNETCOREPATH property. Its value is '1'.
Either there are no .NET Framework assemblies present in MsiAssembly table or they do not require the GAC, no need to check for the .NET Framework
MSI (s) (D0:B4) [23:03:13:421]: Skipping action: CA_ErrorPrereqDotNet (condition is false)
MSI (s) (D0:B4) [23:03:13:421]: Skipping action: CA_SetARPINSTALLLOCATION (condition is false)
MSI (s) (D0:B4) [23:03:13:421]: Doing action: SetODBCFolders
Action ended 23:03:13: IsDotNet20Installed. Return value 1.
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ODBCDriver
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2228 2: 3: ODBCDriver 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCDriver`, `Component` WHERE `ODBCDriver`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ODBCTranslator
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2228 2: 3: ODBCTranslator 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCTranslator`, `Component` WHERE `ODBCTranslator`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
Action start 23:03:13: SetODBCFolders.
MSI (s) (D0:B4) [23:03:13:421]: Doing action: MigrateFeatureStates
Action ended 23:03:13: SetODBCFolders. Return value 0.
MSI (s) (D0:B4) [23:03:13:421]: Skipping MigrateFeatureStates action: not run in maintenance mode
Action start 23:03:13: MigrateFeatureStates.
MSI (s) (D0:B4) [23:03:13:421]: Doing action: InstallValidate
Action ended 23:03:13: MigrateFeatureStates. Return value 0.
MSI (s) (D0:B4) [23:03:13:421]: Feature: SQL_SNAC_CORE; Installed: Local; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Feature: SQL_SNAC_SDK; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: RedistVersionReg.C3E5819B-5744-41E9-BEF2-12652D7B9053; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: Redist_Uninstall_RegKey.E63C6774-A4E8-4A1A-A090-567FE0DA2FBF; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: License_SQLNCLI_ENU.txt.84118FFB_F307_45F3_B5BC_3A4F8261108D; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.dll.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: RedistQFEKey.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlnclir.rll.A0C5BB09_6818_43E8_AF1C_A1C3C70B210C; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.chm.A0C5BB09_6818_43E8_AF1C_A1C3C70B210C; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: msmd.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: oledbdm.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: srv.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.lib.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: opends60.lib.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: __uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __Redist_Uninstall_RegKey.E63C6774-A4E8-4A65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __RedistVersionReg.C3E5819B-5744-41E9-BEF265; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __RedistQFEKey.9B634CFE_9A39_4508_9CA8_D8D65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __sqlncli.dll.9B634CFE_9A39_4508_9CA8_D8DE65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __sqlnclir.rll.A0C5BB09_6818_43E8_AF1C_A1C65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_payload.98CB24AD_52FB_DB5F_FF165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_manifest.98CB24AD_52FB_DB5F_FF65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_manifest.63E949F6_03BC_5C40_FF65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: BindImage
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: Class 3: -2147287038
Action start 23:03:13: InstallValidate.
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: _RemoveFilePath
MSI (s) (D0:B4) [23:03:13:437]: PROPERTY CHANGE: Modifying CostingComplete property. Its current value is '0'. Its new value: '1'.
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: BindImage
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2727 2:
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2727 2:
MSI (s) (D0:B4) [23:03:13:437]: Doing action: InstallInitialize
Action ended 23:03:13: InstallValidate. Return value 1.
MSI (s) (D0:B4) [23:03:13:437]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:437]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:437]: BeginTransaction: Locking Server
MSI (s) (D0:B4) [23:03:13:437]: SRSetRestorePoint skipped for this transaction.
MSI (s) (D0:B4) [23:03:13:437]: Server not locked: locking for product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
Action start 23:03:13: InstallInitialize.
MSI (s) (D0:B4) [23:03:13:859]: Doing action: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1
Action ended 23:03:13: InstallInitialize. Return value 1.
MSI (s) (D0:70) [23:03:13:875]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAB.tmp, Entrypoint: Sqlmsirc_ValidateAppGuid
Action start 23:03:13: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1.
<Func Name='Sqlmsirc_ValidateAppGuid'>
<EndFunc Name='Sqlmsirc_ValidateAppGuid' Return='0' GetLastError='0'>
MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_RefCountAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_BackupAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_CheckAppDependency.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:890]: Doing action: SxsInstallCA
Action ended 23:03:13: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1. Return value 1.
MSI (s) (D0:88) [23:03:13:906]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAC.tmp, Entrypoint: CustomAction_SxsMsmInstall
Action start 23:03:13: SxsInstallCA.
1: sxsdelca 2: traceop 3: 1262 4: 0
1: sxsdelca 2: traceop 3: 1263 4: 0
1: sxsdelca 2: traceop 3: 1264 4: 0
1: sxsdelca 2: traceop 3: 1269 4: 0
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 259
1: sxsdelca 2: SxsMsmInstall completed 3: 0 4: 0
MSI (s) (D0:B4) [23:03:14:000]: Skipping action: AllocateRegistrySpace (condition is false)
MSI (s) (D0:B4) [23:03:14:000]: Doing action: ProcessComponents
Action ended 23:03:14: SxsInstallCA. Return value 1.
Action start 23:03:14: ProcessComponents.
MSI (s) (D0:B4) [23:03:14:000]: Doing action: UnpublishComponents
Action ended 23:03:14: ProcessComponents. Return value 1.
MSI (s) (D0:B4) [23:03:14:000]: Note: 1: 2262 2: PublishComponent 3: -2147287038
Action start 23:03:14: UnpublishComponents.
MSI (s) (D0:B4) [23:03:14:000]: Doing action: MsiUnpublishAssemblies
Action ended 23:03:14: UnpublishComponents. Return value 1.
Action start 23:03:14: MsiUnpublishAssemblies.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnpublishFeatures
Action ended 23:03:14: MsiUnpublishAssemblies. Return value 1.
Action start 23:03:14: UnpublishFeatures.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: StopServices
Action ended 23:03:14: UnpublishFeatures. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: ServiceControl 3: -2147287038
Action start 23:03:14: StopServices.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: DeleteServices
Action ended 23:03:14: StopServices. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: ServiceControl 3: -2147287038
Action start 23:03:14: DeleteServices.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterComPlus
Action ended 23:03:14: DeleteServices. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: Complus
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: Complus 4: SELECT `ComponentId`, `FileName`, `Component`.`Directory_`, `ExpType`, `Component`.`Action`, `Component`.`Installed` FROM `Complus`, `Component`, `File` WHERE `Complus`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND `Action` = 0
Action start 23:03:14: UnregisterComPlus.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: SelfUnregModules
Action ended 23:03:14: UnregisterComPlus. Return value 0.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: SelfReg 4: Select `File`.`FileName`,`Component`.`Directory_`,`Component`.`Installed`, `File`.`Component_`,`SelfReg`.`File_` From `SelfReg`, `File`, `Component` Where `SelfReg`.`File_` = `File`.`File` And `File`.`Component_` = `Component`.`Component` And `Component`.`Action` = 0
Action start 23:03:14: SelfUnregModules.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterTypeLibraries
Action ended 23:03:14: SelfUnregModules. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 23:03:14: UnregisterTypeLibraries.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterFonts
Action ended 23:03:14: UnregisterTypeLibraries. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: Font 4: SELECT `FontTitle`, `FileName`, `Directory_`, `Installed`From `Font`, `FileAction` Where `Font`.`File_` = `FileAction`.`File` And `FileAction`.`Action` = 0 ORDER BY `FileAction`.`Directory_`
Action start 23:03:14: UnregisterFonts.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: RemoveRegistryValues
Action ended 23:03:14: UnregisterFonts. Return value 1.
Action start 23:03:14: RemoveRegistryValues.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterClassInfo
Action ended 23:03:14: RemoveRegistryValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2262 2: Class 3: -2147287038
Action start 23:03:14: UnregisterClassInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterExtensionInfo
Action ended 23:03:14: UnregisterClassInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2262 2: Extension 3: -2147287038
Action start 23:03:14: UnregisterExtensionInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterProgIdInfo
Action ended 23:03:14: UnregisterExtensionInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: ProgId 4: SELECT DISTINCT `BinaryType`, `ProgId`, `Class_`, `ProgId`.`Description`, `ProgId`.`Icon_`, `ProgId`.`IconIndex`, null, `Component`.`RuntimeFlags` , `Component`.`Component` FROM `ProgId`, `Class`, `Feature`, `Component` WHERE `ProgId`.`Class_` = `Class`.`CLSID` AND `Class`.`Feature_` = `Feature` AND `Class`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)))
Action start 23:03:14: UnregisterProgIdInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterMIMEInfo
Action ended 23:03:14: UnregisterProgIdInfo. Return value 0.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: MIME
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: MIME 4: SELECT `BinaryType`, `ContentType`, `Extension`.`Extension`, `MIME`.`CLSID`, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `MIME`, `Extension`, `Feature`, `Component` WHERE `MIME`.`Extension_` = `Extension`.`Extension` AND `Feature_` = `Feature` AND `Extension`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)))
Action start 23:03:14: UnregisterMIMEInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveIniValues
Action ended 23:03:14: UnregisterMIMEInfo. Return value 0.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: IniFile
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: IniFile 4: SELECT `FileName`,`IniFile`.`DirProperty`,`Section`,`IniFile`.`Key`,`IniFile`.`Value`,`IniFile`.`Action` FROM `IniFile`, `Component` WHERE `Component`=`Component_` AND `Component`.`Action`=0 ORDER BY `FileName`,`Section`
Action start 23:03:14: RemoveIniValues.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveShortcuts
Action ended 23:03:14: RemoveIniValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: Shortcut 4: SELECT `Name`, null, `Shortcut`.`Directory_`, `Component`.`RuntimeFlags`, `Feature`.`Action`, `Component`.`Action` From `Shortcut`, `Feature`, `Component` WHERE `Target` = `Feature` AND `Shortcut`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)))
Action start 23:03:14: RemoveShortcuts.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveEnvironmentStrings
Action ended 23:03:14: RemoveShortcuts. Return value 0.
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: Environment
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: Environment 4: SELECT `Name`,`Value` FROM `Environment`,`Component` WHERE `Component_`=`Component` AND (`Component`.`Action` = 0)
Action start 23:03:14: RemoveEnvironmentStrings.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveDuplicateFiles
Action ended 23:03:14: RemoveEnvironmentStrings. Return value 1.
Action start 23:03:14: RemoveDuplicateFiles.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveFiles
Action ended 23:03:14: RemoveDuplicateFiles. Return value 1.
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: RemoveFile
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: RemoveFile
Action start 23:03:14: RemoveFiles.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveFolders
Action ended 23:03:14: RemoveFiles. Return value 0.
Action start 23:03:14: RemoveFolders.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: CreateFolders
Action ended 23:03:14: RemoveFolders. Return value 0.
Action start 23:03:14: CreateFolders.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: MoveFiles
Action ended 23:03:14: CreateFolders. Return value 0.
Action start 23:03:14: MoveFiles.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: InstallFiles
Action ended 23:03:14: MoveFiles. Return value 1.
Action start 23:03:14: InstallFiles.
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: Patch 4: SELECT `Patch`.`File_`, `Patch`.`Header`, `Patch`.`Attributes`, `Patch`.`Sequence`, `Patch`.`StreamRef_` FROM `Patch` WHERE `Patch`.`File_` = ? AND `Patch`.`#_MsiActive`=? ORDER BY `Patch`.`Sequence`
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: MsiPatchHeaders
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: MsiPatchHeaders 4: SELECT `Header` FROM `MsiPatchHeaders` WHERE `StreamRef` = ?
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:14:062]: Doing action: DuplicateFiles
Action ended 23:03:14: InstallFiles. Return value 1.
Action start 23:03:14: DuplicateFiles.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: PatchFiles
Action ended 23:03:14: DuplicateFiles. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2228 2: 3: Patch 4: SELECT `File`,`FileName`,`FileSize`,`Directory_`,`PatchSize`,`File`.`Attributes`,`Patch`.`Attributes`,`Patch`.`Sequence`,`Component`.`Component`,`Component`.`ComponentId` FROM `File`,`Component`,`Patch` WHERE `Patch`.`#_MsiActive`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence`
Action start 23:03:14: PatchFiles.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: BindImage
Action ended 23:03:14: PatchFiles. Return value 0.
Action start 23:03:14: BindImage.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterClassInfo
Action ended 23:03:14: BindImage. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2262 2: Class 3: -2147287038
Action start 23:03:14: RegisterClassInfo.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterExtensionInfo
Action ended 23:03:14: RegisterClassInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2262 2: Extension 3: -2147287038
Action start 23:03:14: RegisterExtensionInfo.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterProgIdInfo
Action ended 23:03:14: RegisterExtensionInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2228 2: 3: ProgId 4: SELECT DISTINCT `BinaryType`, `ProgId`, `Class_`, `ProgId`.`Description`, `ProgId`.`Icon_`, `ProgId`.`IconIndex`, null, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `ProgId`, `Class`, `Feature`, `Component` WHERE `ProgId`.`Class_` = `Class`.`CLSID` AND `Class`.`Feature_` = `Feature` AND `Class`.`Component_` = `Component` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND ((`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4))))
Action start 23:03:14: RegisterProgIdInfo.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterMIMEInfo
Action ended 23:03:14: RegisterProgIdInfo. Return value 0.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: MIME
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: MIME 4: SELECT `BinaryType`, `ContentType`, `Extension`.`Extension`, `MIME`.`CLSID`, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `MIME`, `Extension`, `Feature`, `Component` WHERE `MIME`.`Extension_` = `Extension`.`Extension` AND `Feature_` = `Feature` AND `Extension`.`Component_` = `Component` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND ((`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4))))
Action start 23:03:14: RegisterMIMEInfo.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteRegistryValues
Action ended 23:03:14: RegisterMIMEInfo. Return value 0.
Action start 23:03:14: WriteRegistryValues.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteIniValues
Action ended 23:03:14: WriteRegistryValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: IniFile
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: IniFile 4: SELECT `FileName`,`IniFile`.`DirProperty`,`Section`,`IniFile`.`Key`,`IniFile`.`Value`,`IniFile`.`Action` FROM `IniFile`, `Component` WHERE `Component`=`Component_` AND (`Component`.`Action`=1 OR `Component`.`Action`=2) ORDER BY `FileName`,`Section`
Action start 23:03:14: WriteIniValues.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteEnvironmentStrings
Action ended 23:03:14: WriteIniValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: Environment
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: Environment 4: SELECT `Name`,`Value` FROM `Environment`,`Component` WHERE `Component_`=`Component` AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2)
Action start 23:03:14: WriteEnvironmentStrings.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterFonts
Action ended 23:03:14: WriteEnvironmentStrings. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: Font 4: SELECT `FontTitle`, `FileName`, `Directory_`, `Action` From `Font`, `FileAction` Where `Font`.`File_` = `FileAction`.`File` And (`FileAction`.`Action` = 1 Or `FileAction`.`Action` = 2) ORDER BY `FileAction`.`Directory_`
Action start 23:03:14: RegisterFonts.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterTypeLibraries
Action ended 23:03:14: RegisterFonts. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 23:03:14: RegisterTypeLibraries.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: SelfRegModules
Action ended 23:03:14: RegisterTypeLibraries. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: SelfReg 4: Select `FileAction`.`FileName`,`FileAction`.`Directory_`,`FileAction`.`Action`, `FileAction`.`Component_`,`SelfReg`.`File_` From `SelfReg`, `FileAction` Where `SelfReg`.`File_` = `FileAction`.`File` And (`FileAction`.`Action` = 1 OR `FileAction`.`Action` = 2)
Action start 23:03:14: SelfRegModules.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterComPlus
Action ended 23:03:14: SelfRegModules. Return value 1.
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2205 2: 3: Complus
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2228 2: 3: Complus 4: SELECT `ComponentId`, `FileName`, `Component`.`Directory_`, `ExpType`, `Component`.`Action`, `Component`.`Installed` FROM `Complus`, `Component`, `File` WHERE `Complus`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND (`Action` = 1 OR `Action` = 2)
Action start 23:03:14: RegisterComPlus.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: InstallServices
Action ended 23:03:14: RegisterComPlus. Return value 0.
MSI (s) (D0:B4) [23:03:14:093]: Detected older ServiceInstall table schema
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2205 2: 3: ServiceInstall
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2228 2: 3: ServiceInstall 4: SELECT `Name`,`DisplayName`,`ServiceType`,`StartType`,`ErrorControl`,`LoadOrderGroup`,`Dependencies`,`StartName`,`Password`,`ComponentId`,`Directory_`,`FileName`,`Arguments` FROM `ServiceInstall`, `Component`, `File` WHERE `ServiceInstall`.`Component_` = `Component`.`Component` AND (`Component`.`KeyPath` = `File`.`File`) AND (`Action` = 1 OR `Action` = 2)
Action start 23:03:14: InstallServices.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: StartServices
Action ended 23:03:14: InstallServices. Return value 1.
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2262 2: ServiceControl 3: -2147287038
Action start 23:03:14: StartServices.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: RegisterUser
Action ended 23:03:14: StartServices. Return value 1.
Action start 23:03:14: RegisterUser.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: RegisterProduct
Action ended 23:03:14: RegisterUser. Return value 0.
Action start 23:03:14: RegisterProduct.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: PublishComponents
Action ended 23:03:14: RegisterProduct. Return value 1.
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2262 2: PublishComponent 3: -2147287038
Action start 23:03:14: PublishComponents.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: MsiPublishAssemblies
Action ended 23:03:14: PublishComponents. Return value 1.
Action start 23:03:14: MsiPublishAssemblies.
MSI (s) (D0:B4) [23:03:14:109]: Doing action: PublishFeatures
Action ended 23:03:14: MsiPublishAssemblies. Return value 1.
Action start 23:03:14: PublishFeatures.
MSI (s) (D0:B4) [23:03:14:109]: Doing action: PublishProduct
Action ended 23:03:14: PublishFeatures. Return value 1.
Action start 23:03:14: PublishProduct.
MSI (s) (D0:B4) [23:03:14:109]: Doing action: CreateShortcuts
Action ended 23:03:14: PublishProduct. Return value 1.
MSI (s) (D0:B4) [23:03:14:109]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:14:109]: Note: 1: 2228 2: 3: Shortcut 4: SELECT `Name`, `FileName`, `Component`.`Directory_`, `Arguments`, `WkDir`, `Icon_`, `IconIndex`, `Hotkey`, `ShowCmd`, `Shortcut`.`Description`, `Shortcut`.`Directory_`, `Component`.`RuntimeFlags`, `Component`.`Action`, `Target`, `ComponentId`, `Feature`.`Action`, `Component`.`Installed` From `Shortcut`, `Feature`, `Component`, `File` WHERE `Target` = `Feature` AND `Shortcut`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)))
Action start 23:03:14: CreateShortcuts.
MSI (s) (D0:B4) [23:03:14:109]: Skipping action: SNAC_SetClientSSNLDefaults.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD (condition is false)
MSI (s) (D0:B4) [23:03:14:109]: Doing action: InstallFinalize
Action ended 23:03:14: CreateShortcuts. Return value 0.
MSI (s) (D0:B4) [23:03:14:109]: Running Script: C:WINDOWSInstallerMSIAD.tmp
MSI (s) (D0:B4) [23:03:14:109]: PROPERTY CHANGE: Adding UpdateStarted property. Its value is '1'.
MSI (s) (D0:B4) [23:03:14:109]: Machine policy value 'DisableRollback' is 0
MSI (s) (D0:B4) [23:03:14:125]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionInstallerRollbackScripts 3: 2
MSI (s) (D0:B4) [23:03:14:125]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=919255143,LangId=1033,Platform=0,ScriptType=1,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
Action start 23:03:14: InstallFinalize.
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ProductInfo(ProductKey={F9B3DD02-B0B3-42E9-8650-030DFF0D133D},ProductName=Microsoft SQL Server Native Client,PackageName=sqlncli.msi,Language=1033,Version=150997986,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIco,,PackageCode={8225F098-4183-422F-B208-3018904DFA0C},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server Native Client)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (D0:B4) [23:03:14:125]: Executing op: SetBaseline(Baseline=0,)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: SetBaseline(Baseline=1,)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ProgressTotal(Total=6,Type=1,ByteEquivalent=24000)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ComponentRegister(ComponentId={B26AC90F-A196-4D67-A57D-FE81C9202A2C},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludemsmd.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={9E91B830-1D04-4B78-9244-ACA6C7790142},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludeoledbdm.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={A2F6B3E4-9050-4BD3-9C29-17E05509F383},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludesqlncli.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={7372B29A-8237-4C56-9E27-5DB074A8AD07},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludesrv.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={AD0B21CC-B175-4F95-B728-2B5C6C0B65CE},KeyPath=C:Program FilesMicrosoft SQL Server90SDKLibx86sqlncli.lib,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={EE67DC7C-00F8-40A3-A6EB-62F764614040},KeyPath=C:Program FilesMicrosoft SQL Server90SDKLibx86opends60.lib,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: ActionStart(Name=InstallFiles,Description=Copying new files,Template=File: [1], Directory: [9], Size: [6])
MSI (s) (D0:B4) [23:03:14:156]: Executing op: ProgressTotal(Total=193043,Type=0,ByteEquivalent=1)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: SetTargetFolder(Folder=C:Program FilesMicrosoft SQL Server90SDKInclude)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: SetSourceFolder(Folder=1PFilesMICROS~190SDKInclude|Program FilesMicrosoft SQL Server90SDKInclude)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: ChangeMedia(MediaVolumeLabel=SNAC,MediaPrompt=Please insert the disk: ,MediaCabinet=snac.cab,BytesPerTick=32768,CopierType=2,ModuleFileName=1sqlncli.msi,,,,,IsFirstPhysicalMedia=1)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: FileCopy(Source
Connect SQL Server 2005 With ODBC Drive “SQL Native Client
Sep 13, 2007
Hi,
When I'm using SQL server 2005, and ODBC drive €œSQL Native Client€? I get an error when executing the below given code. Error Message: €œTransaction cannot start because more than one ODBC connection is in use.€?
But this works well with SQL Server 2000 with ODBC drive "SQL Native Client" and in SQL server 2005 also when I used ODBC drive €œSQL Server€?.
I used aTrgConn.Execute(€œBegin Transaction€?) and it's working properly. But unfortunately I cannot use this method, because I want to run the same code with Oracle ODBC as well.
Is this a known issue in SQL Native client drive with SQL server 2005? Do you know a solution for this?
Please Help..............
Thanks in advance.
Code:
Dim aTrgConn As New ADODB.connection
Dim aCmdIns As New ADODB.Command
Dim aCmdUpd As New ADODB.Command
aTrgConn.Open sConnStr
Set aCmdIns.ActiveConnection = aTrgConn
Set aCmdUpd.ActiveConnection = aTrgConn
aTrgConn.BeginTrans
Unable To Install Native Client Components In SQL Server 2005 Enterprise Evaluation Version
Dec 14, 2007Hi all,
I have downloaded Microsoft SQL Server 2005 Enterprise Evaluation Edition ISO from the following site and burned it onto a DVD.
http://www.microsoft.com/downloads/details.aspx?FamilyId=6931FA7F-C094-49A2-A050-2D07993566EC&displaylang=en
Prior to this I have installed Visual Studio 2005 Professional Edtion. During setup I have selected all the native client components i.e. Management Studio, Business Intelligense Studio. But after the install I am not able to see them under All Programs-> Microsoft SQL Server 2005. On further searching I have come across this link
http://channel9.msdn.com/ShowPost.aspx?PostID=142941
First of all, there is no sqlrun_tools.msi under setup folder of the dvd. And also when I tried to change component from Add/Remove programs and following the instructions as specified on clicking Change Installed components all that I see are: Connectivity Components and Software Development kit.
Could someone tell me how can I install Management Studio/ Business Intelligence Studio seperately? I don't want to go through the process of re-installation.
Error 15002 Executing Sp_setapprole Statement Using The SQL Native Client Connected To SQL Server 2005
Oct 16, 2007Does anyone know if this is a SQL Native Client bug? I've read a previous thread (posted back on Jan. 18th, 2007) about this error, but there are no replies. I am getting this error when I issue the sp_setapprole command using sqlexecdirect() ODBC api call. Is there any way to work around this? Or is there a fix to the SQL Native Client? The error 15002 message text states "The procedure sys.sp_setapprole cannot be executed within a transaction". This is on a new connection so there should be no transactions active at the time. Thanks in advance for any info anyone can provide on this.
View 5 Replies View RelatedSOAP/Native XML Web Services
Apr 3, 2008Anyone have experience with using SOAP/Native XML Web Services in SQL Server 2005 to expose data to external web clients? Any issues/pitfalls?
-A
Integration Services :: Using 2008 Native Client 10.0 Provider To Connect 2012 DB?
Jul 9, 2015In our packages, we are using Microsoft SQL Server Native Client 10.0 provider to connect our SQL Server 2008 DBs, which is working fine till we are migrating 2008 DB server to 2012. after the upgrade, some of our packages are working fine, some are not. I'm just curiuos to know will the
old provider(Microsoft SQL Server Native Client 10.0) will work fine for connecting 2012 DBs? or I need to update all our packages to re-point to new 2012 Provider.
Reporting Services :: Can't Find Any Literature On The Native Mode SSRS Databases
Jun 15, 2015I can't find any literature on the native mode SSRS databases.
so something similar to the MSDB sys tables [URL] Is documentation non existent?
Reporting Services :: Create Dashboard With SSRS 2008 R2 Native Mode?
Jul 22, 2015We want to create interactive dashboards using SSRS 2008 R2. We currently has Report Server installed in Native mode. I see that we can build some good dashboards using SSRS, SharePoint 2010 and PerformancePoint. But I wanted to find out if we can build that level of dashboard using just SSRS. We are still convincing the management for getting SharePoint license. In case if they don't agree for the Sharepoint license, can we build some good dashboards just using SSRS?
View 5 Replies View RelatedNative SQL 2005 Driver For PHP Under Linux/Unix
Oct 16, 2007Hello!
I'm looking a native driver for SQL 2005 running under Linux/Unix!
Or Is accessible anywhere source code of the existing driver for php?
I tried FreeTDS, but it has some bugs and has no support.
Is there any good solution for this problem?
Thanks!
SQL Native Client 2005 Connect To Database Mirroring
Apr 7, 2008
Hi all,
i have a small problem to connect SQL Native ODBC Client to a mirrored Database.
The connection goes without any problem when I connect to a primary Database, but when i give this connect string to an
ODBC Client ""Server=Partner_A; Failover Partner=Partner_B; Database=XXX; Network=dbmssocn"", then i get an connect fail.
There are no firewalls and other things on the network.
I am also able to connect to a mirror database during failover, but I'm not able to set both servers on the ODBC Connection.
Kind Regards,
Gruna
Set Up Failed SQL Native Client &&<sqlncli.msi&&> - SQL 2005 Express
Dec 18, 2007I have .NET Framework 2.0 and Visual studio 2005 installed on my machine. I also have SQL Server 2000 Developer Edition installed with Service Pack 4.
When I try to install SQL Server 2005 express, I get an error when the setup tries to install SQL Native Client. I have read many forums, but couldnt find a resolution. I can not see SQL Native Client in my Add Remove Programs either.
I tried to unzip the SQLEXPR.exe into a temp folder and when I right click sqlncli.msi and say Repair or Uninstall. It says "This action is valid for products that are currently installed."
When i try to run the sqlncli.msi file ..i get an error message saying "Installation of Microsoft SQL Server Native Client failed because a higher version already exisits on the machine. To proceed uninstall the higher version and then run Microsoft SQL Server Native Client Setup"
Please help as I am unable to install SQL Server 2005 Express....
SQL Server Native Client -- Set up failed
SQL VSS Writer -- Set up failed
Database Services -- Set up failed
Thank you in advance
Log mesg -==
Verbose logging started: 12/17/2007 23:18:36 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: c:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (74:B4) [23:18:36:828]: Resetting cached policy values
MSI (c) (74:B4) [23:18:36:828]: Machine policy value 'Debug' is 0
MSI (c) (74:B4) [23:18:36:828]: ******* RunEngine:
******* Product: {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
******* Action:
******* CommandLine: **********
MSI (c) (74:B4) [23:18:36:828]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (74:B4) [23:18:36:828]: Grabbed execution mutex.
MSI (c) (74:B4) [23:18:36:828]: Cloaking enabled.
MSI (c) (74:B4) [23:18:36:828]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (74:B4) [23:18:36:828]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (100) [23:18:36:828]: Grabbed execution mutex.
MSI (s) (10:E0) [23:18:36:843]: Resetting cached policy values
MSI (s) (10:E0) [23:18:36:843]: Machine policy value 'Debug' is 0
MSI (s) (10:E0) [23:18:36:843]: ******* RunEngine:
******* Product: {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
******* Action:
******* CommandLine: **********
MSI (s) (10:E0) [23:18:36:843]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (10:E0) [23:18:36:843]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (10:E0) [23:18:36:843]: User policy value 'DisableMedia' is 0
MSI (s) (10:E0) [23:18:36:843]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Looking for sourcelist for product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Adding {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Now checking product {50A0893D-47D8-48E0-A7E8-44BCD7E4422E}
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Media is enabled for product.
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Processing net source list.
MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Processing media source list.
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Trying media source G:.
MSI (s) (10:E0) [23:18:36:843]: Note: 1: 2203 2: G:sqlncli.msi 3: -2147287038
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Processing URL source list.
MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1402 2: UNKNOWNURL 3: 2
MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1706 2: -2147483647 3: sqlncli.msi
MSI (s) (10:E0) [23:18:36:843]: Note: 1: 1706 2: 3: sqlncli.msi
MSI (s) (10:E0) [23:18:36:843]: SOURCEMGMT: Failed to resolve source
MSI (s) (10:E0) [23:18:36:843]: MainEngineThread is returning 1612
MSI (c) (74:B4) [23:18:36:859]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (74:B4) [23:18:36:859]: MainEngineThread is returning 1612
=== Verbose logging stopped: 12/17/2007 23:18:36 ===
SQL Native Client Error During MS SQL 2005 Instalation On MS Vista Ultimate RC1
Sep 19, 2006Hi !
How to avoid a SQL Native Client Instalation (a corrupted package ? from MSDN Disc !?) during MS SQL 2005 Server Standard instalation on MS Windows Vista Ultimate RC1 ?!?
Generally after this error all instalation failed !
Thanks in advance.
Parameter Passing In SQL Server 2005 Integration Services (SSIS) 2005 From VB.Net2005
Sep 7, 2007Is it possible to parm in a value to a SSIS
in my SSIS i have a variable;
Name : FileName
Scope : PackageName
Type : String
Value : ""
I have tried adding the following code in my vb.net project ;
pkg.Variables("filename").Value = "C: emp estfile.001"
pkg.execute()
but come up with the following error
A first chance exception of type 'System.MissingMemberException' occurred in Microsoft.VisualBasic.dll
Public member 'Variables' on type 'IDTSPackage90' not found.
can anyone help ?
Parameter Passing In SQL Server 2005 Integration Services (SSIS) 2005
Jan 16, 2007Hi All,
Parameter passing in SSIS 2005 sometimes appears to be a cumbursome task. I have been digging into this topic for quite some time and here i note down some simple steps to demonstrate parameter passing at Package level.
(1) Create a SSIS project using Business Intelligence 2005 Or VS 2005.
(2) Create datasource (.ds) and Data Source View as required.
(3) A default SSIS Package by the name Package.dtsx is created. Double click this and you are shown tabs for Control Flow, Data Flow, Event Handlers, Package Explorer. On the Control Flow, drap and drop Execute SQL Task from Control Flow Items in the toolbar.
(4) Lets now create a variable at Package level. Right click anywhere in the control flow box (not on the Task created in Step 3 above). Click on the Variables on the context menu displayed. Variables window appears on the left of the screen. Click the Add Variable box in this window to create a variable. Name it var1 (or whatever you may like), Scope as Package, DataType as String and Value as MyValue. This is only the default value.
(5) Now let us edit the SQL Task created in Step 3. Double on it, on the General tab you can change its Name, Description. Set ResultSet as None. We shall proceed to execute a stored procedure by name MySPName and pass it a parameter. Set ConnectionType as OLE DB. Select the connection you creates in step 2. Set SQLSourceType as Direct input. SQLStatement as MySPName ? . Note the ? mark after the name of the stored procedure. This is important to accept the variable value (var1) created in Step 4.
(6) Select Parameter Mapping tab now. Click on Add button. Select the Variable Name as User::var1. This is the user created variable of Step 4. Select Direction as Input, DataType as Varchar and Parameter Name as @var1. Click on OK now.
(7) This sets up the basic of parameter passing. Compile the project to verify everything works. Right Click on the SQL Task and select Execute Task. This will execute the package taking default value of the variable. This can be used along with dtexec command with /set option to pass the parameter at command prompt.
Can We Install Reporting Services 2005 In A Machine In Which Is Not Installed SQL Server 2005
Nov 19, 2007Hi,
Can we install reporting services 2005 in a machine in which is not installed SQL server 2005.?
Thanks
Upgrade From SQL Express 2005 Report Server With Advanced Services To SQL 2005 Standard Fails
Feb 25, 2008I am trying to upgrade SQL Server Express 2005 Report Server to SQL 2005 Standard and it fails with the following error:
SQL Server Setup did not have the administrator permissions required to copy a file: C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting ServicesReportServer
ssrvpolicy.config. To continue, verify that the file exists, and either grant administrator permissions to the account currently running Setup or log in with an administrator account. Then run SQL Server Setup again.
After I click OK on the message, this whole path where the upgrade is bieng installed dissapears C:Program FilesMicrosoft SQL ServerMSSQL.8Reporting Services. The error is a bit missleading because the file that it is trying to copy rssrvpolicy.config does appear in that upgrade folder so I am not sure why it would try to copy a file that has already been copied.
I was able to upgrade the Database Engine instance fine but can't upgrade Reporting Services due to that error. I have verified that the account that ran the setup had the administrator permissions. Your prompt reply to my question would be greatly appreciatted.
Visual Studio 2005 Bootstrap Package For SQL Server 2005 Express Edition With Advanced Services SP2
Feb 15, 2008Hi there,
Anyone know how I can replace (or download) the sqlexpr32.exe bootstrap package with the advanced services SP2 edition of SQL 2005 express ?
Pieter
Cannot Install SQL Server Express On Vista Ultimate - Cannot Find MS SQL Server Native Client
Apr 5, 2007I am trying to install SQL Server Express - (the non ADV version) and get the following error.
"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli_x64.msi'".
I have 64 bit Vista Ultimate running on an HP dv9000.
I am using the download from the bottom of the download page for SSX where it says 64 bit version.
Prior to this I got the. "64-bit ASP.net is registered. Required 32-bit ASP.NET to install Microsoft Reporting services 2005(32-bit)." messagd during the pre-install scan. From what I gather in the posts, the reporting issue is different from my installation package problem.
I have been trying to prove a point to friends about how far you can go with SSX but am having no luck installing it. This whole process took 1 hour in XP but I've been stymied for 2 days.
I would appreciate being pointed at the right downloads for what seems to be a simple install.
Linked Server Using SQL Native Client
May 28, 2007We have a SQL 2005 SP2 64 bit server that needs to communicate with our 32 bit AS400 server. We have stored procedures in databases that query the AS400 (generally just select statements). I am not understanding the procedure to connect to the AS400 now that the OLE DB for ODBC provider no longer exists.
I know how to create a system DSN (and that it will be located in C:WINDOWSSysWOW64odbcad32.exe). I called the System DSN 'ConnectMe'. The server I am trying to access is 'ServerA'. I have filled out the following to create a linked server:
Linked Server: AS400
Provider: SQL Native Client
Product Name: AS400 (from what I understand, this holds no value and only serves as a description)
Data source: ServerA
Provider String: dsn::=ConnectMe (same as system DSN)
Catalog:<I left it blank>
Under the security tab I have the remote username and password that should be used.
When I try to create the linked server, I get the error:
"OLE DB provider "SQLNCLI" for linked server "AS400" returned message "An error has occured while establishing a connection to the server. ..may be be caused by the fact that under the default settings SQL Server does not allow remote connections"
Remote connections for both TCP/IP and named pipes is enabled and SQL services have restarted to enable that. What am I missing?
SQL Server Native UDT Serialization Format
Jul 4, 2007I have created a UDT Point from an MSDN example. Its declaration is the following:
Code Snippet [Serializable]
[Microsoft.SqlServer.Server.SqlUserDefinedType(Format.Native,
IsByteOrdered = true, ValidationMethodName = "ValidatePoint")]
public struct Point : INullable
{
private bool is_Null;
private Int32 _x;
private Int32 _y;
...
So it means that this class will be serialized in the native SQL Server format.
Is there any possibility to deserialize data retrieved from server as bytes to an object instance?
For example:
Code Snippet SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
// Retrieve the raw bytes into a byte array
byte[] buffer = new byte[32];
long byteCount = rdr.GetBytes(1, 0, buffer, 0, 32);
Point pt = new Point();
// Here I need to fill the created object with retrieved data
}
After I retrieved the data in bytes format, I need to write it to the object. How can I do this? In fact, I have no possibility to use SqlDataReader in the following manner:
Code Snippet // Retrieve the value of the UDT
Point pnt = (Point)rdr[1];
// Point pnt = (Point)rdr.GetSqlValue(1);
// Point pnt = (Point)rdr.GetValue(1);
because I retrieve data in bytes not from the server, but from an unmanaged application.
I have a possibility to create an instance of the class, but how can I fill this instance with data? Is it possible to do using native SQL Server native format? How can I do this when UDT uses user defined serialization?
RDA - Vb 2005 App - Desktop && Pocket Pc Emulator - Error: 80072F76 Native Error: 28035
Oct 12, 2006RDA - vb 2005 app - desktop & pocket pc emulator - error: 80072F76 native error: 28035
PDA info:
.NET CF 1.0 env-string...
MS SQL client
MS SQLCE 2.0 dev
MS SQLCE 2.0
DESKTOP info:
Microsoft SQL Server Management Studio Express 9.00.2047.00
Microsoft Data Access Components (MDAC) 2000.085.1117.00
(xpsp_sp2_rtm.040803-2158)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.2900.2180
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600
copied an app from http://www.codeproject.com/netcf/PocketPCwithSQLCE/PocketPCwithSQLCE_Src.zip
modified its CONFIG.XML to...
<?xml version="1.0" encoding="utf-8" ?>
<Configuration>
<DatabaseServer>192.168.1.89</DatabaseServer>
<DatabaseName>D1Temp</DatabaseName>
<DatabaseLogin>sa</DatabaseLogin>
<DatabasePassword></DatabasePassword>
<SQLCEURL>http://192.168.1.89/SqlMobile/sqlcesa30.dll</SQLCEURL>
<LocalDBConnect>Provider=Microsoft.SQLServer.OLEDB.CE.2.0; Data Source=My DocumentsMyFav.sdf;</LocalDBConnect>
<LocalDBLocation>My Documents</LocalDBLocation>
<LocalDBName>MyFav.sdf</LocalDBName>
<IISLogin>192.168.1.89/Jason</IISLogin>
<IISPassword>batman2005</IISPassword>
</Configuration>
error is "Header information is either corrupted or missing. [,,, header name,,]"
have spent weeks google-ing trying to get this to work, to no avail.
Has ANYONE got RDA PULL to work with above setups?
Multiple SQL Server Native Client Versions
Nov 24, 2006One of the big problems with the old MDAC was different versions on different client machines. You would test your app with the latest version say, but when you deployed it, it might fail as the client has a different version.
My company develops software for Municipal Government clients. These clients use other SQL Server applications as well as ours, but they can only use one version of the client software (MDAC) on a given desktop. That means if we require a particular MDAC version, but the clients other applications from other vendors don't officially support that MDAC version, the client is in a real jam.
Our software also supports Oracle, which allows our software to specify a particular Oracle Home which points to a directory with a particular version of the Oracle client dlls (along with corresponding registry entries for that Oracle Home), such that we control the exact client version of the Oracle software that the client uses with our applications. This will not interfere with, and is completely seperate, from the default Oracle home installed when you install the Oracle client software.
What I would like to see for the Native Client is the ability to have our applications use the version of the Native Client that we wish to support and deploy without interfering with the Native Client version used by other applications. Have a default Native Client, but allow applications to somehow specify a different Native Client version/set of DLLs.
Is there any such functionality with the Native Client? (I didn't see any mention of such in the documentation, but I thought I'd ask)
If not, are there any future plans to support multiple Native Client versions on the same desktop?
Upgrading From Sql Server 2005 Express Edition To Sql Server 2005 Express With Advanced Services
Oct 4, 2006If i have been using sql server 2005 express for developing my application and i decide to upgrade to sql server 2005 express with advanced services while still working on the same application, what will happen to my application's database. Can i be able to continue with my work with out any major regrets.
View 1 Replies View RelatedSQL Server Native Client - SDK Doesn't Include X64 Libs
Jul 19, 2007I've installed the SQL Server Native Client, and I included the optional SDK components. Only the x86 versions of opends60.lib and sqlncli.lib get installed, not the x64 (or amd64) versions. Any idea where I can get ahold of these?
An Unspecified Error Had Occurred In The Native SQL Server Connection Component.
Apr 13, 2007
Hello All,
I need you help badly. Iam a student and iam working on "Creating a Mobile Application with SQL Server Compact Edition" http://msdn2.microsoft.com/en-us/library/ms171908.aspx . This tutorial works fine until
Create the publication snapshot
In SQL Server Management Studio, in Object Explorer, expand the (local) computer node.
Expand the Local Publications folder, select the publication name, right-click SQLMobile, and then click View Snapshot Agent Status.
In the View Snapshot Agent Status dialog box, click Start.
Make sure that the snapshot job has succeeded before you continue.
When I try to create a snapshot iam getting the following error "An unspecified error had occurred in the native SQL Server connection component." . I have no clue what to do next please help me out.
A Native Exception Occurred: Synchronizing Data Between The MS SQL Server Database And PDA
Sep 27, 2005ISSUE: While synchronizing data between the PDA and MS SQL Server database, using Active Sync connection, the sync process fails at times and displays an empty error message box and occasionally it shows the following exception: Error During Synchronization: A native exception occurred. ExceptionCode:0xc0000005 ExceptionAddress:0x01627b28 Reading: 0x1e000000 OK to terminate CANCEL to debug Moreover the .SDF file on the PDA gets corrupted. The ActiveSync connection drops as soon as the sync process fails. Later when the .SDF file is deleted and restored the synchronization is successful. Note: The replication monitor in the SQL Server indicates that the synchronization was successful even when the above error occurs.
View 3 Replies View RelatedInstalling SQL Server Native Client Requires Administrator Rights
Jun 26, 2007Hi All,
We're deploying an app. using a MSSQL Server 2005 (Std. Ed.).
In order to install an ODBC driver for the DB, we've made the installation of Sqlncli.msi part of the package.
It will not run - unless user has Admin priv.s on the klient PC targeted.
Does any one have any experience w. other ways of installing the sql native client (like MDAC) - og just an idea about circumventing the Admin rights problem?
Regards
RDA Pull From Windows Server 2003 Gives Native Error 28035
Mar 28, 2006I currently have a Vs.Net 2003 Pocket PC application that uses sql server ce 2.0 to push and pull data from Sql Server 2000 to the Pocket PC. The sscesa20.dll isapi agent is installed on a Windows 2000 server and points to another server that hosts the SQL database. In this configuration everything works like a charm. I am in the process of upgrading my application server to Windows 2003 Server but the RDA PULL process does not work, giving an Native Error of 28035 EVERY time. I use the exact same code in the app but when I point to the isapi agent on the 2003 box it does not work. When I connect to the the sscesa20.dll via the Pocket IE it returns the "Sql Server CE Server Agent" message. When I do an RDA.Submit it works and the SQL table is updated as expected.
I have configured IIS 6 with the proper web extensions
I have turned off the firewall and antivirus on the server.
I have reinstalled the server agent several times.
I set up the sscesa20.dll manually.
I removed all file level security.
I opened up the virtual directory.
I verified the ddl versions match.
I'm dead in the water right now. I'm not sure what else to try.
Any help would be greatly appreciated.
SQL Server Reporting Services 2005 Service Would Not Start On Windows Server 2003
Dec 13, 2007SQL Server Reporting Services 2005 Service would not Start on windows server 2003. Working great till yesterday and no changes were made to config file.
Here is the error in Event log
Event Type: Error
Event Source: SQL Server Report Service
Event Category: None
Event ID: 0
Date: 12/13/2007
Time: 8:25:59 AM
User: N/A
Computer: XXXXXXXXXXX
Description:
Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information.
at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime)
at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args)
at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)
For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Here is i found in log files
ReportingServicesService!resourceutilities!4!12/13/2007-08:25:59:: i INFO: Running on 0 physical processors, 1 logical processors
ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Exception caught loading and setting code permissions policy level: System.Security.XmlSyntaxException: Invalid syntax on line 158.
at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index)
at System.Security.Util.Parser.ParseContents()
at System.Security.Util.Parser..ctor(Tokenizer t)
at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type)
at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type)
at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy()
ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Error Starting Service: System.Security.XmlSyntaxException: Invalid syntax on line 158.
at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index)
at System.Security.Util.Parser.ParseContents()
at System.Security.Util.Parser..ctor(Tokenizer t)
at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type)
at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type)
at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy()
at Microsoft.ReportingServices.Library.ServiceController.StartService(Boolean firstStart)