I have been using 'MSXML2.ServerXMLHttp.4.0' to make web requests from SQL server with no problems for about 6 months now (on Win2K Servers).
Now trying to move the databases onto a new 2003 server and getting the well known 'Access denied' error message. I beleive I have sorted out the following:
- Execute permissions on the master database for sp_OACreate, sp_OAGetErrorInfo,.....
- Allowed 'All unkown ISAPI Extensions' - not that I'm happy about that!!
- Uninstalled the 'Internet Explorer Enhanced Security Configuration'
- I have enabled 'Submit nonencrypted form data' for the relevant zones in IE Security Settings
But none of these seem to have had an effect. I have also tried using WinHTTP.WinHTTPRequest.5.1 as suggested in a MS KB article, but this is not suitable as I need to pass authenitication parameters with each request, and it seems as though the response size is limited.
If anyone has any tips/checklists for getting this going I would be very interested.
I need help! When installing SQL Server 2005 Express on one machine, I get an error with the following summary.txt Machine : xxx Product: MSXML 6.0 Parser Product version: 6,10,1129,0 Installed: Failed. Log file: c:Program Files... (see below) Error Number: 1625
in log file from above. MainEngineThread is returning 1625 This installation is forbidden by system policy. Contact your system administrator.
The person trying to install has administration privileges. BTW: The computer shares a wireless internet connection with other computers in the office but the clients or not setup to share data. My user is installing SQL, the data, and app on a single client. The MS Sql Server 2005 express seems to install on all other boxes. Thanks for your time.
I can't install SQL 2005 Delveloper edition and show error with MSXML component
It shows these massage:
=== Verbose logging started: 6/11/2007 17:17:36 Build type: SHIP UNICODE 3.01.4000.4003 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe === MSI (c) (A8:90) [17:17:36:545]: Resetting cached policy values MSI (c) (A8:90) [17:17:36:545]: Machine policy value 'Debug' is 0 MSI (c) (A8:90) [17:17:36:545]: ******* RunEngine: ******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi ******* Action: ******* CommandLine: ********** MSI (c) (A8:90) [17:17:36:545]: Client-side and UI is none or basic: Running entire install on the server. MSI (c) (A8:90) [17:17:36:545]: Grabbed execution mutex. MSI (c) (A8:90) [17:17:36:555]: Cloaking enabled. MSI (c) (A8:90) [17:17:36:555]: Attempting to enable all disabled priveleges before calling Install on Server MSI (c) (A8:90) [17:17:36:555]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (30:AC) [17:17:36:575]: Grabbed execution mutex. MSI (s) (30:40) [17:17:36:575]: Resetting cached policy values MSI (s) (30:40) [17:17:36:575]: Machine policy value 'Debug' is 0 MSI (s) (30:40) [17:17:36:575]: ******* RunEngine: ******* Product: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi ******* Action: ******* CommandLine: ********** MSI (s) (30:40) [17:17:36:675]: Incrementing counter to disable shutdown. Counter after increment: 0 MSI (s) (30:40) [17:17:36:906]: Machine policy value 'DisableUserInstalls' is 0 MSI (s) (30:40) [17:17:37:176]: File will have security applied from OpCode. MSI (s) (30:40) [17:17:39:119]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: Verifying package --> '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi' against software restriction policy MSI (s) (30:40) [17:17:39:269]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi has a digital signature MSI (s) (30:40) [17:17:41:702]: SOFTWARE RESTRICTION POLICY: \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi is permitted to run at the 'unrestricted' authorization level. MSI (s) (30:40) [17:17:41:702]: End dialog not enabled MSI (s) (30:40) [17:17:41:702]: Original package ==> \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi MSI (s) (30:40) [17:17:41:702]: Package we're running from ==> C:WINDOWSInstaller3afbb9.msi MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'. MSI (s) (30:40) [17:17:41:722]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (30:40) [17:17:41:722]: MSCOREE already loaded, using loaded copy MSI (s) (30:40) [17:17:41:732]: Machine policy value 'TransformsSecure' is 0 MSI (s) (30:40) [17:17:41:732]: User policy value 'TransformsAtSource' is 0 MSI (s) (30:40) [17:17:41:732]: Note: 1: 2262 2: MsiFileHash 3: -2147287038 MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisablePatch' is 0 MSI (s) (30:40) [17:17:41:732]: Machine policy value 'AllowLockdownPatch' is 0 MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableLUAPatching' is 0 MSI (s) (30:40) [17:17:41:732]: Machine policy value 'DisableFlyWeightPatching' is 0 MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: looking for appcompat database entry with ProductCode '{AEB9948B-4FF2-47C9-990E-47014492A0FE}'. MSI (s) (30:40) [17:17:41:732]: APPCOMPAT: no matching ProductCode found in database. MSI (s) (30:40) [17:17:41:732]: Transforms are not secure. MSI (s) (30:40) [17:17:41:732]: Command Line: STPSETUPTHREADID=3708 STPSETUPPROCESSID=424 EXTERNALCONTROL=1 ADDLOCAL=ALL SKIPPENDINGREBOOTCHECK=1 APPGUID={982DB00A-9C4E-436B-8707-18E113BAA44C} REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=424 MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{A60D52F8-FAAB-4544-AF65-EAC1A22E5435}'. MSI (s) (30:40) [17:17:41:732]: Product Code passed to Engine.Initialize: '' MSI (s) (30:40) [17:17:41:732]: Product Code from property table before transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}' MSI (s) (30:40) [17:17:41:732]: Product Code from property table after transforms: '{AEB9948B-4FF2-47C9-990E-47014492A0FE}' MSI (s) (30:40) [17:17:41:732]: Product not registered: beginning first-time install MSI (s) (30:40) [17:17:41:732]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'. MSI (s) (30:40) [17:17:41:732]: Entering CMsiConfigurationManager:etLastUsedSource. MSI (s) (30:40) [17:17:41:763]: User policy value 'SearchOrder' is 'nmu' MSI (s) (30:40) [17:17:41:763]: Adding new sources is allowed. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'. MSI (s) (30:40) [17:17:41:763]: Package name extracted from package path: 'msxml6.msi' MSI (s) (30:40) [17:17:41:763]: Package to be registered: 'msxml6.msi' MSI (s) (30:40) [17:17:41:763]: Note: 1: 2262 2: AdminProperties 3: -2147287038 MSI (s) (30:40) [17:17:41:763]: Machine policy value 'DisableMsi' is 0 MSI (s) (30:40) [17:17:41:763]: Machine policy value 'AlwaysInstallElevated' is 0 MSI (s) (30:40) [17:17:41:763]: User policy value 'AlwaysInstallElevated' is 0 MSI (s) (30:40) [17:17:41:763]: Product installation will be elevated because user is admin and product is being installed per-machine. MSI (s) (30:40) [17:17:41:763]: Running product '{AEB9948B-4FF2-47C9-990E-47014492A0FE}' with elevated privileges: Product is assigned. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '3708'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '424'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding SKIPPENDINGREBOOTCHECK property. Its value is '1'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding APPGUID property. Its value is '{982DB00A-9C4E-436B-8707-18E113BAA44C}'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'. MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '424'. MSI (s) (30:40) [17:17:41:763]: TRANSFORMS property is now: MSI (s) (30:40) [17:17:41:763]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '300'. MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminApplication Data MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminFavorites MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminNetHood MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy Documents MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminPrintHood MSI (s) (30:40) [17:17:41:773]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminRecent MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminSendTo MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminTemplates MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminLocal SettingsApplication Data MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminMy DocumentsMy Pictures MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools MSI (s) (30:40) [17:17:41:783]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersDesktop MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsAdministrative Tools MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuProgramsStartup MSI (s) (30:40) [17:17:41:793]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart MenuPrograms MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminStart Menu MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAdminDesktop MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:Documents and SettingsAll UsersTemplates MSI (s) (30:40) [17:17:41:803]: SHELL32:HGetFolderPath returned: C:WINDOWSFonts MSI (s) (30:40) [17:17:41:803]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16 MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'. MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2 MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Exact'. MSI (s) (30:40) [17:17:41:803]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2 MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is 'Exact Software'. MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller3afbb9.msi'. MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is '\inwa202746-1GSQL Server x86ServersSetupmsxml6.msi'. MSI (s) (30:40) [17:17:41:803]: Note: 1: 2205 2: 3: PatchPackage MSI (s) (30:40) [17:17:41:803]: Machine policy value 'DisableRollback' is 0 MSI (s) (30:40) [17:17:41:803]: User policy value 'DisableRollback' is 0 MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'. === Logging started: 6/11/2007 17:17:41 === MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'. MSI (s) (30:40) [17:17:41:803]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'. MSI (s) (30:40) [17:17:41:803]: Doing action: INSTALL MSI (s) (30:40) [17:17:41:803]: Running ExecuteSequence MSI (s) (30:40) [17:17:41:803]: Skipping action: SkipInstallCA (condition is false) MSI (s) (30:40) [17:17:41:803]: Doing action: LaunchConditions Action start 17:17:41: INSTALL. Action start 17:17:41: LaunchConditions. MSI (s) (30:40) [17:17:41:803]: Doing action: FindRelatedProducts Action ended 17:17:41: LaunchConditions. Return value 1. Action start 17:17:41: FindRelatedProducts. MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 property. Its value is '{A43BF6A5-D5F0-4AAA-BF41-65995063EC44}'. MSI (s) (30:40) [17:17:41:813]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false) MSI (s) (30:40) [17:17:41:813]: Doing action: CA_SetRefCountNewerFoundFlag Action ended 17:17:41: FindRelatedProducts. Return value 1. MSI (s) (30:40) [17:17:41:813]: PROPERTY CHANGE: Adding NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 property. Its value is '1'. Action start 17:17:41: CA_SetRefCountNewerFoundFlag. MSI (s) (30:40) [17:17:41:813]: Doing action: IsPendingRebootKey Action ended 17:17:41: CA_SetRefCountNewerFoundFlag. Return value 1. MSI (s) (30:F8) [17:17:41:813]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI68.tmp, Entrypoint: IsPendingReboot MSI (s) (30:1C) [17:17:41:813]: Generating random cookie. MSI (s) (30:1C) [17:17:41:823]: Created Custom Action Server with PID 1832 (0x728). MSI (s) (304) [17:17:41:873]: Running as a service. MSI (s) (304) [17:17:41:873]: Hello, I'm your 32bit Impersonated custom action server. Action start 17:17:41: IsPendingRebootKey. No PendingFileRenameOperations MSI (s) (30:40) [17:17:41:973]: Skipping action: CA_ErrorDifferentLang (condition is false) MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOW (condition is false) MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWAppendCustomPath (condition is false) MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH (condition is false) MSI (s) (30:40) [17:17:41:973]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH_ADD (condition is false) MSI (s) (30:40) [17:17:41:973]: Doing action: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D Action ended 17:17:41: IsPendingRebootKey. Return value 1. MSI (s) (30:50) [17:17:41:983]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI69.tmp, Entrypoint: Sqlmsirc_ValidateAppGuid Action start 17:17:41: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. <Func Name='Sqlmsirc_ValidateAppGuid'> <EndFunc Name='Sqlmsirc_ValidateAppGuid' Return='0' GetLastError='0'> MSI (s) (30:40) [17:17:42:003]: Doing action: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D Action ended 17:17:42: Sqlmsirc_ValidateAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 1. MSI (s) (30:EC) [17:17:42:013]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI6A.tmp, Entrypoint: Sqlmsirc_RefCountAppGuid Action start 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. <Func Name='Sqlmsirc_RefCountAppGuid'> <EndFunc Name='Sqlmsirc_RefCountAppGuid' Return='2' GetLastError='0'> Action ended 17:17:42: Sqlmsirc_RefCountAppGuid_NewerFound.8AC30717_CC63_4611_9BB6_8CBCA668674D. Return value 3. Action ended 17:17:42: INSTALL. Return value 3. Property(S): ProductCode = {AEB9948B-4FF2-47C9-990E-47014492A0FE} Property(S): Manufacturer = Microsoft Corporation Property(S): ProductVersion = 6.00.3883.8 Property(S): ProductLanguage = 1033 Property(S): UpgradeCode = {1B117BA7-5BC1-419E-820E-7D4F3F412C7B} Property(S): NEWERFOUND999893F976BBB4A4DAD8F62CFA4D7C55 = 1 Property(S): ARPPRODUCTICON = ARPIco Property(S): PIDTemplate = 53934<````=````=````=````=`````>@@@@@ Property(S): PROMPTROLLBACKCOST = P Property(S): DiskPrompt = [1] Property(S): INSTALLLEVEL = 100 Property(S): ALLUSERS = 1 Property(S): InstallMode = Typical Property(S): ErrorIcon = ErrorIco Property(S): SuccessIcon = SuccessIco Property(S): WarningIcon = WarningIco Property(S): LicenseIcon = LicenseIco Property(S): SetupIcon = SetupIco Property(S): CompleteIcon = CompleteIco Property(S): CustomIcon = CustomIco Property(S): RepairIcon = RepairIco Property(S): RemoveIcon = RemoveIco Property(S): ModifyIcon = ModifyIco Property(S): NewIcon = NewIco Property(S): UpIcon = UpIco Property(S): DialogBanner = BannerBmp Property(S): WelcomeBmp = WelcomeBmp Property(S): ApplicationUsers = AllUsers Property(S): Details = 0 Property(S): AgreeToLicense = No Property(S): _IsMaintenance = Reinstall Property(S): _IsMaintenance2 = Modify Property(S): ReinstallModeText = omus Property(S): Display_IsBitmapDlg = 1 Property(S): Interrupted = 0 Property(S): ProductID = none Property(S): ISENABLEDWUSFINISHDIALOG = 1 Property(S): SQLServerText1 = 0 Property(S): SQLServerVersionText1 = 0 Property(S): SQLServerVersionText2 = 0 Property(S): SQLServerVersionText3 = 0 Property(S): CA_ERRORCOUNT = 0 Property(S): CA_WARNINGCOUNT = 0 Property(S): CA_SUCCESSCOUNT = 0 Property(S): MINIMUMOS = true Property(S): UI_SHOWCOPYRIGHT = yes Property(S): ShowUserRegistrationDlg = 1 Property(S): ErrorDialog = ErrorDlg Property(S): DefaultUIFont = Tahoma8 Property(S): NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 = {A43BF6A5-D5F0-4AAA-BF41-65995063EC44} Property(S): VersionNT = 501 Property(S): ARPHELPLINK = http://go.microsoft.com/fwlink/?LinkId=52156 Property(S): SecureCustomProperties = NEWERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1;OLDERFOUND2.72DE5BCD_5CB0_4335_B118_AB4C4DA70AE1 Property(S): DesktopFolder = C:Documents and SettingsAll UsersDesktop Property(S): ButtonTextStyle = {ButtonTextStyle} Property(S): DlgTextStyle = {DlgTextStyle} Property(S): DlgTextStyleB = {DlgTextStyleB} Property(S): DlgTitleStyle = {DlgTitleStyle} Property(S): DlgTitleStyleB = {DlgTitleStyleB} Property(S): FixedStyle = {FixedStyle} Property(S): COMPANYNAME = Exact Software Property(S): USERNAME = Exact Property(S): DialogTitleSetup = Setup Property(S): DialogTitlePatch = Patch Property(S): DialogTitleUpgrade = Upgrade Property(S): Text_ArrowLeft = < Property(S): Text_ArrowRight = > Property(S): ButtonText_Next = Next Property(S): ButtonText_Next_Hot = &Next Property(S): ButtonText_Cancel = Cancel Property(S): ButtonText_Cancel_Hot = &Cancel Property(S): ButtonText_Back = Back Property(S): ButtonText_Back_Hot = &Back Property(S): ButtonText_Finish = Finish Property(S): ButtonText_Finish_Hot = &Finish Property(S): ButtonText_Update = Update > Property(S): ButtonText_Update_Hot = &Update > Property(S): ButtonText_Ok = OK Property(S): ButtonText_Ok_Hot = &OK Property(S): ButtonText_Yes = Yes Property(S): ButtonText_Yes_Hot = &Yes Property(S): ButtonText_No = No Property(S): ButtonText_No_Hot = &No Property(S): ButtonText_Abort = Abort Property(S): ButtonText_Abort_Hot = &Abort Property(S): ButtonText_Ignore = Ignore Property(S): ButtonText_Ignore_Hot = &Ignore Property(S): ButtonText_Retry = Retry Property(S): ButtonText_Retry_Hot = &Retry Property(S): ButtonText_Change = Change... Property(S): ButtonText_Change_Hot = &Change... Property(S): ButtonText_Help = Help Property(S): ButtonText_Help_Hot = &Help Property(S): ButtonText_Install = Install Property(S): ButtonText_Install_Hot = &Install Property(S): ButtonText_Exit = Exit Property(S): ButtonText_Exit_Hot = &Exit Property(S): ButtonText_Remove = Remove Property(S): ButtonText_Remove_Hot = &Remove Property(S): ButtonText_Space = Space Property(S): ButtonText_Space_Hot = &Space Property(S): ButtonText_Browse = Browse... Property(S): ButtonText_Browse_Hot = Bro&wse... Property(S): ButtonText_DiskCost = Disk Cost... Property(S): ButtonText_DiskCost_Hot = &Disk Cost... Property(S): LabelText_Status = Status Property(S): LabelText_SerialNumber = &Serial Number: Property(S): LabelText_UserName = &User Name Property(S): LabelText_PersonName = Name Property(S): LabelText_PersonOrganization = Company Property(S): LabelText_InstallTo = Install to Property(S): LabelText_Modify = &Modify Property(S): LabelText_Repair = Re&pair Property(S): LabelText_Remove = &Remove Property(S): LabelText_Complete = &Complete Property(S): LabelText_Custom = Cu&stom Property(S): LabelText_NetworkLocation = &Network location: Property(S): LabelText_LookIn = &Look in Property(S): LabelText_FolderName = &Folder name Property(S): LabelText_FeatureDescription = Feature description Property(S): LabelText_CopyFilesFrom = Copy Files from Property(S): LabelText_InstallFor = Install this application for Property(S): HeadText_AdminWelcome = Welcome to the Install Wizard for Property(S): HeadText_InstallWelcome = Welcome to the Install Wizard for Property(S): HeadText_WelcomePatch = Welcome to the Patch for Property(S): HeadText_SetupWelcome = Welcome to the Property(S): HeadText_SetupWelcome2 = Setup Property(S): HeadText_ResumeInstall = Resuming the Install Wizard for Property(S): HeadText_SetupInterrupted = Setup Interrupted Property(S): HeadText_LicenseAgreement = License Agreement Property(S): HeadText_FeatureSelection = Feature Selection Property(S): HeadText_NetworkLocation = Network Location Property(S): HeadText_ProgramMaintenance = Program Maintenance Property(S): HeadText_DiskSpaceRequirements = Disk Space Requirements Property(S): HeadText_FilesInUse = Files in Use Property(S): HeadText_DatabaseFolder = Database Folder Property(S): HeadText_RegistrationInformation = Registration Information Property(S): HeadText_CompletingSetup = Completing the Property(S): HeadText_CompletingSetup2 = Setup Property(S): HeadText_InstallingProduct = Installing Property(S): HeadText_UninstallProduct = Uninstalling Property(S): HeadText_ChangeDestinationFolder = Change Current Destination Folder Property(S): HeadText_ReadyInstall = Ready to Install the Program Property(S): HeadText_ReadyRepair = Ready to Repair the Program Property(S): HeadText_ReadyModify = Ready to Modify the Program Property(S): HeadText_RemoveProgram = Remove the Program Property(S): HeadText_OutOfDiskSpace = Out of Disk Space Property(S): DescText_FilesInUse = Some files that need to be updated are currently in use. Property(S): DescText_RegistrationInformation = The following information will personalize your installation. Property(S): DescText_ServerImage = Setup will create a server image of Property(S): DescText_ServerImage2 = at a specified network location. To continue, click Next. Property(S): DescText_InstallModifyRemove = Setup helps you install, modify or remove Property(S): DescText_InstallModifyRemove2 = . To continue, click Next. Property(S): DescText_PatchInstall = The Install Wizard will install the Patch for Property(S): DescText_PatchInstall2 = on your computer. To continue, click Update. Property(S): DescText_WizardComplete = The Install Wizard will complete the installation of Property(S): DescText_WizardComplete2 = on your computer. To continue, click Next. Property(S): DescText_CompleteSuspended = The Install Wizard will complete the suspended installation of Property(S): DescText_CompleteSuspended2 = on your computer. To continue, click Next. Property(S): DescText_SuccessfulInstallation = Setup has installed Property(S): DescText_SuccessfulInstallation2 = successfully. Click Finish to exit. Property(S): DescText_SuccessfulRemove = Setup has removed Property(S): DescText_SuccessfulRemove2 = successfully. Click Finish to exit. Property(S): DescText_SuccessfulRepair = Setup has repaired Property(S): DescText_SuccessfulRepair2 = successfully. Click Finish to exit. Property(S): DescText_SuccessfulModify = Setup has modified Property(S): DescText_SuccessfulModify2 = successfully. Click Finish to exit. Property(S): DescText_SetupInterrupted = Setup was interrupted before Property(S): DescText_SetupInterrupted2 = could be completely installed. Property(S): DescText_PreparingSetup = Setup is preparing the Install Wizard which will guide you through the program setup process. Please wait. Property(S): DescText_FeatureSelection = Select the program features you want installed. Property(S): DescText_ProgramFeaturesInstall = The program features you selected are being installed. Property(S): DescText_ProgramFeaturesUninstall = The program features you selected are being uninstalled. Property(S): DescText_ReadLicense = Please read the following license agreement carefully. Property(S): DescText_SpecifyNetworkLocation = Specify a network location for the server image of the product. Property(S): DescText_BrowseDestination = Browse to the destination folder. Property(S): DescText_ModifyRepairRemove = Repair or remove the program. Property(S): DescText_ReadyInstallation = Setup is ready to begin installation. Property(S): DescText_ChosenRemove = You have chosen to remove the program from your system. Property(S): DescText_DiskSpaceRequirements = The disk space required for the installation of the selected features. Property(S): DescText_DiskExceedsAvailable = Disk space required for the installation exceeds available disk space. Property(S): Text_ReRunSetup = Your system has not been modified. To complete installation at another time, please run setup again. Property(S): Text_FinishExit = Click Finish to exit Setup. Property(S): Text_RestoreState = You can either keep any existing installed elements on your system to continue this installation at a later time or you can restore your system to its original state prior to the installation. Property(S): Text_RestoreClick = Click Restore or Continue Later to exit Setup. Property(S): Text_InstallWait = Please wait while the Install Wizard installs Property(S): Text_InstallWait2 = . This may take several minutes. Property(S): Text_UninstallWaitText = Please wait while the Install Wizard uninstalls Property(S): Text_UninstallWaitText2 = . This may take several minutes. Property(S): Text_UninstallWait = Please wait while the Install Wizard uninstalls Property(S): Text_UninstallWait2 = . This may take several minutes. Property(S): Text_ProgressDone = Progress done Property(S): Text_Copyright = WARNING: This program is protected by copyright law and international treaties. Property(S): Text_BeginInstallation = Click Install to begin the installation. Property(S): Text_ReviewChange = If you want to review or change any of your installation settings, click Back. Click Cancel to exit Setup. Property(S): Text_AlterFeatureInstall = Click an icon in the following list to change how a feature is installed. Property(S): Text_ConfirmExit = The installation is not yet complete. Are you sure you want to exit? Property(S): Text_FeatureSelectionDescription = This feature requires 4 MB on your hard drive. Property(S): Text_EnterNetworkLocation = Enter the network location or click Change to browse to a location. Click Install to create a server image of Property(S): Text_EnterNetworkLocation2 = at the specified network location or click Cancel to exit Setup. Property(S): Text_SelectDifferentDrive = The highlighted volumes do not have enough disk space available for the currently selected features. You can remove files from the highlighted volumes, choose to install less features onto local drives, or select different destination drives. Property(S): Text_RepairInstallationErrors = Repair installation errors in the program. This option fixes missing or corrupt files, shortcuts, and registry entries. Property(S): Text_RemoveFromComputer = Remove Property(S): Text_RemoveFromComputer2 = from your computer. Property(S): Text_UsingFilesRetry = The following applications are using files that need to be updated by this setup. Close these applications and click Retry to continue. Property(S): Text_ClickRemove = Click Remove to remove Property(S): Text_ClickRemove2 = from your computer. After removal, this program will no longer be available for use. Property(S): Text_ReviewChangeBack = If you want to review or change any settings, click Back. Property(S): Text_AllUsers = &Anyone who uses this computer (all users) Property(S): Text_OnlyMe = Only for &me ([USERNAME]) Property(S): Text_NotAcceptTerms = I &do not accept the terms in the license agreement Property(S): Text_AcceptTerms = I &accept the terms in the license agreement Property(S): Text_RegInfoNameAndOrg = Enter your name and the name of your organization in the fields below. Property(S): Text_RegInfoOrg = Enter the name of your organization in the field below. Property(S): Upgrade_Confirmation = A lower version of this product has been detected on your system. Would you like to upgrade your existing installation? Property(S): AdminMessage = Setup requires user to be in the administrator group in order to continue the installation process. Setup is aborting as the current user is not in the administrator group. Property(S): SupportedOSMessage = Installation of this product failed because it is not supported on this operating system. For information on supported configurations, see the product documentation. Property(S): ShortCutText = MSXML 6.0 Property(S): DialogTitle = MSXML 6.0 Parser Setup Property(S): ProductName = MSXML 6.0 Parser Property(S): ShortName = MSXML 6.0 Parser Property(S): WrongPackage = This MSXML6.0 package is not supported on the current processor type. Property(S): DialogPatchTitle = MSXML 6.0 Parser Patch Property(S): SystemFolder = C:WINDOWSsystem32 Property(S): WdSfpCaMainModId.41646F16_4E6C_4E96_BF1B_772105414B9D = 86F857F6_A743_463D_B2FE_98CB5F727E09 Property(S): AppGuidRegKey = Wdsfpca_Uninstall_RegKey.86F857F6_A743_463D_B2FE_98CB5F727E09 Property(S): PackageCode = {A60D52F8-FAAB-4544-AF65-EAC1A22E5435} Property(S): ProductState = -1 Property(S): PackagecodeChanging = 1 Property(S): STPSETUPTHREADID = 3708 Property(S): STPSETUPPROCESSID = 424 Property(S): EXTERNALCONTROL = 1 Property(S): ADDLOCAL = ALL Property(S): SKIPPENDINGREBOOTCHECK = 1 Property(S): APPGUID = {982DB00A-9C4E-436B-8707-18E113BAA44C} Property(S): REBOOT = ReallySuppress Property(S): CURRENTDIRECTORY = C:Program FilesMicrosoft SQL Server90Setup Bootstrap Property(S): CLIENTUILEVEL = 3 Property(S): CLIENTPROCESSID = 424 Property(S): VersionDatabase = 300 Property(S): VersionMsi = 3.01 Property(S): WindowsBuild = 2600 Property(S): ServicePackLevel = 2 Property(S): ServicePackLevelMinor = 0 Property(S): MsiNTProductType = 1 Property(S): WindowsFolder = C:WINDOWS Property(S): WindowsVolume = C: Property(S): System16Folder = C:WINDOWSsystem Property(S): RemoteAdminTS = 1 Property(S): TempFolder = C:DOCUME~1AdminLOCALS~1Temp Property(S): ProgramFilesFolder = C:Program Files Property(S): CommonFilesFolder = C:Program FilesCommon Files Property(S): AppDataFolder = C:Documents and SettingsAdminApplication Data Property(S): FavoritesFolder = C:Documents and SettingsAdminFavorites Property(S): NetHoodFolder = C:Documents and SettingsAdminNetHood Property(S): PersonalFolder = C:Documents and SettingsAdminMy Documents Property(S): PrintHoodFolder = C:Documents and SettingsAdminPrintHood Property(S): RecentFolder = C:Documents and SettingsAdminRecent Property(S): SendToFolder = C:Documents and SettingsAdminSendTo Property(S): TemplateFolder = C:Documents and SettingsAll UsersTemplates Property(S): CommonAppDataFolder = C:Documents and SettingsAll UsersApplication Data Property(S): LocalAppDataFolder = C:Documents and SettingsAdminLocal SettingsApplication Data Property(S): MyPicturesFolder = C:Documents and SettingsAdminMy DocumentsMy Pictures Property(S): AdminToolsFolder = C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools Property(S): StartupFolder = C:Documents and SettingsAll UsersStart MenuProgramsStartup Property(S): ProgramMenuFolder = C:Documents and SettingsAll UsersStart MenuPrograms Property(S): StartMenuFolder = C:Documents and SettingsAll UsersStart Menu Property(S): FontsFolder = C:WINDOWSFonts Property(S): GPTSupport = 1 Property(S): OLEAdvtSupport = 1 Property(S): ShellAdvtSupport = 1 Property(S): Intel = 6 Property(S): PhysicalMemory = 1023 Property(S): VirtualMemory = 2183 Property(S): AdminUser = 1 Property(S): LogonUser = Administrator Property(S): UserSID = S-1-5-21-842925246-1580818891-1957994488-500 Property(S): UserLanguageID = 1033 Property(S): ComputerName = CHUN107907-1 Property(S): SystemLanguageID = 1054 Property(S): ScreenX = 1024 Property(S): ScreenY = 768 Property(S): CaptionHeight = 25 Property(S): BorderTop = 1 Property(S): BorderSide = 1 Property(S): TextHeight = 16 Property(S): ColorBits = 32 Property(S): TTCSupport = 1 Property(S): Time = 17:17:42 Property(S): Date = 6/11/2007 Property(S): MsiNetAssemblySupport = 2.0.50727.42 Property(S): MsiWin32AssemblySupport = 5.1.2600.3019 Property(S): RedirectedDllSupport = 2 Property(S): Privileged = 1 Property(S): DATABASE = C:WINDOWSInstaller3afbb9.msi Property(S): OriginalDatabase = \inwa202746-1GSQL Server x86ServersSetupmsxml6.msi Property(S): UILevel = 2 Property(S): Preselected = 1 Property(S): ACTION = INSTALL MSI (s) (30:40) [17:17:42:093]: Note: 1: 1708 MSI (s) (30:40) [17:17:42:093]: Product: MSXML 6.0 Parser -- Installation failed.
MSI (s) (30:40) [17:17:42:093]: Cleaning up uninstalled install packages, if any exist MSI (s) (30:40) [17:17:42:093]: MainEngineThread is returning 1603 MSI (s) (30:AC) [17:17:42:193]: Destroying RemoteAPI object. MSI (s) (30:1C) [17:17:42:193]: Custom Action Manager thread ending. === Logging stopped: 6/11/2007 17:17:42 === MSI (c) (A8:90) [17:17:42:193]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1 MSI (c) (A8:90) [17:17:42:193]: MainEngineThread is returning 1603 === Verbose logging stopped: 6/11/2007 17:17:42 ===
Hi, I need to import an SQL string from MS Excel 2003 to SQL SERVER 2000. The string I need to import is composed by 5 different several blocks and looks like:
The detail of the SQL string is at: http://forums.microsoft.com/msdn/showpost.aspx?postid=2093921&siteid=1&sb=0&d=1&at=7&ft=11&tf=0&pageid=1
I am trying to implement OJ's suggestion: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2117223&SiteID=1 to use multi - batch processing to import the string to SQL SERVER, something like:
Code Snippet Dim SqlCnt, cmd1, cmd2, cmd3 'set the properties and open a connection
cmd1="use my_db" cmd2="create table mytb" cmd3="insert into mytb"
I may not be the best forum for this post, however I believe some onecan still help me or direct me somewhere else.I'm finding that win 2003 x64 and SQL 2005 CTP is slower than win 2003and SQL 2000.Machine A: Opteron 2.2 (248) w/ 2 cpus. 8GB memory. SCSI disk array.Windows Enterprise 2003 x64 final release. SQL Server 2005 enterpriseCTP.Machine B: Opeteron 2.2 (248) w/ 2 CPUs. 4GB Memory. IDE Drives.Windows Server 2003 (32bit) and SQL Server 2005 (standard).I'm using Cognos' DecisionStream as the ETL tool (32bit). I have theidentical job on both machines. Machine A is slower to do my nightlybuild (1h 20m) vs. Machine B (50m).I've done no tweaking of the databases. I Used SQL 2005's studio tocopy the database from Machine B to Machine A.The only major difference is the O/S and SQL, the machines are samespeed, however Machine A has twice the memory and faster disk; so Iwould expect it to be faster.Can anyone think of smoking guns I might be missing?TIA
Hi, I am having a problem connecting my .net applications from the application server to the database server. When I run the application from my windows xp (sp2) box it works fine. When I try to connect via SQL Management Studio to the database server from the application server I get the same error. Here is the error: System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) Here is the Environment: App Server: Windows Server 2003 Standard Edition Inside Company's Firewall/ Network Database Server: Windows Server 2000 Advanced Edition SQL Server 2000 SP4 Remote Connections to the Server is checked Enable Protocols: Named Pipes & TCP/IP TCP/IP Port: 1402 (I don't know why it isn't the default of 1433) The db server is sitting out side the Company's firewall (don't ask me why). I can access it fine from inside the firewall on my XP box but not from windows server 2003. There is a web server outside the our network that also connects to the db server with no problem and that is running Windows Server 2003 Web Edition. I can ping the db server from the app server using the IP address. I tried using the IP address and the port 1402 in my connection string but that didn't work from any machine (XP and Server). I imagine the issue is somehow related to the company's firewall but why would it only block Windows Server 2003 and not XP? What do I tell the network admin to change? Any help would be appreciated. Thanks, Oran
Hi,Is it possible to install on a Windows server 2003,SQL SERVER 2000 in the folowing configuration :SQL server 7.0 as a default InstanceandSQL server 2000 as a named instance.Thanks for your answer.
We have a project already developed iusing VS 2003 Enterprise architect edition using sql server 2000(have lots of table and stored procs etc.) Now planning to switch to Sql server 2005 are there any issues associated with the switch.
I mean front end programming wise asp.net and vb.net front end codes do they work straight away or need to make any changes to all the front end codes, we are using datasets, data readers calling stored procs and also using lot of hash tables and XML object to make bulk loads to sql server via sqlxml3.0 sp3. Please help thank you very much for the information.
Hi all,I just asked some people to help me out and phone microsoft with thefollowing information, kindly they refused unless we setup a supportcontract with them first, for pre-sales information. (That really doesnot sound like good business sense to me - anyway here is our problem,if anyone could help thanks)."To tell and ask microsoft:We will be setting up a microsoft sql server 2000 instance running on awindows 2003 server.1) We need to check this can run alongside a microsoft 2003 sql server(either workgroup or standard edition), on the same machine. Are thereany .dll clashes if we do this? If there are can we run SQL Server2000, in a virtual machine running windows 2000 professional. (I have alicenced copy we can use for this).2) If we run one instance of 2000, and one of 2003 of the sql servers,can one use the processor licence model, and one use the CAL licencemodel."Thanks for any help, and any idea why they actually force you to usenews groups for pre-sales information?David
Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it.
I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP):
These are two things that I need to facilitate:
1) They want to be able to write queries using Query Designer and run from their PCs.
2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database.
3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this.
Any suggestions are appreciated, especially with item number 1.
SQL Server Reporting Services 2005 Service would not Start on windows server 2003. Working great till yesterday and no changes were made to config file.
Here is the error in Event log
Event Type: Error Event Source: SQL Server Report Service Event Category: None Event ID: 0 Date: 12/13/2007 Time: 8:25:59 AM User: N/A Computer: XXXXXXXXXXX Description: Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. See the report server log files for more information. at Microsoft.ReportingServices.Library.ServiceAppDomainController.Start(Boolean firstTime) at Microsoft.ReportingServices.NTService.ReportService.OnStart(String[] args) at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state) For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
Here is i found in log files ReportingServicesService!resourceutilities!4!12/13/2007-08:25:59:: i INFO: Running on 0 physical processors, 1 logical processors ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Exception caught loading and setting code permissions policy level: System.Security.XmlSyntaxException: Invalid syntax on line 158. at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index) at System.Security.Util.Parser.ParseContents() at System.Security.Util.Parser..ctor(Tokenizer t) at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type) at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type) at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy() ReportingServicesService!servicecontroller!4!12/13/2007-08:25:59:: e ERROR: Error Starting Service: System.Security.XmlSyntaxException: Invalid syntax on line 158. at System.Security.Util.Parser.GetRequiredSizes(TokenizerStream stream, Int32& index) at System.Security.Util.Parser.ParseContents() at System.Security.Util.Parser..ctor(Tokenizer t) at System.Security.SecurityManager.LoadPolicyLevelFromStringHelper(String str, String path, PolicyLevelType type) at System.Security.SecurityManager.LoadPolicyLevelFromString(String str, PolicyLevelType type) at Microsoft.ReportingServices.Library.ServiceController.SetAppDomainPolicy() at Microsoft.ReportingServices.Library.ServiceController.StartService(Boolean firstStart)
I'm trying to configure SQL server 2000 (standard edition) to send e-mail on a Small Business Server 2003. There's a great article on how to do this on a SBS 2000 server (KB304967), but it does not apply to SBS 2003. Can anyone point me to a article or white paper on how to configure SQL on a SBS 2003 server to send e-mail. Thanks.
Hi We have a bunch of servers running server 2000 & 2003 along with many sql server (versions 2000 & 2005) databases in a production environment pulling transactions then doing warehousing & reporting.
An audit has shown up 1 production server using English_US 'mmddyyyy' system date formats, all others being English_Australian 'ddmmyyyy'.
Is it safe to simply change the regional settings on this English_US server to English_Australian or will it mess up the data in our SQL 2005 databases? I've not been able to get a definitive answer from anyone yet!
My uncle runs a small networking company and has extra licenses for Windows 2003 Server as well as SQL Server 2000. Since I just graduated from college and have started working as a database programmer (for a different company) I'd like to setup a small server at home to learn more about SQL (as well as networking, but SQL is my primary concern). I know I can setup SQL Server 2000 on my main PC, but I'd still like to set everything up in a server environment.
So, what I'm wondering is if any books (or web sites?) exist that walk you through setting up Windows 2003 Server and SQL Server 2000. I've actually set these up before (it's not very complicated) but I'm not sure if I did it the "correct" way.
Ideally if any books exist on O'Reilly's Safari Bookshelf that would be even better.
Stupid question but please be gentle and answer anyway please....
Background: We have SQL Server 2003 (32bit) running on our servers. Our .Net applications (from old release of VS) are still running on them and using the old databases. From what I understand there is no immediate plans to upgrade the servers. However the developers were just given this new upgrade (2005) SQL Server and VS (and fixing depreciated code etc in the .net apps).
Question: Can the applications and new stored procedures written via the 2005 environment be deployed successfully on the 2003 Servers? Same goes with Reporting Services?
Event Type: Error Event Source: MSSQL$SHAREPOINT Event Category: (2) Event ID: 17055 User: NT AUTHORITYSYSTEM Description: 18210 : BackupVirtualDeviceFile:repareToFreeze: failure on backup device '{74A09E78-8845-47EB-9602-705E4406096C}1'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
Event Type: Error Event Source: VSS Event Category: None Event ID: 6013 User: N/A Description: Sqllib error: OLEDB Error encountered calling ICommandText::Execute. hr = 0x80040e14. SQLSTATE: 42000, Native Error: 3013 Error state: 1, Severity: 16 Source: Microsoft OLE DB Provider for SQL Server Error message: BACKUP DATABASE is terminating abnormally.
Event Type: Error Event Source: MSSQL$SHAREPOINT Event Category: (2) Event ID: 17055 User: NT AUTHORITYSYSTEM Description: 18210 : BackupVirtualDeviceFile:repareToFreeze: failure on backup device '{74A09E78-8845-47EB-9602-705E4406096C}5'. Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.).
I need to get the Backup System working again urgently. Any advice will be greatly appreciated
I cant figure out why this is happening.. its a fresh 2003 x64 R2 sp2 server, during the installation of the SQL Server Database Services the server hangs and displays Setting File Security. I let the install run for over 45 mins and it still hangs... the log file is useless.. i cant find any clues as to why ...
hi everyone, can anyone help me how to install sql 2005 server express edition on windows server 2003 x64 edition. because its my first time installing on a 64 bit OS i dont know how. When i tried installing it gives a warning on ASP.Net , when i ignore that & continue the installation. when installing now the SQLServer Management Studio Express now it says "installation of this product failed because it is not supported on this qperating system....." any idea?
Re: Best Practices (security): Should SQL Server (2005) *not* be installed on the same physical HD as the Windows OS (Server 2003 R2) ?
Hi,
We're setting up some new servers, and today I'm looking into best practices for the SQL Server Setup portion of it.
The servers have include 2 x 250G HD, and from what I've read, where IIS is concerned, it should not be installed on the drive that has the OS on it, for security reasons. I was wondering if the installation of SQL Server should be on the non-OS drive as well ?
I was a Oracle Developer / DBA on Unix Environments all along my career, Very recently iam starting to manage a SQL Server 2005/Windows 2003 Server setup.
Part of my new job is to automate to load Huge Data files/Flat Files (3/4 GB in size) into SQL Server 2005 DB.
Have these initial questions.. Since the files are too large to open at once... What sort of Command Line Interfaces people use on the Windows Boxes.. like doing a "wc" (Word Count) / GREP 'ng Files / Massaging Data Files one line at a time (Like using SED / AWK Commands).. Etc
We got SQL Server 2000 Standard Edition SP3 running on Windows 2003 Standard Edition server.
Now, we would like to apply windows 2003 SP2 to the Operating System.
We are concerned that whether windows 2003 SP2 is compatible with SQL server 2000 (SP3)?
I was looking at the application compatibility chart for Windows 2003 SP2.Among them Microsoft SQL Server Standard (2000) was listed but with no Service pack details. And also does Standard means standard edition there?
My Question - Is windows 2003 server SP2 compatible with SQL Server 2000 (SP3) Standard Edition? And what if I plan to apply SP4 to Sql Server ?
I have installed SQL server 2005 enterprise edition on Windows 2003 virtual PC (full installation). The installation went through successfully. However, after install completed, I cannot find any of the client tools under the start menu -> all programs -> Microsoft SQL server 2005 menu. The only item listed under the SQL server 2005 is Configuration Tools, which is used to configure the database server.
I have tried to install the client component again (in case I didn't install them at the first place) but the installation process cannot be started since it detected that the client components have been installed already. I can also see the sql server native client running in the services.
The server engine is working fine since I can connect to that sql server using another machine where I have the client tool (SQL server management studio).
One of my friends has exactly the same problem. He installed the sql server 2005 Standard edition on windows 2003 server (full installation), but the client tools are not showing up in the start menu either.
I also checked the location for the SQL server management studio (Microsoft SQL server/90/Tools/Binn/VSShell/Common7/IDE), there is only one folder called publicAssemblies listed under. Is this correct or something is missing?
I am developing a windows application that needs to communicate with a remote SQL server 2005 database. Server allows remote connections and MSDTC service also running. Do I need to run MSDTC service on the client machine where I use desktop application ? any ideas ? It's throwing some error like An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
But my SQL Server allows remote connection, and I am able to do a select statement. But when I insert/update anything, it's throwing this error. I guess some problem with MSDCT. Anybody have any idea ?
I'moving my asp application to a new hosting server.
So when i tried the setup locally with the live DB & application in my test machine... The DB access is denied when application tries to hit the DB.
DB is in seperate machine with SQL Server 2000 & application(ASP) is in Windows server 2003..... Kindly help me with your suggestions....on what went wrong?
If SQL Server Setup fails, Setup will roll back the installation but may not remove all .manifest files. The workaround is to rename the files and then rerun Setup. For more information, see How to: Work Around COM+ Check Failure in SQL Server Setup.
I have been unable to install SQL Express 2005 Server on my Windows 2003 Server (with SP2 installed). I keep getting an error message saying that Microsoft Windows Installer 3.1 is not installed.
Click here for image
So, I downloaded Microsoft Windows Installer 3.1 v2 (WindowsInstaller-KB893803-v2-x86.exe) but whenever I try to install it I get an error message saying that "the Service Pack version of this system is newer than the update you are applying" and that there is no need to install the update and it stops there.
Click here for image
Is there a workaround to this? How can I get Microsoft Windows Installer 3.1 installed? I tried going to the Windows Update site, I already have everything installed and I even started the Windows Installer service manually. Has anyone else experienced this?
How can I get SQL Server 2005 Express installed if not how can I install SQL Server 2000 on tihs machine? The only reason I am trying to install SQL Server 2005 is because wanted to try it so I uninstalled SQL Server 2000 now I can no longer install SQL Server 2000 again because it won't let me because of the SP2 patch.
Has anyone heard of any problems running SQL 7 under Windows Server 2003?We're upgrading to 2003 and are wondering if we can keep SQL 7 with the newOS.Question 2: If we upgrade SQL to SQL 2005, can I run our database in SQL 7mode? Or would it be better to just convert it to SQL 2005?Thanks!Neil
I dont know if i am in the right place to post this.
Is there any release of SQL server called SQL server 2003. I came accross this in a couple of job descriptions and also in a couple of interviews that i had. I Have been working on SQL Server since SQL Server 6.5, but hadnt heard about any release by that name. I really appreciate it if some one could provide some information on this. Thanks in advance.
I am new to the CE Edition. I am using Visual Studio 2003 and VB.NET.
I downloaded all the components to install SQL Server CE. I am running on Windows Media Center and have IIS working OK as I can do ASP.NET and connect to the localhost. I have Visual Studio.NET 2003 and the IIS. I also applied service pack 4 to SQL Server 2000 which is also running and working properly on my local machine. In other words, all the components are on one PC.
After the download, I then navigate to and run Sqlcesql2ksp2.exe and get the following message:
SQL Server CE Tools is compatible only with SQL Server 2000 SP1 and higher. When you install SQL Server CE Server Tools on a computer running both IIS and SQL Server 2000, ensure the installer for SQL Server CE Server Tools corresponds to the version of SQL Server 2000.
Can anyone help and tell me what I am doing wrong??
Where can I further educate myself on this subject?
Right off from the start I would assume that installing SQL Server 2000 or 2005 on Windows Server 2003 that is set up as a web server hosting a website would be against "best practices." Is my assumption right?
Common sense tells me to not to host a website on a pc that is also hosting my database.
