SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2005 for 64 bit version OS (Windows 7)


SQL Server 2005 for 64 bit version OS (Windows 7)

Author
Message
dfine
dfine
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 597
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?

Raj
Meet George Jetson
Meet George Jetson
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3914 Visits: 1398
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.
dfine
dfine
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 597
So, You mean there is only one developer version that can be installed irrespective of 34 or 64 bit system.

Raj
Meet George Jetson
Meet George Jetson
Hall of Fame
Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)Hall of Fame (3.9K reputation)

Group: General Forum Members
Points: 3914 Visits: 1398
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.
dfine
dfine
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 597
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

Raj
Malcolm Daughtree
Malcolm Daughtree
Mr or Mrs. 500
Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)Mr or Mrs. 500 (561 reputation)

Group: General Forum Members
Points: 561 Visits: 335
you can run the 32bit on the 64bit machine, you only have 4 gig so it doesn't matter.
paul.knibbs
paul.knibbs
SSCarpal Tunnel
SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)SSCarpal Tunnel (4.2K reputation)

Group: General Forum Members
Points: 4202 Visits: 6240
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).
chiayin.powers
chiayin.powers
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 95
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.
chiayin.powers
chiayin.powers
Grasshopper
Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)Grasshopper (12 reputation)

Group: General Forum Members
Points: 12 Visits: 95
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search