Avatar of Mike Eghtebas
Mike EghtebasFlag for United States of America asked on

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.
Microsoft SQL Server 2008Microsoft SQL Server

Avatar of undefined
Last Comment
Sagir87

8/22/2022 - Mon
SOLUTION
lludden

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
SOLUTION
Aneesh

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Mike Eghtebas

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
ASKER
Mike Eghtebas

To avoid any problem, could you please give somewhat detailed instruction how to uninstall sp1 x86 and install sp1 x64?

Thank you,

Mike
Aneesh

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
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER
Mike Eghtebas

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.
lludden

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.
Aneesh

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
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.