Hi,

After trying to upgrade DPM2012 SP1beta in another thread, I decided to delete the old database and the beta installation of DPM. It will take a 1-2 hours to reconfigure, but since I tried everything else this would work probably the best for me.. (unfortunately it doesn't).

With my new DPM2012 SP1 installation (fresh install + reboot + reboot of SQL-box) I receive the following error in the DPMSETUP.LOG:

[30-1-2013 10:44:29] Data : checkId = ClientTCPEnabled
[30-1-2013 10:44:29] Information : Running the check: ClientTCPEnabled
[30-1-2013 10:44:29] Information : Getting the check for the checkId : ClientTCPEnabled
[30-1-2013 10:44:29] Information : Calling the method: CheckIfClientTCPEnabled
[30-1-2013 10:44:29] Information : Check if SQL Server has DPM Server already installed on it.
[30-1-2013 10:44:29] * Exception : Expecting the following exception. Ignoring intentionally.  => System.Management.ManagementException: Not found
   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementObject.Get()
   at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectPrerequisites.GetSqlToolsWMINameSpace()
[30-1-2013 10:44:29] * Exception : Expecting the following exception. Ignoring intentionally.  => System.Management.ManagementException: Invalid namespace
   at System.Management.ManagementException.ThrowWithExtendedInfo(ManagementStatus errorCode)
   at System.Management.ManagementScope.InitializeGuts(Object o)
   at System.Management.ManagementScope.Initialize()
   at System.Management.ManagementObject.Initialize(Boolean getObject)
   at System.Management.ManagementObject.Get()
   at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectPrerequisites.CheckIfClientTCPEnabled(InspectContext context)
[30-1-2013 10:44:29] * Exception : Failed to perform the check => System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Management.ManagementException: Invalid namespace
   at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.InspectPrerequisites.CheckIfClientTCPEnabled(InspectContext context)
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at Microsoft.Internal.EnterpriseStorage.Dls.Setup.Inspect.Inspect.RunCheck(String checkId)
[30-1-2013 10:44:29] Information : Adding the check result entry for checkId: ClientTCPEnabled and result: 1

[30-1-2013 10:44:29] Information : Got Error Message: Failed to perform the check.See the log file for details and try again.
[30-1-2013 10:44:29] Data : Result = 1

It looks like the TCP/IP protocol is disabled on the , but that's not true according to the SQL configmgr. And the DB worked right just before. There are other DB's on the instance which are working fine.  The last exception in the above log:

 [30-1-2013 10:44:29] * Exception : Failed to perform the check

Was not ignored intentionally (the other 2 ones were ignored intentionally), so that seems to be the problem. Unfortunately, this is gibberish for me. Can anyone help?

Thanks in advance!

I deleted all local SQL tools on the DPM server then I was able to continue!

• Marked as answer by Dennis Ku Friday, February 01, 2013 9:30 AM

I deleted all local SQL tools on the DPM server then I was able to continue!

• Marked as answer by Dennis Ku Friday, February 01, 2013 9:30 AM

I deleted all local SQL tools on the DPM server then I was able to continue!

• Marked as answer by Dennis Ku Friday, February 01, 2013 9:30 AM

Hey Dennis. I'm having the same issue. I'm trying to do it to a remote instance? did you uninstall the sql tools on the dpm server or the remote sql server? What exactly is "all local sql tools"?

Thanks!!

P.S. I removed a SQL Management Studio install that was on the DPM server. Not sure why it was on there, but once I removed that the install went through.

• Edited by DStelz Thursday, February 07, 2013 2:06 PM

Hey Dennis. I'm having the same issue. I'm trying to do it to a remote instance? did you uninstall the sql tools on the dpm server or the remote sql server? What exactly is "all local sql tools"?

Thanks!!

P.S. I removed a SQL Management Studio install that was on the DPM server. Not sure why it was on there, but once I removed that the install went through.

• Edited by DStelz Thursday, February 07, 2013 2:06 PM

Hey Dennis. I'm having the same issue. I'm trying to do it to a remote instance? did you uninstall the sql tools on the dpm server or the remote sql server? What exactly is "all local sql tools"?

Thanks!!

P.S. I removed a SQL Management Studio install that was on the DPM server. Not sure why it was on there, but once I removed that the install went through.

• Edited by DStelz Thursday, February 07, 2013 2:06 PM

Dennies thanks a lot!

I had the same issue. After removing all the SQL stuff on DPM, I was able to upgrade from DPM 2012 to DPM 2012 SP1. I also moved the remote SQL DB to a new server with a new SQL instance with SQL 2012 SP1. Upgrade went through successfully!

Hi,

I am also facing the same issue;

I did not find the solution but the exact cause in my case is:

The ManagementObject.get() throwing exception when i'm trying to configure protocols for 32-bit SQL Server and Management studio X64 is installed;