Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 for 64 bit version OS (Windows 7) Expand / Collapse
Author
Message
Posted Sunday, December 12, 2010 11:26 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 28, 2014 3:27 AM
Points: 337, Visits: 456
Guys,

I have Windows 7 64 bit. Now I would like to purchase MS SQL Server 2005 developer edition. Can you guys tell me is there any difference in the "MS SQL Server 2005 developer edition" for 32 bit and 64 bit OS Or "MS SQL Server 2005 developer edition" is comman for both type of system?


Joe
Post #1033596
Posted Monday, December 13, 2010 10:19 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:11 PM
Points: 1,749, Visits: 1,324
The main difference between 32-bit and 64-bit for Developer edition is the memory allocation or AWE switch is already enabled and you don't have the limitation like you do with 32-bit

http://www.microsoft.com/sqlserver/2005/en/us/system-requirements.aspx


Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Post #1033952
Posted Tuesday, December 14, 2010 8:40 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 28, 2014 3:27 AM
Points: 337, Visits: 456
So, You mean there is only one developer version that can be installed irrespective of 34 or 64 bit system.

Joe
Post #1034489
Posted Tuesday, December 14, 2010 8:48 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:11 PM
Points: 1,749, Visits: 1,324
No, there are three different versions of Developer edition. x86, 64-bit and 64-bitIA

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
Post #1034497
Posted Tuesday, December 14, 2010 10:53 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Monday, July 28, 2014 3:27 AM
Points: 337, Visits: 456
Thank you, By the way can you tell me which edition (x86, 64-bit and 64-bitIA ) I should buy ?
my system configuration is

x64 Based PC
Intel Core i5 CPU M 460
4 GB RAM


Joe
Post #1034589
Posted Tuesday, December 14, 2010 10:31 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, November 2, 2011 9:50 PM
Points: 189, Visits: 335
you can run the 32bit on the 64bit machine, you only have 4 gig so it doesn't matter.
Post #1034887
Posted Wednesday, December 15, 2010 5:54 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Yesterday @ 8:50 AM
Points: 1,631, Visits: 5,578
In point of fact you can use either the 32-bit or 64-bit version when you buy a SQL server license (so long as you don't use both at the same time, of course). With only 4Gb of RAM I would agree that there's little point using the 64-bit version, but if you might upgrade the RAM at some future date you might as well install the 64-bit one now rather than have to do an upgrade installation later. (You would need the x64 edition, by the way--IA64 is for Itanium CPUs).
Post #1035062
Posted Thursday, July 19, 2012 10:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 4:02 PM
Points: 2, Visits: 39
I am curious to find out if you ever run SSIS package on this machine.
My office work environment uses a Standard edition sql 2005 on Windows 7 professional. The control flow script task can not be open. When I drop a Script Task into a package, navigate to "Design Script" button and click. The dialog dissapears, no editor ever appears - no error message.

Framework 4.0 is installed. I also downloaded Framework 2.0 sdk. SQL 2008 R2 was installed and uninstalled to narrow down the possible conflicts.
Post #1332337
Posted Wednesday, October 10, 2012 2:24 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 20, 2012 4:02 PM
Points: 2, Visits: 39
Mystery solved. Reinstall SQL 2005, apply sql server sp4. Most important - turn on 32 bit asp.net on 64 bit IIS.
http://blogs.msdn.com/b/ionutg/archive/2008/04/07/running-32-bit-asp-net-applications-on-a-64bit-os.aspx

My design script window opens and works fine.
Post #1371115
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse