Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
daveman6610
Starting Member
8 Posts |
 Posted - 2004-05-18 : 12:39:13
|
| We recently changed passwords that the DTC service is running under and the event log shows the information below, running Windows Standard 2003. The Component services shows the computer red and I can not get in to the properties dialog to change the password. Any ideas of why I get the Red Down Arrow and what I can do to make it go away?Event Log Text---------------------------------------------------------------------The account that the MS DTC service is running under is invalid. This can happen if the service account information has been changed using the Services snap-in in Microsoft Management Console (MMC). MS DTC service will continue to start. Please make sure that the MS DTC service account information is updated using the Component Services Explorer. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-18 : 13:24:37
|
| Go to control panel, then to administrative tools, then to services. Go to the service and double click on it. Go to logon tab. Change the password in there.Tara |
 |
|
|
daveman6610
Starting Member
8 Posts |
Posted - 2004-05-18 : 13:41:43
|
| Thanks for the quick reply.I've actually changed the password through this interface already, but per the error message, it indicates I have to change it through the Component Services MMC, which is also on Administrative Tools menu.The problem is, my computer is listed with a Red Down Arrow (which I'm sure is an error of some kind) and I can't open the Properties dialog to change it there.BTW, I think this issue of where to change the password is a 2003 specific issue as well, because I don't remember ever going anywhere else than Services to change account user names and passwords.Any ideas? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-05-18 : 13:47:51
|
| Are you an administrator on the machine?Tara |
|
|
|
daveman6610
Starting Member
8 Posts |
Posted - 2004-05-18 : 13:54:52
|
| Yes, and I've tried two different admin accounts as well, just for kicks.I've read on the NET something about the Red Arrows indicating an agent can't communicate with the console in another context, but I really don't know much about Component Services and whether there are any Agents running on its behalf. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
daveman6610
Starting Member
8 Posts |
Posted - 2004-05-18 : 18:10:10
|
| Just to update anyone who's interested in this topic.We were able to resolve this issue by setting DTC to run under the Windows 2003 NetworkService account in the Services Control Panel. We didn't seem to be able to change the account to anything else (even the password) but for some reason could change it to NetworkService. After stopping and starting DTC & SQL Server and resetting the DTC logs, everything appeared to work and we could get to the Properties tab in Component Services.Under Windows 2003, DTC should not be run under any other account unless you make sure that the other accounts have the necesary permissions, as even Admin accounts can't do everything the NetworkService account can. |
|
|
|
|
|
|
|
|
Change Account Name in DTC