?
Solved

installing SQL 2005 64bit

Posted on 2011-04-29
12
Medium Priority
?
545 Views
Last Modified: 2012-05-11
Hi,

I'm running Windows 2003 R2 x64 SP2. I installed SQL 2005 from the DVD, but 32bit got installed and I was not prompted for any x64.

select @@VERSION:
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)   Oct 14 2005 00:33:37   Copyright (c) 1988-2005 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

How can I install 64bit? I thought that SQL 2005 64bit will get installed automatically if the OS is 64bit..no?

Please advise

Thanks

0
Comment
Question by:ezzadin
12 Comments
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35493349
>>How can I install 64bit? I thought that SQL 2005 64bit will get installed automatically if the OS is 64bit..no? <<
I suspect the DVD only contained the 32-bit version.

0
 
LVL 9

Expert Comment

by:radcaesar
ID: 35493350
No. You need to have the installation of Itanum based (EPIC Architecture) systems (And your processor should support that)

http://www.microsoft.com/sqlserver/2005/en/us/64-bit.aspx

I believe that the CD you have is 32 bit version.
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35493367
>> You need to have the installation of Itanum <<
Why?  He does not have the Itanium processor.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 40

Expert Comment

by:mrjoltcola
ID: 35493371
>> You need to have the installation of Itanum <<

Well, not necessarily Itanium, he probably means x64. Separate DVD in my case.
0
 

Author Comment

by:ezzadin
ID: 35493416
the processor is intel Xeon E5620 so I dont know why I need Itanium...
0
 

Author Comment

by:ezzadin
ID: 35493445
how can I tell the CD i got is only 32bit? when I go to Setup Folder, I need files like:

sqlcli.msi
sqlcli_x64.msi

msxml6.msi
msxml6_x64.msi

SQLServer2005_BC.msi
SqlServer2005_BC_x64.msi

SqlRun.msi which I guess is the main installation file doesn't have the x64

so does this means that the CD is 32bit only?

Thanks
0
 

Author Comment

by:ezzadin
ID: 35493466
sorry, "I need files like" should be "I see files like"
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35493475
>>the processor is intel Xeon E5620 so I dont know why I need Itanium... <<
You don't.  The subject should have never come up.  It was a red-herring.

It sounds like you have both versions.  Perhaps you are checking the wrong server.
0
 

Author Comment

by:ezzadin
ID: 35493507
wrong server?! really?!
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 35497230
>>wrong server?! really?!<<
I don't know, unfortunately I am not in front of your computer, so I cannot tell.
0
 

Accepted Solution

by:
ezzadin earned 0 total points
ID: 35825538
run this first sqlcli_x64.msi and started to work.
0
 

Author Closing Comment

by:ezzadin
ID: 35868934
no
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Screencast - Getting to Know the Pipeline

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question