The place where I work at currently runs a 32-bit SQL Server 2005 installation on its server which we work with. In addition, the systems we are developing on have not yet been tested for 64 bit ODBC compatibility.
I also do independent projects from home which will require me to install 64-bit SQL Server instances on my laptop. I'm a little worried about the combinations so I need to know if it'll work.
I'll be installing SQL Server 2005 developer edition (32-bit) to my laptop. I expect this will work fine along with the installation of the service packs.
I'll then be installing SQL Server 2008 developer edition (64-bit) on to the same laptop.
Are there any gotchas that I need to look out for or prevent from happening?