SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 X64 bit Sql Server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

yslatha
Starting Member

8 Posts

Posted - 05/14/2008 :  17:50:43  Show Profile  Reply with Quote
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

Why showing NO? i am missing anything?

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/14/2008 :  18:58:09  Show Profile  Reply with Quote
Did you reboot server after all these? you should be good
Go to Top of Page

yslatha
Starting Member

8 Posts

Posted - 05/14/2008 :  20:21:13  Show Profile  Reply with Quote
yes i reboot the server and still i am seeing same in advance tab
running under 64 bit OS is no
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 05/14/2008 :  20:50:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
That field means "Indicates whether this 32-bit service is running on a 64 bit OS". Your field should be grayed out and say No.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

yslatha
Starting Member

8 Posts

Posted - 05/15/2008 :  00:24:12  Show Profile  Reply with Quote
not grayed out and i can change it to yes also. I din't changed so far.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 05/15/2008 :  00:31:22  Show Profile  Visit tkizer's Homepage  Reply with Quote
I can change it to Yes too, but it should be set to No. When I said grayed out, I meant the field name. There are a bunch in a lighter color.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

yslatha
Starting Member

8 Posts

Posted - 05/15/2008 :  10:01:14  Show Profile  Reply with Quote
Kizer you are right and do i have to be concerned about anything?
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 05/15/2008 :  11:23:49  Show Profile  Visit tkizer's Homepage  Reply with Quote
Why would you be concerned about it if it's set correctly?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

Van
Constraint Violating Yak Guru

458 Posts

Posted - 05/15/2008 :  11:28:36  Show Profile  Reply with Quote
I think they are worried since they installed 64bit Windows and 64bit SQL.
Go to Top of Page

sodeep
Flowing Fount of Yak Knowledge

USA
7174 Posts

Posted - 05/15/2008 :  11:35:25  Show Profile  Reply with Quote
No worry.you are good.
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 05/15/2008 :  11:40:21  Show Profile  Visit tkizer's Homepage  Reply with Quote
The setting is correct because it isn't a 32-bit service. It is a 64-bit service. The setting would probably say Yes if you installed 32-bit SQL Server on x64 platform.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Database maintenance routines:
http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx
Go to Top of Page

yslatha
Starting Member

8 Posts

Posted - 05/15/2008 :  12:30:27  Show Profile  Reply with Quote
Thank you Tara Kizer
Go to Top of Page

SQLServing
Starting Member

1 Posts

Posted - 07/20/2012 :  14:05:13  Show Profile  Reply with Quote
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:


SELECT @@VERSION
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?

Thanks.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000