Here is my situation: I am creating a database driven ASP.Net web application that will be used over the internet. My ASP.Net application connects to my SQL server 2005 database/server by using a SQL server login. I am using the DPAPI API to encrypt my connection stings with a hidden entropy value for extra security. I am using the SQL login for obvious reasons, as my users will not have a windows login.
What I am trying to do: I want to limit this SQL login account to be able to just run/execute stored procedures and NOT access the tables or views directly. In my ASP.Net application I am using the MS applications data block, and I am using stored procedures for every single database access action. There is no inline SQL being executed from my web application.
What I have tried so far:
I created a new schema and made the above SQL login account owner of this schema. I then granted "Execute" permissions to the SQL login and DENY permissions to all other permissions.
I created an database role with "Execute" only permissions and DENY permissions to all other permissions.
What Happened: In BOTH of the above scenarios I tested a direct SQL statement against one of my tables, from my ASP.Net application and I was able retrieve data back, NOT GOOD, exactly what I am trying to STOP.
If someone could give me (Step-by-Step) guide on how to setup the situation I am looking for, I would be very grateful!
=== Verbose logging started: 8/16/2006 8:56:23 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: c:faca48e439bf4182f2bd96setup.exe === MSI (c) (98:00) [08:56:23:850]: Resetting cached policy values MSI (c) (98:00) [08:56:23:850]: Machine policy value 'Debug' is 0 MSI (c) (98:00) [08:56:23:850]: ******* RunEngine: ******* Product: c:faca48e439bf4182f2bd96SetupSqlSupport.msi ******* Action: ******* CommandLine: ********** MSI (c) (98:00) [08:56:23:850]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (98:00) [08:56:23:850]: Grabbed execution mutex. MSI (c) (98:00) [08:56:23:850]: Cloaking enabled. MSI (c) (98:00) [08:56:23:850]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (98:00) [08:56:23:860]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (70:58) [08:56:23:870]: Grabbed execution mutex. MSI (s) (70:FC) [08:56:23:870]: Resetting cached policy values MSI (s) (70:FC) [08:56:23:870]: Machine policy value 'Debug' is 0 MSI (s) (70:FC) [08:56:23:870]: ******* RunEngine: ******* Product: c:faca48e439bf4182f2bd96SetupSqlSupport.msi ******* Action: ******* CommandLine: ********** MSI (s) (70:FC) [08:56:23:870]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (70:FC) [08:56:23:870]: File will have security applied from OpCode. MSI (s) (70:FC) [08:56:23:920]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'c:faca48e439bf4182f2bd96SetupSqlSupport.msi' against software restriction policy MSI (s) (70:FC) [08:56:23:920]: SOFTWARE RESTRICTION POLICY: c:faca48e439bf4182f2bd96SetupSqlSupport.msi has a digital signature MSI (s) (70:FC) [08:56:23:990]: SOFTWARE RESTRICTION POLICY: c:faca48e439bf4182f2bd96SetupSqlSupport.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (70:FC) [08:56:23:990]: End dialog not enabled MSI (s) (70:FC) [08:56:23:990]: Original package ==> c:faca48e439bf4182f2bd96SetupSqlSupport.msi MSI (s) (70:FC) [08:56:23:990]: Package we're running from ==> c:WINDOWSInstaller4e59e6d.msi MSI (s) (70:FC) [08:56:23:990]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'. MSI (s) (70:FC) [08:56:23:990]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (70:FC) [08:56:23:990]: MSCOREE already loaded, using loaded copy MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'TransformsSecure' is 0 MSI (s) (70:FC) [08:56:24:000]: User policy value 'TransformsAtSource' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisablePatch' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'AllowLockdownPatch' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisableLUAPatching' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (s) (70:FC) [08:56:24:000]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'. MSI (s) (70:FC) [08:56:24:000]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (70:FC) [08:56:24:000]: Transforms are not secure. MSI (s) (70:FC) [08:56:24:000]: Note: 1: 2205 2: 3: Control MSI (s) (70:FC) [08:56:24:000]: Command Line: ADDLOCAL=All REINSTALLMODE=vomus REBOOT=ReallySuppress CURRENTDIRECTORY=c:faca48e439bf4182f2bd96 CLIENTUILEVEL=3 CLIENTPROCESSID=2712 MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{EE7DF8EF-0E50-44E1-9603-0E4FD66A993D}'. MSI (s) (70:FC) [08:56:24:000]: Product Code passed to Engine.Initialize: '' MSI (s) (70:FC) [08:56:24:000]: Product Code from property table before transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}' MSI (s) (70:FC) [08:56:24:000]: Product Code from property table after transforms: '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}' MSI (s) (70:FC) [08:56:24:000]: Product not registered: beginning first-time install MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'. MSI (s) (70:FC) [08:56:24:000]: Entering CMsiConfigurationManager::SetLastUsedSource. MSI (s) (70:FC) [08:56:24:000]: User policy value 'SearchOrder' is 'nmu' MSI (s) (70:FC) [08:56:24:000]: Adding new sources is allowed. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'. MSI (s) (70:FC) [08:56:24:000]: Package name extracted from package path: 'SqlSupport.msi' MSI (s) (70:FC) [08:56:24:000]: Package to be registered: 'sqlsupport.msi' MSI (s) (70:FC) [08:56:24:000]: Note: 1: 2262 2: AdminProperties 3: -2147287038 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'DisableMsi' is 0 MSI (s) (70:FC) [08:56:24:000]: Machine policy value 'AlwaysInstallElevated' is 0 MSI (s) (70:FC) [08:56:24:000]: User policy value 'AlwaysInstallElevated' is 0 MSI (s) (70:FC) [08:56:24:000]: Product installation will be elevated because user is admin and product is being installed per-machine. MSI (s) (70:FC) [08:56:24:000]: Running product '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}' with elevated privileges: Product is assigned. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'All'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding REINSTALLMODE property. Its value is 'vomus'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'c:faca48e439bf4182f2bd96'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'. MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '2712'. MSI (s) (70:FC) [08:56:24:000]: TRANSFORMS property is now: MSI (s) (70:FC) [08:56:24:000]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '200'. MSI (s) (70:FC) [08:56:24:000]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHApplication Data MSI (s) (70:FC) [08:56:24:000]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHFavorites MSI (s) (70:FC) [08:56:24:000]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHNetHood MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHMy Documents MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHPrintHood MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHRecent MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHSendTo MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHTemplates MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data MSI (s) (70:FC) [08:56:24:010]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHLocal SettingsApplication Data MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHMy DocumentsMy Pictures MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersDesktop MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart MenuProgramsAdministrative Tools MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart MenuProgramsStartup MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart MenuPrograms MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHStart Menu MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsRickHDesktop MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersTemplates MSI (s) (70:FC) [08:56:24:020]: SHELL32::SHGetFolderPath returned: C:WINDOWSFonts MSI (s) (70:FC) [08:56:24:020]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16 MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding USERNAME property. Its value is ' '. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is ' '. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'c:WINDOWSInstaller4e59e6d.msi'. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'c:faca48e439bf4182f2bd96SetupSqlSupport.msi'. MSI (s) (70:FC) [08:56:24:030]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (70:FC) [08:56:24:030]: Machine policy value 'DisableRollback' is 0 MSI (s) (70:FC) [08:56:24:030]: User policy value 'DisableRollback' is 0 MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'. === Logging started: 8/16/2006 8:56:24 === MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'. MSI (s) (70:FC) [08:56:24:030]: Doing action: INSTALL MSI (s) (70:FC) [08:56:24:030]: Running ExecuteSequence MSI (s) (70:FC) [08:56:24:030]: Doing action: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B Action start 8:56:24: INSTALL. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B property. Its value is 'C:Program FilesCommon Files'. Action start 8:56:24: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B. MSI (s) (70:FC) [08:56:24:030]: Doing action: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 Action ended 8:56:24: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B. Return value 1. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:Documents and SettingsRickHLocal SettingsApplication Data'. Action start 8:56:24: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. MSI (s) (70:FC) [08:56:24:030]: Doing action: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 Action ended 8:56:24: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:WINDOWS'. Action start 8:56:24: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. MSI (s) (70:FC) [08:56:24:030]: Doing action: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 Action ended 8:56:24: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1. MSI (s) (70:FC) [08:56:24:030]: PROPERTY CHANGE: Adding ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:Program Files'. Action start 8:56:24: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. MSI (s) (70:FC) [08:56:24:030]: Doing action: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 Action ended 8:56:24: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'C:Program FilesCommon Files'. Action start 8:56:24: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. MSI (s) (70:FC) [08:56:24:040]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 8:56:24: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 8:56:24: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (70:FC) [08:56:24:040]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E Action ended 8:56:24: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 8:56:24: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. MSI (s) (70:FC) [08:56:24:040]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 8:56:24: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'. Action start 8:56:24: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (70:FC) [08:56:24:040]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E Action ended 8:56:24: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (70:FC) [08:56:24:040]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'. Action start 8:56:24: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. MSI (s) (70:FC) [08:56:24:040]: Doing action: LaunchConditions Action ended 8:56:24: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1. MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2205 2: 3: LaunchCondition MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2228 2: 3: LaunchCondition 4: SELECT `Condition`, `Description` FROM `LaunchCondition` Action start 8:56:24: LaunchConditions. MSI (s) (70:FC) [08:56:24:040]: Doing action: FindRelatedProducts Action ended 8:56:24: LaunchConditions. Return value 0. MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2205 2: 3: Upgrade MSI (s) (70:FC) [08:56:24:040]: Note: 1: 2228 2: 3: Upgrade 4: SELECT `UpgradeCode`,`VersionMin`,`VersionMax`,`Language`,`Attributes`,`ActionProperty` FROM `Upgrade` Action start 8:56:24: FindRelatedProducts. MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_ValidateAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_RefCountAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_BackupAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_RegisterAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Skipping action: Sqlmsirc_RestoreAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:040]: Doing action: AppSearch Action ended 8:56:24: FindRelatedProducts. Return value 0. MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2205 2: 3: AppSearch MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2228 2: 3: AppSearch 4: SELECT `Property`, `Signature_` FROM `AppSearch` Action start 8:56:24: AppSearch. MSI (s) (70:FC) [08:56:24:050]: Doing action: CCPSearch Action ended 8:56:24: AppSearch. Return value 0. MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2205 2: 3: CCPSearch MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch` Action start 8:56:24: CCPSearch. MSI (s) (70:FC) [08:56:24:050]: Doing action: RMCCPSearch Action ended 8:56:24: CCPSearch. Return value 0. MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2205 2: 3: CCPSearch MSI (s) (70:FC) [08:56:24:050]: Note: 1: 2228 2: 3: CCPSearch 4: SELECT `Signature_` FROM `CCPSearch` Action start 8:56:24: RMCCPSearch. MSI (s) (70:FC) [08:56:24:050]: Skipping action: Sqlmsirc_CheckLanguage.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false) MSI (s) (70:FC) [08:56:24:050]: Doing action: CostInitialize Action ended 8:56:24: RMCCPSearch. Return value 0. MSI (s) (70:FC) [08:56:24:050]: Machine policy value 'MaxPatchCacheSize' is 10 Action start 8:56:24: CostInitialize. MSI (s) (70:FC) [08:56:24:080]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'c:'. MSI (s) (70:FC) [08:56:24:080]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'. MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: Patch MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: MsiPatchHeaders MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: __MsiPatchFileList MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (70:FC) [08:56:24:080]: Note: 1: 2228 2: 3: PatchPackage 4: SELECT `DiskId`, `PatchId`, `LastSequence` FROM `Media`, `PatchPackage` WHERE `Media`.`DiskId`=`PatchPackage`.`Media_` ORDER BY `DiskId` MSI (s) (70:FC) [08:56:24:080]: Doing action: FileCost Action ended 8:56:24: CostInitialize. Return value 1. MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: Class 3: -2147287038 MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: Extension 3: -2147287038 MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: TypeLib 3: -2147287038 Action start 8:56:24: FileCost. MSI (s) (70:FC) [08:56:24:090]: Doing action: IsolateComponents Action ended 8:56:24: FileCost. Return value 1. Action start 8:56:24: IsolateComponents. MSI (s) (70:FC) [08:56:24:090]: Doing action: CostFinalize Action ended 8:56:24: IsolateComponents. Return value 0. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'. MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2205 2: 3: Patch MSI (s) (70:FC) [08:56:24:090]: Note: 1: 2262 2: Condition 3: -2147287038 MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'c:'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying TempFolder property. Its current value is 'C:DOCUME~1RickHLOCALS~1Temp'. Its new value: 'c:DOCUME~1RickHLOCALS~1Temp'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B property. Its current value is 'C:Program FilesCommon Files'. Its new value: 'c:Program FilesCommon Files'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:Documents and SettingsRickHLocal SettingsApplication Data'. Its new value: 'c:Documents and SettingsRickHLocal SettingsApplication Data'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding LocalAppDataPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTH'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding LocalAppDataErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREP'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonUQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQSIGNOFF'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonUQRegularFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQREGULAR'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonUQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQHEADLES'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:Program Files'. Its new value: 'c:Program Files'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:Program FilesCommon Files'. Its new value: 'c:Program FilesCommon Files'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SharedFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Program FilesCommon FilesMicrosoft Shared'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding DWFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Program FilesCommon FilesMicrosoft SharedDW'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding DWIntlFolder_1033.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:Program FilesCommon FilesMicrosoft SharedDW1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WindowsPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTH'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WindowsErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTHERRORREP'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonAQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTHERRORREPQSIGNOFF'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WatsonAQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSPCHEALTHERRORREPQHEADLES'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WindowsINFFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 property. Its value is 'c:WINDOWSINF'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'c:WINDOWSsystem32'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxs'. MSI (s) (70:FC) [08:56:24:090]: 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) (70:FC) [08:56:24:090]: 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) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsManifests'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPolicies'. MSI (s) (70:FC) [08:56:24:090]: 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) (70:FC) [08:56:24:090]: 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) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWS'. Its new value: 'c:WINDOWS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'c:WINDOWSsystem32'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxs'. MSI (s) (70:FC) [08:56:24:090]: 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) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPolicies'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'c:WINDOWSwinsxsManifests'. MSI (s) (70:FC) [08:56:24:090]: 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) (70:FC) [08:56:24:090]: 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) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Modifying ProgramFilesFolder property. Its current value is 'C:Program Files'. Its new value: 'c:Program Files'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLSQLDIR property. Its value is 'c:Program FilesMicrosoft SQL Server'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding InstallDir.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPA.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARes1033.EF99D297_8F3F_42F1_8766_460250F41CDA property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.41746B4B_478E_4AF6_946E_774617467ABF property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLDIR.41746B4B_478E_4AF6_946E_774617467ABF property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPA.41746B4B_478E_4AF6_946E_774617467ABF property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLDIR.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPASchemas.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPASchemas'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepository.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepository'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKR'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKRin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKR'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKRin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIIS'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIES'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIESin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEID'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEIDin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLE'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLEin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESID'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESIDin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKR'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKRin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepositoryASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTED'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPARepbinASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTEDin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSDEFAULTIISYUKON.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKON'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSDEFAULTIISYUKON_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKONin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSCUSTOMSECURITY.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITY'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RSCUSTOMSECURITY_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITYin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding BPAbin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBPAin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.117A1A21_ACE1_414A_88CC_83C84195F101 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.117A1A21_ACE1_414A_88CC_83C84195F101 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.4845A713_8D8A_4100_8CAA_164C5AC9E452 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.4845A713_8D8A_4100_8CAA_164C5AC9E452 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.3512ABB7_9344_4EF4_BCF5_984E466B5161 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.3512ABB7_9344_4EF4_BCF5_984E466B5161 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Ver.476E40C2_BF50_44F5_B79F_85F11E8470B6 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Gac.476E40C2_BF50_44F5_B79F_85F11E8470B6 property. Its value is 'c:Program FilesMicrosoft SQL Server90GAC'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SqlVer.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08 property. Its value is 'c:Program FilesMicrosoft SQL Server90'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding INSTALLDIR property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding finish1033.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding RES.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapResources'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Res11033.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapResources1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Help.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding Res21033.8DFD65FF_E015_42C8_B398_112982807348 property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp1033'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SETUPBIN property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapBin'. MSI (s) (70:FC) [08:56:24:090]: PROPERTY CHANGE: Adding SETUPLOG property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup BootstrapLog'. MSI (s) (70:FC) [08:56:24:090]: Target path resolution complete. Dumping Directory table... MSI (s) (70:FC) [08:56:24:090]: Note: target paths subject to change (via custom actions or browsing) MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: TARGETDIR , Object: c: MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: TempFolder , Object: c:DOCUME~1RickHLOCALS~1Temp MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsFolder , Object: c:WINDOWS MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: CommonFilesFolder.DCA909F7_1890_4AD6_9EAE_3C9D956FE00B , Object: c:Program FilesCommon Files MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: LocalAppDataFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication Data MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: LocalAppDataPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTH MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: LocalAppDataErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREP MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WatsonUQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQSIGNOFF MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WatsonUQRegularFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQREGULAR MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WatsonUQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Documents and SettingsRickHLocal SettingsApplication DataPCHEALTHERRORREPQHEADLES MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: ProgramFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program Files MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: CommonFilesFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon Files MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: SharedFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon FilesMicrosoft Shared MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: DWFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon FilesMicrosoft SharedDW MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: DWIntlFolder_1033.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:Program FilesCommon FilesMicrosoft SharedDW1033 MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWS MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsPCHealth.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTH MSI (s) (70:FC) [08:56:24:090]: Dir (target): Key: WindowsErrorReporting.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTHERRORREP MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WatsonAQSignoffFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTHERRORREPQSIGNOFF MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WatsonAQHeadlessFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSPCHEALTHERRORREPQHEADLES MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WindowsINFFolder.D0DF3458_A845_11D3_8D0A_0050046416B9 , Object: c:WINDOWSINF MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWS MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSsystem32 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxs MSI (s) (70:FC) [08:56:24:100]: 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) (70:FC) [08:56:24:100]: 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) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsManifests MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPolicies MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773 MSI (s) (70:FC) [08:56:24:100]: 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) (70:FC) [08:56:24:100]: Dir (target): Key: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWS MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSsystem32 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxs MSI (s) (70:FC) [08:56:24:100]: 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) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPolicies MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: c:WINDOWSwinsxsManifests MSI (s) (70:FC) [08:56:24:100]: 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) (70:FC) [08:56:24:100]: 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) (70:FC) [08:56:24:100]: Dir (target): Key: ProgramFilesFolder , Object: c:Program Files MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLSQLDIR , Object: c:Program FilesMicrosoft SQL Server MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: InstallDir.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPA.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARes1033.EF99D297_8F3F_42F1_8766_460250F41CDA , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA1033 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.41746B4B_478E_4AF6_946E_774617467ABF , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLDIR.41746B4B_478E_4AF6_946E_774617467ABF , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPA.41746B4B_478E_4AF6_946E_774617467ABF , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLDIR.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPA MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPASchemas.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPASchemas MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepository.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepository MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKR MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinDBUNWRI.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDBUNWRITABLE_UPGBLKRin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKR MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinYukUPBlock.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryYUK1_UPGBLKRin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIIS MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinRSDIIS.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIES MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinRSCA.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMASSEMBLIESin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEID MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinResDBID.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRESERVEDATABASEIDin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLE MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinLogin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryLOGINNAMEASSERVERROLEin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESID MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinDUPSid.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATESIDin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKR MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinDUPIdx.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryDUPLICATEINDEX_UPGBLKRin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepositoryASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTED MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPARepbinASP.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryASPNETUSERENCRYPTEDin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSDEFAULTIISYUKON.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKON MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSDEFAULTIISYUKON_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSDEFAULTIISYUKONin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSCUSTOMSECURITY.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITY MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RSCUSTOMSECURITY_bin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPARepositoryRSCUSTOMSECURITYin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: BPAbin.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBPAin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.741C00B4_26BA_4E42_B590_3D7E63AF2EC4 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.117A1A21_ACE1_414A_88CC_83C84195F101 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.117A1A21_ACE1_414A_88CC_83C84195F101 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.4845A713_8D8A_4100_8CAA_164C5AC9E452 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.4845A713_8D8A_4100_8CAA_164C5AC9E452 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.3512ABB7_9344_4EF4_BCF5_984E466B5161 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.3512ABB7_9344_4EF4_BCF5_984E466B5161 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Ver.476E40C2_BF50_44F5_B79F_85F11E8470B6 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Gac.476E40C2_BF50_44F5_B79F_85F11E8470B6 , Object: c:Program FilesMicrosoft SQL Server90GAC MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SqlVer.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08 , Object: c:Program FilesMicrosoft SQL Server90 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: INSTALLDIR , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: finish1033.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup Bootstrap1033 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: RES.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapResources MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Res11033.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapResources1033 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Help.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: Res21033.8DFD65FF_E015_42C8_B398_112982807348 , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapHelp1033 MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SETUPBIN , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapBin MSI (s) (70:FC) [08:56:24:100]: Dir (target): Key: SETUPLOG , Object: c:Program FilesMicrosoft SQL Server90Setup BootstrapLog MSI (s) (70:FC) [08:56:24:100]: PROPERTY CHANGE: Adding INSTALLLEVEL property. Its value is '1'. MSI (s) (70:FC) [08:56:24:100]: Disallowing installation of component: {1A6D8713-9116-44AE-BA60-4CF0E8C1D58B} since the same component with higher versioned keyfile exists Action start 8:56:24: CostFinalize. MSI (s) (70:FC) [08:56:24:120]: Doing action: ARPInstallLocation.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08 Action ended 8:56:24: CostFinalize. Return value 1. MSI (s) (70:FC) [08:56:24:120]: PROPERTY CHANGE: Adding ARPINSTALLLOCATION property. Its value is 'c:Program FilesMicrosoft SQL Server90Setup Bootstrap'. Action start 8:56:24: ARPInstallLocation.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08. MSI (s) (70:FC) [08:56:24:120]: Doing action: SetODBCFolders Action ended 8:56:24: ARPInstallLocation.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08. Return value 1. MSI (s) (70:FC) [08:56:24:120]: Note: 1: 2205 2: 3: ODBCDriver MSI (s) (70:FC) [08:56:24:120]: 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) (70:FC) [08:56:24:120]: Note: 1: 2205 2: 3: ODBCTranslator MSI (s) (70:FC) [08:56:24:120]: 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 8:56:24: SetODBCFolders. MSI (s) (70:FC) [08:56:24:120]: Doing action: MigrateFeatureStates Action ended 8:56:24: SetODBCFolders. Return value 0. MSI (s) (70:FC) [08:56:24:120]: Skipping MigrateFeatureStates action: feature settings already made Action start 8:56:24: MigrateFeatureStates. MSI (s) (70:FC) [08:56:24:120]: Doing action: InstallValidate Action ended 8:56:24: MigrateFeatureStates. Return value 0. MSI (s) (70:FC) [08:56:24:120]: Feature: SupportFiles; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlspars.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlsval.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: DbgHelp.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: setup.exe.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlcu.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: xmlrw.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: ARPWrapper.exe.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SqlBoot.dll.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: RedistQFEKey.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: CancelAutoplay.A78BF737_1F3C_4946_82B7_F6EC3A0BAA08; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: setupsql9.chm.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlspars.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: setup.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: sqlcu.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: ARPWrapper.rll.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: finish.txt.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: finish_sku.txt.8DFD65FF_E015_42C8_B398_112982807348; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Null MSI (s) (70:FC) [08:56:24:120]: Component: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Null MSI (s) (70:FC) [08:56:24:120]: Component: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Null MSI (s) (70:FC) [08:56:24:120]: Component: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: ExceptionMessageBox.dll.476E40C2_BF50_44F5_B79F_85F11E8470B6; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: WizardFrameworkLite.dll.3512ABB7_9344_4EF4_BCF5_984E466B5161; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.FB6C1C52464E44DC8FDC03E5FCADA0D2; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.65B0CF1C908640AD8A72C6C615216394; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: Microsoft.SqlServer.GridControl.dll.4845A713_8D8A_4100_8CAA_164C5AC9E452; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: Microsoft.SqlServer.Setup.117A1A21_ACE1_414A_88CC_83C84195F101; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.D7B464C2927E4A57AC167006E343B1A1; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.A6AED2EF66B84CCCB5FC3C32CF6E2253; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MS.Sql.CustomControls.dll.741C00B4_26BA_4E42_B590_3D7E63AF2EC4; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.7CFE79FEC34C4C79B0387EF66E24ECA0; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SxSComp.A3A47DFCA5F64B03AC400222997E22E9; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: Sql_AsmPublicKeys.6E1C5F41_647A_4340_A91C_FC4906A1EC10; Installed: Absent; Request: Local; Action: Null MSI (s) (70:FC) [08:56:24:120]: Component: MSS.AnalysisServices.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.BestPracticesAnalyzer.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.DTS.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.NotificationServices.UA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.SString.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.UpgradeAdvisor.UaEngine.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: MSS.UpgradeAdvisor.UaInterface.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: UACmd.exe.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpacmd.exe.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BpaCmdX.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SQLBPA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SQLSORT.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: SQLDATA.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BPAClient.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpacommon.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BPAdmin.exe.config.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BPAServer.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: BPLib.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RSCUSTOMSECURITY.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RSDEFAULTIISYUKON.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.ASPNETUSERENCRYPTED.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.DUPLICATEINDEX_UPGBLKR.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.DUPLICATESID.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.LOGINNAMEASSERVERROLE.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RESERVEDATABASEID.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request: Local; Action: Local MSI (s) (70:FC) [08:56:24:120]: Component: bpa.RSCUSTOMASSEMBLIES.dll.9164C7A9_1051_4AA4_85FD_6C5B2CDCAE4B; Installed: Absent; Request:
I 'm trying to install Sql Server 2005 Express Edition using c# 2.0 by starting a process and launching setup. I also want to informed about installation progress. For instance i want to inform end user if any installation error return or if setup has successfully completed etc. I think i need a callback... I have no problem about silent - unattended install but how can i informed about running installation progress ? and send these info to end user 's form ?
Does anyone know the best way to set up NT security. It seems a little confusing as to how to set up NT groups and assign permissions (where do the roles come into it?).
I face the following problem and want to ask if there is a simple way to solve.
we have already running an IS API Filter which handles the authentication for all websites. The fiter is built to secure all websites. It verfies access to URLs and authrize users against an LDAP Directory. Affer the user has authenticated he can connect to the website. The ISAPI Filter sets the LOGONUSER Severvariable so the website can do userspecific filtering.
With the same ISAPI Filter we want to secure report server.
We want to setup roles with usernames to allow or deny specific reports. (this usernames should be validated against the servervariable LOGONUser - by String Comparison).
We do not have any windows authenitcation - and do not need.
The ReportServer User Variable should return this LOGON User to allow report secific data filtering
Hi All, I have trouble with SQL Server 2005. I downloaded last night trial evolution. And I want to intall it but I cant progress after some points. And pop-up window appears with a msg that
TITLE: Microsoft SQL Server Setup ------------------------------ SQL Server Setup could not validate the service accounts. Either the service accounts have not been provided for all of the services being installed, or the specified username or password is incorrect. For each service, specify a valid username, password, and domain, or specify a built-in system account. For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.06&EvtSrc=setup.rll&EvtID=SQLSetup90&EvtType=28075
And I opened the link above it says I must enter a strong password and I have done but I couldnt pass the step again.
I have posted this issue for a week, haven't got any reply yet, I posted it again and desperately need your help.
The article http://msdn2.microsoft.com/en-us/library/ms365343.aspx says: Model Item Security can be set for differnt security filters, but when I use SQL Server Management Studio to set Model Item Security, it seems "Permissions" property surpass "Model Item Security" property. -- My report server is using Custom Authentication.
For example, in "Permissions" property of the model, if I checked "Use these roles for each group or user account" without setting any user or group, no matter what users I added to "Model Item Security" with "Secure individual model items independently for this model" checked, NO one user can see the model on report manager and report builder;
in above situation, if I added "user1" and gave role such as "Browser" role to "user1" in "Permissions" property, if I checked "Secure individual model items independently for this model" in "Model Item Security" property, even I did NOT grant "user1" to root model and any entities under the model, the "user1" is able to access the model and all entities in report builder.
My question is on the same report model, how to set "AdminFilter" (empty security filter) for administrator permissions and set "GeneralFilter" (filtered on UserID) for general user based on their UserID?
The article also says:
"Security filters are always applied, even for users who have Content Manager or Administrator permissions to the model. To allow administrators or other users to see all rows of an entity on which row-level security is defined, you can create an empty security filter (which always returns True) and then use the filter to grant those users access to all the rows."
So I defined 2 filters "GeneralFilter" and "AdminFilter" for "Staff" entity for my report model "SSRSModel", I expect after I deployed the report model, the administrator users use report builder to build reports with all rows available, and the non-admin users can only see rows based on their UserID.
I can only get one result at a time but not both:
either the rows are filtered or not filtered at all, no matter how I set the "SecurityFilter" for the entity: I tried setting both "AdminFilter" and "GeneralFilter" for SecurityFilter at the same time, combination of "DefaultSecurityFilter" and "SecurityFilter", or one at a time.
Hi All, We have a Progress DB in our Company. We are trying to move all the data to SQL Server 2005. When I try to run the Import Data task from SQL Server 2005 the radio button called "Copy data from one or more tables or views" is getting disabled and it is asking me to write a SQL script to copy all data from 120 tables.
I am using a .NET Framework Data Provider for ODBC when I run the Import Data task from SQL Server 2005.
I am using the DataDirect 4.1 32-Bit Progress SQL92 v9.1D ODBC Driver to connect to Progress DB. I am getting a connection but the copy feature is getting disabled.
Can anyone please help me to resolve this issue, or even if you provide me with some pointers that will be really helpful.
I am writing an Internet/Extranet based (ASP.Net 2.0) web application that uses SQL server 2005 as the database. I am using forms authentication on my web application. I am also storing the connection string to SQL server in my web config file. The conn string is encrypted using DPAPI with entropy. I currently have created a SQL login account on my SQL server for use by the web application. This is the user ID I am using in my conn string. The reason for this is because all persons using the application will NOT have a windows login.
Here is my question: The login I created currently has defaulted to the "dbo" role and therefore has "dbo" rights to the database. I want to setup up this login account so that all it can do is execute stored procedures. I dont want this SQL login to be able to do anything else. In my application I am using stored procedures for ALL data access functions, via a data access layer in my application. Can someone guide me step by step as to how to setup this type of access for this SQL login.
Last night at home on my 64 bit Vista machine, I encountered the same error 29506 that said that the management studio express could not be installed. I looked up the error message and below is what I received. I also installed the 64 bit .net framework which installed just fine before trying to install the SSSME.
I followed the instructions below but this did not seem to make a difference. However, I did not reboot after applying new permissions. I have installed this software a few times now on 32 bit machines for both XP and RC1 Vista, and have not had a problem. Last night, I did use the 64 bit version. Also, there is no data file yet because after the install it rolls back, so I gave myself Full permissions on the SQL server directory which should include all sub directories, right? Thanks, Teri Error 29506. SQL Server Setup failed to modify security permissions on file Drive:Program FilesMicrosoft SQL ServerMSSQL.xMSSQLData for user SYSTEM. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
Note A SQL Server service pack refers to SQL Server 2005 Service Pack 1 (SP1) and later service packs. CAUSE This problem occurs because one or more data files exist that do not have the required permissions. By default, the Full Control permission of the Administrators group is granted to the data file when you create a database. If the permission of this group is removed from the data file, the SQL Server 2005 service pack setup will fail. RESOLUTION To resolve this problem, grant the Full Control permission to the Administrators group on all data files and on the Data folder. To grant the Full Control permission to the data files, follow these steps:
1. Locate the folder that contains the data files. By default, these files are located in the following folder: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData
2. Right-click the data file that has no required permissions for the Administrators group, and then click Properties.
3. If the Administrators group is not in the Group or user names list, click Add, type Administrators, and then click OK.
4. Click Administrators in the Group or user names list, and then click to select the Allow check box for the Full Control item in the Permissions for Administrators list.Note If the files in the Data folder have an orphan owner, you have to take ownership of the files and then grant the Full Control permission to the files. We recommend that you do not change the default permissions for the data files.
Trying to install SQL Server 2005 x64 Enterprise Edition during the "Workstation components, etc." part of the install, the install stops and gives me this error.
---------------------- Microsoft SQL Server 2005 Setup Failed to install and configure assemblies C:Program Files (x86)Microsoft SQL Server90NotificationServices9.0.242Binmicrosoft.sqlserver.notificationservices.dll in the COM+ catalog. Error: -2147024893 Error message: The system cannot find the path specified. Error description: Could not load file or assembly 'System.EnterpriseServices.Wrapper.dll' or one of its dependencies. The system cannot find the path specified. [Abort] [Ignore] [Retry]
----------------------
This install is being attempted on 3 seperate servers all running Windows Server 2003 R2 Enterprise x64 Edition (Service Pack 2).
Futher notes: Distributed Transaction Coordinator services is setup and running (started). I checked to make sure there are no MSMQ components in the COM+ Application struture in Component Services.
Here's a really annoying problem. Let's say you have a text file with 2 million rows.Delimiters all look good and rows are previewed well but the file has a missing row at say lin 1234567 - way deep in the file. When SSIS encounters the blank row, an error is raised and processing on the file STOPS! I verified this in by checking the SSIS log and have even developed an error routine to notify me via email when the error occurs (really cool if I do say so myself ). The main problem still remains - how to resume processing from the point of failure in the file? Any help is appreciated. Thanks.
I have Sql Server Express installed on Vista (service pack 2)
I have Visual Studio 2005 with an application that I'm trying to access it with within a WCF service.
The login ID of the service is added to the database.
The database has remote access turned on.
The ID is granted access to all databases within the server.
The thread is being set with WindowsProvider and the services set their thread to WindowsProvider.
The dataserver is set with using Windows Authentication for security.
When I open my connection to the database, though, it reports the typically useless message that the connection is not allowed and that the server may not allow remote connections.
How to I get past this? I've done everything right.
MSI (s) (D8!A0) [21:07:09:062]: Product: Microsoft SQL Server 2005 -- Error 29506. SQL Server Setup failed to modify security permissions on file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData for user Administrator. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
Tried running install with a domain account and local account with same results.
Based on the error message, I checked permission on the drive and still received the same error.
Followed resolution based on KB 916766, this did not resolve the error.
Only possible resolution I found was to disable UAP, reboot and retry the install. This will be done as a last resort, but any other suggestion will be appreciated.
If i wanted to set up my SQL Server DB to run in an Application Server environment (i.e. clients connecting to a remote server) would i be required to give every user a WINDOWS SERVER logon as well as a SQL Server logon or would i only need to setup just a SQL Server logon for them? (obviously using SQL Server Security opposed to NT Integrated Security)
After I login into the Reports Server (<servername>/Reports1/Pages/UILogon.aspx?) the Home page is blank ( accpet for links to Home |MySubscriptions | Help in the upper right corner). Please read on before thinking you know the answer. I am using Reporting Services with Forms Authentication with a custom security extension. In the LogonUser methothd I validate the user and return True if the user is good. Should I be doing anything else in this method or any of the other methods in my custom extension? I'm asking because, I can use Sql Server Management Studio to login into the Reporting Server, view any folders such as the Data Sources or Models folder, but can't make any changes. In the Users table in the ReportServer database the user I'm logging in with has a UserType of 0 and AuthType of 3. I've tride changing these to match the BUILTINAdministrators user but still no luck. Also, I can not login as the BUILTINAdministrators because that user would not be in our database. Any help with this is appreciated. Thanks.
We are working on a new Payroll server. Our payroll department wants to lock out MIS and SQL Admins as much as possible. What we would like to do is allow the SQL Admins to still perform admin tasks such as backups, audit tracking, etc, while not being able to get into the tables. Also, we would prefer to do this security at the database level, rather than the server level. Any thoughts on this?
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
We are using SQL 2005 / Windows Server 2003 / Sharepoint portal.
Our reports are used through Sharepoint. I have added a web part which displays the folders. There are several reports within each of the folders. Users that have access to the Sharepoint site have access to all of the reports that are available in all of the folders. I would like to control folder access through SSRS.
Hi I just deploy a report model and want use report builder to create ad-hoc using this report model. I want some entitis and attributes are not visiable for some user, so I config the model item security for this model. But no matter which user I use to login the report server, I always can access all the entities. Even I delete all the groups and users in "Permissions" property of the model, I still can access this model through report builder. All the user I used to test are local user of server with report service, my server is SQL Server 2005+SP2.
I am having a little trouble with my SRS installation. I have a fresh-out of the box server running Win 2003. I installed SQL & SRS on it. I have successfully deployed my report project and can run reports, etc.
The problem is, even when logged in on the console as the local admin, I can't seem to perform the usual administrative functions on the report server- simple things like hide items in list view. I have no menu options for any of the security stuff, either. I though that the local admin was able to do these things by default. I have a feeling that this has something to do with active directory & role membership? It is like the administrator only has guest privledges.
When I connect to the report server from management studio, I can see the roles but no information about users, no options ot add users to the roles, either. My goal is to simply add a user (Administrator) to the proper role to be able to configure the report server environment.
For what it is worth, this box is simply set up in my home office, no domain, etc. Please be gentle, I am mainly a SQL geek, very little knowledge of Server OS & Windows security.
Hello, I would like to know if anyone here has any information on how to change the default version of SQL Server 2005 Express which ships with Visual Studio 2005 to the new SQL 2005 Express SERVICE PACK 1?
I see a file under disc:vswcuSSESQLEXPR.exe I am wondering if changing that file with the new one from Microsoft Download Center will do it...
There's another file under that folder named sqlexpr32.exe I am wondering what it's for?
We have vendor that is implementing an employee self serve application for current and potential employees (employment applications). There is a web server in our DMZ that has the application installed but also on the server is a SQL database that has names and social security numbers. This server will also query the backend accounting server for earnings statements and W2s. We have a Cisco ASA as the firewall and SSL to protect client authentication from the Internet. There is no SSL between the web server and the accounting server. The fact that the SQL database on the web server containing SSN associated with names concerns me. It seems that none of this information is masked or encrypted and can be seen if the server was to ever be compromised.
My idea of such a service involves a web server that queries the backend database over SSL and presents the information to the user over SSL. No personally identifiable information would be resident on the web server at all, just a facade. That is not the case and it is not what we described to them as to what we want.
It seems they have installed it the only way they know how which is not secure, or maybe it is, that's why I am here. They have installed this at numerous locations and they actually wanted any and all ports open between the web server and the backend accounting server. It took us a while to get them to follow the rule of least privilege but we essentially had to do it ourselves.
Also on our main webserver for our Internet site I found the test database they used almost 2 years ago to test this application along with names and SSN. This was before I arrived and there is no encryption or authentication for this server. Is this good secure practice? All my training says no but it is hard to believe a mutli-million dollar organization is this ignorant. I guess it shouldn't surprise me, TJX didn't pay attention either.
I saw this thread which provide some good information but I am not a database admin and I am not familiar with SQL services, etc.
My questions are: Is their implementation secure? Does anyone know where I can find more info regarding web services and HIPAA? I read where 2 firewalls are required but would like documentation to show. Any suggestions on how to implement this securely?
I have just reciently installed and started upgrading the last beta code to this beta and am having a problem conecting to my sqlinstance with the WebSite Configuration Tool.
I'm installing SQL Server Express SP1 on a new Windows XP Pro SP2 laptop that is part of a corporate network. The last item in the Setup Progress dialog box says:
Workstation Components, Books Online and Development Tools....Setup failed. Refer to log file.
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt looks fine except for the last few lines:
-------------------------------------------------------------------------------- Machine : ROVER Product : Microsoft SQL Server 2005 Tools Product Version : 9.1.2047.00 Install : Failed Log File : c:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0004_ROVER_Tools.log Last Action : InstallFinalize Error String : SQL Server Setup failed to modify security permissions on WMI namespace \. ootMicrosoftSqlServerComputerManagement. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that the WMI namespace exists on the destination drive. Error Number : 29516
Is this a common error when installing on a PC that is part of a corporate network? I didn't dig too far into SQLSetup0004_ROVER_Tools.log; however, it contains a few references to "SOFTWARE RESTRICTION POLICY".
Other than this error, SQL Server Express seems to be working ok. Is this anything to be concerned about?
Hi All, I'am looking for a software (Installer) to create a setup file to install a SQL Server Database just like the one in the Reports Starter Kit, when you install it a dialog will guide you to instaal the database thats what i'am looking for. Anybody knows how can i do that or is there a software that can help me doing that.Best Regards.Wafi Mohtaseb
I am working on SQL Server 2014 and I want to know, Is it possible to change the location of SQL log file and will it affect to the database if it is possible to change its location?