On my laptop I've got SQL2005 developper edition SP1 with 3 SSIS-jobs scheduled through SQL-agent.
These 3 SSIS-jobs are in fact maintenance plans which are also used on our production SQLServers.
These take backups (full, transactional), Cleanup old backups, reorganize indexes, update stats ...
One of these jobs runs every hour to take transaction logbackups. After installing SP2 this started failing.
When I opened the sources of that job in visual studio It seemed like the unit of thime was changed for cleanup jobs fe cleanup bak-files after 4 days changed into after 4 hours. The backup task for transactional backups which had the property to do that for all databases whas changed into specific databases which no database selected.
Even when I changed that into All databases and saved it, when I opened that backup task again, this was changed back into specific databases with no database selected.
I uninstalled SQL2005 and reinstalled it, including SP1 and everything works well again.
I have been trying to install Visual Web Developer 2005 Express Edition and SQL Server 2005. The Web Developer installs ok but the SQL Server installation fails. I can't figure out why. I have (I think...) uninstalled my previous beta intallations. The must be something else that prevents the installation. Can anyone point me to some FAQ or something that can give me some ideas on how to handle the installation./anders
Hi, Trying to install SQL Server 2005 SP1 on a windows 2003 box and it fails for database services and reporting services patch. It installs successfully other components of the patch.
Following errors are logged in the event log.
1) Product: Microsoft SQL Server 2005 - Update 'Service Pack 1 for SQL Server Database Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:WINNTHotfixSQL9LogsSQL9_Hotfix_KB913090_sqlrun_sql.msp.log 2) Product: Microsoft SQL Server 2005 -- Error 29506. SQL Server Setup failed to modify security permissions on file C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData for user birendraa. To proceed, verify that the account and domain running SQL Server Setup exist, that the account running SQL Server Setup has administrator privileges, and that exists on the destination drive.
3) Product: Microsoft SQL Server 2005 Reporting Services -- Error 29561. SQL Server Setup failed to retrieve the SSL Certificate Name.
4) Product: Microsoft SQL Server 2005 Reporting Services - Update 'Service Pack 1 for SQL Server Reporting Services 2005 ENU (KB913090)' could not be installed. Error code 1603. Additional information is available in the log file C:WINNTHotfixRS9LogsRS9_Hotfix_KB913090_sqlrun_rs.msp.log.
The account running SQL server setup has admin privileges on that box.
Hi I've recently upgraded 4 sql servers to sp5a and have just found that BCP fails on all of them with a DR Watson error. I did reinstall the Nt sp after installing sql server sp5a. Can anyone help ? Thanks
I'm building an SQL Server 2005 cluster on a Windows 2003 cluster. Windows 2003 cluster and MSDTC service are all up and running properly. No problems there, but when I try to install SQL Server 2005 as a cluster service, it fails. The installation goes past the stage where it validates both the nodes and doesn't find any issue there, but when it tries to install fiels it fails. It fails on node 2. When I checked the scduled installer job it creates on node2 to install, the job never seems to run and fails. I'm using only one user account to setup windows cluster MSDTC and SQL Server. Now the complications: It is 64 bit Windows 2003 and SQL Server 2005. Also, the node 1 is built to be a domain controller as well.
We have successfully been using MSCS with MSSQL7 (SP1) running under NT4 EE (SP6a), installed in an active/active configuration using, two DELL PowerEdge 6350 machines. Recently I installed MSSQL7 (SP2), I followed the instructions that came with SP2, and unclustered the SQL nodes using the Failover Cluster Wizard, and installed SP2, this was uneventful, and appeared to install correctly. Next I tried to recluster the SQL nodes using the Failover Cluster Wizard as directed. This failed with: "Could not run setup on remote machine. SQL Cluster Setup failed." So I began the usual research using the usual resources, and have found articles that discusses this error, and the things to look for when it happens. I have exhausted all suggestions without success. I appear to have everything correctly configured. I have enabled Cluster Logging (level 3), following are the two things I have found that indicate something is wrong:
1. In the SQL Error Log the following gets logged when I run the wizard: "Attempting to initialize Distributed Transaction Coordinator." "Failed to obtain TransactionDispenserInterface: XACT_E_TMNOTAVAILABLE"
2. In the Cluster Log I see the following message repeatedly: "[ClRtlCopySecurityDescriptor] MakeSelfRelativeSD failed, 0x00000551"
3. In the sqlclstr.log I see the following, without an indication of which file is missing: "[reghelp.h:235] : 2 (0x2): The system cannot find the file specified." "[clushelp.cpp:166] : 259 (0x103): No more data is available." "[validate.cpp:147] DeleteTestGroup:OpenClusterResource: 5007 (0x138f): The cluster resource could not be found." "~~~ XXX InstallRemote failed"
Does anyone have any ideas about what could be causing this problem? Many thanks in advance.
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
Using the new Visual Studio 2008 I created a setup project for a small program, and added SQL Express 2005 SP2 to the list of prerequisites. I checked the box so the setup project will contain all necessary files in a sub directory of the setup project.
My setup starts nice (on windows vista) prompts me to install SQL Express, setup of SQL Express runs for some time, I get an UAC prompt, then setup fails with error 1706.
The last lines of the setup log file: Installing using command 'C:UserswilfiAppDataLocalTempVSDE5B7.tmpSqlExpresssqlexpr32.exe' and parameters '-q /norebootchk /qn reboot=ReallySuppress addlocal=all instancename=SQLEXPRESS SQLAUTOSTART=1 ADDUSERASADMIN=1' Process exited with code 1706 Status of package 'SQL Server 2005 Express Edition SP2 (x86)' after install is 'InstallFailed'
I really would like to install SQL Express as part of the setup project, can someone help me with this problem?
I just upgraded ACT database and it needs SQL Server. I just keep getting "SQL Server Setup Failed". I downloaded SQL from Microsoft, went to install and get the same error. It then refers to a summary txt log which I have had a look at but to be quite honest means nothing to me.
I have a Windows 2003 Server SP1, Active Directory, Application Server and RIS installed on my computer. After installing SQL Server 2005 April CTP my DHCP Service fails to start. In the Event Viewer I see the following Events.
Hi, pls can anyone help me out with this? I'm installing SQL2005 SP2 over an Itanium machine with W2003 SP2 but it keeps on failing on those features. Client components got installed with no problems. I've installed SQL2005-SP2 over x86 and x64 (not Itanium) machines many times before successfuly. I've been investigating this issue for several days with no luck so I'm a bit clueless at the moment. As I'm using Administrator account I think it is not file permission related. Summary says "Unable to install Windows Installer MSP file".
Hi I have a strange scheduling problem. I have a job, i test it through BIDS - Works I test it through SSMS - works I run the job - Works I schedule for a run time job - Works I schedule for a recurring job - Works
However (here is the really annoying part) it fails to run at the night run (11.20PM) there are 6 other packages that run fine after it , 11.30 , 1AM .. 4 AM etc ...
So last night I changed the package to run at a later time, and it worked, but the other package that ran 2nd (which now ran 1st) failed !!
its almost as if the 1st package has to fail !!!!! When i look at the history and detailed log all it says is "The step Failed"
anyway , I can set up a workaround by starting a dummy job that is supposed to fail..
FYI the jobs are run under administrator and they are protected by a password (encryptSensitiveWithpassword) .
With a DTS scheduled job if I needed to make a modification, I just changed the DTS and saved it, and the job would automatically Run the latest DTS (so long as the name was the same)
When I migrate a package to SSMS and schedule it , if I need to modify the package, do I need to modify it through BIDS (visual studio), then re-import it to SSMS and then reschedule it ?
I have just started to use Integration Services Catalog with SQL Server Agent. After I deploy a new version of the project the any Server Agent job that uses any of dstx still uses the old one. How do I fix this?
I have a package that has a file connection. We have set the connection in the package for development - we also have the connection in a config file.
We are calling the package from SQL Jobs. In the step we call the package in, we try to set the value for the connection in the Data Source tab. However, the package does NOT use the value we enter.
I then removed the connection from the config file - then the package uses what the connection was set to in development. It still will not use what we enter in SQL Jobs.
Furthermore, when we run the package we lose the values that we put in the DataSource tab!!!!
My work around has been to change the SQL Job type from an INtegration services package to a straight command line - this works.
The question is - can you set a package's connection strings from SQL Jobs using the SSIS Job Type ???
I am hoping someone can help me with a problem I am having with SSIS. I am attempting to move certain sql agent jobs from our older sql 2000 server to our new sql 2005 server and I am receiving the error [Transfer Jobs Task] Error: Execution failed with the following error: "The specified '@server' is invalid (valid values are returned by sp_helpserver).".
Does my server name need to be the same if I am using SSIS to transfer jobs? Is there a way to update the server name during the execution process?
This seems like it should be a relatively easy task but has not been so far.
I'm having an issue in SQL Server 2005 with jobs that execute SSIS packages. The jobs run fine for a week or so, then I'll come to find that four or five (of the ten or so jobs) are hung in "executing" status. They seem to hang indefinitely (as some have been "executing" for hours with no end. The schedules of the hung jobs are all different, varying from every 10 minutes to nightly. The packages perform completely diffent tasks, as well. I can't seem to find any common thread with the jobs that get hung, other than they are all executing SSIS packages.
I've tried manually stopping the jobs and restarting the agent and SQL Server but the jobs hang again on there next scheduled run. The only thing that fixes the issue is rebooting the box, and then the jobs hang again in a week or so. Could some sort of memory leak be consuming resources throughout the week and be causing the jobs to eventually hang? I just rebooted the box and the sqlagent90.exe process is currently using about 7mb of memory. I'll keep an eye on it. Any other suggestions?
I've thought of creating another job that stops jobs that are hung, but what's to say that this job won't get hung as well? Plus this seems like a band-aid fix...
I don't recall having these problems until installing SQL Server 2005 SP2. Could this be related? I've searched like crazy and still can't find a resolution to this. It's becoming a big PITA...
Anyway, any suggestions would be very much appreciated!
I would like to create an SSIS package in 2005 and run it in 2000. Is there anyway to do this? Or does SQL Server 2000 have a precursor to SSIS? I am trying to create a job to automatically catch and kill orphaned processes. -Kyle
I have created simple package loading data from source to destination.in BIDS working fine, but when i created job through sql server agent job I am getting below error.
Error:- The Job was invoked by User . The last step to run was step SQL AGENT JOB.
Hello All, My database application has certain stored procedures which are scheduled to run at certain predefined interval (say once everyday). Now to implement this logic I have two options with me, first being to use the EXECUTE SQL TASK of the SSIS package and schedule it using the windows scheduler and the other is to use the SQL Server Agent Jobs and schedule it there itself. Now the current implementation is using the SSIS packages and I even know that the second approach of using the SQL Server Agents Job is better. The only thing I want to know is whether it makes sense to invest time in converting my SSIS packages (20 in all) to SQL Server Agent jobs or not. Can somebody briefly explain or give some pointers regarding the performance benefits of Agent Jobs over the SSIS packages.
Just an FYI for those scheduling SSIS packages on 64bit Itaniums. This came to light when using a 32 bit OLEDB driver on a 64bit Itanium.
When manually executing the package on the server through SQL Management Studio, we got the expected results. However, when we scheduled the package as a job, it failed every time. The error was: "The AcquireConnection method call to the connection manager 'ConnectionName' failed with error code 0xC0202009€?.
We tried everything to fix this, but nothing worked. Finally we found that when manually running the package, SQL Management Studio was calling the 32bit version of dtexec.exe, while the Agent calls the 64bit version of dtexec.exe. The fix is to not use the "SQL Server Integration Services Package" type in the job step, but use "Operating system (CmdExec)" type. Then in the command box, call the 32bit (x86) version of dtexec.exe.
Environment: SQL Server 2005 Enterprise Edition x64, 3 server cluster. Two active servers with seperate instances and one passive server. SQL Server was installed on the two active servers.
Problem: When I fail over either of my instances to the passive server in the cluster my maintenance jobs fail to run and there are error messages in the application event viewer "SSIS Subsystem failed to load". I am guessing that all of the needed components are not installed on the passive server? Is this a close guess? If so, exactly what components are missing and do you have to have another license to install them?
I'm trying to execute my package using schedule in SQL Server Agent, I've already tested my package by run it manually in Integration services and it works. The table created, the data from my flat file also inserted into the table correctly and the result return with success.
The question is why when I execute my package using SQL Server Agent, the SQL Server Agent keep executing my package like infinite loop until I stop the job. after I stop the job there is no error generated by sql server. Could you figured why this happen?? I've already tried to upgrade into SP2 and set the package protection level and still not get good result from it. thank you.
I want to learn about developing SSIS packages. I have installed trial version of SQL Server 2005 Express Edition. what additional software do I need to install to develop SSIS packages???
I have deployed to production a number of nested packages (parent packages that call child packages) to the SQL msdb via the Save As option rather than building a deployment utility. These packages reference configuration files in a static location off of the c: drive on the production server. In the development environment, when connection changes are made and I run the Reload with Upgrade option the connection manager takes on the new server and user id settings. However, out on the production side I get the following error from the SQL job log:
Cannot load the XML configuration file. The XML configuration file may be malformed or not valid.
As a result the SQL job uses the default connection information which references the development database rather than the production database. I did research the error but found no good solutions. Is there a way to ensure the configuration files are formed correctly and that the packages are correctly referencing the configuration files? We are trying to run the ETL updates via a SQL job.
Hi all., I am trying to schedule a SSIS package into SQL Job., for that I created a account with sysadmin role which named karthikm., I create a new proxy settings., with all the permissions.,
But still the Job fails.,
Error message: The job failed. The Job was invoked byUserkarthikm. The last step to run was step1(Step1).,
Message The job failed. Unable to determine if the owner (ACIsnasir) of job VistaODSFeed has server access (reason: Could not obtain information about Windows NT group/user 'ACIsnasir', error code 0x6ba. [SQLSTATE 42000] (Error 15404)).
ACIsnasir is not the account under which SQL Server Agent service runs. However ACIsnasir has sa priveleges. not sure why am I getting ACIsnasir in the error and not the account under which sql server agent runs.
I am trying to run a SSIS package from a job. But the job fails. The Package extracts data from an MS Access database, and pumps into the SQL Server 2005. And the Access mdf file is located in a network shared location. While developing, I mapped the network share location to a local drive letter, and finished th dev work, and added a XML config file to point to the shared location. But when I tried to run the same package from a job, it fails with an error, unable to access the Q: drive. I even tried creating the same network drive on server, and it still fails with the same error.
I have tried to read the properties using the script from the below location, and package loads the configs from XML perfectly. http://blogs.conchango.com/jamiethomson/archive/2005/10/10/2253.aspx
The same package runs perfect, when I run from VS on server, or directly from Management Studio on server. But, only the job fails.
[The Access mdf contains linked xl files mapped to Q drive, but I am not using any of those linked files. Does the package validate the whole access mdf file before if establishes a connection? Even though, I have created a Q: drive on the server too, it fails]
I am unable to figure out the problem. Anybody had the same problem?
I feel stupid for asking this but I can't seem to find where to install the SSIS tutorials referenced in msdn.. specifically the "Deploying Packages Tutorial". In the SQL Server 2005 Developer Edition DVD that I have, I've chosen to install all of the samples etc. I have the AdventureWorks and AdventureWorksDW and a whole bunch of samples in "C:Program FilesMicrosoft SQL Server90SamplesIntegration ServicesPackage Samples" but under the directory "C:Program FilesMicrosoft SQL Server90SamplesIntegration ServicesTutorial" I only have sample data for "Creating a Simple ETL Package".
I know... feels like a dumb question but I have run the install wizard on both the dev edition dvd and the msdn library dvd several times and looked at all the options and can't find anything about tutorials under the SQL server installation or the workstation component installation. Please help. Thanks.
Hi, I have hourly job running which I inherited from developers. I get this errors in the job. I can't figure out what's wrong and why it's failing. I can't troubleshoot it either because I do not have exact dev enviornment to reproduce the problem. error is attached. Please advise ================= Executed as user: USsqldbagent. ...Execute Package Utility Version 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:06:02 AM Error: 2007-08-21 10:06:03.30 Code: 0xC020837F Source: Fill Update Table with new data DataReader Source [1] Description: The data type of "output column "AvailabilityBy" (1885)" does not match the data type "System.String" of the source column "AvailabilityBy". End Error Error: 2007-08-21 10:06:03.30 Code: 0xC004706B Source: Fill Update Table with new data DTS.Pipeline Description: "component "DataReader Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA". End Error Error: 2007-08-21 10:06:03.30 Code: 0xC004700C Source: Fill Update Table with new data DTS.Pipeline Description: One or more component failed validation. End Error Error: 2007-08-21 10:06:03.30 Code: 0xC0024107 Source: Fill Update Table with new data Description:. The step failed. =========== I can run the job for testing. I can't really change anything on server to test this other than database. Thanks a lot in advance