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.
| Author |
Topic |
|
khalid_kuw
Starting Member
1 Post |
 Posted - 2007-12-31 : 03:30:24
|
| I had purchase SQL Server 2005 32 bit. in 2006.Now we want to updgrade SQL Server 2005 32 bit to 64 bit ?Q1) Can SQL server 2005 32 bit will be installed and work with limitaion(with not full functionality) on x64 Server ?Q2) Can we updgrade licensce from 32 bit to 64 bits ?Thank in Advance |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-12-31 : 14:41:43
|
| 1. Yes the 32 bit software will run just fine on 64 bit hardware and OS.2. As far as I know you get the 32 and 64 bit versions with SQL Server 2005 Standard or Enterprise, you don't purchase separate products. So if you have Standard or Enterprise you shouldn't need to upgrade at all. |
 |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-12-31 : 15:05:53
|
| i don't recommend you run 32bit software in your 64bit OS though. the reason is that there is a separation between 32/64bit apps and their different registry entries. This comes into play when you try to monitor your SQL environment. It is very difficult to monitor your 32bit SQL Server on an x64 system because of this.-ec |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-31 : 23:37:02
|
| And you can't get any 64-bit benefits. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-09 : 19:51:57
|
| In 64-bit SQL server , they have problem with Linked server . They don't have providers for ODBC (like MSDASQL in 32-bit) |
|
|
|
|
|
|
SQL Server 2005 32-bit --64-bit