> I have a problem with installation of sqlserver 2000.
> I have a pc at home, my pc is not in a network. The
> operative system installed is windows xp professional.
> When I try to install sqlserver I receive the following
> message: " sqlserver 2000 enterprise edition component is
> not supported in this operative system. You can install
> only client components"; so I install only client
> components.

> I must use Query Analizer, but when I try to connect to
> my computer (local server) I get this error message: "
> Unable to connect to server (my pc) Msg 17, level 16,
> [Microsoft][odbc sqlserver driver][Shared Memory]
> sqlserver does not exist or access denied".
> I cannot change system operative and I must use Query
> Analizer. How can I do? Please help me!

"Giulia" <giulia74z@libero.it> wrote in message
news:050701c3cadd$dca77110$a101280a@phx.gbl...
> I have a problem with installation of sqlserver 2000.
> I have a pc at home, my pc is not in a network. The
> operative system installed is windows xp professional.
> When I try to install sqlserver I receive the following
> message: " sqlserver 2000 enterprise edition component is
> not supported in this operative system. You can install
> only client components"; so I install only client
> components.
>
> I must use Query Analizer, but when I try to connect to
> my computer (local server) I get this error message: "
> Unable to connect to server (my pc) Msg 17, level 16,
> [Microsoft][odbc sqlserver driver][Shared Memory]
> sqlserver does not exist or access denied".
> I cannot change system operative and I must use Query
> Analizer. How can I do? Please help me!
>

>-----Original Message-----
>Giulia (giulia74z@libero.it) writes:
>> I have a problem with installation of sqlserver 2000.
>> I have a pc at home, my pc is not in a network. The
>> operative system installed is windows xp professional.
>> When I try to install sqlserver I receive the
following
>> message: " sqlserver 2000 enterprise edition component
is
>> not supported in this operative system. You can
install
>> only client components"; so I install only client
>> components.
>
>This is because on Windows XP you can only install
Deverloper Edition,
>Personal Edition, Evaulation Edition and MSDE. You
cannot install
>Standard Edition and Enterprise Edition. These two
edition require
>a server operating system.
>
>> I must use Query Analizer, but when I try to connect
to
>> my computer (local server) I get this error message: "
>> Unable to connect to server (my pc) Msg 17, level 16,
>> [Microsoft][odbc sqlserver driver][Shared Memory]
>> sqlserver does not exist or access denied".
>> I cannot change system operative and I must use Query
>> Analizer. How can I do? Please help me!
>
>Since you did not install server components, there is no
local server
>to connect to. So either you need to connect to network
where there
>is an SQL Server available, install an edition of SQL
Server that
>runs on XP.
>
>
>--
>Erland Sommarskog, SQL Server MVP, sommar@algonet.se
>
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techinfo/productdoc/2000/boo
ks.asp
>.