Cannot register a local instance

I have SQL Server 2000 installed, client tools only. I can
access the SQL Server on my network and various remote SQL
boxes but I cannot register a local instance.
I keep getting the "SQL Server does not exist or access
denied error message".
Any advice?If you have only the client tools installed locally, you won't be able to
connect to a local instance because there's no local instance. You need to
install the actual engine to be able to connect locally. However, if you
have sql installed locally and you can't connect, make sure the service is
running. You can check this out in the services applet in administrative
tools.
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Rich" <anonymous@.discussions.microsoft.com> wrote in message
news:67db01c3e422$2409f840$7d02280a@.phx.gbl...

quote:

---

> I have SQL Server 2000 installed, client tools only. I can
> access the SQL Server on my network and various remote SQL
> boxes but I cannot register a local instance.
> I keep getting the "SQL Server does not exist or access
> denied error message".
> Any advice?

---

|||Thanks for that.
I have run a local instance of SQL server on a stand alone
machine in the past, SQL 7 was also installed though.
I need to be able to use SQL server offline at home on my
laptop. Any suggestions?
No SQL services apparently running locally.

quote:

---

>--Original Message--
>If you have only the client tools installed locally, you

---

won't be able to

quote:

---

>connect to a local instance because there's no local

---

instance. You need to

quote:

---

>install the actual engine to be able to connect locally.

---

However, if you

quote:

---

>have sql installed locally and you can't connect, make

---

sure the service is

quote:

---

>running. You can check this out in the services applet in

---

administrative

quote:

---

>tools.
>--
>Carlos E. Rojas
>SQL Server MVP
>Co-Author SQL Server 2000 programming by Example
>
>"Rich" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:67db01c3e422$2409f840$7d02280a@.phx.gbl...
can[QUOTE]
SQL[QUOTE]
>
>.
>

---

|||What version of windows are you running? You could try sql 2000 desktop
edition or developer edition. You can find more info on
www.microsoft.com/sql
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
<anonymous@.discussions.microsoft.com> wrote in message
news:490501c3e42a$7e056cf0$a501280a@.phx.gbl...[QUOTE]
> Thanks for that.
> I have run a local instance of SQL server on a stand alone
> machine in the past, SQL 7 was also installed though.
> I need to be able to use SQL server offline at home on my
> laptop. Any suggestions?
> No SQL services apparently running locally.
> won't be able to
> instance. You need to
> However, if you
> sure the service is
> administrative
> message
> can
> SQL|||Windows 2000 Professional SP3, that is why I could only
install client tools. Desktop edition still cannot find a
local instance to install from.
SQL server 7 would allow a local instance even when not
installed on a server. There must be a way to run an
offline/stand alone version of SQL Server 2000?

quote:

---

>--Original Message--
>What version of windows are you running? You could try

---

sql 2000 desktop

quote:

---

>edition or developer edition. You can find more info on
>www.microsoft.com/sql
>--
>Carlos E. Rojas
>SQL Server MVP
>Co-Author SQL Server 2000 programming by Example
>
><anonymous@.discussions.microsoft.com> wrote in message
>news:490501c3e42a$7e056cf0$a501280a@.phx.gbl...
alone[QUOTE]
my[QUOTE]
you[QUOTE]
locally.[QUOTE]
in[QUOTE]
I[QUOTE]
remote[QUOTE]
access[QUOTE]
>
>.
>

---

|||MSDE (desktop edition), personal edition, or developer edition should
install on a non-server edition of Windows. If you're getting an error
installing SQL Server you can post the exact error and sqlstp.log to the
setup newsgroup. If you're installing MSDE there is a slipstreamed version
that includes SP3, otherwise install the RTM version then immediately apply
SP3. Then apply the latest security rollup for SQL Server.
122352 INF: Supported Windows Versions for SQL Server
http://support.microsoft.com/?id=122352
SQL Server 2000 Evaluation Edition and Developer Edition can run on the
following operating systems:
Operating systems listed above for Enterprise and Standard Editions
Windows XP Professional
Windows XP Home Edition
Windows 2000 Professional
Windows NT Workstation 4.0 with SP5 or later
SQL Server 2000 Personal Edition and SQL Server 2000 Desktop Engine (MSDE)
can run on the following operating systems:
Operating systems listed above for Enterprise, Standard, Evaluation, and
Developer Editions
Windows Server 2003, Web Edition1 (MSDE only)
Windows 98
Windows Millennium Edition (Windows Me)
Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.