SQL SERVER – Running 64 bit SQL SERVER 2005 on 32 bit Operating System

Few days ago, I have received email from users asking question :How to run 64 bit SQL SERVER 2005 on 32 bit operating system?

NO. It is not possible. 64 bit SQL Server can not run on 32 bit operating system.

It is true other way. SQL Server 32 bit can run on 64 bit operating system.

Read additional documentation on : 64-bit Computing with SQL Server 2005

Reference : Pinal Dave (http://blog.SQLAuthority.com)

About these ads

6 thoughts on “SQL SERVER – Running 64 bit SQL SERVER 2005 on 32 bit Operating System

  1. Pinal,
    If I run 32-bit sql on 64-bit environment, I have learnt that the 32-bit tools run in the WOW environment and hurts performance. The question is: will AWE have to be enabled to address memory over 4gb since the sql server is 32-bit? I realize 64-bit doesn’t have the limitation but will 32-bit sql address that memory over 4gb without awe. I believe it wont but I’d like to get a confirmation.

    thanks for your time.
    Clement

  2. I have a sql 32bit running in os 64bit. Can i configure a AWE to support more memory ?? I tried to configure but the sql send me error about “lock pages”. Can anyone help me ?
    Thanks

  3. We have sql server 2005 developers edition(SSIS,SSAS,SSRS etc) and servers are in cluster and OS of windows 2003 R2. We had configured this in 2007. At present the data size has been increased to four times..
    Can u please provide info to upgrade the same to handle the load..

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s