How to update the User(Domain user) and Password on This User option in Identity section of Microsoft excel application through Powershell for DCOMcnfg

Sivanjaneyulu K 1

Viki Ji_MSFT 4,411 Reputation points

2021-08-20T01:46:18.047+00:00

Hi @Sivanjaneyulu K ,
Welcome to Q&A forum!
Since this issue is more related to PowerShell, but the tag office-excel-itpro focuses on genral issues about Excel client, I will remove it.
Thanks for your understanding!
Rich Matheisen 44,776 Reputation points

2021-08-20T02:09:06.867+00:00

@Viki Ji_MSFT

While the question asked about doing this in PowerShell, I don't think there's a way (or at least an easy way) to do this without C#.

So how would you do this using any MS supplied software, excluding any that relies on a GUI? That's right in line with the office "itpro" category.

2 answers

Rich Matheisen 44,776 Reputation points

2021-08-19T18:07:56.947+00:00

Download DCOMFIX from here: 11.aspx

You can change the user by rewriting a registry key, but the password can't be done that way.
Please sign in to rate this answer.

1 person found this answer helpful.
Sivanjaneyulu K 1 Reputation point

2021-08-19T18:17:13.427+00:00

Yes, We can't update the password with this. But, My goal is need to update the User account and password.
Because every morning 6 AM I need to update My team domain account and Evening 6 PM, I need to update other team domain account to use the Microsoft Excel application. So, I want to avoid this manual efforts daily.!!

Rich Matheisen 44,776 Reputation points

2021-08-19T18:44:29.387+00:00

Have a look at the other EXE in that zip file: DCOMPERM. Something like this should work.

dcomperm -runas {12345678-1234-1234-1234-00aa00bbf7c7} redmond\jdoe password

Sivanjaneyulu K 1 Reputation point

2021-08-19T19:06:56.507+00:00

No, Not working, Better we need to try different method. My case need to update APP ID {00020812-0000-0000-C000-000000000046} on Identity option as this user with Domain service account with Password.

Rich Matheisen 44,776 Reputation points

2021-08-20T02:05:18.267+00:00

"Not working" isn't a helpful description. Do you get an error? If so, what is it? Are you running it from an elevated prompt?

There's an open source version of dcomperm here: dcompermex . It's distributed as source code so you'll have to build the exe (using Visual Studio that should be easy enough). Or you can have a look at the code and find out how to set the user/password and get that to work in PowerShell.

Sivanjaneyulu K 1 Reputation point

2021-08-20T04:32:06.75+00:00

Get-WMIObject -Class Win32_DCOMApplicationSetting -Filter 'AppID="{00020812-0000-0000-C000-000000000046}"'|Select -Property AppID,Caption,RunAsUser

Get-CimInstance -ClassName Win32_DCOMApplicationSetting -Filter 'AppID="{00020812-0000-0000-C000-000000000046}"'

I was able to get the information about what account is using for Microsoft Excel application, Any other way to set the run as user with domain account and password?

Sivanjaneyulu K 1 Reputation point

2021-09-12T11:28:28.977+00:00

Any Other powershell scripts to update DCom settings?
Sign in to comment
Rich Matheisen 44,776 Reputation points

2021-08-19T14:56:56.043+00:00

How about this?

change-dcom-config-security-settings-using-powershell
Please sign in to rate this answer.
Sivanjaneyulu K 1 Reputation point

2021-08-19T17:48:05.783+00:00

Provided script in Url, No Where else asking user name and Password to update the domain account.
Sign in to comment