I wont write on article on this because I found an excellent ready one.

But the situation is that you have to move sharepoint to a different server keeping the sql-server instance name as is.

http://www.toddklindt.com/blog/Lists/Posts/Post.aspx?ID=255

Thanks Todd!