locked
Running under 64-bit OS RRS feed

  • Question

  • In configuration manager, the parameter "running under 64-bit os" is grayed out on my sql services.

    How can you change this?  Where does it get set?  At install?

    Tuesday, February 7, 2006 10:24 PM

Answers

  • It turns out that the label is very confusing.  There is a bug filed on it in the SQL bug database and it will hopefully get fixed in the future to make this clearer.  It turns out that this field shows if you are running a 32-bit version of SQL under a 64-bit OS (as in WoW).  I had an X64 machine here with a 64-bit instance of SQL and a 32-bit instance of SQL.  The field shows "No" for the 64-bit version of SQL and "Yes" for the 32-bit version of SQL.  A bit misleading, but "correct" if you look at it in this way.  :)

    Thanks,
    Sam Lester (MSFT)

    Friday, February 2, 2007 10:17 PM
  • Looks like you are running the 32-bit OS version...if you had the Itanium or 64bit edition, it would specifically say so...
    Friday, February 10, 2006 8:47 PM

All replies

  • This can't be changed...it is set depending on the OS version and SQL Server bits you've installed.  In order for it to be set, you'd need to be running a 64bit OS (IA64 or x64) and have the appropriate SQL server bits installed (IA64 SQL version or x64 SQL version)...

     

    Wednesday, February 8, 2006 2:30 AM
  • I checked...the server is an Itanium 2 and the SQL Server software is definitely the IA64 version (select @@version output), but how can you tell if the OS is 64 bit? 

    According to the My Computer properties, I'm running Windows Server 2003 Enterprise Edition Version 5.2 SP1.  No mention of 64 bit.  Anywhere else I should look?

    Friday, February 10, 2006 6:25 PM
  • Looks like you are running the 32-bit OS version...if you had the Itanium or 64bit edition, it would specifically say so...
    Friday, February 10, 2006 8:47 PM
  • I have SQL Server 2005 EE 64 bit installed on a 64 bit Server with Windows Server 2003 R2 Enterprise x64 Edition.  However, the SQL Configuration Manager still shows No for the Running under 64 bit OS property.  Any suggestions on what is going on?  Thanks.
    Tuesday, January 23, 2007 9:52 PM
  • I am also having this problem.  We have Server 2003 Enterprise x64 Edition, and the SQL Server 2005 version is as follows:

    Microsoft SQL Server 2005 - 9.00.2047.00 (X64)   Apr 14 2006 01:11:53   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

    What gives?
    Friday, February 2, 2007 6:31 PM
  • It turns out that the label is very confusing.  There is a bug filed on it in the SQL bug database and it will hopefully get fixed in the future to make this clearer.  It turns out that this field shows if you are running a 32-bit version of SQL under a 64-bit OS (as in WoW).  I had an X64 machine here with a 64-bit instance of SQL and a 32-bit instance of SQL.  The field shows "No" for the 64-bit version of SQL and "Yes" for the 32-bit version of SQL.  A bit misleading, but "correct" if you look at it in this way.  :)

    Thanks,
    Sam Lester (MSFT)

    Friday, February 2, 2007 10:17 PM
  • Thank you!  I actually have only one 64-bit instance of SQL 2005 and several 32-bit instances of SQL 2000 on the server.  No 32-bit instances of SQL 2005 are installed.  I'll trust that it's running in 64-bit mode.
    Friday, February 2, 2007 10:28 PM