Re: SQL Server Native Client is not supported on the current proce



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



"soccerwiz13" <soccerwiz13@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1A5DEAFB-0A25-4185-941D-E96731B869A1@xxxxxxxxxxxxxxxx
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.

"Ekrem Önsoy" wrote:

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



"soccerwiz13" <soccerwiz13@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:B9CC43DD-4162-45EE-9342-F5A502A77BFB@xxxxxxxxxxxxxxxx
> 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?
>
> "soccerwiz13" wrote:
>
>> 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
>>
>> "Ekrem Önsoy" wrote:
>>
>> > 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
>> >
>> >
>> >
>> > "soccerwiz13" <soccerwiz13@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in >> > message
>> > news:9AF2C177-3C04-42A4-9C02-02F3554A1FEB@xxxxxxxxxxxxxxxx
>> > > 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?
>> > >
>> > > "soccerwiz13" wrote:
>> > >
>> > >> 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?
>> > >>
>> > >> "Aaron Bertrand [SQL Server MVP]" wrote:
>> > >>
>> > >> >
>> > >> > > 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"?
>> > >> >
>> > >> > > 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?
>> > >> >
>> > >> > > 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.
>> > >> >
>> > >> >
>> >


.