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

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



"soccerwiz13" <soccerwiz13@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:7DC1AC5F-8700-444F-8593-06D6D1AA0967@xxxxxxxxxxxxxxxx
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.

"Ekrem Önsoy" wrote:

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


.