I was told that SQL2000 SP4 needs to install prior to installing SP2 for windows 2003 server. Is that true? What issues I will encounter if the installation is done the other way around?
Thanks for any insights
Dear ALl,
We have SQL 2005 running on Window 2003.
Our Dev team created a web application. Which user we need to add in the database and what permission we need to assign him. So web application can do read, write and modify in the database tables.
Database name = ACCT
IIS server name = MASS (running on different machine win 2003)
What role following accounts play in the connection of iis to database server login.
1: ASP.NET
2: MASSii$1 & massiis1
If
<indentitt impersonate = TRUE or False> in the config file..
Thanks in advance.
I have problem connecting to a SQL 2000 server that is hosted on a Windows 2003 server. My application uses classic ASP with VB6 components. VB6 components connect to SQL server and return data to ASP application. Everything was working fine when the application and SQL server was hosted on NT machine. Recently we have shifted to Windows 2003 server. Since then we could not establish connection to SQL2000.
I'm using UDL as connection string.
IIS and SQL2000 hosted on the same machine with Windows 2003 OS.
This seems to be a security issue. Earlier I faced this issue for a .net application which I resloved adding a domain account to both SQL server and IIS directory security.
Request your input to solve this problem.
Sunandajit Ray
Infrasoft Technologies Limited
i m trying to install sql server 2005 dev edition n window vista home primium.but onll book online part is installed.how can i install it.
View 1 Replies View RelatedCan you install 64 bit 2k5 sql server on 32 bit 2k3 OS, yes, no? if there is way then can anyone guide me.
thanks
Derek
I am going to start installing sql server soon, do I have to have IIS installed? Is it a requirement?
Thanks.
Hi there,
We've got a Windows 2003 (64 bit edition) box to use as our Database server.
I installed SQL Server 2005 (Standard Edition) on the machine, but I have a feeling it has installed the 32 bit version and not the 64 bit version.
The reason I think this is that the MSSQL directory is under the 32 bit program files directory and not the 64 bit directory, and also when I look at the service properties it says it's running from WOW6432 registry entry.
Is there a separate disc for the 64bit version? Does the installer automatically work out which version to install or is there some sort of switch I have to do to tell it to install the 64 bit version.
Many thanks for your time.
Simon
Has anyone run into the issue of installing SP1 on a 2003 R2 server?
I have seen a post or two on other sites but I cannot seem to find them again.
Install goes great up until it comes to the upgrading of SSIS (Integration Services).
At that point is fails with the error of:
A recently applied update, KB913090, failed to install.
This is a dialog box that I hit the "send error report" button. It then goes to the upgrading of the Client Components (CC) and fails with the same error message of:
A recently applied update, KB913090, failed to install.
The ugrade the continues after I hit the same "send error report"button.
ALL of the other steps complete with SUCESSFULLY. Only the SSIS and Client Components show a failed status in the Installation Prog
In the Installation Complete screen, I can highlight both the SSIS and CC and see an additional error of:
Unable to install Windows Installer MSP file
I then can hit the View Log button (which I have done for the SSIS step) and see the error log but I am having a tough time making heads or tails of it.
I have attached the output from the SSIS error log below.
I have a couple of questions:
1. Is the install of SP1 good for all the other steps that completed successfully
2. Has anyone had issues with installing SP1 on a Windows 2003 R2 server? I have installed SP1 on other Windows 2003 servers NOT running R2 and it ran like a champ.
Thanks ALL!
====== ERROR LOG FROM SSIS UPGRADE ============================================
01/07/2007 19:23:23.247 ================================================================================
01/07/2007 19:23:23.247 Hotfix package launched
01/07/2007 19:23:23.747 Product discovery successfully completed during the install process for DTS
01/07/2007 19:23:23.762 SP Level check successfully completed during the install process for DTS
01/07/2007 19:23:23.778 Product language check successfully completed during the install process for DTS
01/07/2007 19:23:23.793 Product version check successfully completed during the install process for DTS
01/07/2007 19:23:23.825 Command-line instance name check completed during the install process
01/07/2007 19:23:23.840 Baseline build check completed during the install process
01/07/2007 19:28:41.393 Attempting to install instance: DTS
01/07/2007 19:28:41.408 Attempting to install target: AUS02DB13
01/07/2007 19:28:41.440 Attempting to check for locked files: sqlrun_dts.msp
01/07/2007 19:28:41.502 Attempting to check for locked files: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp
01/07/2007 19:28:41.518 Creating MSP locked file check log at: C:WINDOWSHotfixDTS9LogsDTS9_Hotfix_KB913090_sqlrun_dts.msp.out
01/07/2007 19:28:48.799 MSP returned 1602: The user cancels installation.
01/07/2007 19:28:49.017 Successfully checked file: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp
01/07/2007 19:28:49.033 Successfully opened registry key: SystemCurrentControlSetControlSession Manager
01/07/2007 19:28:49.064 Successfully read registry key: PendingFileRenameOperations
01/07/2007 19:28:49.080 Multi-string values:
01/07/2007 19:28:49.096 ??g:a4be8c9b1bce3ffa869bbb5137
01/07/2007 19:28:49.111 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerShared9.0.2047.0
C:Program FilesMicrosoft SQL ServerShareddbghelp.dll
01/07/2007 19:28:49.127 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlDumper.exe
01/07/2007 19:28:49.142 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlDumper.exe
01/07/2007 19:28:49.158 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlDumper.exe
01/07/2007 19:28:49.174 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsqm.exe
01/07/2007 19:28:49.205 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinndtsinstall.exe
01/07/2007 19:28:49.221 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesmsmdsrv.rll
01/07/2007 19:28:49.236 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesmsmdsrv.rll
01/07/2007 19:28:49.252 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesmsmdsrv.rll
01/07/2007 19:28:49.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsmsmdlocal.dll
01/07/2007 19:28:49.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsmsmdlocal.dll
01/07/2007 19:28:49.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsmsmdlocal.dll
01/07/2007 19:28:49.314 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponents9.0.2047.0
C:Program FilesMicrosoft SQL ServerSharedmsmdlo~1.dll
01/07/2007 19:28:49.330 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServerCe.Dts.Provider9.0.242.0__89845dcd8080cc91Microsoft.SqlServerCe.Dts.Provider.dll
01/07/2007 19:28:49.361 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll
01/07/2007 19:28:49.377 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.CustomControls9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.CustomControls.dll
01/07/2007 19:28:49.392 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WizardFramework9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WizardFramework.dll
01/07/2007 19:28:49.408 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.Xmla9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.XMLA.dll
01/07/2007 19:28:49.424 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.OlapEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.OlapEnum.dll
01/07/2007 19:28:49.439 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.ActiveXScriptTask.xml
01/07/2007 19:28:49.455 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll
01/07/2007 19:28:49.470 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll
01/07/2007 19:28:49.486 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll
01/07/2007 19:28:49.517 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ActiveXScriptTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTask.dll
01/07/2007 19:28:49.533 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.ActiveXScriptTaskUtil.dll
01/07/2007 19:28:49.549 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.ActiveXScriptTask.dll
01/07/2007 19:28:49.580 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataTransformationServices.Controls9.0.242.0__89845dcd8080cc91Microsoft.DataTransformationServices.Controls.DLL
01/07/2007 19:28:49.595 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSWizard.exe
01/07/2007 19:28:49.611 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5SDKAssembliesMicrosoft.SqlServer.TxScript.dll
01/07/2007 19:28:49.627 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.TxScript.dll
01/07/2007 19:28:49.642 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TxScript9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TxScript.dll
01/07/2007 19:28:49.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSampling.dll
01/07/2007 19:28:49.689 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSampling.dll
01/07/2007 19:28:49.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSampling.dll
01/07/2007 19:28:49.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxRowCount.dll
01/07/2007 19:28:49.752 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxRowCount.dll
01/07/2007 19:28:49.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxRowCount.dll
01/07/2007 19:28:49.783 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Dts.DtsClient9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Dts.DtsClient.dll
01/07/2007 19:28:49.799 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataReaderDest9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataReaderDest.dll
01/07/2007 19:28:49.814 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.Dts.DtsClient.dll
01/07/2007 19:28:49.830 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.DataReaderDest.dll
01/07/2007 19:28:49.830 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferSqlServerObjectsTask.xml
01/07/2007 19:28:49.845 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferSqlServerObjectsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferSqlServerObjectsTask.dll
01/07/2007 19:28:49.877 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferSqlServerObjectsTask.dll
01/07/2007 19:28:49.892 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferStoredProceduresTask.xml
01/07/2007 19:28:49.908 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferLoginsTask.xml
01/07/2007 19:28:49.924 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferJobsTask.xml
01/07/2007 19:28:49.939 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferErrorMessagesTask.xml
01/07/2007 19:28:49.970 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.TransferDatabasesTask.xml
01/07/2007 19:28:49.986 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferStoredProceduresTask.dll
01/07/2007 19:28:50.002 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferLoginsTask.dll
01/07/2007 19:28:50.002 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferJobsTask.dll
01/07/2007 19:28:50.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferErrorMessagesTask.dll
01/07/2007 19:28:50.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferDatabasesTask.dll
01/07/2007 19:28:50.049 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TransferObjectsTask.dll
01/07/2007 19:28:50.064 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferStoredProceduresTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferStoredProceduresTask.dll
01/07/2007 19:28:50.080 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferLoginsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferLoginsTask.dll
01/07/2007 19:28:50.095 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferJobsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferJobsTask.dll
01/07/2007 19:28:50.111 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferErrorMessagesTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferErrorMessagesTask.dll
01/07/2007 19:28:50.111 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferDatabasesTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferDatabasesTask.dll
01/07/2007 19:28:50.127 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferObjectsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferObjectsTask.dll
01/07/2007 19:28:50.142 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DtsTransferProvider9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DtsTransferProvider.dll
01/07/2007 19:28:50.158 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TableTransferGeneratorTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TableTransferGeneratorTask.dll
01/07/2007 19:28:50.174 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.DtsTransferProvider.dll
01/07/2007 19:28:50.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.TableTransferGeneratorTask.dll
01/07/2007 19:28:50.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermExtraction.dll
01/07/2007 19:28:50.205 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermExtraction.dll
01/07/2007 19:28:50.220 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermExtraction.dll
01/07/2007 19:28:50.236 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermLookup.dll
01/07/2007 19:28:50.252 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermLookup.dll
01/07/2007 19:28:50.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxTermLookup.dll
01/07/2007 19:28:50.283 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResources.90.2047.0
E:MSSQLMSSQLSS2K5DTSBinnResourcesdts.rll
01/07/2007 19:28:50.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtsconn.rll
01/07/2007 19:28:50.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtsconn.rll
01/07/2007 19:28:50.314 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtsconn.rll
01/07/2007 19:28:50.330 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsenMicrosoft.SqlServer.ForEachAdoEnumerator.xml
01/07/2007 19:28:50.345 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsenMicrosoft.SqlServer.ForEachSMOEnumerator.xml
01/07/2007 19:28:50.377 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSConnectionsenMicrosoft.SqlServer.ManagedConnections.xml
01/07/2007 19:28:50.392 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSPipelinePerf.dll
01/07/2007 19:28:50.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtspipeline.rll
01/07/2007 19:28:50.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtspipeline.rll
01/07/2007 19:28:50.424 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnResourcesdtspipeline.rll
01/07/2007 19:28:50.439 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.FtpTask.xml
01/07/2007 19:28:50.455 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.FtpTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.FtpTask.dll
01/07/2007 19:28:50.470 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.FtpTask.dll
01/07/2007 19:28:50.486 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.ExecProcTask.xml
01/07/2007 19:28:50.517 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.SendMailTask.xml
01/07/2007 19:28:50.549 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.MSMQTask.xml
01/07/2007 19:28:50.580 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll
01/07/2007 19:28:50.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll
01/07/2007 19:28:50.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll
01/07/2007 19:28:50.611 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.MSMQTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQTask.dll
01/07/2007 19:28:50.627 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.MSMQUtil.dll
01/07/2007 19:28:50.642 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.MSMQUtil.dll
01/07/2007 19:28:50.658 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.MSMQUtil.dll
01/07/2007 19:28:50.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.MSMQTask.dll
01/07/2007 19:28:50.689 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMulticast.dll
01/07/2007 19:28:50.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMulticast.dll
01/07/2007 19:28:50.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMulticast.dll
01/07/2007 19:28:50.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsCommandDest.dll
01/07/2007 19:28:50.736 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsCommandDest.dll
01/07/2007 19:28:50.752 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsCommandDest.dll
01/07/2007 19:28:50.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileInserter.dll
01/07/2007 19:28:50.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileInserter.dll
01/07/2007 19:28:50.799 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileInserter.dll
01/07/2007 19:28:50.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileExtractor.dll
01/07/2007 19:28:50.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileExtractor.dll
01/07/2007 19:28:50.861 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxFileExtractor.dll
01/07/2007 19:28:50.877 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLineage.dll
01/07/2007 19:28:50.892 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLineage.dll
01/07/2007 19:28:50.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLineage.dll
01/07/2007 19:28:50.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnPivot.dll
01/07/2007 19:28:50.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnPivot.dll
01/07/2007 19:28:50.955 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnPivot.dll
01/07/2007 19:28:50.955 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponents.90.2047.0
E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxPivot.dll
01/07/2007 19:28:50.970 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMergeJoin.dll
01/07/2007 19:28:50.986 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMergeJoin.dll
01/07/2007 19:28:51.002 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxMergeJoin.dll
01/07/2007 19:28:51.017 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponents.90.2047.0
E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxUnAll.dll
01/07/2007 19:28:51.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSort.dll
01/07/2007 19:28:51.033 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSort.dll
01/07/2007 19:28:51.049 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSort.dll
01/07/2007 19:28:51.064 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSplit.dll
01/07/2007 19:28:51.080 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSplit.dll
01/07/2007 19:28:51.080 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxSplit.dll
01/07/2007 19:28:51.095 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLookup.dll
01/07/2007 19:28:51.111 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLookup.dll
01/07/2007 19:28:51.127 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxLookup.dll
01/07/2007 19:28:51.142 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxGroupDups.dll
01/07/2007 19:28:51.158 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxGroupDups.dll
01/07/2007 19:28:51.158 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxGroupDups.dll
01/07/2007 19:28:51.174 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDerived.dll
01/07/2007 19:28:51.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDerived.dll
01/07/2007 19:28:51.205 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDerived.dll
01/07/2007 19:28:51.220 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDataConvert.dll
01/07/2007 19:28:51.236 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDataConvert.dll
01/07/2007 19:28:51.252 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxDataConvert.dll
01/07/2007 19:28:51.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCopyMap.dll
01/07/2007 19:28:51.267 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCopyMap.dll
01/07/2007 19:28:51.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCopyMap.dll
01/07/2007 19:28:51.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCharMap.dll
01/07/2007 19:28:51.314 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCharMap.dll
01/07/2007 19:28:51.330 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxCharMap.dll
01/07/2007 19:28:51.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxBestMatch.dll
01/07/2007 19:28:51.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxBestMatch.dll
01/07/2007 19:28:51.361 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxBestMatch.dll
01/07/2007 19:28:51.377 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxAgg.dll
01/07/2007 19:28:51.392 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxAgg.dll
01/07/2007 19:28:51.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsTxAgg.dll
01/07/2007 19:28:51.424 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.XmlTask.xml
01/07/2007 19:28:51.439 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5dtsBinnatchparser90.dll
01/07/2007 19:28:51.455 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.SQLTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SQLTask.dll
01/07/2007 19:28:51.470 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnSQLTaskConnections.dll
01/07/2007 19:28:51.470 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnSQLTaskConnections.dll
01/07/2007 19:28:51.486 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnSQLTaskConnections.dll
01/07/2007 19:28:51.502 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.SQLTask.dll
01/07/2007 19:28:51.533 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsSqlDest.dll
01/07/2007 19:28:51.549 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsSqlDest.dll
01/07/2007 19:28:51.580 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsSqlDest.dll
01/07/2007 19:28:51.595 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5SDKAssembliesMicrosoft.SqlServer.ScriptTask.dll
01/07/2007 19:28:51.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ScriptTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ScriptTask.dll
01/07/2007 19:28:51.611 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.ScriptTask.dll
01/07/2007 19:28:51.627 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRecordSetDest.dll
01/07/2007 19:28:51.642 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRecordSetDest.dll
01/07/2007 19:28:51.658 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRecordSetDest.dll
01/07/2007 19:28:51.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawSource.dll
01/07/2007 19:28:51.674 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawSource.dll
01/07/2007 19:28:51.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawSource.dll
01/07/2007 19:28:51.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawDest.dll
01/07/2007 19:28:51.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawDest.dll
01/07/2007 19:28:51.736 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsRawDest.dll
01/07/2007 19:28:51.752 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.ASTasks.xml
01/07/2007 19:28:51.767 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ASTasks9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ASTasks.dll
01/07/2007 19:28:51.783 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.ASTasks.dll
01/07/2007 19:28:51.799 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbSrc.dll
01/07/2007 19:28:51.799 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbSrc.dll
01/07/2007 19:28:51.830 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbSrc.dll
01/07/2007 19:28:51.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbDest.dll
01/07/2007 19:28:51.845 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbDest.dll
01/07/2007 19:28:51.861 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsOleDbDest.dll
01/07/2007 19:28:51.892 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileDest.dll
01/07/2007 19:28:51.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileDest.dll
01/07/2007 19:28:51.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileDest.dll
01/07/2007 19:28:51.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileSrc.dll
01/07/2007 19:28:51.955 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileSrc.dll
01/07/2007 19:28:51.955 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsFlatFileSrc.dll
01/07/2007 19:28:51.970 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.FileSystemTask.xml
01/07/2007 19:28:51.986 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.FileSystemTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.FileSystemTask.dll
01/07/2007 19:28:52.017 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.FileSystemTask.dll
01/07/2007 19:28:52.033 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnExecPackageTask.dll
01/07/2007 19:28:52.049 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.DmQueryTask.xml
01/07/2007 19:28:52.064 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DMQueryTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DmQueryTask.dll
01/07/2007 19:28:52.064 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.DmQueryTask.dll
01/07/2007 19:28:52.095 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.BulkInsertTask.xml
01/07/2007 19:28:52.111 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll
01/07/2007 19:28:52.127 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll
01/07/2007 19:28:52.142 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll
01/07/2007 19:28:52.158 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.BulkInsertTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTask.dll
01/07/2007 19:28:52.174 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMicrosoft.SqlServer.BulkInsertTaskConnections.dll
01/07/2007 19:28:52.189 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.BulkInsertTask.dll
01/07/2007 19:28:52.205 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.WMIEWTask.xml
01/07/2007 19:28:52.220 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.WMIDRTask.xml
01/07/2007 19:28:52.236 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSTasksenMicrosoft.SqlServer.WebServiceTask.xml
01/07/2007 19:28:52.252 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WebServiceTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WebServiceTask.dll
01/07/2007 19:28:52.267 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.MaintenancePlanTasks9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MaintenancePlanTasks.dll
01/07/2007 19:28:52.283 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.WebServiceTask.dll
01/07/2007 19:28:52.299 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSTasksMicrosoft.SqlServer.MaintenancePlanTasks.dll
01/07/2007 19:28:52.314 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesdtspipeline.rll
01/07/2007 19:28:52.330 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesdtspipeline.rll
01/07/2007 19:28:52.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsResourcesdtspipeline.rll
01/07/2007 19:28:52.345 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexceldest.dll
01/07/2007 19:28:52.377 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexceldest.dll
01/07/2007 19:28:52.392 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexceldest.dll
01/07/2007 19:28:52.392 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexcelsrc.dll
01/07/2007 19:28:52.408 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexcelsrc.dll
01/07/2007 19:28:52.439 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsexcelsrc.dll
01/07/2007 19:28:52.439 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.XMLSrc.dll
01/07/2007 19:28:52.455 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSPipelineComponentsMicrosoft.SqlServer.ADONETSrc.dll
01/07/2007 19:28:52.470 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.XmlSrc9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.XMLSrc.dll
01/07/2007 19:28:52.486 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ADONETSrc9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ADONETSrc.dll
01/07/2007 19:28:52.502 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.PipelineHost9.0.242.0__89845dcd8080cc91Microsoft.SQLServer.PipelineHost.dll
01/07/2007 19:28:52.517 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSPipeline.dll
01/07/2007 19:28:52.533 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ForEachNodeListEnumerator9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ForEachNodeListEnumerator.dll
01/07/2007 19:28:52.549 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ForEachSMOEnumerator9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ForEachSMOEnumerator.dll
01/07/2007 19:28:52.564 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll
01/07/2007 19:28:52.580 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll
01/07/2007 19:28:52.595 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll
01/07/2007 19:28:52.595 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0
E:MSSQLMSSQLSS2K5DTSBinnDTSComEx.dll
01/07/2007 19:28:52.611 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinndtsmsg.dll
01/07/2007 19:28:52.642 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTSLog.dll
01/07/2007 19:28:52.642 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0
E:MSSQLMSSQLSS2K5DTSBinnDtsUt.dll
01/07/2007 19:28:52.658 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinnDTS.dll
01/07/2007 19:28:52.674 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0
E:MSSQLMSSQLSS2K5DTSBinnDTEParsM.dll
01/07/2007 19:28:52.705 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5DTSBinn.90.2047.0
E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsNodeList.dll
01/07/2007 19:28:52.705 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsForEachFileEnumerator.dll
01/07/2007 19:28:52.720 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsForEachFileEnumerator.dll
01/07/2007 19:28:52.736 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsForEachFileEnumerator.dll
01/07/2007 19:28:52.752 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSForEachEnumeratorsMicrosoft.SqlServer.ForEachSMOEnumerator.dll
01/07/2007 19:28:52.767 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5DTSBinnMsDtsSrvr.exe
01/07/2007 19:28:52.783 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NETenMicrosoft.AnalysisServices.AdomdClient.xml
01/07/2007 19:28:52.799 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NETMicrosoft.AnalysisServices.AdomdClient.dll
01/07/2007 19:28:52.814 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll
01/07/2007 19:28:52.830 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedmsasxpress.dll
01/07/2007 19:28:52.845 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedmsasxpress.dll
01/07/2007 19:28:52.861 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedmsasxpress.dll
01/07/2007 19:28:52.877 Failed to read version information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResources
E:MSSQLMSSQLSS2K5ToolsBinnResourcessqlcm.xml
01/07/2007 19:28:52.877 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResourcesSqlManager.rll
01/07/2007 19:28:52.908 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResourcesSqlManager.rll
01/07/2007 19:28:52.924 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsBinnResourcesSqlManager.rll
01/07/2007 19:28:52.939 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsinnSqlManager.dll
01/07/2007 19:28:52.939 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsinnSqlManager.dll
01/07/2007 19:28:52.970 Failed to read associated hotfix build information for the following file: E:MSSQLMSSQLSS2K5ToolsinnSqlManager.dll
01/07/2007 19:28:52.986 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsvcsync.dll
01/07/2007 19:28:52.986 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsvcsync.dll
01/07/2007 19:28:53.002 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsvcsync.dll
01/07/2007 19:28:53.017 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsecacctchg.dll
01/07/2007 19:28:53.033 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsecacctchg.dll
01/07/2007 19:28:53.049 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlsecacctchg.dll
01/07/2007 19:28:53.064 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlftacct.dll
01/07/2007 19:28:53.064 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlftacct.dll
01/07/2007 19:28:53.095 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsqlftacct.dll
01/07/2007 19:28:53.111 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedisacctchange.dll
01/07/2007 19:28:53.111 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedisacctchange.dll
01/07/2007 19:28:53.127 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedisacctchange.dll
01/07/2007 19:28:53.158 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsvrenumapi.dll
01/07/2007 19:28:53.174 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsvrenumapi.dll
01/07/2007 19:28:53.189 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedsvrenumapi.dll
01/07/2007 19:28:53.189 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerShared.90.2047.0
C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Rmo.dll
01/07/2007 19:28:53.205 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL
01/07/2007 19:28:53.236 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL
01/07/2007 19:28:53.252 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll
01/07/2007 19:28:53.252 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
01/07/2007 19:28:53.267 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
01/07/2007 19:28:53.299 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
01/07/2007 19:28:53.299 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll
01/07/2007 19:28:53.314 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll
01/07/2007 19:28:53.330 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll
01/07/2007 19:28:53.345 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll
01/07/2007 19:28:53.361 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll
01/07/2007 19:28:53.377 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedSqlSAC.exe
01/07/2007 19:28:53.392 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerSharedMicrosoft.SqlSac.Public.dll
01/07/2007 19:28:53.392 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.msxml6_interop6.0.0.0__89845dcd8080cc91Microsoft.SqlServer.msxml6_interop.dll
01/07/2007 19:28:53.517 Attempting to install file: sqlrun_dts.msp
01/07/2007 19:28:53.548 Attempting to install file: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp
01/07/2007 19:28:53.564 Creating MSP install log file at: C:WINDOWSHotfixDTS9LogsDTS9_Hotfix_KB913090_sqlrun_dts.msp.log
01/07/2007 19:28:53.580 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
01/07/2007 19:28:53.580 Failed to read registry key: Debug
01/07/2007 19:29:48.375 MSP returned 1603: A fatal error occurred during installation.
01/07/2007 19:29:48.672 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
01/07/2007 19:29:48.687 Failed to read registry key: Debug
01/07/2007 19:29:48.687 Unable to install MSP file: \AUS02DB13g$2fe15a257eaedfc36c121fc912HotFixDTSFilessqlrun_dts.msp
01/07/2007 19:29:48.703 The following exception occurred: Unable to install Windows Installer MSP file Date: 01/07/2007 19:29:48.703 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856
01/07/2007 19:29:48.750
01/07/2007 19:29:48.765 Product Status Summary:
01/07/2007 19:29:48.781 Product: SQL Server Native Client
01/07/2007 19:29:48.797 SQL Server Native Client (RTM ) - Success
01/07/2007 19:29:48.812
01/07/2007 19:29:48.828 Product: Setup Support Files
01/07/2007 19:29:48.844 Setup Support Files (RTM ) - Success
01/07/2007 19:29:48.844
01/07/2007 19:29:48.859 Product: Database Services
01/07/2007 19:29:48.875 Database Services (SP1 2047 ENU) - Success
01/07/2007 19:29:48.890
01/07/2007 19:29:48.906 Product: Integration Services
01/07/2007 19:29:48.922 Integration Services (SP1 ENU) - Failure
01/07/2007 19:29:48.937 Details: Unable to install Windows Installer MSP file
01/07/2007 19:29:48.953
01/07/2007 19:29:48.969 Product: Client Components
01/07/2007 19:29:48.969 Client Components (SP1 2047 ENU) - Not Applied
01/07/2007 19:29:48.984
01/07/2007 19:29:49.015 Product: MSXML 6.0 Parser
01/07/2007 19:29:49.062 MSXML 6.0 Parser (RTM ) - Not Applied
01/07/2007 19:29:49.078
01/07/2007 19:29:49.094 Product: SQLXML4
01/07/2007 19:29:49.109 SQLXML4 (RTM ) - Not Applied
01/07/2007 19:29:49.109
01/07/2007 19:29:49.140 Product: Backward Compatibility
01/07/2007 19:29:49.156 Backward Compatibility (RTM ) - Not Applied
01/07/2007 19:29:49.156
01/07/2007 19:29:49.172 Product: Microsoft SQL Server VSS Writer
01/07/2007 19:29:49.187 Microsoft SQL Server VSS Writer (RTM ) - Not Applied
01/07/2007 19:29:49.203
I get and error when installing MS SQL 2005 on Windows 2003 server with SP2. It bombs at the very end of the install and Microsoft notification program generated he message below to be sent to Microsoft. Please help. At a stand still.
-------------------------------------------------------------------------------------------------------------------
EventType : sql90setup P1 : unknown P2 : 0x645 P3 : unknown
P4 : 0x645 P5 : unknown P6 : unknown P7 : sqlserver2005_bc.msi@
Below is the summary.txt
-------------------------------------
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
Time : Thu Feb 28 22:52:28 2008
Machine : ESAPPS
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_1.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_1.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_2.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_2.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_3.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_3.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_3.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_BOL_1.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_3.log
--------------------------------------------------------------------------------
Machine : ESAPPS
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLXML4_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Thu Feb 28 23:01:11 2008
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_BackwardsCompat_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLSupport_3.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLNCLI_3.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_OWC11_3.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_BOL_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_MSXML6_3.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SQLXML4_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework 2.0 LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework Upgrade Advisor.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework Upgrade Advisor LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework Windows Installer.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_.NET Framework Windows Installer LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_SCC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_ESAPPS_WI.log
Hello.
When I installed SQL 2005 SP1 on Windows 2003 Server, I received the following message:
"A recently applied update, KB913090, failed to install."
At the end, "Database Services" was marked as "Failure".
I have tried everything I could find in the knowledge base and on the forums, but still
was not able to install SP1.
For example:
http://support.microsoft.com/default.aspx?scid=kb;en-us;918357
Any insights would be greatly appreciated.
compare to ms sql 2000, the newer version seems to be slow when i tryto open or modify a table. is this a demerit of the newer vesion or mymachine problem?
View 4 Replies View RelatedI have a windows 2003 server with the latest service pack and patches. This server also acts a domain controller.
View 4 Replies View RelatedGood Day,
I have an application that is being developed on Visual Studio 2005 (VB) and SQL Express. The application is set up to use the SQL Express on the development computer, and if an Internet or CD install is built, it installs SQL Express as expected. The question is, when it is time to deploy and put the SQL Express database on the 2003 server, how should the install on the server be done and how should we set the database path to the server?
Thanks,
Dave
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.
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.
Hi All,
When we to inset record into the tables through BCP we are getting following errors.
C:> bcp ACCT.dbo.dtpro out C: estdtpro_TA.dat -T-n
C:>bcp ACCT.dbo.Semiaa out C: estSemiaa_TA.dat -T -n
BCP out works fine only BCP in have problems.
Please can you let me know how to resolved this problem.
===========
Exp - 1
===========
C:> bcp ACCT.dbo.dtpro in C: estdtpro_TA.dat -T-n
Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
===========
Exp - 2
===========
C:>bcp ACCT.dbo.Semiaa in C: estSemiaa_TA.dat -T -n
Starting copy...
SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
0 rows copied.
Network packet size (bytes): 4096
Clock Time (ms.) Total : 1
============
Exp-3
============
C:>bcp ACCT.dbo.SemiH in C: estSemiH_TA.dat -T -n
Starting copy...SQLState = HY000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unexpected EOF encountered in BCP data-file
SQLState = 42000, NativeError = 7339
Error = [Microsoft][SQL Native Client][SQL Server]OLE DB provider 'STREAM' for l
inked server '(null)' returned invalid data for column '[!BulkInsert].Created'.
BCP copy in failed
Thanks in Advance
when trying to install SQL Sever 2005 to windows server 2003 its display the message Windows Installer 3.1 is required. But when tring to install windows installer 3.1 is displays the message Service Pack version of newer than the update that you are applying, Ther is no need to install the update. Why?
View 1 Replies View RelatedHello
I've installed Windows 2003 SP2 in a stand-alone cluster (will be adding a second node later). I'm now installing SQL Server 2005 Developer Edition 64-bit extended and would like to have the "Create a SQL Server Failover Cluster" box to not be grayed out. Even when I check the "SQL Server Database Services" box, it still has the cluster box grayed out.
Any idea's?
TIA!
I've successfully installed SQL Server 2005 Standard Edition on an Enterprise edition of Windows Server 2003 x64. I'm now (and also tried & failed during the install of the database engine) attempting to install the "Management Tools" component on the same server. However, in all my attempts to do so, I receive the following error:
---
The feature(s) specified are not valid for this edition of SQL Server
---
The message box does not list the features that are not valid but since the only item I've selected to install is the "Management Tools" option under "Client Components" it obviously points to something with that.
Am I missing something or are the Management Tools not supported in my config - most notably SQL Server 2005 Standard edition running on Windows Server 2003 x64?
Thanks.
- Lance
Colorado State University
I am attempting to install SQL Server 2005 on a Laptop with Windows 2003 Standard Edition.
The installation fails and the File Summary.txt has the following entries:
Microsoft SQL Server 2005 9.00.1399.06
==============================
OS Version : Microsoft Windows Server 2003 family, Standard Edition Service Pack 2 (Build 3790)
Time : Fri Nov 30 09:36:53 2007
Machine : SAPDEMO
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log
--------------------------------------------------------------------------------
Machine : SAPDEMO
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log
--------------------------------------------------------------------------------
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%Microsoft SQL Server90Setup BootstrapLOGSummary.txt.
Time : Fri Nov 30 09:38:41 2007
List of log files:
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core(Local).log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SqlWriter_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_MSXML6_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLSupport_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLNCLI_2.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_BOL_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SQLXML4_1.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Datastore.xml
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Core.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGSummary.txt
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework 2.0 LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Upgrade Advisor LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_.NET Framework Windows Installer LangPack.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SNAC.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_Support.log
C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0006_SAPDEMO_SCC.log
The Log File, SQLSetup0004_<hostname>_Core.log, has the following entries:
Microsoft SQL Server 2005 Setup beginning at Mon Dec 03 08:54:09 2007
Process ID : 2980
C:SAP_CDCD2x86EnterpriseEditionServerssetup.exe Version: 2005.90.1399.0
Running: LoadResourcesAction at: 2007/11/3 8:54:9
Complete: LoadResourcesAction at: 2007/11/3 8:54:9, returned true
Running: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9
Loaded DLL:C:SAP_CDCD2x86EnterpriseEditionServersxmlrw.dll Version:2.0.3604.0
Complete: ParseBootstrapOptionsAction at: 2007/11/3 8:54:9, returned true
Running: ValidateWinNTAction at: 2007/11/3 8:54:9
Complete: ValidateWinNTAction at: 2007/11/3 8:54:9, returned true
Running: ValidateMinOSAction at: 2007/11/3 8:54:9
Complete: ValidateMinOSAction at: 2007/11/3 8:54:9, returned true
Running: PerformSCCAction at: 2007/11/3 8:54:9
Complete: PerformSCCAction at: 2007/11/3 8:54:9, returned true
Running: ActivateLoggingAction at: 2007/11/3 8:54:9
Complete: ActivateLoggingAction at: 2007/11/3 8:54:9, returned true
Delay load of action "DetectPatchedBootstrapAction" returned nothing. No action will occur as a result.
Action "LaunchPatchedBootstrapAction" will be skipped due to the following restrictions:
Condition "EventCondition: __STP_LaunchPatchedBootstrap__2980" returned false.
Running: PerformSCCAction2 at: 2007/11/3 8:54:9
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042
Loaded DLL:C:WINDOWSsystem32msi.dll Version:3.1.4000.4042
Complete: PerformSCCAction2 at: 2007/11/3 8:54:9, returned true
Running: PerformDotNetCheck at: 2007/11/3 8:54:9
Complete: PerformDotNetCheck at: 2007/11/3 8:54:9, returned true
Running: ComponentUpdateAction at: 2007/11/3 8:54:9
Complete: ComponentUpdateAction at: 2007/11/3 8:55:6, returned true
Running: DetectLocalBootstrapAction at: 2007/11/3 8:55:6
Complete: DetectLocalBootstrapAction at: 2007/11/3 8:55:6, returned true
Running: LaunchLocalBootstrapAction at: 2007/11/3 8:55:6
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1605
Aborting queue processing as nested installer has completed
Message pump returning: 1605
Regards
How do I do this when my instalation cd is an old veriosn with no SPīs? Win2003 requires MS SQL 2000 SP3 sp what do I do???RegardsAnders
View 2 Replies View RelatedWhat is the corrrect way to install 6.5 and 2000 on a winnt server? I need to do this to test a 6.5 upgrade to 2000.
I'm having issues with the installs and not sure if i have the right order or not. Any ideas?
thanks in advance. :rolleyes:
Hi,I'm installing SQL2000 on a new cluster server.I selected a 'custom installation' and was presented with a'Collation settings' screen.I need it to be SQL_Latin1_General_CP1_CI_AS collationas I will be restoring databases with this collation.What should I choose from the 'Collation designator' and 'SQLCollations' box.Is it 'Dictionary order, case-insensitive, for use with 1252characters'?What will be the default? Will it be the same default as for the'typical' installation?Thanks
View 1 Replies View Relatedi have a vista basic running on my lappy,i have beeen trying to install either sql2000 or sql2005 on it for the past one month i keep getting funny errors like installshield engine has stopped working.WHile on the sql2005 the installation will exclude the database mangament studio ,etc..I had disabled the norton antivirus running to no effect.
I really need help here!
Hi, though i've been using sql server 2000 developer edition for awhile, I guess i overlooked the fact that the full-text search tool was never installed and i never needed it until now. Anyway, tried installing it today and get this error:
Installation of Microsoft Full-Text Search Engine Package Failed (-2147220991) 0x80040201
An event was unable to invoke any of the subsribers
I have no idea what this means - can you help me to get this installed correctly? I did just install service pack 4, and i tried reinstalling the components, tried rebuilding the registery of the current instance, and even tried creating a new instance with hopes that the new instance would install the full-text component - which it did not.
Any suggestions? I just completely uninstalled sql2000 and did a full-reinstallation and still it wont let me install the full-text search engine component - i check the checkbox in the installation wizard and then it gives me the same error as above.
Thanks ahead!
Dan
Hello, I'll start by saying that I don't know the first thing about SQL.
I have product that I am trying to setup on a windows 2003 R2 SP2 server that requires SQL Server Express 2005. I have this same setup installed under Windows XP Pro SP2 and it works fine.
The product uses a PHP script to talk to the SQL Server to create the orginal DB but I get the following errors:
*******************************************************************************************************************************************
Creating initial MFP Database...
Warning: mssql_pconnect() [function.mssql-pconnect]: Unable to connect to server: localhost,1444 in C:Inetpubwwwrootdbwrap.php on line 15
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: SELECT * FROM master.dbo.sysdatabases WHERE name = 'MFPACS'
Warning: mssql_num_rows(): supplied argument is not a valid MS SQL-result resource in C:Inetpubwwwrootdbwrap.php on line 55
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: CREATE DATABASE MFPACS
Warning: mssql_select_db(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 26
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: CREATE TABLE Logs ( username varchar(32) not null, accesstime datetime not null, message varchar(32) not null )
Warning: mssql_query(): supplied argument is not a valid MS SQL-Link resource in C:Inetpubwwwrootdbwrap.php on line 34
MSSQL Query Error:
Error:
Query: CREATE TABLE Users ( username varchar(32) not null, passmd5 char(32) not null, fullname varchar(64) not null, access int not null, interface int not null, timeout int not null, loggedin bit not null, remoteip varchar(16) null, lastaction datetime null )
*********************************************************************************************************
I have enabled the running of PHP scripts under IIS in Windows 2003 R2 (along with all of the other listed web executables). But I am stuck. For some reason the PHP scripts seem to either not have permission to talk to the DB, or Windows has some extra security in it that I need to know how to work correctly with.
I also am checking my ODBC > System DSN
when I try to craete my datasource, I get:
Connection Failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client]Named Pipes Provider: Could not open a connection to SQL Server [2].
Connection failed;
SQLState: 'HYT00'
SQL Server Error: 0
[Microsoft][SQL Native Client]Login timeout expired
Connection Failed:
SQLState: '08001'
SQL Server Error: 2
[Microsoft][SQL Native Client] An error has occurred while establishing a connection to the server. When connecting to the SQL server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
FYI I have set TCP/IP properties for SQL under Protocol > General > Enable - YES.
Thanks for any assistance.
Hello to all,
we try to install an SQL 2005 server on a Windows 2003 server that is also a Domain controller. In discussions of july last year, Dan Jones said :"Unfortunately in setup you cannot change the default account for all services. So there is absolutely no work around for this problem. This will absolutely be fixed by RTM - "
Can anybody help me in that way. We tried installing with our latest CDs (december 2005)
I've been having no luck trying to install SQL 2k 32bit on Windows 2003 64bit x86 SP1 - I've found several articles regarding needing to put SP4 on the 64bit OS, but my problem is the SQL 2k 32bit ",,x86setupsetupsql" won't run.
I consistantly receive a "...(localuserdir)Local.ins. Unable to load installaion instructions. Error 703."
And of course, the SP4 setup won't run because there is not an existing SQL Service to upgrade.
Anyone come up against a similar problem?
Thanks!
hi
I have installed SQL Server Reporting Service on window xp. everything working fine except one thing.
I have installed sql server with my a/c. my a/c have admin rights. when i giving http://dineshpatel/reports it is displaying page but Report Builder and other option are not displaying. I hope i don't have admin rights.
I have checked with local administrator login also but same problem.
what additional setting are require for admin rights?
Dinesh Patel
Dear members,
In MSDN, it says that it is recommended to use windows authentication to connect to SQL Server rather than use mixed authentication.
I create user deltasqluser on windows OS, and I specify in my webform ASP.NET script below :
protected System.Web.UI.WebControls.Label Label1;
private string _connString = @"data source=deltasql2000;initial catalog=northwind;integrated security=false;user id=deltasqluser";
/*
comment : I login to my windows as deltakoronx, and I want to every user (including me), connected to sql server through IIS, will be identified as deltasqluser not as user's login (impersonate)
*/
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection(_connString);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select suser_sname()";
conn.Open();
string userName = cmd.ExecuteScalar() as string;
conn.Close();
conn.Close();
Label1.Text = userName;
}
at web.config, I add :
<identity impersonate="false" userName="deltasqluser" password="" />
at IIS webApplication1's properties, tab "Directory Security", at "Authentication and access control" section, I checked "enable anonymous access" with user : DELTAIUSR_DELTA and checked "Integrated Windows Authentication",
at query analyzer, I login as "sa" and execute script below :
exec sp_grantdbaccess 'deltasqluser','northwind'
when I run the ASP.NET script, error at conn.Open(); with error message :
Login failed for user 'NT AUTHORITYNETWORK SERVICE'.
What should I do so that IIS login to SQL Server as user deltasqluser not as "NT AUTHORITYNETWORK SERVICE" ?
Regards,
Koronx
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
Is it possible to install and configure the MSDTC resource in a SQL Server 2000 cluster after SQL is installed and running?
When I recently went through a rebuild of my cluster, I forgot to install the resource before installing SQL Server. Now, if I install and bring online the MSDTC resource the SQL disk groups will not fail over correctly. The SQL Server resource will not come online.
Thanks in advance for any help. I would really like to avoid rebuilding again.
Andy
Hi,
I am using SSRS Microsoft SQL Server Reporting Services Designers
Version 9.00.1399.00. I want to open linked report in new window.
I tried whats mentioned in http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=240172&SiteID=1 but i get an error on Window.Open method.
How do I solve the problem?
Thanks