We installed X64 bit windows 2003 sp2 and X64 sql server 2005 and installed sucessfully. when run select @@version and i got following results and looks good Microsoft SQL Server 2005 - 9.00.3200.00 (X64) Oct 2 2007 12:23:02 Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)
When i go to sql server configuration manager and properties of sql server and clicked advanceed tab i am seeing running under 64 bit OS is no
This does not sound like something I need to be so concerned about, but this is really confusing. Also, I realize that this is a SQL Server 2005 thread, but I think this also applies to SQL Server 2008 R2.
I am running a 64-bit OS and a 64-bit SQL Server. Here is the info:
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1 <X64> (Build 7600: ) (Hypervisor)
But in SQL Server Configuration Manager, when I look at the properties of a SQL Server instance on the advanceed tab, it says NO for "running under 64 bit OS". WHY?
Shouldn't this be YES since the service is running under a 64-bit OS? If the value is NO, then does that mean that it is running under a 32-bit OS? What does this all mean?