x64 Opteron running SQL Server 2005 in 32-bit?

Hi,

I installed SQL Server 2005 Ent. on an x64 AMD Hammer server running Windows 2003 Server Std. x64 ed.

When I open SQL Server configuration Manager and view advanced properties of the SQL Server (MSSQLSERVER) then the 'Running under 64 bit OS'-parameter is set to 'No'. When I try to change this to 'Yes' and press OK the system changes the parameter back to 'No'

Does this mean that my x64 server is running SQL2k5 server in 32-bit mode

Can anyone explain Thank you very much.

- Jacob

Answer this question

x64 Opteron running SQL Server 2005 in 32-bit?

Challe
Eric,

Thank you for your response.

However, I can positively say that I have installed the Extended 64-bit version of MS SQL Server 2005. So I'm afraid that didn't answer my question.

/Jacob
Trust Coder
If that's what the errorlog shows, then you are running the 64-bit product. This sounds like a bug in the configuration manager.

Besides the annoyance, does it cause any other problem
FearTec
Hi Eric,

Thank you for your reply. I don't have any problems besides that. My main concern is server performance but if you think it's a only a bug in the configuration manager and does not affect the supposed performance gains running an x64 system - then I'll take your word for it.

Regards, Jacob
phantastikfan
Hi Jacob

That attribute in configuration manager is read only, and just indicates what the configuration manager believes to be true. Eeven if you could change it, its not going to convert a 32-bit executable into a 64-bit executable.

Can you take a look in your SQL Server Error Log, and let us know what the first line says.

On a 32-bit system it will look something like

2005-11-11 19:12:37.75 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)

On a 64-bit system the (Intel X86) will be replaced with a platform specific ( X64, or IA64) string.

Regards

Steve
PETER I
Hi Steve,

Thanks for your. SQL Server Logs, first line shows:

Date  16-11-2005 09:14:50
Log  SQL Server (Current - 16-11-2005 09:15:00)

Source  Server

Message
Microsoft SQL Server 2005 - 9.00.1399.06 (X64)
Oct 14 2005 00:35:21
Copyright (c) 1988-2005 Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

Query on @@VERSION gives:

Microsoft SQL Server 2005 - 9.00.1399.06 (X64)   Oct 14 2005 00:35:21   Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 1)

Any suggestions

KR
Jacob
tskinner
We are running dell server with two dual-core intels and I'm getting the same thing on the advanced tab for properties on both the sql service and athe sql agent service.
Michael Shorten - MB Limited
I am getting the "running under 64 bit os - No" on a dell PE6800 also.
lukics
Hi, I got the same here on DELL PE285. but my machine seems running very slowly.
OrionsToy
SQL Server 2005 comes in both 32-bit and 64-bit versions. Evidently, you have installed the 32-bit version.
cookie24

Please see http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=1184224&SiteID=1&mode=1 for an explanation.

Thanks,
Sam Lester (MSFT)
DChap
Hi Jacob

I get exactly the same here. I am running Sun v40z server with 4xOpterons. Windows Server 2003 Enterprise x64 and SQL 2005 64 bit. So I think (and hoping) its just a bug in the configuration manager.

Mat
x64 Opteron running SQL Server 2005 in 32-bit?

Answer this question