October 22, 2009 at 11:42 am
Is it possible to install 32 bit SQL 2005 std edition on a 64 bit Windows 2003 Server?
Sunds a bit wacko, but I need to find out.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 22, 2009 at 12:54 pm
You should be able to do that. You will lose some of the 64 bit memory management and processing.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
October 22, 2009 at 1:25 pm
You can do that .... The question is WHY would you !!!
If you have 64-bit available, use as much 64-bit software as you can !
(btw with x64 sql2005 with sp3 + CU4 hotfix you can use "lock pages in memory" which was only available for x64 EntEdtn up until then
)
Keep in mind this doesn't matter for you connecting applications ! They can connect to 32-bit as well as 64-bit !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
October 22, 2009 at 1:48 pm
Yes you can - but the real question is why do you think you need to? There are very few reasons that you would need to do that.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 3:00 pm
Licensing and availability issue. I agree it is best to use 64 bit for both products.
I'll see what we can do about this.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 22, 2009 at 7:31 pm
fizzleme (10/22/2009)
Licensing and availability issue. I agree it is best to use 64 bit for both products.I'll see what we can do about this.
Not sure what you are referring to - there are no licensing cost differences between x86 and x64. What availability issues are you concerned about?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 22, 2009 at 11:26 pm
There should not be any licencing issue. As far as you are installing it on the single PC 🙂
Because COST of the 32bit and 64bit is same.
The only reason what I am looking is that you have already purchage 32bit sql licence and having the new 64bit hardware.
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
October 23, 2009 at 7:51 am
free_mascot (10/22/2009)
The only reason what I am looking is that you have already purchage 32bit sql licence and having the new 64bit hardware.
There is no such thing as a 32bit SQL license. You purchase a license for a SQL Server Edition (Standard, Enterprise, Web, etc...) - not the platform it is going to run on.
If you are being told that you have to purchase a new license specific to a platform - I would recommend that you contact Microsoft directly for confirmation.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 23, 2009 at 11:23 am
Ok. I mainly wanted to check if it is possible to use a 64 bit server with 32 bit SQL. Thanks for the clarity.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
October 23, 2009 at 8:31 pm
Jeffrey Williams-493691 (10/23/2009)
free_mascot (10/22/2009)
The only reason what I am looking is that you have already purchage 32bit sql licence and having the new 64bit hardware.There is no such thing as a 32bit SQL license. You purchase a license for a SQL Server Edition (Standard, Enterprise, Web, etc...) - not the platform it is going to run on.
If you are being told that you have to purchase a new license specific to a platform - I would recommend that you contact Microsoft directly for confirmation.
Not a challenge here, Jeff... I really don't know and would like to find out. Are you saying that if I want to retire a 32 bit version of SQL Server 2005, that I can take that retired copy and install it on a 64 bit machine without having to pay a new fee to Microsoft (everything else being the same, of course)?
--Jeff Moden
Change is inevitable... Change for the better is not.
October 23, 2009 at 10:30 pm
Jeff Moden (10/23/2009)
Not a challenge here, Jeff... I really don't know and would like to find out. Are you saying that if I want to retire a 32 bit version of SQL Server 2005, that I can take that retired copy and install it on a 64 bit machine without having to pay a new fee to Microsoft (everything else being the same, of course)?
Everything else being the same - yes you can. The license you purchased is not tied to a specific machine and can be transferred to another machine with no problem. You did not purchase a license for the 32bit version - you purchased a license for the Edition. Whether that is a device CAL or processor license.
But, do not take my word for it - validate with your Microsoft licensing representative.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
October 24, 2009 at 4:29 am
I think you even have 60 days to switch to another server with the same license.
e.g. hardware switch or DRP
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply