How to Tell Whether You Are Running 32 bit 64 Bit SQL Server

April 5th, 2009 by Andrew Chen

The other day when I installed SQL server 2000 on a 64 bit

machine a dialog box pop up and said I couldn’t install SQL server 2000 using the current installation program and and I had to use another executable under a different folder to do installation. Later on a person asked me whether the SQL server installed on the 64 bit machine was a 32 bit or 64 bit version. I said it was of course a 64 bit version because the 32 bit version doesn’t work on 64 bit machine. It was embarrassed to find out I was wrong. In fact even though the 32 bit installation program asked me to use another installation program that program was still a 32 bit installation. The version information of SQL that are running can be returned using the following query

SELECT @@VERSION
SELECT SERVERPROPERTY(’ProductLevel’)

If the version returned is x86 that means it is a 32 bit installation and if it is x64 then it means it is a 64 bit installation. As simple as that! 32 bit version works on 64 bit machine but not vice versa

Can Not Connect to SQL Server Named Instance Remotely?

Link MySQL Server Into MSSQL Server

How to Connect to SQL Server Running on Non Standard Port

SQL Server Backup Device Error or Device off-line

How to Kill AutoShrink Process

Posted in SQL Server | 2,187 views