Problem w/ SQL 2005 64-bit install on Win 2008 64-bit 1

[mkrausnick]

I'm setting up a new server running Windows 2008 standard 64-bit. I downloaded the 64-bit SQL server 2005 64 bit (self-extracting zip SW_CD_SQL_Svr_Standard_Edtn_2005_64Bit_X64_English_1_x64_MLF_X11-57664.exe) and installed it. I installed the whole package, then installed SP2. While poking around I happened to right-click the Sql Server in the SQL Configuration Manager and choose properties. The line "Running on 64-bit OS" says "No", and when I click the mouse there, the tool-tip says "Indicates whether this 32-bit service is running on a 64-bit operating system."

The properties window of My Computer ("Computer" actually) indicates it's running a 64-bit version of Windows.

Why does SQL Server think it's a 32-bit version, and why doesn't it know it's running on Win 2K8 64-bit?

Thanks for your help.


Mike Krausnick
Dublin, California

 

[mrdenny]

Look in Task Manager. Does the sqlservr.exe process say x86 next to it? If so its running 32bit, if not its running 64bit.

If you installed from the x64 ISO then it'll only install the 64bit edition. The 32bit build isn't included in that ISO.

Denny
MVP
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / SQL 2008 Implementation and Maintenance / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Admin (SQL 2005/2008) / Database Dev (SQL 2005)

My Blog

 

[mkrausnick]

Thanks for the reply. Taskmgr indicates SqlServr.exe - no x86. I feel better now. I know the Windows is x64, so it must just be a bug in the properties window. Very strange.



Mike Krausnick
Dublin, California