CE DB Requires SQL Express Install On Client Machines?

Aug 27, 2007

I'm working on a C# 2008 project, when i add a CE Database to it, then publish the app, the installer wants to download and install the entire SQL Server Express product on the client machines. My understanding is that I should be able to embed this database right into the app, but it defeats the purpose to have the installer download and install the entire express product (the actual project is 1 meg).

Is this expected behavior? or am I doing something wrong?

View 3 Replies


ADVERTISEMENT

SQL Server Express And Client App Both On Win XP Machines ?

Mar 29, 2007

Hi,



Can I access from App machine (on WinXP) to SQL 2005 Exp machine (on WinXP) ?



I installed SQL 2005 Exp SP2 on Win XP SP2 on my PC. Please consider following environment:



- My PC name: MyPC

- Database name : MyData

- Database role for MyData without any permissions: MyDBRole

- Application role for MyData having all permisions: MyAppRole

- Database user: MyDBUser

- SQL Login: MyLogin (WinXP Limited Login) mapped to MyDBUser

- Application Name to access MyData: MyApp

- Using Application Role MyRole in MyApp



I am accessing data from MyApp within MyLogin. When I want to access from other tool like Management Studio Express, I can not access it and that that is what I want.



Till now it is OK when I am doing all these things on MyPC.



Now question is : Is it possible to connect from other PC (say CleintPC) running Windows XP SP2 use MyApp ?



I think ClientPC should access MyPC through MyPC's MyLogin.



[ I have tried successful simple SQL server connection with MyPC's Guest Login]



Please tell me is it possible ? (Running SQL Express on one machine, Application on second machine and both machine's operationg system is Windows XP)



Thanks

View 1 Replies View Related

Upgrade Client Connectiviity Tools On Client Machines

Jul 23, 2005

Hello,Is it necessary to upgrade the Client Connectivity Tools on all clientmachines after the SQL Server database server is upgraded from Version7.0 to 2000?Thank you in advance!Eddy

View 1 Replies View Related

?? SQL Server 2005 Express SP2 Install Fails On Native Client ??

Jun 11, 2007

Hello 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

View 5 Replies View Related

Installing SQL Server Native Client Requires Administrator Rights

Jun 26, 2007

Hi 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

View 1 Replies View Related

Configuring SQL Express During Installation And Attaching Smart Client DB / Silent Install For One Click?

Oct 9, 2006



Hey all,

Cool place! Has anyone deployed SQL Express silently using one click and an attached a smart client DB from within the app ... would love to see some of the best practices or horror stories! Just kidding... :) I'm about to deploy a smart client using SQL Express and could use some tips from someone who has been there.

Thanks in advance,

Bill

View 7 Replies View Related

Can't Connect From A Vista Client To SQL 2005 Box,other Machines Work Fine

Oct 27, 2006

Hey. I've a windows vista machine which can't connect to SQL 2005 box. Other machines which are lower than vista work fine. Also, vista box can connect to other SQL 2005 instances but can't connect to only one instance. But, I can connect to the instance fine from my XP box. Also, it's not a permissions issue. This user is an SA and can connect form some other machine. SQL 2005 box is at 2047 version right now. And, the user is able to connect to some other boxes which are also at 2047. Please help. Thank you

View 1 Replies View Related

Integration Services :: SMTP Server Requires A Secure Connection Or Client Was Not Authenticated

Apr 11, 2013

I have an issue with SMTP server " send mail task ".  we see the following error [Send Mail Task] Error: An error occurred with the following error message: "The SMTP server requires a secure connection or the client was not authenticated.In SMTP connection manager what we should give in SMTP SERVER, if we use gmail id's in send mail task editor.

View 4 Replies View Related

SQL Server 2000 Requires Explicit Declaration Of Data Types In Client App After Installing A Certain HotFix

Jun 15, 2004

I think I may have figured out the solution to my recent conundrum with SQL Server 2000 that had me stressed and depressed over the last couple of days. In a nutshell, after a HotFix was installed on a SQL2K database server I have space on, I was unable to perform INSERT or UPDATE queries on database table of type TEXT, when trying to either create or modify records with more than 4,000 characters of data. While it was frustrating as heck, it seemed too rigid to be random, so I did some snooping.

The HotFix was intended to solve a known problem of not being able to run UPDATEs against TEXT fields, but in so doing, caused another headache entirely: http://support.microsoft.com/?kbid=839523

Apparently this is a semi-known problem, in that a certain HotFix forces SQL Server 2000 to be a lot more stringent in requiring explicit declaration of data types and data lengths for parameters in stored procedure. In my client code, I was initially using the overloaded constructor of the SqlParameter object that took as arguments only the parameter name and a value, without specifying a value from the SQLDBType enumeration or length of the parameter (which in my case, needs to be TEXT and 16 (or 2147483647), respectively):

System.Data.SqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@parameterName",parameterValue);

It appears that after the HotFix is installed, if the client doesn’t syntactically set the type and length of data for a parameter, SQL Server and/or .NET will default to a type of NVARCHAR, which has the 4,000-character limit. This all makes sense. I’m going to now need to modify the code to straight out declare what’s going in the SPROC:

System.Data.SqlDataAdapter.InsertCommand.Parameters.Add(new SqlParameter("@parameterName",SqlDbType.Text);
System.Data.SqlDataAdapter.InsertCommand.Parameters["@parameterName"].Value = parameterValue;

It’s a minor change, and it sucks that I have to make it after the code had worked flawlessly over several thousands executions over several months, but c’est la vie! Better thay than have to rebuild my DB from scratch or switch to a new server. Changing the client code evidently is the only known fix at this time: http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b827366

View 1 Replies View Related

Install SQL Server2005 Error:[Native Client]Encryption Not Supported On The Client

May 10, 2006

Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Encryption not supported on the client. Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

View 78 Replies View Related

Cannot Install SQL Server Express On Vista Ultimate - Cannot Find MS SQL Server Native Client

Apr 5, 2007

I 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.

View 5 Replies View Related

How Do I Connect Client Machines To SQL Server 2005 Installed On A Windows 2003 Server

Apr 11, 2008

I am new to SQL server 2005


Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it.

I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP):

These are two things that I need to facilitate:

1) They want to be able to write queries using Query Designer and run from their PCs.

2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database.

3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this.

Any suggestions are appreciated, especially with item number 1.

View 9 Replies View Related

How Can I Shrink SQL Express Database On Local Machines?

Oct 27, 2006

Hello,

I have deployed a vb.net application to a few laptops that holds the SQL Express database as a local datastore. What is the best way to compress or shrink the database and log files? I would like a way that this can be done automatically or unattended if possible...

Thanks in advance.

View 10 Replies View Related

Is It Possible To Send Message From SQL Server Express To Applications Using It On Different Machines ?

Mar 8, 2008

Hello,

Is it possible to send message from SQL Server Express to Applications using it on different machines ?

For example When an important record is inserted or updated, a message appears on Application user's screen.

If yes then how ?

Thanks

View 3 Replies View Related

VS2005 Error: Connection To SQL Server Files (*.mdf) Requires SQL Server Express 2005 To Function Properly.

Mar 6, 2008



Good Evening All,

I've serached this forum and Google'd for a resolution to this issue, to no avail. Here's the scenario:
I'm running VS 2005 on Windows Media Center laptop and need to create ASP.net membership for my web application built using VB. I have SQL Server Developer installed with instance name MSSQLSERVER. Previously, I uninstalled SQL Express and installed Developer edition and can now open and utilize Management Studio.

Now, when I try to create a new SQL Server database in my solution's App_Data directory, I receive the above error. I already changed instance name in VS2005 per Tools-Options-Database Tools-Data Connections to MSSQLSERVER.

Could someone provide me with a list of procedures to ensure proper setup of VS2005 with SQL Server Developer Edition?

Thanks much for your help.

View 5 Replies View Related

Do I Need To Install The SQL 7 Client?

May 25, 2001

Hello,

I am upgrading existing databases through the wizard from 6.5 to 7.0. If I leave the databases in 6.5 mode do I need to install the SQL 7.0 client?

Thanks,
Darrin Carter

View 1 Replies View Related

Client Install

Oct 26, 2000

I am trying to install the SQL Server 6.5 client utilities and constantly get the infamous
"setup.exe has caused an invalid page fault in kernel32.dll" message.

I have scoured the web and found many suggestions for resolving this issue but nothing helps.

Has anyone suffered this same fate? Any ideas on how to resolve it?

View 3 Replies View Related

Can We Install SQL Client On Another Domain?

Dec 8, 1998

Can we install SQL client on another domain to access the SQL server on another domain? If can, Pls say how to?

View 2 Replies View Related

SSIS Install On Client Box?

Sep 15, 2006

I note that I can install SSIS on a client box not just a server. What is the advantage (expect maybe if the client is a portable computer) to installing SSIS on a client box? I would normally expect to find it running on the server side of the house.



TIA,



Barkingdog



View 1 Replies View Related

How 2 Install Client Tools For SQl Server

May 31, 2004

In Server Explorer of VS .NET 2003, I tried to generate SQL script of the dbo.Portal (ibs)
but got
"To use this feature, you must install the client tols for SQL Server"

When I searched for Help, I've got
"1.Insert the MS SQL Server 2000 compact disc in your CD-ROM drive"

I installed and use MSDE and cannot recall the use of any CD for installation.

1)
Does it mean that I cannot install client tools from MSDE installation?

If not...

2)
I have installation of MS SQL Server200 Enterprise that cannot be installed on Windows Xp Professional that I use. Can I still install "client tools" from Enterprise Ed. for MSDE

View 2 Replies View Related

SQL05 Client Tool Install

Dec 15, 2005

I'm running XP w/ SP2 and I tried to install just the client tools (management solution) from a SQL 05 Standard Edition. Don't have any kind of SQL sever or client tools installed (like older version or express). The install goes really quickly and installs successfully. When I try to go to Start - All Programs - SQL Server nothing shows up? It seems that nothing was installed. What am I doing wrong. Any ideas? All I'm trying to do is to connect to a SQL2005 server from a workstation with the new Management tool (the new version of Enterprise Manager). Thanks!

View 3 Replies View Related

Need To Install Service Pack On Client?

Jan 4, 2001

We are running SQL Server 7.0 on an NT Server in an NT environment. We have Service Pack 2 installed on the server hosting the database. Do we need the service pack installed on the client machines? Even if they only need client connectivity? Also does anyone know what fixes sp3 is supposed to fix? We are running our production environment without any known problems using sp2 and really dont want to disrupt it with sp3 if its not needed. Thanks in advance.

View 4 Replies View Related

How To Install Reports On Client Machine

Aug 9, 2007

Hi
I am developing a Report Project ,that contains some reports
using VS.Net ,My task is to install these reports on client Machine.
Is there any option to add a "Set Up Project" to the Report Project solution, so that client may run this setup project(.exe) to install the reports in his server.

My Main requirement is , client can install these reports into his machine by executing a set up file.
Is this possible?, Please suggest me a good solution

View 1 Replies View Related

How Do I Install Sqlcmd.exe In My SQL Server Client

Nov 14, 2006

I have SQL Server 2000 client installed in my machine and I need to call stored procedures thru sqlcmd utility. When I tried using this utility, I got an error message from command prompt sqlcmd command does not exist.

I have osql utility in my client version, but i need to have sqlcmd utility.



Please advice how do I install sqlcmd.exe in my SQL Server client?

View 1 Replies View Related

Unattended Install Of Client Components

Jun 20, 2006

I'm trying to do an unattended install of the client components for SLQ2005. I have read the document on doing a install from the command prompt but when I use the "ADDLOCAL" switches I get some components that I don't require. For example, I am using the following command to run the setup - "start /wait <path>setup.exe ADDLOCAL=Client_Components,SQL_Tools90,Connectivity". When I look at the Add/Remove Programs list I can see that it has installed "MSXML 6.0 Parser", "SQL 2005 Backward Compatibilty" and "Office 2003 Web Components". The only components I require are the "SQL Support Files", "SQL Server Native Client" and " CLient Tools". If I run "start /wait <path>setup.exe REMOVE=SQLXML,TOOLS_BC_DEP" it will remove "Office 2003 Web Components" and "SQL 2005 Backward Compatibilty" but not the "MSXML 6.0 Parser". How can I get rid of this?

Thanks for any help.

View 1 Replies View Related

How Can I Install SSIS On Client Side?

Oct 13, 2006

Hi,

We just moved from SQL 2000 to SQL 2005 Ent. To use SSIS service, I need install this package on client side. But when I install the 2005 on my PC(Win XP Prof), I did not find any place I can include it. Anyone has similar experience or know how to do it?

Thanks in advance,

Jie

View 9 Replies View Related

Cannot Install Client Components On X64 System

Jan 8, 2008

I'm building a new server and am having a problem witht he SQL install. It's a Dell 2905 running Windows 2003 SP1 x64 and SQL 2005 x64. I'm able to install everything except for the Client Components, and even upgrade to SQL SP2.

I keep getting the following error:

"There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information"
TITLE: Microsoft SQL Server 2005 Setup
------------------------------
There was an unexpected failure during the setup wizard. You may review the setup logs and/or click the help button for more information.

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=50000&EvtType=packageengine%5cinstallpackageaction.cpp%40InstallToolsAction.10%40sqls%3a%3aInstallPackageAction%3a%3aperform%400x643
------------------------------
BUTTONS:
OK
------------------------------

The problem is that I can't find any solutions to this so far. Anyone recognize or have any insight into this?

View 4 Replies View Related

X64 Win XP (32 Bit) Edition -&&> Can't Install Sql 2005 Client

Sep 21, 2006

One user has an HP x64 Athalon box and IS installed Windows XP, 32 bit edition, on it.  Today I installed the sql 2005 x86 client on this box, but the install came back saying that the "minimum hardware requirments" were not met.  I need to know exactly what has not been met. Where can I look?

TIA,

 

Barkingdog

P.S. When I tried to install the sql 2005 x64 clinet on the same box the OS replied "not a valid 32 bit app". Well, duh!

 

 

View 2 Replies View Related

Newbie - New Install Client Config Problem

Feb 13, 2000

Hi,

I've just set up a new installation of SQL 7 in a WinNT4/sp5 machine so I can learn more about this stuff and I'm trying to configure a Win98 client. From the Win98 client all looks well on the surface. Interestingly when I click on the server from within the Win98 MMC/Enterprise Manager it attempts to establish a dial-up connection to my ISP. The only network protocol I have running is TCP/IP.

Also, I can do what ever I want from within Enterprise Manager and SQL Analyzer but if I attempt to execute a script using the OSQL utility at a dos prompt as follows

osql /Usa /P /i "c:sqlimplexercisech02myscript2.sql"

I get the following error

[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]General network error.
Check your network documentation.
[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (connect()).

Any clues as to what I need to do to straighten this out? I have a DSN for the server which tests successfully using TCP/IP on the default port 1433.

View 2 Replies View Related

Client OLAP Manager Doesn&#39;t Install

May 13, 1999

I can't get the OLAP Manager to install on my client PC running Windows95. It does install on the server running NT4.0.
I want to remotely administer the OLAP, just like I do with the Enterprise Manager on the client. Anyone have any suggestions?
Do you have to have NT on the client?

View 1 Replies View Related

Create A Client Install Directory For SQL 2000

Dec 19, 2001

Is there a way to extract (and copy to a network drive) the necessary files from the SQL Server 2000 CD for the purpose of a creating a client install directory? I would like to invoke the Setup from the network. I do not want to place the whole CD on the network. I do not necessarily want to have to re-key the serial number (product key) every time a client install takes place.

View 1 Replies View Related

Install SQL 2000 Client On SQL 2005 Server

Dec 27, 2007

I'm trying to remember how to install the SQL 2000 client tools onto a SQL 2005 server. There are a couple of bizarre steps that will allow this to happen, but I can't for the life of me remember what comes after the unicycle down the stairs with the umbrella stand of machetes.

Can anybody remember the magic, or do I resort to using VPC to kludge the install until I can find my clay tablets again?

-PatP

View 5 Replies View Related

SQl Server 2005 Client Software Install

Feb 11, 2008

I am new to SQL Server 2005.

Windows 2003 Server SP 2
SQL Server 2005

Unable to locate client connectivity software ntwdblib.dll Check with your miscrosoft SQL Server database administrator to install the appropriate client software.

Where will find Client software and how do we install that.

Please advice. Thanks.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved