MSXML In Win Server 2003
Jan 26, 2004
Hi,
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.
TIA
View 1 Replies
ADVERTISEMENT
Sep 11, 2007
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.
Zone: SQL Server 2005
View 8 Replies
View Related
Jan 31, 2007
I have a small VB.Net 2005 app using the Microsoft.SQLServer.ManagedDTS.dll so I can use the SSIS/DTSx functionality.
The program ran fine in the IDE.
Then when I tried to create a setup project for it I recieved a warning that all dependancies for MSXML6.DLL were not found.
I clicked ok and the setup was created.
I tried to run the setup and it failed with "....msxml6.dll failed to register. HRESULT -2147023782. ...
So I said cancel the setup and registered msxml6.dll.
I deleted my setup project and recreated it. This time I did not get the warning about msxml6.dll dependancies.
I tried the setup again and it executed without any errors however when I run the program I now get:
"Cannot create an instance of the XML Document Object Model. MSXML may not be registered."
So I went back into the IDE with the project and now it will not run either. IT gets the same error.
Does anyone have any suggestions?
View 3 Replies
View Related
Jun 11, 2007
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 ===
View 48 Replies
View Related
Sep 11, 2007
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:
Code Snippet
CommandLine01 = "USE mydb"
CommandLine02 = "SELECT Block ..."
CommandLine03 = "GO
ALTER TABLE Block...
GO"
CommandLine04 = "UPDATE Block..."
CommandLine05 = "SELECT Block..."
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"
SqlCnt.execute cmd1
SqlCnt.Execute cmd2
SqlCnt.Execute cmd3
Below is the code (just partial) I have, and I need help to complete it.
Thanks in advance,
Aldo.
Code Snippet
Function TestConnection()
Dim ConnectionString As New ADODB.Connection
Dim RecordSet As New ADODB.RecordSet
ConnectionString = "Driver={SQL Server};Server=myServer;Database=myDBName;Uid=UserName;Pwd=Password"
ConnectionString.Open
CmdLine01 = " USE " & myDB
CmdLine02 = " SELECT ACCOUNTS.FULLNAME FROM ACCOUNTS" ...
CmdLine03 = "GO
ALTER TABLE Block...
GO"
CmdLine04 = "UPDATE Block..."
CmdLine05 = "SELECT Block..."
RecordSet.Open CmdLine01, ConnectionString
RecordSet.Open CmdLine02, ConnectionString
ConnectionString.Execute CmdLine01
ConnectionString.Execute CmdLine02
'Retrieve Field titles
For ColNr = 1 To RecordSet.Fields.Count
ActiveSheet.Cells(1, ColNr).Value = RecordSet.Fields(ColNr - 1).Name
Next
ActiveSheet.Cells(2, 1).CopyFromRecordset RecordSet
'Close ADO objects
RecordSet.Close
ConnectionString.Close
Set RecordSet = Nothing
Set ConnectionString = Nothing
End Function
View 7 Replies
View Related
Jul 23, 2005
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
View 2 Replies
View Related
Apr 3, 2008
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
View 4 Replies
View Related
Jul 23, 2005
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.
View 1 Replies
View Related
Aug 24, 2006
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.
View 1 Replies
View Related
Nov 20, 2006
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
View 4 Replies
View Related
Apr 11, 2008
I am new to SQL server 2005
Windows 2003 Server and all client PCs are all on the same network. I installed SQL 2005 std version on windows server 2003 and created a database and tables in it.
I have two users, who want to connect to SQL server 2005 from their PCs (they have windows XP):
These are two things that I need to facilitate:
1) They want to be able to write queries using Query Designer and run from their PCs.
2) I created an MS Access database on my PC, I want to use Access database as a front end to the SQL server database. I will create queries, forms in Access DB, and I want to be able to get the data from SQL server Database to do this. I guess I can use ODBC to connect to tables in SQL server database.
3) I want to connect SQL server to Oracle database, and run oracle stored procedures. I want to load the results of oracle stored procedures into SQL server database tables. I guess I will use IIS for this.
Any suggestions are appreciated, especially with item number 1.
View 9 Replies
View Related
Dec 13, 2007
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)
View 1 Replies
View Related
Sep 20, 2007
While attempting to install SQL Server 2005 Enterprise Edition on a Windows Server 2003 box, it is failing as follows...
Microsoft SQL Server 2005 Setup beginning at Thu Sep 20 11:11:35 2007
Process ID : 5440
E:setup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/8/20 11:11:35
Complete: LoadResourcesAction at: 2007/8/20 11:11:35, returned true
Running: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35
Loaded DLL:E:xmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/8/20 11:11:35, returned false
Error: Action "ParseBootstrapOptionsAction" failed during execution. Error information reported during run:
Could not parse command line due to datastore exception.
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 124
----------------------------------------------------------
writeEncryptedString() failed
Source File Name: utillibpersisthelpers.cpp
Compiler Timestamp: Fri Jul 29 01:13:55 2005
Function Name: writeEncryptedString
Source Line Number: 123
----------------------------------------------------------
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: cryptohelpercryptsameusersamemachine.cpp
Compiler Timestamp: Mon Jun 13 14:30:00 2005
Function Name: sqls::CryptSameUserSameMachine:rotectData
Source Line Number: 50
2
Could not skip Component update due to datastore exception.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "InstallMediaPath" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Running: ValidateWinNTAction at: 2007/8/20 11:11:35
Complete: ValidateWinNTAction at: 2007/8/20 11:11:35, returned true
Running: ValidateMinOSAction at: 2007/8/20 11:11:35
Complete: ValidateMinOSAction at: 2007/8/20 11:11:35, returned true
Running: PerformSCCAction at: 2007/8/20 11:11:35
Complete: PerformSCCAction at: 2007/8/20 11:11:35, returned true
Running: ActivateLoggingAction at: 2007/8/20 11:11:35
Error: Action "ActivateLoggingAction" threw an exception during execution. Error information reported during run:
Datastore exception while trying to write logging properties.
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "primaryLogFiles" {"SetupStateScope", "", ""} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupStateScope.primaryLogFiles
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupStateScope"
00CFCFC8Unable to proceed with setup, there was a command line parsing error. : 2
Error Code: 0x80070002 (2)
Windows Error Text: The system cannot find the file specified.
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.InstallMediaPath
Source Line Number: 44
Failed to create CAB file due to datastore exception
Source File Name: datastorecachedpropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:49 2005
Function Name: CachedPropertyCollection::findProperty
Source Line Number: 130
----------------------------------------------------------
Failed to find property "HostSetup" {"SetupBootstrapOptionsScope", "", "5440"} in cache
Source File Name: datastorepropertycollection.cpp
Compiler Timestamp: Fri Jul 29 01:13:50 2005
Function Name: SetupBootstrapOptionsScope.HostSetup
Source Line Number: 44
----------------------------------------------------------
No collector registered for scope: "SetupBootstrapOptionsScope"
Message pump returning: 2
Any ideas?
Thanks in advance.
View 1 Replies
View Related
Nov 5, 2007
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.
David Neahusan
View 1 Replies
View Related
Oct 18, 2007
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!
many thanks in advance; GaryP
View 1 Replies
View Related
Nov 24, 2004
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.
Thanks in advance,
John
View 4 Replies
View Related
Nov 28, 2007
Hi,
I have a question to do..
can I install sql server 2005 express edition on a windows storage server 2003 R2????
Thank-you!!
MTV
View 3 Replies
View Related
Jan 20, 2006
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?
View 1 Replies
View Related
Apr 23, 2008
Hi
MS Backup in Microsoft windows server 2003 for small business server reports:
<-- Volume shadow copy creation: Attempt 1.
"MSDEWriter" has reported an error 0x800423f4. This is part of System State. The backup cannot continue.
Error returned while creating the volume shadow copy:800423f4
Aborting Backup. -->
The VSS events that I get are 8193 & 6013
The MSSQL$SHAREPOINT events are 17055, 18452 & 18456
These are the main Errors that I get:
Event Type: Error
Event Source: VSS
Event Category: None
Event ID: 8193
Description:
Volume Shadow Copy Service error: Unexpected error calling routine IClientVirtualDevice::GetCommand. hr = 0x80770004.
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
View 8 Replies
View Related
Mar 21, 2008
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 ...
any thoughts..
View 2 Replies
View Related
Feb 25, 2008
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?
View 1 Replies
View Related
May 22, 2008
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 ?
Thanx,
Barry O'Neill
View 6 Replies
View Related
May 8, 2007
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
Any Input / Direction is appreciated...
View 4 Replies
View Related
Mar 17, 2008
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 ?
Please help. Thanks
View 7 Replies
View Related
Jul 18, 2007
Hello,
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?
Thanks
View 11 Replies
View Related
Dec 6, 2007
Hi,
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 ?
View 1 Replies
View Related
Dec 25, 2007
Hi!!
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?
View 1 Replies
View Related
Sep 21, 2006
COM Plus Catalog Requirement (Warning)
Messages
COM Plus Catalog Requirement
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.
View 6 Replies
View Related
Aug 17, 2006
Hello Experts,
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.
Help! :(
View 1 Replies
View Related
Sep 13, 2007
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
View 2 Replies
View Related
Dec 20, 2005
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.
View 1 Replies
View Related
May 5, 2007
Hello;
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??
Thanks.
John
View 3 Replies
View Related
Jan 31, 2006
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.
View 4 Replies
View Related
