SQL Server Native Client is not supported on the current processor

Discussion:

(too old to reply)

soccerwiz13

2008-06-15 23:53:00 UTC

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?

soccerwiz13

2008-06-15 23:55:01 UTC

Permalink

I meant SQL Server 2005.

Post by soccerwiz13
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?

Aaron Bertrand [SQL Server MVP]

2008-06-16 03:50:28 UTC

Permalink

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

Post by soccerwiz13
I meant SQL Server 2005.

soccerwiz13

2008-06-16 18:24:01 UTC

Permalink

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?

Post by Aaron Bertrand [SQL Server MVP]
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
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
will contain X86, otherwise X64.
A
On 6/15/08 7:55 PM, in article

Post by soccerwiz13
I meant SQL Server 2005.

Aaron Bertrand [SQL Server MVP]

2008-06-16 19:06:07 UTC

Permalink

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL 2005 was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

Post by soccerwiz13
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?

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.

soccerwiz13

2008-06-16 19:36:00 UTC

Permalink

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?

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL 2005 was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

soccerwiz13

2008-06-19 07:48:00 UTC

Permalink

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?

Post by soccerwiz13
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
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?

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL 2005 was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

Ekrem Önsoy

2008-06-19 08:34:32 UTC

Permalink

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

Post by soccerwiz13
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?

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL 2005 was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

soccerwiz13

2008-06-19 17:37:01 UTC

Permalink

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

Post by Ekrem Ãnsoy
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

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL 2005 was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

soccerwiz13

2008-06-24 20:05:03 UTC

Permalink

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?

Post by soccerwiz13
I have the following programs installed on the machine, according to the
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

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL 2005 was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

Post by soccerwiz13
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?

Ekrem Önsoy

2008-06-24 20:39:52 UTC

Permalink

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
"Installed Instances" list? If so, what's the version of that Shared
Component item?

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

Post by soccerwiz13
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?

Post by soccerwiz13
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?

Post by soccerwiz13
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
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?

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL
2005
was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

Post by soccerwiz13
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?

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.

soccerwiz13

2008-06-24 20:50:01 UTC

Permalink

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.

Post by Ekrem Ãnsoy
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
"Installed Instances" list? If so, what's the version of that Shared
Component item?
I'm not even sure if 9.x components would be listed there... Just a
suggestion.
--
Ekrem Önsoy

Post by soccerwiz13
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?

Post by soccerwiz13
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?

Post by soccerwiz13
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
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?

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL
2005
was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

Post by soccerwiz13
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?

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.

Ekrem Önsoy

2008-06-24 21:37:10 UTC

Permalink

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

Post by soccerwiz13
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
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
Client Tools: Skipped
As you can see, it still thinks something for 2005 is installed.

Post by soccerwiz13
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?

Post by soccerwiz13
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?

Post by soccerwiz13
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
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?

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL
2005
was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

Post by soccerwiz13
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?

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.

soccerwiz13

2008-06-25 16:26:00 UTC

Permalink

I checked using SQL configuration manager 2008. I have the developer edition
and the express eidition, plus SQL Server Analysis Services (MSSQLSERVER) and
SQL Server Agent which is not running (MSSQLSERVER).

I do not have Microsoft SQL Server in my start menu list.

I opened services and there are no SQL 2005 services.

I installed the Windows Installer Cleanup and found no SQL with Version 9.
The SQL 2005 backward compatability tools have version 8.x.xxx, but I'm
pretty sure that was installed with SQL 2008.

I decided to reinstall the SQL 2005 tools and they try to uninstall them
again. I installed SQL Server 2005 Client tools and it installed properly.
However, it did not show my 2008 instances when I tried to connect to the
database in SQL Server Manager. I enable Named Pipes on both my SQLEXPRESS
instance and my MSSQLSERVER instance, and was still unable to connect to any
2008 instance. Is there a compatibility issue there?

I then unstalled the SQL 2005 client tools so we could have a clean
uninstall. I ran the 2008 Client tools and am still getting the same error
message.

Help, I'm lost! I don't care if I have 2008 or 2005 tools installed, but
neither seem to be working properly in my environment.

Post by Ekrem Ãnsoy
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
http://support.microsoft.com/kb/290301/
--
Ekrem Önsoy

Post by soccerwiz13
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?

Post by soccerwiz13
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?

Post by soccerwiz13
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
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?

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of SQL
2005
was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both Program
Files (x86) and Program Files.

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?

Post by soccerwiz13
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?

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.

Ekrem Önsoy

2008-06-25 17:13:57 UTC

Permalink

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

Post by soccerwiz13
I checked using SQL configuration manager 2008. I have the developer edition
and the express eidition, plus SQL Server Analysis Services (MSSQLSERVER) and
SQL Server Agent which is not running (MSSQLSERVER).
I do not have Microsoft SQL Server in my start menu list.
I opened services and there are no SQL 2005 services.
I installed the Windows Installer Cleanup and found no SQL with Version 9.
The SQL 2005 backward compatability tools have version 8.x.xxx, but I'm
pretty sure that was installed with SQL 2008.
I decided to reinstall the SQL 2005 tools and they try to uninstall them
again. I installed SQL Server 2005 Client tools and it installed properly.
However, it did not show my 2008 instances when I tried to connect to the
database in SQL Server Manager. I enable Named Pipes on both my SQLEXPRESS
instance and my MSSQLSERVER instance, and was still unable to connect to any
2008 instance. Is there a compatibility issue there?
I then unstalled the SQL 2005 client tools so we could have a clean
uninstall. I ran the 2008 Client tools and am still getting the same error
message.
Help, I'm lost! I don't care if I have 2008 or 2005 tools installed, but
neither seem to be working properly in my environment.

Post by soccerwiz13
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
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
Client Tools: Skipped
As you can see, it still thinks something for 2005 is installed.

Post by Ekrem Ãnsoy
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
"Installed Instances" list? If so, what's the version of that Shared
Component item?
I'm not even sure if 9.x components would be listed there... Just a
suggestion.
--
Ekrem Önsoy

Post by soccerwiz13
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?

Post by soccerwiz13
I have the following programs installed on the machine, according
to
the
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

Post by Ekrem Ãnsoy
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

Post by soccerwiz13
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?

Post by soccerwiz13
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
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?

Post by Aaron Bertrand [SQL Server MVP]

Post by soccerwiz13
I did install SQL Server + components, but no instance of
SQL
2005
was
installed.

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

Post by soccerwiz13
I looked in my program files and I have files in both
Program
Files (x86) and Program Files.

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?

Post by soccerwiz13
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?

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.