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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Moving server from one machine name to another

Author  Topic 

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-05 : 16:05:54
SQL Server 2005, when moving a machine to a different domain and changing the hostname the logins such as domain\SQLServer2005MSSQLUSER$hostname$MSSQLSERVER are still showing the old hostname and domain name. Does anyone know what impact this has on the system and also if there is anyway to update these accounts without reinstalling SQL Server?



Future guru in the making.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-05 : 21:51:48
Not much, as long as you moved all affected sql logins and sql service accounts over.
Go to Top of Page

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-06 : 15:25:59
i don't use the groupings created by 2005, just add the group if they're not there... if they're there... just remove the old ones



--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -