SP2 Fails On Upgrading Database Services

Apr 27, 2007

I have a WinXP Pro sp2 system that I have installed SQL Express in one case and in another caes I have installed SQL Express sp1. When trying to upgrade either to the next service pack, I get a "Setup Failed" on the "SQL Server Database Services". When I look at the log file, the following is the error:

...
MSI (s) (F8!28) [14:43:23:980]: PROPERTY CHANGE: Adding EditionTypechecksum.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 property. Its value is 'Express Edition with Advanced Services'.
<Func Name='GetSkuIt'>
GetServiceUserGroup failed for SQLEXPRESS, 5
Error Code: 0x80070534 (1332)
Windows Error Text: No mapping between account names and security IDs was done.
Source File Name: sqlcasqlcax.cpp
Compiler Timestamp: Fri Feb 9 22:35:05 2007
Function Name: SetInstanceProperty
Source Line Number: 1223

Error Code: 1332
MSI (s) (F8!28) [14:43:27:235]: Product: Microsoft SQL Server 2005 -- Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

Error 29528. The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation.

<EndFunc Name='LaunchFunction' Return='1332' GetLastError='203'>...



I was hoping someone has run into this before and can direct me to the solution.



Thank you.



KSLarson

View 3 Replies


ADVERTISEMENT

Analysis Services 2005 Database Processing Fails When Run From Integration Services

Oct 11, 2007

Hello, I have a problem when trying to fully process an SSAS database using Integration Services "Analysis Services Processing Task" task. I have 2 of these tasks which are responsible for processing the Dimensions then the Cubes. When I run the package either via the BIDS environment or on the local server from the Integration Services engine, I will get an error after about 20 minutes stating:

"Error: Memory Error: Allocation failure. Not enough storage is available to process this command""Error: Errors in the metadata manager. An error occurred when loading the <cube name> cube from the file \?D:Program FilesMicrosoft SQL ServerMSSQL.2OLAPDataMyWarehouse<cube file>.xml"

The cube name is not specific, it will fail and any of my cubes could be in the error log

If I fully process the AS database using the AS engine (logon to local AS server, right-click AS database and click Process), I get no errors at all, it processes and completes fine. The processing options are identical when I run in AS or via the SSIS "Analysis Services Processing Task" task.

I've searched quite a lot online but no joy, the information I have gleaned from various sites does not directly link SSIS with SSAS processing problems.

When either the AS processing starts via SSAS or SSIS the memory usage of MSMDSRV.exe increases to around 1.4 / 1.5 GB but never goes to 2GB ever, even when the error appears.

I've done the following with no effect.

" Have run via AS and works fine
" No specific cube it fails on
" Have created a Dimension only package, same problem
" Changed the maxmemorylimit
" Changed the connections to localhost
" Memory DOES NOT max out on server

Server Specs:
Windows Server 2003 Standard + Service Pack 2
4GM ram, 2GB paging file

SQL Server 2005 + Service Pack 2


Can anyone help?

Andy

View 2 Replies View Related

2005 SP2 Update Fails On Database Services

Apr 15, 2008

I tried to upgrade my SQL Server 2005 Developer edition to SP2 today. What a disaster.


The install of the update fails because the installer process can't get my MSSQLSERVER instance to restart after it's done updating all the files.


Everything else in the SP2 upgrade succeeds. Now my SQL Server instance won't start. The following is what ends up in my ERRORLOG file when I try to start the Service:






Code Snippet

2008-04-15 14:43:45.29 Server (c) 2005 Microsoft Corporation.


2008-04-15 14:43:45.29 Server All rights reserved.
2008-04-15 14:43:45.29 Server Server process ID is 3692.
2008-04-15 14:43:45.29 Server Authentication mode is MIXED.
2008-04-15 14:43:45.29 Server Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2008-04-15 14:43:45.29 Server This instance of SQL Server last reported using a process ID of 3316 at 4/15/2008 2:43:00 PM (local) 4/15/2008 9:43:00 PM (UTC). This is an informational message only; no user action is required.
2008-04-15 14:43:45.29 Server Registry startup parameters:
2008-04-15 14:43:45.29 Server -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2008-04-15 14:43:45.29 Server -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2008-04-15 14:43:45.29 Server -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2008-04-15 14:43:45.31 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2008-04-15 14:43:45.31 Server Detected 1 CPUs. This is an informational message; no user action is required.
2008-04-15 14:43:45.42 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2008-04-15 14:43:45.43 Server Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2008-04-15 14:43:45.45 Server The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like distributed transaction functionality, please start this service.
2008-04-15 14:43:45.45 Server Database mirroring has been enabled on this instance of SQL Server.
2008-04-15 14:43:45.46 spid5s Starting up database 'master'.
2008-04-15 14:43:45.54 spid5s SQL Trace ID 1 was started by login "sa".
2008-04-15 14:43:45.56 spid5s Starting up database 'mssqlsystemresource'.
2008-04-15 14:43:45.56 spid5s The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2008-04-15 14:43:45.62 spid5s Server name is 'NATHAN-PARALLEL'. This is an informational message only. No user action is required.
2008-04-15 14:43:45.84 Server The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x80090304. Check certificates to make sure they are valid.
2008-04-15 14:43:45.84 Server Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2008-04-15 14:43:45.84 Server Error: 17182, Severity: 16, State: 1.
2008-04-15 14:43:45.84 Server TDSSNIClient initialization failed with error 0x80090304, status code 0x80.
2008-04-15 14:43:45.84 Server Error: 17182, Severity: 16, State: 1.
2008-04-15 14:43:45.84 Server TDSSNIClient initialization failed with error 0x80090304, status code 0x1.
2008-04-15 14:43:45.84 Server Error: 17826, Severity: 18, State: 3.
2008-04-15 14:43:45.84 Server Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2008-04-15 14:43:45.84 Server Error: 17120, Severity: 16, State: 1.
2008-04-15 14:43:45.84 Server SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.




I'm currently dead in the water on two development projects until this is resolved. Of course there's no way to uninstall SP2, and since I have to install SQL Server over a network using VPN it'll take me several hours to complete a reinstall... not to mention I still won't have SP2.


Please help.


-Nathan

View 6 Replies View Related

SQL Server 2005 SP1 Fails When Installing Database Services

Apr 10, 2007

I can't seem to get all of the SQL9_Hotfix_KB913090_sqlrun_sql.msp.log to post (too big), but I can post the SQL9_Hotfix_KB913090.log file...hope that helps and which seems to me might contain the clue as to what's going. Any ideas would be appreciated. This is happening on a fresh install of Win Server 2003 and SQL Server standard 2005.



Thanks,

Steve



04/09/2007 16:14:30.562 ================================================================================
04/09/2007 16:14:30.578 Hotfix package launched
04/09/2007 16:14:33.312 Product discovery successfully completed during the install process for MSSQLSERVER
04/09/2007 16:14:33.328 SP Level check successfully completed during the install process for MSSQLSERVER
04/09/2007 16:14:33.359 Product language check successfully completed during the install process for MSSQLSERVER
04/09/2007 16:14:33.390 Product version check successfully completed during the install process for MSSQLSERVER
04/09/2007 16:14:33.421 Command-line instance name check completed during the install process
04/09/2007 16:14:33.437 Baseline build check completed during the install process
04/09/2007 16:16:52.828 Attempting to install instance: MSSQLSERVER
04/09/2007 16:16:52.875 Attempting to install target: TURBULENT2
04/09/2007 16:16:53.015 Attempting to stop service: SQLSERVERAGENT
04/09/2007 16:16:58.171 Successfully stopped service: SQLSERVERAGENT
04/09/2007 16:16:58.203 Attempting to stop service: MSSQLServer
04/09/2007 16:17:00.250 Successfully stopped service: MSSQLServer
04/09/2007 16:17:00.281 Attempting to check for locked files: sqlrun_sql.msp
04/09/2007 16:17:00.468 Attempting to check for locked files: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp
04/09/2007 16:17:00.500 Creating MSP locked file check log at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.out
04/09/2007 16:17:38.125 MSP returned 1602: The user cancels installation.
04/09/2007 16:17:38.328 Successfully checked file: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp
04/09/2007 16:17:38.359 Successfully opened registry key: SystemCurrentControlSetControlSession Manager
04/09/2007 16:17:38.421 Failed to read registry key: PendingFileRenameOperations
04/09/2007 16:17:38.468 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlfilt.dll
04/09/2007 16:17:38.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnThaWBrkr.dll
04/09/2007 16:17:38.562 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnquery.dll
04/09/2007 16:17:38.609 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnls400.dll
04/09/2007 16:17:38.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnlhtml.dll
04/09/2007 16:17:38.734 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsir5jp.dll
04/09/2007 16:17:38.765 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftesql.exe
04/09/2007 16:17:38.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftepxy.dll
04/09/2007 16:17:38.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsftefd.exe
04/09/2007 16:17:38.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnmsfte.dll
04/09/2007 16:17:38.890 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnLangWrbk.dll
04/09/2007 16:17:38.921 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnkorwbrkr.dll
04/09/2007 16:17:38.937 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinninfosoft.dll
04/09/2007 16:17:38.968 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnFTERefFTERef.dll
04/09/2007 16:17:39.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnCHTBRKR.DLL
04/09/2007 16:17:39.015 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnChsBrkr.dll
04/09/2007 16:17:39.046 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMResources1033REPLRES.rll
04/09/2007 16:17:39.062 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
eplrec.dll
04/09/2007 16:17:39.093 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
plisapi.dll
04/09/2007 16:17:39.156 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:WINDOWSassemblyGAC_32Microsoft.SqlServer.Replication9.0.242.0__89845dcd8080cc91Repl.dll
04/09/2007 16:17:39.171 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll
04/09/2007 16:17:39.203 Failed to read version information for the following file: C:Program FilesCommon FilesMicrosoft SharedDatabase ReplicationResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
plhtfin.sql
04/09/2007 16:17:39.218 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstall
C:Program FilesMicrosoft SQL Server90COMqrdrsvc.exe
04/09/2007 16:17:39.250 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMsnapshot.exe
04/09/2007 16:17:39.281 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COM
eplmerg.exe
04/09/2007 16:17:39.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90COM ablediff.exe
04/09/2007 16:17:39.328 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90COM2005.90.2047.0
C:Program FilesMicrosoft SQL Server90COMDISTRIB.exe
04/09/2007 16:17:39.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnDatabaseMail90.exe
04/09/2007 16:17:39.390 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources30822005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources2052sqlevn70.rll
04/09/2007 16:17:39.406 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10422005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1041sqlevn70.rll
04/09/2007 16:17:39.437 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10402005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1036sqlevn70.rll
04/09/2007 16:17:39.453 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1031sqlevn70.rll
04/09/2007 16:17:39.484 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources10282005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033XPStar90.RLL
04/09/2007 16:17:39.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
04/09/2007 16:17:39.531 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
04/09/2007 16:17:39.562 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlaccess.dll
04/09/2007 16:17:39.578 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn6.6.3.5
C:Program FilesMicrosoft SQL Server90Sharedmsxmlsql.dll
04/09/2007 16:17:39.609 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2.0.3609.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxmlrw.dll
04/09/2007 16:17:39.640 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
04/09/2007 16:17:39.656 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
04/09/2007 16:17:39.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnsqlsvc90.dll
04/09/2007 16:17:39.703 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLBOOT.dll
04/09/2007 16:17:39.734 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnxplog70.dll
04/09/2007 16:17:39.765 Failed to read version information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn2005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnatchp~1.dll
04/09/2007 16:17:39.796 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
04/09/2007 16:17:39.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
04/09/2007 16:17:39.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAgentMail90.rll
04/09/2007 16:17:39.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
04/09/2007 16:17:39.906 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
04/09/2007 16:17:39.921 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnResources1033SQLAGENT90.RLL
04/09/2007 16:17:39.953 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
04/09/2007 16:17:39.984 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
04/09/2007 16:17:40.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAgentMail90.dll
04/09/2007 16:17:40.031 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
04/09/2007 16:17:40.062 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
04/09/2007 16:17:40.078 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinnSQLAGENT90.EXE
04/09/2007 16:17:40.140 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90SharedResources10339.0.2047.0
C:Program FilesMicrosoft SQL Server90Sharedmsmdrdir.dll
04/09/2007 16:17:40.156 Failed to read version information for the following file: C:Program FilesCommon FilesSystemole db2.0.3609.0
C:Program FilesCommon FilesSystemole dbxmlrw.dll
04/09/2007 16:17:40.171 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
04/09/2007 16:17:40.203 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
04/09/2007 16:17:40.218 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsmdlocal.dll
04/09/2007 16:17:40.265 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
04/09/2007 16:17:40.281 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
04/09/2007 16:17:40.296 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlbrowser.exe
04/09/2007 16:17:40.312 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
04/09/2007 16:17:40.328 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
04/09/2007 16:17:40.359 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
04/09/2007 16:17:40.375 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90enMicrosoft.AnalysisServices.AdomdClient.xml
04/09/2007 16:17:40.390 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90Microsoft.AnalysisServices.AdomdClient.dll
04/09/2007 16:17:40.421 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll
04/09/2007 16:17:40.437 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033
C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033sqlcm.xml
04/09/2007 16:17:40.453 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
04/09/2007 16:17:40.484 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
04/09/2007 16:17:40.500 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
04/09/2007 16:17:40.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
04/09/2007 16:17:40.531 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
04/09/2007 16:17:40.546 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
04/09/2007 16:17:40.578 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
04/09/2007 16:17:40.593 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
04/09/2007 16:17:40.609 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnatchparser90.dll
04/09/2007 16:17:40.625 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources10332005.90.2047.0
C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLInstallsysdbupg.sql
04/09/2007 16:17:40.656 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
04/09/2007 16:17:40.671 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
04/09/2007 16:17:40.687 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSQLSVC90.DLL
04/09/2007 16:17:40.703 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2.0.3609.0
C:Program FilesMicrosoft SQL Server90ToolsBinnSQLdiag.exe
04/09/2007 16:17:40.718 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinn2005.90.2047.0
C:Program FilesMicrosoft SQL Server90Sharedsqlsvc~1.dll
04/09/2007 16:17:40.765 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
04/09/2007 16:17:40.781 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
04/09/2007 16:17:40.796 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
04/09/2007 16:17:40.812 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
04/09/2007 16:17:40.843 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
04/09/2007 16:17:40.875 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
04/09/2007 16:17:40.890 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
04/09/2007 16:17:40.906 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
04/09/2007 16:17:40.937 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
04/09/2007 16:17:40.968 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
04/09/2007 16:17:40.984 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
04/09/2007 16:17:41.000 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
04/09/2007 16:17:41.015 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared2005.90.2047.0
C:Program FilesMicrosoft SQL Server90Sharedsqlsqm.exe
04/09/2007 16:17:41.046 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared9.0.2047.0
C:Program FilesMicrosoft SQL Server90Shareddbghelp.dll
04/09/2007 16:17:41.062 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
04/09/2007 16:17:41.125 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
04/09/2007 16:17:41.171 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
04/09/2007 16:17:41.203 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Rmo.dll
04/09/2007 16:17:41.234 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL
04/09/2007 16:17:41.250 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL
04/09/2007 16:17:41.265 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll
04/09/2007 16:17:41.281 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
04/09/2007 16:17:41.312 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
04/09/2007 16:17:41.328 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
04/09/2007 16:17:41.359 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll
04/09/2007 16:17:41.375 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll
04/09/2007 16:17:41.406 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll
04/09/2007 16:17:41.421 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll
04/09/2007 16:17:41.453 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll
04/09/2007 16:17:41.484 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlSAC.exe
04/09/2007 16:17:41.515 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedMicrosoft.SqlSac.Public.dll
04/09/2007 16:17:41.687 Attempting to install file: sqlrun_sql.msp
04/09/2007 16:17:41.750 Attempting to install file: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp
04/09/2007 16:17:41.765 Creating MSP install log file at: C:WINDOWSHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log
04/09/2007 16:17:41.796 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
04/09/2007 16:17:41.812 Failed to read registry key: Debug
04/09/2007 16:19:50.187 MSP returned 1603: A fatal error occurred during installation.
04/09/2007 16:19:50.250 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
04/09/2007 16:19:50.265 Failed to read registry key: Debug
04/09/2007 16:19:50.296 Unable to install MSP file: \TURBULENT2f$9104ddf6956f8b22663aHotFixSQLFilessqlrun_sql.msp
04/09/2007 16:19:50.312 The following exception occurred: Unable to install Windows Installer MSP file Date: 04/09/2007 16:19:50.312 File: depotsqlvaultsetupmainsetupsqlsesqlsedllcopyengine.cpp Line: 856
04/09/2007 16:19:50.437
04/09/2007 16:19:50.468 Product Status Summary:
04/09/2007 16:19:50.500 Product: SQL Server Native Client
04/09/2007 16:19:50.546 SQL Server Native Client (RTM ) - Success
04/09/2007 16:19:50.578
04/09/2007 16:19:50.609 Product: Setup Support Files
04/09/2007 16:19:50.640 Setup Support Files (RTM ) - Success
04/09/2007 16:19:50.656
04/09/2007 16:19:50.687 Product: Database Services
04/09/2007 16:19:50.734 Database Services (SP1 2047 ENU) - Failure
04/09/2007 16:19:50.750 Details: Unable to install Windows Installer MSP file
04/09/2007 16:19:50.781 Reporting Services (SP1 2047 ENU) - Not Applied
04/09/2007 16:19:50.812
04/09/2007 16:19:50.843 Product: Client Components
04/09/2007 16:19:50.890 Client Components (SP1 2047 ENU) - Not Selected
04/09/2007 16:19:50.921
04/09/2007 16:19:50.953 Product: MSXML 6.0 Parser
04/09/2007 16:19:50.968 MSXML 6.0 Parser (RTM ) - Not Selected
04/09/2007 16:19:51.015
04/09/2007 16:19:51.046 Product: SQLXML4
04/09/2007 16:19:51.078 SQLXML4 (RTM ) - Not Selected
04/09/2007 16:19:51.109
04/09/2007 16:19:51.125 Product: Backward Compatibility
04/09/2007 16:19:51.140 Backward Compatibility (RTM ) - Not Selected
04/09/2007 16:19:51.171
04/09/2007 16:19:51.203 Product: Microsoft SQL Server VSS Writer
04/09/2007 16:19:51.265 Microsoft SQL Server VSS Writer (RTM ) - Not Selected
04/09/2007 16:19:51.296
04/09/2007 16:29:32.812 Hotfix package closed

View 5 Replies View Related

Post SP2-Hotfixes Fails To Install Database Services On Clustered Servers With System Dbs On Non-default Location

Jan 9, 2008

Hi,

We've had this issue for awhile, but I have not been able to find a resolution for this. We have 2 identical servers (hardware & software) set-up: IBM x3850-(88633RU) running Windows Server 2003 Enterprise x64 (5.2.3790 SP1 Build 3790 R2). Server A was running SP1 (Build 9.0.2047) on a 3-node active-passive-passive failover cluster. Server B was running SP2 + Hotfix KB933097 (Build 9.0.3152) on a 2-node active-passive failover cluster. Both these servers are heavily utilized, and when originally installed with these versions of SQL Server Enterprise 2005 experienced no issues during or post-install. The original install of SQL 2005 Enterprise on both these servers had the Cluster Group Selection "Data files" setting changed to "M:MICROSOFT SQL SERVER" so that all system dbs and binaries would be installed to that location. On Server B where SP2 had already been applied, the update was downloaded on May 1, 2007, well after the GDR issues which had been plaguing SP2 releases was supposed to have been resolved.

Our problems began the night when we tried to apply hotfix KB933097 on Server A, and cumulative update packages 1,2,3 on Servers A & B, as well as catch-up the same SP2 and hotfix packages on other non-clustered servers where default system db locations remained the same. On all servers other than Servers A and B, the installs proceeded smoothly and without issue.

On Server B, which was already running SP2 + Hotfix KB933097, we tried installing Cumulative Update Package 1 (Build 9.0.3161) on the primary node. The install proceeded until the following errors were encountered:

"[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission."

"[Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_memory_grants', because it does not exist or you do not have permission."

After this, the setup finished with the message "Product: Microsoft SQL Server 2005 (64-bit) - Update 'Hotfix 3161 for SQL Server Database Services 2005 (64-bit) ENU (KB935356)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB935356_sqlrun_sql.msp.log."

We rebooted the server and tried several times to reinstall the hotfix as sa and as the database service account with full windows and sa credentials, each time with no success, and rebooting between retries. All other components were installed successfully. We were hesitant to try uninstalling the hotfix, since it was unable to be removed successfully in previous attempts. However, when I connected to Database Engine using Management Studio, I found that the version of SQL being reported was in fact Build 9.0.3161! Everything also appeared to be running properly.

I tried to to Google the answer, but could only find information as applied to SP1 when system dbs master and mssqlsystemresource were located on different locations (http://support.microsoft.com/default.aspx?scid=kb;EN-US;918695 ). I had already verified that all system dbs, including the ones mentioned, were originally and currently located together on M:Microsoft SQL ServerMSSQL.1MSSQLData.


Finally I contacted a fellow DBA who advised me to continue installing all the other hotfixes, and then compare all SQL files against other servers where the install succeeded to ensure all system files were updated correctly (matching file sizes and datetime stamps). Since we were depending on a fix in Cumulative Update Package 3 to fix a critical log-shipping security issue, I went ahead with the rest of the installs, getting the same error with each package, rebooting between each install.

We found after the final install that the mssqlsystemresource files in the M:Microsoft SQL ServerMSSQL.1MSSQLData

directory were in fact updated after each install with a new timestamp, and that all files in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLBinn matched on both file size and timestamp. The log-shipping security issue we were looking to fix also appeared to be resolved by the last update.

On Server A, which was running SP1 (Build 9.0.2047), we installed the same SP2 package as we had on Server B with no issue. We rebooted and then tried to apply the same Hotfix KB933097 (Build 9.0.3152) that had been applied successfully on Server B and found to our surprise that the same errors were being generated here as well. We continued to apply the rest of the hotfixes so that both servers matched software updates. Comparing the above directories showed that files seemed to have been updated, even though database services appeared to be not installed.

It looks like we now need Cumulative Update 5 hotfix package in order to deal with WMI alerting issues, but I'm afraid to apply it until we have a known resolution for the past errors.


Since this issue was supposed to be resolved by SP2, I'm not sure why these post-SP2 hotfixes should fail. It seems to me to be an issue of the directory location of the system files which is in question.

I can post the hotfix log files as well, if anyone is interested in seeing them.

Any help would be greatly appreciated. As well, does anyone have any idea when SP3 is scheduled to come out? I really don't like applying hotfixes which are usually untested for general purposes, and it seems Microsoft is delaying this in favour of releasing SQL 2008.

View 6 Replies View Related

Upgrading To Integration Services From DTS

Sep 26, 2007

Hi

We have developed a datawarehouse using DTS in 2000. Now we have started using 2005 and as it supports DTS so there no issued for our datawarehouse to run.

But every six months there are new requirements and we achange and add to the existing DTS, but now DTS development is not supported in 2005, can we use itegration services for the same and embedd it with the existing DTS or do I need to redevelop the datawarehouse using SSIS.

View 1 Replies View Related

Upgrading / Moving Reporting DBs And Services

Oct 14, 2015

I have a requirement for a side by side upgrade of an instance from SQL 2008 to SQL 2014. There are reporting services configured. How to I properly migrate and configure the reporting piece on new SQL 2014 instance?

View 4 Replies View Related

Upgrading Notification Services From SQL2k-&> 2k5

Aug 20, 2007

Hi all,
I'm running in to the exact same problem described in this post:
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=67406

However there were no replies to that post and the forum is closed. Has anyone figured out what the problem was and if there is a solution for it?

Please help and thank you for your time.

H

View 1 Replies View Related

Database Services Install Fails When Install SQL Server 2005 SP2

Aug 15, 2007

The error I got is:
Hotfix.exe has encountered a problem and needs to close. We are sorry for the inconvenience.

EventType : sqlsesetup P1 : sysdbupg.sql P2 : 0x7361
P3 : odbcstatement__execute_batch@sysdbupg.sql@3 P4 : 0x7361
P5 : lib_odbc_statement.h@91 P6 : unknown P7 : sql9 P8 : hotfix@
P9 : x86 P10 : 3042

Log Location: C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
MSP Error: 29537 SQL Server Setup has encountered the following problem: [Microsoft][SQL Native Client][SQL Server]Cannot find the object 'dm_exec_query_resource_semaphores', because it does not exist or you do not have permission.. To continue, correct the problem, and then run SQL Server Setup again.

I tried to search internet, however, I couldn't get solution.

My SQL server 2005 is standard version, OS Windows server 2003 sp2, I am using Administrator account to install it.

Thanks a lot,

Rex

View 9 Replies View Related

Upgrading To SQL Express Edition SP1 With Advanced Services

Jun 14, 2006

Hello All,

Does anybody have the experience of migrating from SQL 2005 Express to the new adition with Advanced Services? Do I install the upgrade on top of the previos edition or have to go thru uninstall.



Thanks.

Serge

View 3 Replies View Related

Receive Must Declare The Variable When Upgrading To Reporting Services 2005

Dec 10, 2006

We are in the process of migrating our databases to SQL Server 2005 and our Reporting Services Reports to 2005. We have been doing this in a phased approach with excellent success.

However, I have a set of Reporting Services 2000 reports that are reading from a SQL Server 7.0 database. If possible, I would like to migrate the reports before we migrate the database (we're not ready to migrate the database yet).

When I converted the reports to Reporting Services 2005, I first received an error message regarding my data source. Basically the message says anything developed in Visual Studio 2005 using the Microsoft SQL Server connection type cannot connect to a database prior to Microsoft SQL Server 2000. So I switched the connection string to be a OLE DB type.

Well ... the reports contain parameters (i.e. @plant, @employee, etc). So when I attempt to run the query, I get a message saying "Must declare the variable '@plant'". I have searched for a work around until we migrate the database but I am coming up empty.

Is there a way for me to run a report with parameters from Reporting Services 2005 to a SQL Server database that is prior to SQL Server 2000?

Thanks in advance.

View 6 Replies View Related

Upgrading Sqlce 2.0 Database To Sql Server For Mobile Database On Desktopn

Oct 23, 2007

can we upgrade a sqlce forgotten password database to sql server for mobile database on our desktop


Thanks & Regards
Mukesh Gupta

View 1 Replies View Related

Reporting Services :: How To Use RDL File Will Work If Upgrading Server 2005 To 2012

Nov 17, 2015

I have reports developed in SQL Server 2005 (.rdl file) and using report viewer in my ASPX page.Now we have upgraded SQL Server 2005 to 2012, how I can use exsisting .rdl file or what change I need to do.

View 7 Replies View Related

Upgrading Database

Jan 6, 2005

Hey,

Does anyone know how I would go about upgrading a database version to 'C.0.6.43'? I am getting an error and it is telling me to upgrade my database to this version.

Thanks

View 2 Replies View Related

Upgrading Database Engine To 64 Bit

May 7, 2008

If I am upgrading the SQL Server 2005 32 bit to 64 bit (only DB Server), Do Applications that communicate with Database need to be upgraded to 64 bit as well???

Thanks,

View 1 Replies View Related

Upgrading A Database (good Practice)

Mar 5, 2008

hi experts,
i have a postcode database that i need to update. the database cnotains of 6tables, the file i ahev has all the information at once, so i have to organize it and insert records into the appropriate tables.
this is the first time i'm doign this so i would like to know what the best way to do? do i need to create a stored procedure or a script, or may be something special and efficient that i do not know yet.
any advise will be very appreciated
thanks in advance

View 1 Replies View Related

Problem In Upgrading My Database Tables

Mar 8, 2007

hi,

I've modified some of my database tables and in the existing version(ver1.3) of my database and i named the new version as ver1.5.

now when i've detached ver1.3 database and attaching ver 1.5 to server it is taking the .ldf file from the folder ver1.3.(I'm maintaning the each version in a saperate folder)

I want to create an independent .ldf file for ver 1.5 also. i dont want to depend on old version for .ldf file.

Can any one help me regarding this issue....



dpindra@yahoo.com

View 1 Replies View Related

After Upgrading To SQL 7.0 Database Writes/saves Are Slow...

Apr 18, 2002

I upgraded from 6.5 to 7.0 SP3. Now when I save (write) an invoice it takes about 10-12 seconds, at 6.5 it was 1-3 seconds. SQL Server and my Materials App are the only thing running on this box. This is the only area that has gotten slower everything else works great. I have 3 users saving invoices and about 15 people total using the system at one time. It's a compaq DL580 loaded with memory, database is 2,195MB in size. Same 6.5 client to access system as before. Should I rebuild/reindex the database? Is there something from the old 6.5 version I need to remove?? Thanks in advance!!!

View 1 Replies View Related

Problem After Upgrading Access Database To Mssql

Jan 21, 2004

Oke here is the problem. I hope sombody can help me with it.

After a lot of discussion, I finaly got the people that control the MS SQL server with my appertment as far to allow me to upgrade my access database to the MS SQL server.
After this I've created an access project. Devellopping in access I concluded I made a mistake in the rowsource property of one of the tablefields. The people that control the MS SQL server don'n allow me to make changes to the database structure from within access. So I've to write a SQL statement to change this.

example:

fields table1: id_document, id_document_type, document_name
fields tabel2: id_document_type, document_type_description.

the field id_document_type from table 1 is defined as a combo/list box tha contains the values from the field document_type_description from table 2.

I hope somebody can tell me if it is possible to write an SQL statement for this problem and how it shoud look like ?

thank you

View 1 Replies View Related

Upgrading Source Database From 2000 To 2005

Apr 17, 2007

I have one 32-bit SQL 2000 server that is our enterprise-wide reporting server (we'll call it RS) and another 32-bit SQL 2000 server that serves as a stored proc data source for certain reports on that server (we'll call it DS). I am about to go through an upgrade/migration of DS to 64-bit SQL 2005 and was wondering if:

it is possible to just change the data source location on RS and point the old reports against the new DS server?
there are any necessary steps to take within RS to make the data source (DS reference on RS) compatible with the destination (report on RS)?
it is possible/easy to bulk-migrate all the RDL's for a particular data source from RS to DS?

Does anyone know any of the answers to these questions?

Thanks in advance!

View 1 Replies View Related

Upgrading SQL 2000 To SQL 2005 Very Large Database

May 29, 2007

My question is two fold:



We have a database 65 GB in size and has grown over 12 years.



1) How can I upgrade to 2005 without downtime?

2) Our upgrades on SQL 2000 now can take upwards of 10 hours to add just a column and rebuild index tables?



Any way we can speed this up without detaching the database and going offline?



thanks,

Larry Sitka

View 6 Replies View Related

DB Engine :: Can't Open Database After Upgrading To Windows 10

Aug 3, 2015

I just upgraded from Windows 7 to Windows 10, and now I can't connect to SQL Server 2008 R2 nor 2014 Express.  The logs on both say it can't open master.mdf because it was originally formatted with a sector size 4096 but now it's 3072.  But no sector sizes were changed.  The only thing that changed was going from Windows 7 (64-bit) to Windows 10 (64-bit).  How can this be resolved?

View 10 Replies View Related

SQL Server Admin 2014 :: Copy Resource Database MDF For Upgrading

Feb 11, 2015

Copy mssqlsystemresource.mdf of a recently upgraded server and paste to an old server have same effect of upgrading via .exe installation?

My idea is to save time and administrative efforts in upgrades (Service Packs and/or Cumulative Updates) using this method.

According to BOL:

The Resource database makes upgrading to a new version of SQL Server an easier and faster procedure. In earlier versions of SQL Server, upgrading required dropping and creating system objects. Because the Resource database file contains all system objects, an upgrade is now accomplished simply by copying the single Resource database file to the local server.

View 3 Replies View Related

Upgrading From MS SQL 2005 Express To MS SQL 2005 With Advanced Services

Oct 18, 2007

I've installed MS SQL 2005 express, the version without advanced services...now I realized that my application requires the FULL-TEXT SEARCH feature that only the advanced services edition can provide. Please advice if I could just do an upgrade of the installation? Thank you.

View 1 Replies View Related

Reporting Services 2000 SP2 Fails

Jul 3, 2007

I have installed SP2 successfully a number of times before, but always where the Report Server and the Report Server databases were on the same box. This is the first time trying to install the Service Pack where the Report Server is on server X and the databases are on server Y.



When I try to run the SP (on server X), I get the following message:

Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.



I am logged in using a domain account that is a local admin on both servers (and also the SQL Server startup account on server Y). It is also the account used by the Report Server to connect to the RS databases. The startup account for the Report Server service is 'NT AUTHORITYNETWORK SERVICE'.

View 1 Replies View Related

Analysis Services Help - Dim Builds, But Cube Fails.

Dec 8, 2005

If there are any AS gurus out there, I could use some help. I've been having some problems with particular AS dimension and cubes and it's driving me crazy! It doesn't matter what I do, nothing seems to work.

Anyway, here's what I'm trying to do. I've got a fairly simple dimension. There is a date stored in the dimension that is formatted as an int. The dimension needs to only display AGE, so I cast the int as a date and do a datediff to get AGE. The dimension builds just fine and I get the results I want. My problem is when I add the dimension to the cube. The cube fails to build and I get an error message - "Data source provider error: The column prefix 'MY TABLE' does not match with a table name or alias used in the query." Basically, AS is telling me that the table that is used for the dimension doesn't exist, even though the fact and the dimension are joined properly and I've validated the structure.

I've run a number of queries in QA on the two tables and everything works fine. No funky data issues. I've run the service packs a few times, but that didn't work either. I've tried making a cube that only has the just fact table and the one dimension table, and it still fails.

Basically, I'm out of ideas. Any help that anyone has is greatly appreciated.

View 5 Replies View Related

SP1 Integration Services Update Package Fails

Jul 20, 2006

Hello,

the SP1 update of the Integrations Services failed, the rest was fine. Here is the log:

07/20/2006 19:46:56.914 ================================================================================
07/20/2006 19:46:56.914 Hotfix package launched
07/20/2006 19:46:58.648 Product discovery successfully completed during the install process for DTS
07/20/2006 19:46:58.648 SP Level check successfully completed during the install process for DTS
07/20/2006 19:46:58.648 Product language check successfully completed during the install process for DTS
07/20/2006 19:46:58.664 Product version check successfully completed during the install process for DTS
07/20/2006 19:46:58.664 Command-line instance name check completed during the install process
07/20/2006 19:46:58.664 Baseline build check completed during the install process
07/20/2006 19:47:18.118 Attempting to install instance: DTS
07/20/2006 19:47:18.118 Attempting to install target: SGFDDEWER102
07/20/2006 19:47:18.134 Attempting to stop service: MsDtsServer
07/20/2006 19:47:20.150 Successfully stopped service: MsDtsServer
07/20/2006 19:47:20.150 Attempting to check for locked files: sqlrun_dts.msp
07/20/2006 19:47:20.165 Attempting to check for locked files: \SGFDDEWER102c$97de952b8999258c0040eafe4a8d1354HotFixDTSFilessqlrun_dts.msp
07/20/2006 19:47:20.165 Creating MSP locked file check log at: C:WINDOWSHotfixDTS9LogsDTS9_Hotfix_KB913090_sqlrun_dts.msp.out
07/20/2006 19:47:30.244 MSP returned 1602: The user cancels installation.
07/20/2006 19:47:30.244 Successfully checked file: \SGFDDEWER102c$97de952b8999258c0040eafe4a8d1354HotFixDTSFilessqlrun_dts.msp
07/20/2006 19:47:30.244 Successfully opened registry key: SystemCurrentControlSetControlSession Manager
07/20/2006 19:47:30.244 Successfully read registry key: PendingFileRenameOperations
07/20/2006 19:47:30.244 Multi-string values:
07/20/2006 19:47:30.244 ??C:DOCUME~1urgerLOCALS~1Tempose00000.exe
07/20/2006 19:47:45.807 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared9.0.2047.0
C:Program FilesMicrosoft SQL Server90Shareddbghelp.dll
07/20/2006 19:47:45.807 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
07/20/2006 19:47:45.807 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
07/20/2006 19:47:45.807 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlDumper.exe
07/20/2006 19:47:45.807 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsqm.exe
07/20/2006 19:47:45.807 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinndtsinstall.exe
07/20/2006 19:47:45.807 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsResources1033msmdsrv.rll
07/20/2006 19:47:45.807 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsResources1033msmdsrv.rll
07/20/2006 19:47:45.823 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsResources1033msmdsrv.rll
07/20/2006 19:47:45.823 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsmsmdlocal.dll
07/20/2006 19:47:45.823 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsmsmdlocal.dll
07/20/2006 19:47:45.823 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsmsmdlocal.dll
07/20/2006 19:47:45.823 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponents9.0.2047.0
C:Program FilesMicrosoft SQL Server90Sharedmsmdlo~1.dll
07/20/2006 19:47:45.823 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
07/20/2006 19:47:45.823 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataStorage9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataStorage.dll
07/20/2006 19:47:45.823 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.CustomControls9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.CustomControls.dll
07/20/2006 19:47:45.839 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WizardFramework9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WizardFramework.dll
07/20/2006 19:47:45.839 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.Xmla9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.XMLA.dll
07/20/2006 19:47:45.839 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.OlapEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.OlapEnum.dll
07/20/2006 19:47:45.839 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.ActiveXScriptTask.xml
07/20/2006 19:47:45.839 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll
07/20/2006 19:47:45.839 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll
07/20/2006 19:47:45.839 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.ActiveXScriptTaskUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTaskUtil.dll
07/20/2006 19:47:45.854 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ActiveXScriptTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ActiveXScriptTask.dll
07/20/2006 19:47:45.854 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.ActiveXScriptTaskUtil.dll
07/20/2006 19:47:45.854 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.ActiveXScriptTaskUtil.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.ActiveXScriptTaskUtil.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.ActiveXScriptTask.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataTransformationServices.Controls9.0.242.0__89845dcd8080cc91Microsoft.DataTransformationServices.Controls.DLL
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSWizard.exe
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SDKAssembliesMicrosoft.SqlServer.TxScript.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsMicrosoft.SqlServer.TxScript.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TxScript9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TxScript.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxSampling.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxSampling.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxSampling.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxRowCount.dll
07/20/2006 19:47:45.870 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxRowCount.dll
07/20/2006 19:47:45.886 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxRowCount.dll
07/20/2006 19:47:45.886 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
07/20/2006 19:47:45.886 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DataReaderDest9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DataReaderDest.dll
07/20/2006 19:47:45.886 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.Dts.DtsClient.dll
07/20/2006 19:47:45.886 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsMicrosoft.SqlServer.DataReaderDest.dll
07/20/2006 19:47:45.886 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.TransferSqlServerObjectsTask.xml
07/20/2006 19:47:45.886 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferSqlServerObjectsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferSqlServerObjectsTask.dll
07/20/2006 19:47:45.886 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.TransferSqlServerObjectsTask.dll
07/20/2006 19:47:45.901 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.TransferStoredProceduresTask.xml
07/20/2006 19:47:45.901 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.TransferLoginsTask.xml
07/20/2006 19:47:45.901 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.TransferJobsTask.xml
07/20/2006 19:47:45.917 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.TransferErrorMessagesTask.xml
07/20/2006 19:47:45.917 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.TransferDatabasesTask.xml
07/20/2006 19:47:45.917 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.TransferStoredProceduresTask.dll
07/20/2006 19:47:45.917 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.TransferLoginsTask.dll
07/20/2006 19:47:45.932 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.TransferJobsTask.dll
07/20/2006 19:47:45.932 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.TransferErrorMessagesTask.dll
07/20/2006 19:47:45.932 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.TransferDatabasesTask.dll
07/20/2006 19:47:45.932 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.TransferObjectsTask.dll
07/20/2006 19:47:45.932 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferStoredProceduresTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferStoredProceduresTask.dll
07/20/2006 19:47:45.932 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferLoginsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferLoginsTask.dll
07/20/2006 19:47:45.932 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferJobsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferJobsTask.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferErrorMessagesTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferErrorMessagesTask.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferDatabasesTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferDatabasesTask.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TransferObjectsTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TransferObjectsTask.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DtsTransferProvider9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DtsTransferProvider.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.TableTransferGeneratorTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.TableTransferGeneratorTask.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.DtsTransferProvider.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.TableTransferGeneratorTask.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxTermExtraction.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxTermExtraction.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxTermExtraction.dll
07/20/2006 19:47:45.948 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxTermLookup.dll
07/20/2006 19:47:45.964 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxTermLookup.dll
07/20/2006 19:47:45.964 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxTermLookup.dll
07/20/2006 19:47:45.964 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnResources10332005.90.2047.0
C:Program FilesMicrosoft SQL Server90DTSBinnResources1033dts.rll
07/20/2006 19:47:45.964 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnResources1033dtsconn.rll
07/20/2006 19:47:45.964 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnResources1033dtsconn.rll
07/20/2006 19:47:45.964 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnResources1033dtsconn.rll
07/20/2006 19:47:45.964 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSForEachEnumeratorsenMicrosoft.SqlServer.ForEachAdoEnumerator.xml
07/20/2006 19:47:45.979 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSForEachEnumeratorsenMicrosoft.SqlServer.ForEachSMOEnumerator.xml
07/20/2006 19:47:45.979 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSConnectionsenMicrosoft.SqlServer.ManagedConnections.xml
07/20/2006 19:47:45.979 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dll
07/20/2006 19:47:45.979 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dll
07/20/2006 19:47:45.979 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dll
07/20/2006 19:47:45.979 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnResources1033dtspipeline.rll
07/20/2006 19:47:45.995 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnResources1033dtspipeline.rll
07/20/2006 19:47:45.995 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnResources1033dtspipeline.rll
07/20/2006 19:47:45.995 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.FtpTask.xml
07/20/2006 19:47:45.995 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.FtpTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.FtpTask.dll
07/20/2006 19:47:45.995 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.FtpTask.dll
07/20/2006 19:47:46.011 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.ExecProcTask.xml
07/20/2006 19:47:46.011 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.SendMailTask.xml
07/20/2006 19:47:46.011 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.MSMQTask.xml
07/20/2006 19:47:46.011 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll
07/20/2006 19:47:46.011 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.MSMQUtil9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQUtil.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.MSMQTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MSMQTask.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.MSMQUtil.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.MSMQUtil.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.MSMQUtil.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MSMQTask.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxMulticast.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxMulticast.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxMulticast.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsCommandDest.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsCommandDest.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsCommandDest.dll
07/20/2006 19:47:46.026 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxFileInserter.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxFileInserter.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxFileInserter.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxFileExtractor.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxFileExtractor.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxFileExtractor.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxLineage.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxLineage.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxLineage.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxUnPivot.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxUnPivot.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxUnPivot.dll
07/20/2006 19:47:46.042 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponents2005.90.2047.0
C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxPivot.dll
07/20/2006 19:47:46.042 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxMergeJoin.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxMergeJoin.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxMergeJoin.dll
07/20/2006 19:47:46.057 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponents2005.90.2047.0
C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxUnAll.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxSort.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxSort.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxSort.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxSplit.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxSplit.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxSplit.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxLookup.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxLookup.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxLookup.dll
07/20/2006 19:47:46.057 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxGroupDups.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxGroupDups.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxGroupDups.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxDerived.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxDerived.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxDerived.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxDataConvert.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxDataConvert.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxDataConvert.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxCopyMap.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxCopyMap.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxCopyMap.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxCharMap.dll
07/20/2006 19:47:46.073 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxCharMap.dll
07/20/2006 19:47:46.089 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxCharMap.dll
07/20/2006 19:47:46.089 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxBestMatch.dll
07/20/2006 19:47:46.089 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxBestMatch.dll
07/20/2006 19:47:46.089 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxBestMatch.dll
07/20/2006 19:47:46.089 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxAgg.dll
07/20/2006 19:47:46.089 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxAgg.dll
07/20/2006 19:47:46.089 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsTxAgg.dll
07/20/2006 19:47:46.089 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.XmlTask.xml
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90dtsBinnatchparser90.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90dtsBinnatchparser90.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90dtsBinnatchparser90.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.SQLTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SQLTask.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnSQLTaskConnections.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnSQLTaskConnections.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnSQLTaskConnections.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.SQLTask.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsSqlDest.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsSqlDest.dll
07/20/2006 19:47:46.104 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsSqlDest.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SDKAssembliesMicrosoft.SqlServer.ScriptTask.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ScriptTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ScriptTask.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.ScriptTask.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsRecordSetDest.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsRecordSetDest.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsRecordSetDest.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsRawSource.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsRawSource.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsRawSource.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsRawDest.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsRawDest.dll
07/20/2006 19:47:46.120 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsRawDest.dll
07/20/2006 19:47:46.136 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.ASTasks.xml
07/20/2006 19:47:46.136 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ASTasks9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ASTasks.dll
07/20/2006 19:47:46.136 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.ASTasks.dll
07/20/2006 19:47:46.136 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsOleDbSrc.dll
07/20/2006 19:47:46.136 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsOleDbSrc.dll
07/20/2006 19:47:46.136 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsOleDbSrc.dll
07/20/2006 19:47:46.136 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsOleDbDest.dll
07/20/2006 19:47:46.136 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsOleDbDest.dll
07/20/2006 19:47:46.136 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsOleDbDest.dll
07/20/2006 19:47:46.136 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsFlatFileDest.dll
07/20/2006 19:47:46.151 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsFlatFileDest.dll
07/20/2006 19:47:46.151 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsFlatFileDest.dll
07/20/2006 19:47:46.151 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsFlatFileSrc.dll
07/20/2006 19:47:46.151 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsFlatFileSrc.dll
07/20/2006 19:47:46.151 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsFlatFileSrc.dll
07/20/2006 19:47:46.151 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.FileSystemTask.xml
07/20/2006 19:47:46.151 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.FileSystemTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.FileSystemTask.dll
07/20/2006 19:47:46.151 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.FileSystemTask.dll
07/20/2006 19:47:46.167 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnExecPackageTask.dll
07/20/2006 19:47:46.167 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnExecPackageTask.dll
07/20/2006 19:47:46.167 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnExecPackageTask.dll
07/20/2006 19:47:46.167 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.DmQueryTask.xml
07/20/2006 19:47:46.167 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.DMQueryTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.DmQueryTask.dll
07/20/2006 19:47:46.167 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.DmQueryTask.dll
07/20/2006 19:47:46.182 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.BulkInsertTask.xml
07/20/2006 19:47:46.182 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll
07/20/2006 19:47:46.182 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll
07/20/2006 19:47:46.182 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BulkInsertTaskConnections9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTaskConnections.dll
07/20/2006 19:47:46.182 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.BulkInsertTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.BulkInsertTask.dll
07/20/2006 19:47:46.182 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.BulkInsertTaskConnections.dll
07/20/2006 19:47:46.182 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.BulkInsertTaskConnections.dll
07/20/2006 19:47:46.182 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMicrosoft.SqlServer.BulkInsertTaskConnections.dll
07/20/2006 19:47:46.182 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.BulkInsertTask.dll
07/20/2006 19:47:46.198 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.WMIEWTask.xml
07/20/2006 19:47:46.198 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.WMIDRTask.xml
07/20/2006 19:47:46.214 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksenMicrosoft.SqlServer.WebServiceTask.xml
07/20/2006 19:47:46.214 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WebServiceTask9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WebServiceTask.dll
07/20/2006 19:47:46.214 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.MaintenancePlanTasks9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.MaintenancePlanTasks.dll
07/20/2006 19:47:46.214 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.WebServiceTask.dll
07/20/2006 19:47:46.214 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSTasksMicrosoft.SqlServer.MaintenancePlanTasks.dll
07/20/2006 19:47:46.214 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsResources1033dtspipeline.rll
07/20/2006 19:47:46.214 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsResources1033dtspipeline.rll
07/20/2006 19:47:46.214 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsResources1033dtspipeline.rll
07/20/2006 19:47:46.214 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsexceldest.dll
07/20/2006 19:47:46.214 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsexceldest.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsexceldest.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsexcelsrc.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsexcelsrc.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsexcelsrc.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsMicrosoft.SqlServer.XMLSrc.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSPipelineComponentsMicrosoft.SqlServer.ADONETSrc.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.XmlSrc9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.XMLSrc.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ADONETSrc9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ADONETSrc.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.PipelineHost9.0.242.0__89845dcd8080cc91Microsoft.SQLServer.PipelineHost.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSPipeline.dll
07/20/2006 19:47:46.229 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSPipeline.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSPipeline.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ForEachNodeListEnumerator9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ForEachNodeListEnumerator.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ForEachSMOEnumerator9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ForEachSMOEnumerator.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32DTEParseMgd9.0.242.0__89845dcd8080cc91DTEParseMgd.dll
07/20/2006 19:47:46.245 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinn2005.90.2047.0
C:Program FilesMicrosoft SQL Server90DTSBinnDTSComEx.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinndtsmsg.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinndtsmsg.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinndtsmsg.dll
07/20/2006 19:47:46.245 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSLog.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSLog.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTSLog.dll
07/20/2006 19:47:46.261 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinn2005.90.2047.0
C:Program FilesMicrosoft SQL Server90DTSBinnDtsUt.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTS.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTS.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnDTS.dll
07/20/2006 19:47:46.261 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinn2005.90.2047.0
C:Program FilesMicrosoft SQL Server90DTSBinnDTEParsM.dll
07/20/2006 19:47:46.261 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinn2005.90.2047.0
C:Program FilesMicrosoft SQL Server90DTSForEachEnumeratorsNodeList.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSForEachEnumeratorsForEachFileEnumerator.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSForEachEnumeratorsForEachFileEnumerator.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSForEachEnumeratorsForEachFileEnumerator.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSForEachEnumeratorsMicrosoft.SqlServer.ForEachSMOEnumerator.dll
07/20/2006 19:47:46.261 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90DTSBinnMsDtsSrvr.exe
07/20/2006 19:47:46.276 Failed to read version information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90enMicrosoft.AnalysisServices.AdomdClient.xml
07/20/2006 19:47:46.276 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft.NETADOMD.NET90Microsoft.AnalysisServices.AdomdClient.dll
07/20/2006 19:47:46.276 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices.AdomdClient9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.AdomdClient.dll
07/20/2006 19:47:46.276 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
07/20/2006 19:47:46.276 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
07/20/2006 19:47:46.276 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedmsasxpress.dll
07/20/2006 19:47:46.276 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033
C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033sqlcm.xml
07/20/2006 19:47:46.276 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
07/20/2006 19:47:46.276 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
07/20/2006 19:47:46.276 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsBinnResources1033SqlManager.rll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90ToolsinnSqlManager.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsvcsync.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsvcsync.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsvcsync.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlsecacctchg.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
07/20/2006 19:47:46.292 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsqlftacct.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedisacctchange.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90Sharedsvrenumapi.dll
07/20/2006 19:47:46.307 Failed to read version information for the following file: C:Program FilesMicrosoft SQL Server90Shared2005.90.2047.0
C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Rmo9.0.242.0__89845dcd8080cc91Rmo.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.AnalysisServices9.0.242.0__89845dcd8080cc91Microsoft.AnalysisServices.DLL
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.DataWarehouse.Interfaces9.0.242.0__89845dcd8080cc91Microsoft.DataWarehouse.Interfaces.DLL
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.RegSvrEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.RegSvrEnum.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
07/20/2006 19:47:46.307 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_32Microsoft.SqlServer.BatchParser9.0.242.0__89845dcd8080cc91microsoft.sqlserver.batchparser.dll
07/20/2006 19:47:46.323 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.ServiceBrokerEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.ServiceBrokerEnum.dll
07/20/2006 19:47:46.323 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.WmiEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.WmiEnum.dll
07/20/2006 19:47:46.323 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SqlEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SqlEnum.dll
07/20/2006 19:47:46.323 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.SmoEnum9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.SmoEnum.dll
07/20/2006 19:47:46.323 Failed to read associated hotfix build information for the following file: C:WINDOWSassemblyGAC_MSILMicrosoft.SqlServer.Smo9.0.242.0__89845dcd8080cc91Microsoft.SqlServer.Smo.dll
07/20/2006 19:47:46.323 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
07/20/2006 19:47:46.323 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedSqlSAC.exe
07/20/2006 19:47:46.323 Failed to read associated hotfix build information for the following file: C:Program FilesMicrosoft SQL Server90SharedMicrosoft.SqlSac.Public.dll
07/20/2006 19:47:46.511 Attempting to install file: sqlrun_dts.msp
07/20/2006 19:47:46.542 Attempting to install file: \SGFDDEWER102c$97de952b8999258c0040eafe4a8d1354HotFixDTSFilessqlrun_dts.msp
07/20/2006 19:47:46.542 Creating MSP install log file at: C:WINDOWSHotfixDTS9LogsDTS9_Hotfix_KB913090_sqlrun_dts.msp.log
07/20/2006 19:47:46.542 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
07/20/2006 19:47:46.542 Failed to read registry key: Debug
07/20/2006 19:48:48.358 MSP returned 0: The action completed successfully.
07/20/2006 19:48:48.373 Successfully opened registry key: SoftwarePoliciesMicrosoftWindowsInstaller
07/20/2006 19:48:48.373 Failed to read registry key: Debug
07/20/2006 19:48:48.373 Successfully installed file: \SGFDDEWER102c$97de952b8999258c0040eafe4a8d1354HotFixDTSFilessqlrun_dts.msp
07/20/2006 19:48:48.373 Restarting DTS Service MsDtsServer since it was previously running
07/20/2006 19:48:48.373 Attempting to start service: MsDtsServer
07/20/2006 19:49:18.594 Unable to start service: MsDtsServer
07/20/2006 19:49:18.594 The following exception occurred: Unable to start service Date: 07/20/2006 19:49:18.594 File: depotsqlvaultsetupmainsetupsqlsesqlsedllservice.cpp Line: 222
----------------------


First I thought of an ACL problem, so I gave it a try and gave full control to everyone for the MSSQL folder, but that didn't work out.

Thank you for your help! Regards,

Michael burger

View 8 Replies View Related

SQL Server 2000 Reporting Services SP2 Fails

Dec 7, 2006



Hi, This may be a trivial question but neither SQL Server 2000 Reporting Services SP1 or SP2 wil install against our SQL Server 2005 Developer edition installation.

Our Version: Microsoft SQL Server Reporting Services Version 9.00.3027.00

Does anyone know whether the Services Packs are for SQL Server 2000 only? if so, whether the new functionality in SP2 will be made available to SQL Server 2005?

Many Thanks,

Mike

View 3 Replies View Related

Reporting Services :: Report Fails With COM Exception

Nov 5, 2015

I have a particular report that fails to run.  In the browser, the following is shown when the report is run:The attempt to connect to the report server failed. Check your connection information and that the report server is a compatible version.There is an error in XML document (1, 84459).'', hexa decimal value 0x01, is an invalid character. Line 1, position 84459.

When I look into the SSRS logs, I find the following:

library!ReportServer_0-125!6dc0!11/05/2015-08:40:58:: Call to GetPropertiesAction(/PathTo/MyReports/MyReport by Hour, PathBased).
library!ReportServer_0-125!1d34!11/05/2015-08:40:59:: Call to GetSystemPermissionsAction().
ui!ReportManager_0-126!65f8!11/05/2015-08:40:59:: i INFO: PageCountMode 'Estimate' read from config file
ui!ReportManager_0-126!65f8!11/05/2015-08:40:59:: i INFO: AccessibleTablix value not specified in config file.
library!ReportServer_0-125!6dc0!11/05/2015-08:40:59:: Call to GetSystemPropertiesAction().
rshost!rshost!1d50!11/05/2015-08:41:02:: e ERROR: WriteCallback(): failed to write in write callback.

[code]...

There are no other system logs at the corresponding time of this failure.Other reports that use the same data source run fine.  This problem is confined to a few reports within a larger report set.  The reports are provided by a third-party so I don't have a lot of insight to what the report is actually doing.This is running on SSRS 2008 R2.

View 2 Replies View Related

Integration Services :: SSIS Automatic Run When Package Fails

Aug 24, 2015

What is the best approach to run SSIS package (SQL Server 2008/2012/2014) automatically when it fails?

View 5 Replies View Related

Integration Services :: Single Row Resultset In Task Fails

Nov 6, 2015

I created a simple SQL Task in SSIS.

Connection is ADO.Net

SQL Statement is SELECT 10 AS NumberVar

ResultSet is set to single row

But when executing task I always get error message:

[Task 'SQL ausführen'] Fehler: Die zurückgegebene Anzahl von Ergebnisbindungen ist für 'ResultSetType' ungültig: 'ResultSetType_SingleRow'.

In English something like returned number of bindings is not valid.

View 3 Replies View Related

Reporting Services Configuration Fails In Windows 2003 SP2 ,64-bit Machine

May 14, 2008



Hi all,
i am tring to install and configure reporting services in Windows 2003 SP2- 64 bit machine as part of installing SCE 2007, and i followed the procedure for confiurng all the options in reportingservices config tool,

all the options show green flag and still could not proceed further as the following error is coming

"The Selected Sql server reportin service instance is not configured , please configure to continue" which halts the further process,

I have installed SQL Server 2005 edition and installed Sql server 2005 SP2 also,

any inputs on this issue , i would welcome them,

View 2 Replies View Related

Integration Services :: Event Handlers Was Not Executed When Package Get Fails?

Nov 20, 2015

event handlers was not executed when my package get fails it will go to directly to on error...not executing on preexecute. but it was working fine previously...i haven't change anything i have run it again...got this issue...

is there any thing wrong?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved