Friday, March 30, 2012

Question about service configuration on SQL Server 2005 IA 64....

While perusing Configuration Manager, I noticed on the properties for the services there is a parameter to indicate whether or not the service is running on a 64-bit operating system. If I'm running on a 64 bit Itanium server, shouldn't this be checked "Yes"?

I'd ask the server admin who did the install, but he is currently awol.

Yes, it should be, assuming you 64bit Itanium server is running a 64bit OS, and the IA64 version of SQL was installed...you'd need to verify those 2 things...

What version of SQL is running? (run select @.@.version to get this)

What Edition is running? (run select serverproperty('Edition') to get this)

What OS is running, what edition, and what SKU? (you can get this from MSINFO, or right-click My Computer and select properties... the @.@.version output will also give you some of the info)

|||Only 64-bit SQL Server 2005 is available for IA64 machines.sql

No comments:

Post a Comment