安装sqlserver2005的一个怪问题

我在win2003安装sqlserver2005的时候，把服务器升级成域控制器，后来又降级，反复几次，发现有问题。于是自己瞎改了一番，发现出现其他错误，于是卸载sqlserver，发现卸载失败，然后用专业卸载sqlserver2005工具强制卸载。重新安装发现安装失败

SQL Server Setup was unable add user NT AUTHORITY\SYSTEM to local group SQLServer2005MSFTEUser$SANORAYA$MSSQLSERVER.

For help, click: %5csqlsecurityca.cpp%40Do_sqlGroupMember%40Do_sqlGroupMember%40x8ac

百思不得其解，四处求援而不得。

后来google一个办法，终于搞定

Problem resolved.

As xrab suggested I created SQLServer2005MSFTEUser$SANORAYA$MSSQLSERVER local group and added local account to the group. Setup failed again with different error message "can't change permissions on "some file"... Make sure you run setup under admin privileges" or similar.

After that I ran uninstall, and then removed everything remaining manually from Program Files\Miscorosft SQL Server directory". Then copied everythin from Setup disk to HDD and ran setup again from HDD. Beleive it or not, everying went fine.

照做果然解决。还是国外的经多见广啊