SQL Server - SQL Server Native Client is not supported on the current processor

Asked By soccerwiz1

15-Jun-08 07:53 PM

I'm trying to install SQL Server 2008 on Windows Server 2008 x64 bit.  I
installed the components, but when I try to install the native client, I get
the error message "This Microsoft SQL Server Native Client package is not
supported on the current processor type."  I have a quad-core processor.  I
am installing SQL Server 2005 Standard Edition, but I'm not sure if it is 32
bit or 64 bit.  It came with the Microsoft Action Subscription pack, and
doesn't list whether it is the 64 or 32 bit version.

Is there a way I can tell whether I have the 32 bit or 64 bit version?
Also, do I need to install WOW64 on SQL server 2008 in order to get it to
work?

15-Jun-08 07:55 PM

I meant SQL Server 2005.

15-Jun-08 11:50 PM

Do you mean you installed SQL Server + components, then after it was
installed, you ran the native client setup separately?  If so, where did you
get the native client setup file, and why do you need to install it
separately?  (Client connectivity components should have been installed as a
part of setup.)

If SQL Server is now installed, you can tell if it is 32 bit or not in at
least two ways:

1) if it is the only instance on the server, you will find a sqlservr.exe
somewhere under C:\Program Files (x86)\ for 32-bit, or C:\Program Files\ for
64-bit.

2) when you connect to the instance using Management Studio, you can tell
whether it is 32-bit or 64-bit by using SELECT @@VERSION; for 32-bit, this
will contain X86, otherwise X64.

A




On 6/15/08 7:55 PM, in article
3FC69A6D-3482-42C4-A634-FE4AD538FA41@microsoft.com, "soccerwiz13"

16-Jun-08 02:24 PM

I did install SQL Server + components, but no instance of SQL 2005 was
installed.  I looked in my program files and I have files in both Program
Files (x86) and Program Files.  I had two warning during install.  One was
that IIS was not running (although IIS 7 was running) and the other was an
issue with reporting services.  Would these warnings cause the instance of
SQL Server to not install?

16-Jun-08 03:06 PM

Did you review the error logs?  How exactly are you verifying that "no
instance of SQL 2005 was installed"?


Yes, both of these folders should be present (in most cases) on x64.  The
important part is, where did you find the specific file, sqlservr.exe, if at
all?


No, they would simply affect reporting services.  Could you try a much more
simple install, e.g. just the database engine and client connectivity
components.  That is, once you have explained how you have verified that no
instance is already installed, and we have helped you figure out whether
that is accurate or not.

16-Jun-08 03:36 PM

I ran the SQL Configuration manager and my machine had no instances running.
I also looked in servers and no services for SQL existed.

I then ran the install for SQL Server 2008 CTP that came in November 2007.
It installed an instance of SQL Server correctly.  However, it failed to
install the Client Tools and SQl Server Books online.  The error message I am
getting now it:

Setup has detected SQL Server 2005 Client Components on the computer where
you are installing SQL Server 2008. SQL Server 2008 installation is not
supported side-by-side with SQL Server 2005 Client Components. You must
either install SQL Server 2008 Client Components on a different computer or
uninstall SQL Server 2005 Client Components before installing SQL Server 2008
Client Components.

However, I have uninstalled all SQL 2005 components.  Do I need to remove
certain files?  Any ideas?

19-Jun-08 03:48 AM

Any ideas on why I'm getting the following error when trying to install the
tools for SQL 2008?

Setup has detected SQL Server 2005 Client Components on the computer where
you are installing SQL Server 2008. SQL Server 2008 installation is not
supported side-by-side with SQL Server 2005 Client Components. You must
either install SQL Server 2008 Client Components on a different computer or
uninstall SQL Server 2005 Client Components before installing SQL Server 2008
Client Components.

I had the components installed, but have uninstalled everything and
restarted several times.  I am still getting this error message though.  Are
there some registry keys I need to delete?

19-Jun-08 04:34 AM

Are you sure there is no "Workstation Components" in the "Remove SQL Server
2005 common components" list in the Microsoft SQL Server 2005 Uninstall
window when you click the Uninstall button in Add\Remove Programs?

--
Ekrem Önsoy

19-Jun-08 01:37 PM

I have the following programs installed on the machine, according to the
Programs and Features section in the control Panel:

Microsoft Office 2003 Web Conponents
Microsoft SQL Server 2005 Backward compatibility
Microsoft SQL Server 2008
Microsoft SQL Server 2008 Books Online
Microsoft SQL Server 2008 Browser
Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Setup Support Files (English)
Microsoft SQL Server Compact 3.5 SP1 Beta ENU
Microsoft SQL Server Compact 3.5 SP1 Beta Management Tools
Microsoft SQL Server VSS Writer
Microsoft Visual Studio 2005 Premier Partner Edition - ENU
Microsoft Visual Studio 2005 Tools for Applications - ENU
SQLXML4

24-Jun-08 04:05 PM

Any ideas why I sould be getting the error that it thinks 2005 workstation
components are installed if the programs below are all that is installed?

24-Jun-08 04:39 PM

I have not seen a scenario such as I'll tell you right now, but somehow this
might happened to you.

When you open Programs and Features in CP, click on the Microsoft SQL Server
2008 and click Remove button. "Select Instance" window will appear. There,
you'll see installed components. Is there a "<Shared Component>" item in the
Component item?

I'm not even sure if 9.x components would be listed there... Just a
suggestion.

--
Ekrem Önsoy

24-Jun-08 04:50 PM

There is a <Shared Components > listed there, but the version is
10.0.1075.23.  I did hit next, and the option to remove the client tools was
available.  I unselect the Client tools so that it will uninstall.  However,
during the uninstall process, it gets skipped, and I get the following
information from the log:

Product features discovered:
Product:                       SQL2005

Product:                       SQL2008
Instance:                      MSSQLSERVER
Product Version:               10.0.1075.23

Feature                        Edition              Language
SQLEngine                      Developer Edition    1033
SQLEngine\DataFiles            Developer Edition    1033
SQLEngine\FullText             Developer Edition    1033
SQLEngine\SharedTools          Developer Edition    1033
AS                             Developer Edition    1033
RS                             Developer Edition    1033
Instance:                      SQLEXPRESS
Product Version:               10.0.1075.23

Feature                        Edition              Language
SQLEngine                      Express Edition      1033
SQLEngine\DataFiles            Express Edition      1033
SQLEngine\SharedTools          Express Edition      1033

Feature status after execution:
Client Tools: Skipped

As you can see, it still thinks something for 2005 is installed.

24-Jun-08 05:37 PM

Messages below makes me think a SQL Server 2005 instance might be still be
installed with Client Tools on your system.

As far as I can see (from the message below) there are two instances of SQL
Server 2008 installed on your system. One of them is Developer Edition and
the other one is an Express Edition. Apart from these, there seems there is
a SQL Server 2005 instance installed. This could be a reason of an
incomplete uninstallation or something.

Do you have a "Microsoft SQL Server 2005" item on your Start\Programs list?
If so, what items are there under that menu item? Configuration Tools,
Performance Tools etc.?

And can you open Services MMC (Start\Run = services.msc) and ensure there is
no any other SQL Server services except for your Developer and Express
Editions of SQL Server 2008?

If you are sure there is no any SQL Server 2005 services, then I can suggest
you to download Windows Installer Cleanup Utility and run it to clear all
unnecessary SQL Server 2005 installation related items using it. You can
download this utility using the following link:
http://support.microsoft.com/kb/290301/

--
Ekrem Önsoy

25-Jun-08 01:13 PM

Well, I'm out of idea why SQL Server 2008 Setup thinks that SQL Server 2005
Client Tools are installed even though they are not. Sorry.

Unless applying a special patch, you can't connect to your SQL Server 2008
instances using SQL Server 2005' s SSMS.

See the following KB about this issue:
http://support.microsoft.com/default.aspx/kb/946127

Also, you can download and apply Cumulative Update 8 (Which is the lastest
one) which includes this patch I believe.
http://support.microsoft.com/default.aspx/kb/951217/

--
Ekrem Önsoy