title: Upgrade SQL Server 2000 from x86 to x64?
body: <p>I have a SQL Server that's currently x86, and I'd like to upgrade it to x64. It's running on an x64 version of Windows, and I think it's as simple as the wrong version having been installed when the server was configured. It's a production server, so my biggest concern is getting the logins over unaltered, since every user has their own SQL login. I've done some searching, and found an <a href="http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23800128.html" rel="nofollow noreferrer">Experts-Exchange thread</a> that gave the following steps, though he never reported back if it worked.</p>
  
  <ol>
  <li>detach databases - alluser dbs, model and msdb.</li>
  <li>script logins (<a href="http://support.microsoft.com/kb/918992/" rel="nofollow noreferrer">http://support.microsoft.com/kb/918992/</a>) and jobs </li>
  <li>save db files and scripts</li>
  <li>unintall SQL</li>
  <li>install sql x64</li>
  <li>attach dbs</li>
  <li>re attached dbs once files are in correct place.</li>
  <li>run scripts for logins and jobs if msdb is not reattached.</li>
  </ol>
  
  <p>Aside from the fact that you don't need to transfer the system databases to the new instance (so step 1 isn't quite correct, aside from scripting any special XPs or anything else you've created), can anybody think of anything else that needs to be done? More importantly, has anybody actually tried this? Can you share any stories or gotchas, or did it go smoothly?</p>