Production DB installation corrupt

• hp-609534

  SSC Enthusiast

  Points: 198

  More actions

  January 18, 2008 at 12:41 am

  #185698

  I recently migrated a SQL server 2000 database to a SQL server 2005. Due to time constraints the onsite technician did the SQL 2005 installation, and unfortantly he did it wrong ("complete" sql 2005 installation is obviously not good enough a description). The installation was done like this:

  SQL server engine + tools

  SP2 applied

  DTS 200 package designer

  SQL server analysis, integration and reporting services

  SP2 reapplied + KB933508

  The SQL server 2005 is now in production. And I now get some weird errors witch I believe is due to the installation procedure. I am hoping someone has a way of fixing the problems without doing a reinstall of SQL server 2005.

  There are two main errors i get. The first one is when i open a MaintanancePlan and try to edit a task:

  ===================================

  Cannot show the editor for this task. (Microsoft SQL Server Management Studio)

  ===================================

  Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

  ------------------------------

  Program Location:

  at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()

  at Microsoft.SqlServer.Management.DatabaseMaintenance.TaskContextUI.InitializeConnectionCombo(String connectionName)

  at Microsoft.SqlServer.Management.DatabaseMaintenance.DBMaintTaskCheckIntegrityForm.SetTask(DbMaintenanceCheckIntegrityTask task)

  at Microsoft.SqlServer.Management.DatabaseMaintenance.DBMaintTaskCheckIntegrityForm..ctor(TaskHost taskHost, IServiceProvider provider)

  at Microsoft.SqlServer.Management.DatabaseMaintenance.DbMaintTaskCheckIntegrityUI.GetView()

  at Microsoft.DataTransformationServices.Design.DtrTaskDesigner.GetTaskEditor()

  ===================================

  Exception from HRESULT: 0xC0010014 (Microsoft.SqlServer.DTSRuntimeWrap)

  ------------------------------

  Program Location:

  at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPropertiesProvider90.get_Properties()

  at Microsoft.SqlServer.Dts.Runtime.ConnectionManager.get_Properties()

  The second problem is that I am unable to connect to the localy installed integration/analysis and reporting services. The services is running when i check in services.msc.

  Is the anyway of fixing these bugs without doing a uninstall SQL server, reinstall SQL server?