Skills for 2.5 Years SQL Server Developer

Data too large for file format

PerfTime Stop: RestoreSetupParams : Mon Jan 01 20:30:14 2001MSI (s) (DC:8C) [20:30:14:421]: Doing action: ShutdownServiceManager_32Action ended 20:30:14: RestoreSetupParams_32. Return value 1.MSI (s) (DC:F0) [20:30:14:500]: Invoking remote custom action. DLL: C:WindowsInstallerMSI4C11.tmp, Entrypoint: ShutdownServiceManagerAction start 20:30:14: ShutdownServiceManager_32.Function=ShutdownServiceManagerDoing Action: ShutdownServiceManagerPerfTime Start: ShutdownServiceManager : Mon Jan 01 20:30:14 2001PerfTime Stop: ShutdownServiceManager : Mon Jan 01 20:30:14 2001MSI (s) (DC:8C) [20:30:14:750]: Doing action: Write_sqlWellKnownAccountNames_32Action ended 20:30:14: ShutdownServiceManager_32. Return value 1.MSI (s) (DC:E8) [20:30:14:828]: Invoking remote custom action. DLL: C:WindowsInstallerMSI4D5A.tmp, Entrypoint: Write_sqlWellKnownAccountNamesAction start 20:30:14: Write_sqlWellKnownAccountNames_32.Function=Write_sqlWellKnownAccountNamesDoing Action: Write_sqlWellKnownAccountNamesPerfTime Start: Write_sqlWellKnownAccountNames : Mon Jan 01 20:30:15 2001MSI (s) (DC!BC) [20:30:15:078]: PROPERTY CHANGE: Adding AdministratorsGroup property. Its value is ‘BUILTINAdministrators’.MSI (s) (DC!BC) [20:30:15:078]: PROPERTY CHANGE: Adding PerformanceMontiorUsersGroup property. Its value is ‘BUILTINPerformance Monitor Users’.MSI (s) (DC!BC) [20:30:15:078]: PROPERTY CHANGE: Adding PerformanceLogUsersGroup property. Its value is ‘BUILTINPerformance Log Users’.MSI (s) (DC!BC) [20:30:15:093]: PROPERTY CHANGE: Adding UsersGroup property. Its value is ‘BUILTINUsers’.MSI (s) (DC!BC) [20:30:15:093]: PROPERTY CHANGE: Adding NetworkServiceAccount property. Its value is ‘NT AUTHORITYNETWORK SERVICE’.MSI (s) (DC!BC) [20:30:15:093]: PROPERTY CHANGE: Adding SCMNetworkServiceAccount property. Its value is ‘NT AUTHORITYNetworkService’.MSI (s) (DC!BC) [20:30:15:109]: PROPERTY CHANGE: Adding LocalSystemAccount property. Its value is ‘NT AUTHORITYSYSTEM’.MSI (s) (DC!BC) [20:30:15:109]: PROPERTY CHANGE: Adding LocalServiceAccount property. Its value is ‘NT AUTHORITYLOCAL SERVICE’.MSI (s) (DC!BC) [20:30:15:109]: PROPERTY CHANGE: Adding SCMLocalServiceAccount property. Its value is ‘NT AUTHORITYLocalService’.PerfTime Stop: Write_sqlWellKnownAccountNames : Mon Jan 01 20:30:15 2001MSI (s) (DC:8C) [20:30:15:156]: Skipping action: PropSetSQLAutoStart_32 (condition is false)MSI (s) (DC:8C) [20:30:15:156]: Doing action: CheckIIS_32Action ended 20:30:15: Write_sqlWellKnownAccountNames_32. Return value 1.MSI (s) (DC:F0) [20:30:15:218]: Invoking remote custom action. DLL: C:WindowsInstallerMSI4EE2.tmp, Entrypoint: CheckIISAction start 20:30:15: CheckIIS_32.Function=CheckIISDoing Action: CheckIISPerfTime Start: CheckIIS : Mon Jan 01 20:30:15 2001MSI (s) (DC!F4) [20:30:15:453]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is ‘0’.MSI (s) (DC!F4) [20:30:15:453]: PROPERTY CHANGE: Adding SqlIISInstalled property. Its value is ‘1’.MSI (s) (DC!F4) [20:30:15:453]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is ‘1’.Skipping RS Feature Dependency CheckError to find XML node /configuration/system.web/compilationFailed to get ModuleID_RS_Server when getting the ASP Temp directory.MSI (s) (DC!F4) [20:30:16:515]: PROPERTY CHANGE: Adding SqlCOMPlusInstalled property. Its value is ‘1’.Could not get the ASP temp directory.MSI (s) (DC!F4) [20:30:16:531]: PROPERTY CHANGE: Adding RSPREREQUISITECHECKED property. Its value is ‘1’.MSI (s) (DC!F4) [20:30:16:531]: PROPERTY CHANGE: Modifying IISCHECKED property. Its current value is ‘0’. Its new value: ‘1’.SqlCOMPlusInstalled value set to 1PerfTime Stop: CheckIIS : Mon Jan 01 20:30:16 2001MSI (s) (DC:8C) [20:30:16:562]: Skipping action: CheckForGDRPatch_32 (condition is false)MSI (s) (DC:8C) [20:30:16:562]: Doing action: CheckPassedPropertiesLength_32Action ended 20:30:16: CheckIIS_32. Return value 1.MSI (s) (DC:90) [20:30:16:640]: Invoking remote custom action. DLL: C:WindowsInstallerMSI5471.tmp, Entrypoint: CheckPassedPropertiesLengthAction start 20:30:16: CheckPassedPropertiesLength_32.Function=CheckPassedPropertiesLengthDoing Action: CheckPassedPropertiesLengthPerfTime Start: CheckPassedPropertiesLength : Mon Jan 01 20:30:16 2001MSI (s) (DC!2C) [20:30:16:843]: PROPERTY CHANGE: Adding RSSqlPoolLimit property. Its value is ‘100’.CheckPassedPropertiesLength:  Property USERNAME is of legal length.PerfTime Stop: CheckPassedPropertiesLength : Mon Jan 01 20:30:16 2001MSI (s) (DC:8C) [20:30:16:875]: Doing action: Create_RSGUID_32Action ended 20:30:16: CheckPassedPropertiesLength_32. Return value 1.MSI (s) (DC:D4) [20:30:16:953]: Invoking remote custom action. DLL: C:WindowsInstallerMSI55AA.tmp, Entrypoint: Create_RSGUIDAction start 20:30:16: Create_RSGUID_32.Function=Create_RSGUIDDoing Action: Create_RSGUIDPerfTime Start: Create_RSGUID : Mon Jan 01 20:30:17 2001MSI (s) (DC!9C) [20:30:17:156]: PROPERTY CHANGE: Adding RSGUIDVALUE property. Its value is ‘{5b7c2025-5dcc-48b0-8894-8927d9671a31}’.Starting Create_RSGUIDCreated new GUID: {5b7c2025-5dcc-48b0-8894-8927d9671a31}PerfTime Stop: Create_RSGUID : Mon Jan 01 20:30:17 2001MSI (s) (DC:8C) [20:30:17:187]: Doing action: SetAutoSAPWDAndDisableAction ended 20:30:17: Create_RSGUID_32. Return value 1.MSI (s) (DC:8C) [20:30:17:250]: PROPERTY CHANGE: Adding saSetAutoSAPWDAndDisable property. Its value is ‘1’.Action start 20:30:17: SetAutoSAPWDAndDisable.MSI (s) (DC:8C) [20:30:17:250]: Doing action: FindRelatedProductsAction ended 20:30:17: SetAutoSAPWDAndDisable. Return value 1.MSI (s) (DC:8C) [20:30:17:312]: Skipping FindRelatedProducts action: not run in maintenance modeAction start 20:30:17: FindRelatedProducts.MSI (s) (DC:8C) [20:30:17:312]: Doing action: AppSearchAction ended 20:30:17: FindRelatedProducts. Return value 0.Action start 20:30:17: AppSearch.MSI (s) (DC:8C) [20:30:17:375]: PROPERTY CHANGE: Adding RSFXINSTALLED_32 property. Its value is ‘C:Program FilesMicrosoft sql  Server100SharedRsFxInstall’.MSI (s) (DC:8C) [20:30:17:390]: PROPERTY CHANGE: Adding DW20PATH_X86 property. Its value is ‘C:PROGRA~1COMMON~1MICROS~1DWDW20.EXE’.MSI (s) (DC:8C) [20:30:17:390]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\Setup 3: 161 Info 1402. Could not open key: HKEY_LOCAL_MACHINE\Setup.  System error  161.  Verify that you have sufficient access to that key, or contact your support personnel. MSI (s) (DC:8C) [20:30:17:406]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\MSSQLServerFilestream 3: 161 Info 1402. Could not open key: HKEY_LOCAL_MACHINE\MSSQLServerFilestream.  System error 161.  Verify that you have sufficient access to that key, or contact your support personnel. MSI (s) (DC:8C) [20:30:17:406]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\MSSQLServerFilestream 3: 161 Info 1402. Could not open key: HKEY_LOCAL_MACHINE\MSSQLServerFilestream.  System error 161.  Verify that you have sufficient access to that key, or contact your support personnel. MSI (s) (DC:8C) [20:30:17:421]: Note: 1: 1402 2: HKEY_LOCAL_MACHINE\MSSQLServerFilestream 3: 161 Info 1402. Could not open key: HKEY_LOCAL_MACHINE\MSSQLServerFilestream.  System error 161.  Verify that you have sufficient access to that key, or contact your support personnel. MSI (s) (DC:8C) [20:30:17:421]: Note: 1: 1325 2: v2.0.50727 MSI (s) (DC:8C) [20:30:17:421]: Note: 1: 1325 2: EventLogMessages.dll MSI (s) (DC:8C) [20:30:17:421]: PROPERTY CHANGE: Adding ASPNET_EVENTLOGDLL property. Its value is ‘C:WindowsMicrosoft.NETFrameworkv2.0.50727EventLogMessages.dll’.MSI (s) (DC:8C) [20:30:17:437]: PROPERTY CHANGE: Adding UI_INSTALLSQLSHAREDDIR property. Its value is ‘C:Program FilesMicrosoft SQL Server’.MSI (s) (DC:8C) [20:30:17:453]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESOFTWAREMicrosoftVisualStudio7.0 3: 2 MSI (s) (DC:8C) [20:30:17:515]: PROPERTY CHANGE: Adding SQLIEMINVERSION property. Its value is ‘C:Windowssystem32shdocvw.dll’.MSI (s) (DC:8C) [20:30:17:515]: PROPERTY CHANGE: Adding SQLSETUPARPWRAPPER property. Its value is ‘C:Program FilesMicrosoft SQL Server100Setup Bootstrapsetup100.exe’.MSI (s) (DC:8C) [20:30:17:515]: Doing action: DetectSKUOS_32Action ended 20:30:17: AppSearch. Return value 1.MSI (s) (DC:50) [20:30:17:593]: Invoking remote custom action. DLL: C:WindowsInstallerMSI582C.tmp, Entrypoint: DetectSKUOSAction start 20:30:17: DetectSKUOS_32.Function=DetectSKUOSSkipping Action: DetectSKUOS (Condition is false)MSI (s) (DC:8C) [20:30:17:718]: Skipping action: DetectWYukonOS_32 (condition is false)MSI (s) (DC:8C) [20:30:17:718]: Skipping action: SetEnableRanu (condition is false)MSI (s) (DC:8C) [20:30:17:718]: Skipping action: SetErrorReporting (condition is false)MSI (s) (DC:8C) [20:30:17:718]: Skipping action: SetSqmReporting (condition is false)MSI (s) (DC:8C) [20:30:17:718]: Doing action: FindUpgradeableProduct_32Action ended 20:30:17: DetectSKUOS_32. Return value 1.MSI (s) (DC:84) [20:30:17:796]: Invoking remote custom action. DLL: C:WindowsInstallerMSI58F8.tmp, Entrypoint: FindUpgradeableProductAction start 20:30:17: FindUpgradeableProduct_32.Function=FindUpgradeableProductDoing Action: FindUpgradeableProductPerfTime Start: FindUpgradeableProduct : Mon Jan 01 20:30:17 2001PerfTime Stop: FindUpgradeableProduct : Mon Jan 01 20:30:18 2001MSI (s) (DC:8C) [20:30:18:078]: Doing action: SetInstanceProperty_32Action ended 20:30:18: FindUpgradeableProduct_32. Return value 1.MSI (s) (DC:00) [20:30:18:156]: Invoking remote custom action. DLL: C:WindowsInstallerMSI5A60.tmp, Entrypoint: SetInstancePropertyAction start 20:30:18: SetInstanceProperty_32.Function=SetInstancePropertyDoing Action: SetInstancePropertyPerfTime Start: SetInstanceProperty : Mon Jan 01 20:30:18 2001MSI (s) (DC!70) [20:30:18:500]: PROPERTY CHANGE: Adding RemoveFeatureList property. Its value is ‘SQL_DUMPER_LOC,SQL_ENGINE_CORE,SQL_ENGINE_CORE_LOC,MPT_AGENT_CORE_LOC,SQL_Engine,SQL_AGENT,SQL_AGENT_LOC,SQL_CMDLINETOOLS_LOC,SQL_LEGACYTOOLS,SQL_LEGACYTOOLS_LOC,SQL_MAIL,SQL_MAIL_LOC,SQL_UPGRADESCRIPTS,SQL_SFC_LOC,SQL_DMF_LOC,SQL_DATA_COLLECTOR_LOC,SQL_AMO,SQL_AMO_LOC,SQL_ADOMD_LOC,SQL_REPL_ENGINE_SUPPORT,SQL_REPL_ENGINE_SUPPORT_LOC,SQL_SLP_BASE_LOC,SQL_SLP_ENGINE_SUPPORT_LOC,SQL_Replication,SQL_FullText,SQL_BC_DEP,SQL_ENGINE_DB,SQL_BROWSER,SQL_DUMPER,SQL_SCHEMAS,MPT_AGENT_CORE,SQL_CMDLINETOOLS,SQL_SFC,SQL_DMF,SQL_DATA_COLLECTOR,SQL_AS_EXPRESS,SQL_ADOMD,SQL_SLP_BASE,SQL_SLP_ENGINE_SUPPORT,SQL_SharedTools’.MSI (s) (DC!70) [20:30:18:515]: PROPERTY CHANGE: Adding SqlOriginalMachineName property. Its value is ‘SRV01’.MSI (s) (DC!70) [20:30:18:515]: PROPERTY CHANGE: Adding SqlLegacyRegPath property. Its value is ‘Microsoft SQL ServerSQL2K8’.MSI (s) (DC!70) [20:30:18:578]: PROPERTY CHANGE: Adding PreviousInstId property. Its value is ‘MSSQL10.SQL2K8’.Using instanced id: MSSQL10.SQL2K8MSI (s) (DC!70) [20:30:18:578]: PROPERTY CHANGE: Adding InstId property. Its value is ‘MSSQL10.SQL2K8’.Previous instance id: MSSQL10.SQL2K8MSI (s) (DC!70) [20:30:18:593]: PROPERTY CHANGE: Adding InstanceName property. Its value is ‘SQL2K8’.Using instance name: SQL2K8MSI (s) (DC!70) [20:30:18:609]: PROPERTY CHANGE: Adding PrevRegRootPath property. Its value is ‘SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2K8’.Using PrevRegRootPath: SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2K8RegOpenKeyEx failed  on Key(SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2K8MSSQLServerParameters) with returncode 2RegOpenKeyEx failed on Key(SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2K8MSSQLServerParameters) with returncode 2RegOpenKeyEx failed on Key(SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2K8MSSQLServerParameters) with returncode 2MSI (s) (DC!70) [20:30:18:640]: PROPERTY CHANGE: Adding InstanceName_32 property. Its value is ‘SQL2K8’.RegOpenKeyEx failed on Key(SoftwareMicrosoftMicrosoft SQL ServerMSSQL10.SQL2K8MSSQLServerParameters) with returncode 2GetServiceUserGroup failed for SQL2K8, 5        Error Code: 0x80070534 (1332)Windows Error Text: No mapping between account names and security IDs was done.  Source File Name: sqlcasqlcax.cppCompiler Timestamp: Thu Nov  8 02:41:18 2007     Function Name: SetInstancePropertySource Line Number: 1174Error Code: 1332MSI (s) (DC!70) [20:30:18:765]: Product: Microsoft SQL Server 2008 — Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation./

large for file format

Robert,I see the error  :GetServiceUserGroup failed  for SQL2K8, 5        Error Code: 0x80070534 (1332)Windows Error Text: No mapping between account names and security IDs was done.Looks like a SID mismatch case. Try this to fix :1. Type compmgmt.msc at run prompt , this will open Computer Management.2. Go to Computer Management > Local Users and groups > Groups .3. Check that Security Groups exist in the format as below :a. SQLServer2005MSSQLUser$SERVERNAME$INSTANCENAMEb. SQLServer2005MSFTEUser$SERVERNAME$INSTANCENAMEd. SQLServer2005SQLAgentUser$SERVERNAME$INSTANCENAMEc. SQLServer2005SQLBrowserUser$SERVERNAMEd. SQLServer2005MSSQLServerADHelperUser$SERVERNAMEe. SQLServer2005NotificationServicesUser$SERVERNAME4. Make sure that administrator or the current user having admin rights is added in above groups.5. Now , we have to find correct SID for each of these groups. I will explain an example of SQLServer2005MSSQLUser$SERVERNAME$INSTANCENAME6. Download Pstools.zip from http://technet.microsoft.com/en-us/sysinternals/bb897417.aspx7. Extract and locate psgetsid.exe , say psgetsid.exe is at C:PsToolspsgetsid.exe 8. Open command prompt and type as below :C:PsToolspsgetsid.exe SQLServer2005MSSQLUser$SERVERNAME$INSTANCENAMEPsGetSid v1.43 – Translates SIDs to names and vice versaCopyright (C) 1999-2006 Mark RussinovichSysinternals – www.sysinternals.comSID for SQLServer2005MSSQLUser$SERVERNAME$INSTANCENAME:S-1-5-21-1348685464-4023934854-1168248492-1060 9. Note down the above SID and compare it with the on stored in the registry for SQLGroup (steps demostrated further) because we found this SID for SQLServer2005MSSQLUser means a SQLGroup.10. Type regedit and navigate to HKEY_LOCAL_MACHINESOFTWAREMicrosoftMicrosoft SQL ServerMSSQL.1Setup11. See the SID of SQLGroup , if it doesn’t match with the one we just found then update it with new one.12. Follow the steps 8 to 12 for FTSGroup and AGTGroup .13. Now run the setup, should succeed.HTH