I installed sql server 2008 r2 express on a standalone Windows XP Professional Version 2002 SP3 computer (C1). I could connect to the server.
I then tried to copy an sql server 2008 r2 express database from another computer (C2) by restoring a backup copy from C2 on C1. It didn't work, I think, because the server
names were different.
I then uninstalled sql server on C1, changed the computer name of C1 to match C2 (or perhaps
I did it in reverse order). I then rebooted and reinstalled sql server on C1. During the installation I got the first of the twoGo to the complete details ...