SQL 2008 in Hyper V: Error 15401: Windows NT user or group ‘username’ not found. Check the name again.
Wednesday, April 15, 2009, 14:04
Posted by Administrator
We created a BASE2008.vhd disk, so when a new server is required we could easily use this base diks to skip the whole installation part and simply rename the server. Everything worked just great. Adding the new server to the domain and the installation of the new SQL server 2008 went as smooth as we suspected.
But when we wanted to add new users and groups to the SQL server we received the same error:
"Windows NT user or group ‘username’ not found. Check the name again." Because of the "clone" we took, we did change the servername but we never altered the SID of the server. There are 2 possibilities to fix this error:
The newsid tool. - remove this registry key using this node 'REG DELETE HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Wow6432Node /f'
- run the newsid tool and create a new SID for the server
- do not forget the reconnect the server to the domain
The sysprep tool. - OOTB installed on wind2008, run this on your base2008.vhd (%WINDIR%\System32\Sysprep\sysprep.exe)
- select OOBE and don't forget to check generalize. Press OK
- every time you start a new server from this base. It will be like you just installed it.
So the fix this problem with our SQL server we used the first tool and added the server to the domain again. Afterwards we update our base disk for the next servers...
good luck!