Monday, March 26, 2012

Running under 64-bit OS

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?

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)...

|||

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?

|||Looks like you are running the 32-bit OS version...if you had the Itanium or 64bit edition, it would specifically say so...|||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.|||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?|||

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)

|||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.

No comments:

Post a Comment