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!Hi,
Since you have not installed a SQL server , you can not connect Query
Analyser with out having access to a server.
In Windows XP try installing SQL 2K Personal Edition.
Thanks
Hari
MCDBA
"Giulia" <giulia74z@.libero.it> wrote in message
news:050701c3cadd$dca77110$a101280a@.phx.gbl...
quote:|||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.
> 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!
>
quote:
> 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.
quote:
> 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/techin.../2000/books.asp|||Thank you for help!
I installed MSDE from Office 2000 and client components
of sqlserver 2000.
Then I started sql server service manager, in this way I
can connect to local server from Query Analizer!
thank you another
quote:
>--Original Message--
>Giulia (giulia74z@.libero.it) writes:
following[QUOTE]
is[QUOTE]
install[QUOTE]
>This is because on Windows XP you can only install
Deverloper Edition,
quote:
>Personal Edition, Evaulation Edition and MSDE. You
cannot install
quote:
>Standard Edition and Enterprise Edition. These two
edition require
quote:
>a server operating system.
>
to[QUOTE]
>Since you did not install server components, there is no
local server
quote:
>to connect to. So either you need to connect to network
where there
quote:
>is an SQL Server available, install an edition of SQL
Server that
quote:
>runs on XP.
>
>--
>Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
>Books Online for SQL Server SP3 at
>http://www.microsoft.com/sql/techin...uctdoc/2000/boo
ks.asp
quote:|||Thank you for help!
>.
>
I installed MSDE from Office 2000 and client components
of sqlserver 2000.
Then I started sql server service manager, in this way I
can connect to local server from Query Analizer!
quote:
>--Original Message--
>Hi,
>Since you have not installed a SQL server , you can not
connect Query
quote:
>Analyser with out having access to a server.
>In Windows XP try installing SQL 2K Personal Edition.
>Thanks
>Hari
>MCDBA
>"Giulia" <giulia74z@.libero.it> wrote in message
>news:050701c3cadd$dca77110$a101280a@.phx.gbl...
is[QUOTE]
>
>.
>
No comments:
Post a Comment