SSCM configure Sql Server Service Run Under 64bit OS

• NixIsTheNameSQLIsTheGame

  SSC Eights!

  Points: 996

  More actions

  June 12, 2008 at 10:13 am

  #124355

  I'm running SQL Server 2005 Standard SP2 on Windows Server 2003 64 Bit and using the 64 Bit SQL Server 2005.

  I dont know if this is a problem or not but it seems pretty serious to me. I am using Sql Server Configuration Manager to configure the location of my system databases by changing the startup parameters when I noticed a setting under advanced for the SQL Server Running under 64 bit OS is set to NO. When I change the setting to yes and restart the service it is reset to NO. This occurs even if I change the setting after stopping the service and then restarting it.

  Things that make you go HMMMmmmmm

  'nix

• Boris G

  SSC Enthusiast

  Points: 152

  More actions

  July 12, 2011 at 10:15 am

  #1351739

  Did you ever found any info on this? I just notice the same thing on both sql2005 and sql2008 running on 64bit Windows 2003, But

  states "Running under 64 bit OS: NO"

  Borik

• Jayanth_Kurup

  SSC-Insane

  Points: 22967

  More actions

  July 12, 2011 at 10:20 am

  #1351745

  This is no Help but still

  http://connect.microsoft.com/SQLServer/feedback/details/332566/in-configuration-manager-running-under-64-bit-os-proprty-is-set-as-no-where-it-is-installed-on-x64

  http://social.msdn.microsoft.com/forums/en-US/sqlsetupandupgrade/thread/e83b5ded-8cda-468d-ac36-1b8c31b1073b/

  Jayanth Kurup[/url]

• Boris G

  SSC Enthusiast

  Points: 152

  More actions

  July 12, 2011 at 10:53 am

  #1351776

  Thank you. That one less thing for me to worry about today...

  Borik