RE: Installing SQL Server Personal Edition

Hi vivaldi ,

I’m afraid it’s not possible to install either the SQL Server standard or
professional edition or your XP desktop.

Only de SQL server desktop engine or the SQL Server Developer edition can be
installed on an XP laptop.

The SQL Server Developer is available through MSDN subscriber downloads but
this does require and MSDN subscription. If you don’t have one you might want
to take a look at the SQL Server Desktop Engine. This one is available as a
free download from Microsoft but it is severely limited and comes without any
GUI and tools (such as the SQL Server enterprise manager, Query analyser
etc). You can however connect to a SQL Server desktop Engine using an
existing enterprise manager installation.

So if you already have the client tools installed for managing a different
SQL server and you only need basic SQL Server functionality you might want to
check out the Desktop engine.

(But I really recommend that you use the SQL Server developer edition, it’s
really that much more complete.

P.s also note that you are not allowed to install the SQL Server client
tools just for the purpose of using them to manage a desktop engine.

I hope this info helps,

Kind regards,

Leon Krancher
Avanade

The information contained in this posting depicts my own opinion and/or
experience I'm not speaking for my employer and no rights may be derived from
this posting

"vivaldi" wrote:

> I have Windows Small Business Server 2003 Premium Edition and want to install
> the SQL Server Personal Edition on a laptop running XP. The install only
> allows me to install client components. Any ideas of how I can install SQL
> Server on the XP laptop?
.

Relevant Pages

  • Re: SQL Server Native Client is not supported on the current proce
    ... I unselect the Client tools so that it will uninstall. ... When you open Programs and Features in CP, click on the Microsoft SQL Server ... either install SQL Server 2008 Client Components on a different ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL Server 2005 Express OLEDB Connection from VB6
    ... Thanks for getting me to read this again and realizing they meant the client ... I think we'll stick with ODBC, since there is less to install on the client ... Microsoft SQL Server Native Client ...
    (microsoft.public.sqlserver.connect)
  • RE: windows update error SBS2003
    ... Critical Update for SQL Server 2000 Desktop Engine on Windows ... "adaniel" wrote: ... > events when Windows Update tries to install an update for SBS2003. ...
    (microsoft.public.windows.server.sbs)
  • MSDE 2000 SP4 install gets to very end then rolls it all back
    ... On most machines my msde install goes fine. ... exuisting SQL server. ... Starting custom action SaveSqlServerServiceStates() ... Action start 14:23:53: RegisterClassInfo. ...
    (microsoft.public.sqlserver.setup)
  • Re: SBS 2003 and Sql Server ~ Client Install
    ... What are you trying to install on the client? ... We've decided to see what benefits Sql Server might offer us. ... We've input the key that came with the SBS installation disk ...
    (microsoft.public.backoffice.smallbiz2000)