Tuesday, September 22, 2009

SQL2005 setup

Today I try to install a new instance of SQL2005 server to a Windows2003 Server which is previous part of a cluster machine. (Previouly another instance of SQL2005 was installed to the server in a cluster configuration but no longer accessible).


It always display below error message which causes me failure to install a new instance:


SQL Server Setup was unable add user XXX/administrator to local group SQLServer2005SQLBrowserUser$YYY


Finally I find that the solution is to update login name of related SQL Services found in "Administration --> Services function" of Windows2003 Server. Right click the entry and change the login name from "XXX/administrator" to "YYY/administrator" where XXX is machine name of previous cluster machine and YYY is local machine name.

No comments: