X64 bit Sql Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

X64 bit Sql Server

Author

Topic

yslatha
Starting Member

8 Posts

Posted - 2008-05-14 : 17:50:43

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
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-14 : 18:58:09

Did you reboot server after all these? you should be good

yslatha
Starting Member

8 Posts

Posted - 2008-05-14 : 20:21:13

yes i reboot the server and still i am seeing same in advance tab
running under 64 bit OS is no

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-14 : 20:50:21

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

yslatha
Starting Member

8 Posts

Posted - 2008-05-15 : 00:24:12

not grayed out and i can change it to yes also. I din't changed so far.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-15 : 00:31:22

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

yslatha
Starting Member

8 Posts

Posted - 2008-05-15 : 10:01:14

Kizer you are right and do i have to be concerned about anything?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-15 : 11:23:49

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

Van
Constraint Violating Yak Guru

462 Posts

Posted - 2008-05-15 : 11:28:36

I think they are worried since they installed 64bit Windows and 64bit SQL.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-05-15 : 11:35:25

No worry.you are good.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-05-15 : 11:40:21

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

yslatha
Starting Member

8 Posts

Posted - 2008-05-15 : 12:30:27

Thank you Tara Kizer

SQLServing
Starting Member

1 Post

Posted - 2012-07-20 : 14:05:13

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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources