SP x86 or x64?

I ran the following test on a machine (in SQL Server 2012):

SELECT @@Version

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (Intel X86)
      Dec 28 2012 19:06:41
      Copyright (c) Microsoft Corporation
      Enterprise Edition on Windows NT 6.1 <X64> (Build 7601: Service Pack 1) (WOW64)


I see that the operating system is x64 but SP1 is x86.

Question 1: Does this mean wrong SP1 x86 was wrong installation?
Question 2: Because I need to have SP3, Could I just install SP3 x64 or I have to uninstall SP1 x86 first?

Thank you.
LVL 34
Mike EghtebasDatabase and Application DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lluddenCommented:
You have the 32 bit version of SQL 2012 installed on a 64 bit operating system.

You have to install the SP for the 32 bit SQL (if they are separate, it might be 1 SP for both).
0
Aneesh RetnakaranDatabase AdministratorCommented:
You have the correct version, you should have installed the 64 bit SQL Server 2012.
>Question 2: Because I need to have SP3, Could I just install SP3 x64 or I have to uninstall SP1 x86 first?
There is no SP3 released for SQL 2012, SP1 is the latest released service pack at this moment
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
re:> You have the 32 bit version of SQL 2012 installed

Is it that 2012 is not concerned or related to x86 or x64; this is SP version that determines whether it is going to be x86 or x64?

Mike
0
Newly released Acronis True Image 2019

In announcing the release of the 15th Anniversary Edition of Acronis True Image 2019, the company revealed that its artificial intelligence-based anti-ransomware technology – stopped more than 200,000 ransomware attacks on 150,000 customers last year.

Mike EghtebasDatabase and Application DeveloperAuthor Commented:
To avoid any problem, could you please give somewhat detailed instruction how to uninstall sp1 x86 and install sp1 x64?

Thank you,

Mike
0
Aneesh RetnakaranDatabase AdministratorCommented:
it is the type of sql server you have installed on your Server that determines 32 bit or 64 bit. SP should match your original installation of SQL not the OS
0
Mike EghtebasDatabase and Application DeveloperAuthor Commented:
re:> it is the type of sql server you have installed on your Server that determines 32 bit or 64 bit. SP should match your original installation of SQL not the OS

This will be my first installation ever. Someone else has doe the installations before and apparently has messed up installing x86 instead of x64.

Starting from start button, control panel etc. I could use some direction on locating sp1 x86  to uninstall it and then install sp1 x64 after downloading it.
0
lluddenCommented:
It is not the service pack that needs uninstalling, it is the entire SQL server.  You will need to uninstall everything with SQL, then reinstall it all again with the x64 version.

The databases should all work the same.
0
Aneesh RetnakaranDatabase AdministratorCommented:
Your sql server is 32 bit, I suggest, if possible install the 64 bit edition of SQL Server first (you need to uninstall 32 bit of sql server first ) . once you have 64 bit of sql saerver, you can install the 64bit edition of SP1
0
geek_vjCommented:
You need to uninstall entire SQL Server software from Control panel (remove all SQL server components), reboot the server, get the 64 bit edition of sql server and perform the installation.
Here is the step by step instruction list (with images) on how to perform the SQL Server 2012 installation:

http://www.sqlcoffee.com/SQLServer2012_0007.htm

Hope this helps!
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.