November 29, 2010 at 9:45 am
Hi everyone,
Really need some help.
My company is upgrading SQL Server 2005 to SQL Server 2008 R2 x64. My goal is to get SQL Server 2008 on all of my Prod Support team's PCs (as I understand it, I cannot use SQL Server 2005 to connect to SQL Server 2008 to check data). The problem is, all of our machines are x32, and I dont even see an install for SQL Server 2008 R2 for x32 out on MSDN for me to download (I have an MSDN account). When I try to install the x64, I get an install error although I do not know what it specifically is, but I am sure it has to do with the difference in x32/x64. Who knows maybe I am wrong on that.
Either way, does anyone know where I can download the x32 version? and when I do, can I still connect to a x64 with it? Because the x64 will be in all of our environements, but we need local installs on our PCs.
Thanks for the help ahead of time.
November 29, 2010 at 10:14 am
There is not a platform called x32, there are x86 (32-bit) and x64 (64-bit). If you are installing local workstations on 32 bit platforms, use the x86 products. Express or developer should provide you with a local engine, and if you just need the client tools, they are available in almost every product. Read the details or look at the SQL Server product page for the feature set and details you need.
November 29, 2010 at 10:31 am
I'm not sure what level of MSDN subscription you have but there are 32 and 64-bit versions of SQL Server 2008 R2 available for download. I show it as "SQL Server 2008 R2 Enterprise (x86, x64, ia64) - DVD (English)". Also you can connect to a SQL Server 2008 R2 instances with SQL Server 2005 tools, it can cause issues so it is best to use the highest release of tools allowed to you by licensing.
That I know of there is still no 64-bit version of SSMS (SQL Server tools), so you get the 32-bit version regardless. You might want to check your operating system requirements to make sure the OS on your desktops are at the appropriate build number (Service Pack).
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply