Daily Archives: June 17, 2011

moving crm

we needed to move our crm environment… ok it sounds like bad idea and the reason was the server naming convention… ok now you will thick: why the hell didnt they do it correct the first time? actually… we did… but the consultant, how installed the crm, didnt… yeah and its our fault, that he did it wrong, we should have had controlled him better… but on the other hand, its just our test- / dev-enivornment… so it has no impact to our company, when we rename it, reinstall it and so on…

in my opinion, the move is not really importent… ok i am leaving this company next week, but its only a test server… therefore wth? but on the other side, we need to figure out a way, to replicate the data of the productiv environment to test… and i think this will actually be really similar to the move process… therfore, its training 🙂

and with following link pretty easy: http://support.microsoft.com/kb/952934/en-us

now i only have to re-install all our applications and re-configure the iis and re-register the plugins and… meh!

moving ms sql server

we needed to move an sql server… so we looked for space in our virtual environment… there was… but wth? moving is renaming… or isnt it? first it looked like it was, but secondly there were a few problems…

basiclly the sql server instance has the same name as the server… wrong!

sp_dropserver ‘old_name’
GO
sp_addserver ‘new_name’, local
GO

this statements change the instance name… following command returns the current instancename…

select @@SERVERNAME

and thats the history of renaming ms sql servers… funny…