Prior to installing any SP3a service packs:
VERSION:
Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
RTM
After installing sql2ksp3 and sql2kasp3 I get:
VERSION:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
NT 5.1 (Build 2600: Service Pack 1)
SERVERPROPERTY:
SP3
I am having difficulty installing sql2kdesksp3 and was wondering if I was
trying to install it where it is not required?
I have an MSDN copy of SQL Server 2000 Developer Edition.No. It appears that you have the Developer Edition of SQL Server 2000 and
did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp. A
little ways down that page it describes what each of the three files are.
--
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"DesC" <xs667@.hotmail.com> wrote in message
news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> Prior to installing any SP3a service packs:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> RTM
>
> After installing sql2ksp3 and sql2kasp3 I get:
> VERSION:
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on Windows
> NT 5.1 (Build 2600: Service Pack 1)
> SERVERPROPERTY:
> SP3
>
> I am having difficulty installing sql2kdesksp3 and was wondering if I
was
> trying to install it where it is not required?
> I have an MSDN copy of SQL Server 2000 Developer Edition.
>
>
>|||How then can you tell conclusively exactly what you have, i.e. SQL Server
2000 or MSDE 2000 ?
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> No. It appears that you have the Developer Edition of SQL Server 2000 and
> did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be running
> MSDE. Have a look at http://www.microsoft.com/sql/downloads/2000/sp3.asp.
A
> little ways down that page it describes what each of the three files are.
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "DesC" <xs667@.hotmail.com> wrote in message
> news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> > Prior to installing any SP3a service packs:
> >
> > VERSION:
> > Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> > Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
Windows
> > NT 5.1 (Build 2600: Service Pack 1)
> >
> > SERVERPROPERTY:
> > RTM
> >
> >
> > After installing sql2ksp3 and sql2kasp3 I get:
> >
> > VERSION:
> > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
Windows
> > NT 5.1 (Build 2600: Service Pack 1)
> >
> > SERVERPROPERTY:
> > SP3
> >
> >
> > I am having difficulty installing sql2kdesksp3 and was wondering if I
> was
> > trying to install it where it is not required?
> >
> > I have an MSDN copy of SQL Server 2000 Developer Edition.
> >
> >
> >
> >
> >
> >
>|||> After installing sql2ksp3 and sql2kasp3 I get:
Do you really have Analysis Services running? That's what sql2kasp3.exe is
for.
> I am having difficulty installing sql2kdesksp3
Probably because you don't need it. This file is for MSDE (desktop
edition).
Please read http://www.aspfaq.com/2440
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Steve could tell because your @.@.VERSION returned "Developer Edition" in the
text.
If you have more than one installation of SQL Server, you will need to
repeat this process for every instance. Only you know how many instances
you have installed, but the SP3 page has information, I think, on
determining where your other instances live.
Also see http://www.aspfaq.com/2160
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"DesC" <xs667@.hotmail.com> wrote in message
news:OrMYKOsMEHA.268@.TK2MSFTNGP11.phx.gbl...
> How then can you tell conclusively exactly what you have, i.e. SQL Server
> 2000 or MSDE 2000 ?
>
>
> "Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
> news:%23ppi8IsMEHA.2388@.TK2MSFTNGP09.phx.gbl...
> > No. It appears that you have the Developer Edition of SQL Server 2000
and
> > did upgrade it to SP3. Sql2kdesksp3.exe is the update for Microsoft SQL
> > Server 2000 Desktop Engine (MSDE 2000) and you don't appear to be
running
> > MSDE. Have a look at
http://www.microsoft.com/sql/downloads/2000/sp3.asp.
> A
> > little ways down that page it describes what each of the three files
are.
> >
> > --
> > Sincerely,
> > Stephen Dybing
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "DesC" <xs667@.hotmail.com> wrote in message
> > news:%23yKB99rMEHA.128@.TK2MSFTNGP09.phx.gbl...
> > > Prior to installing any SP3a service packs:
> > >
> > > VERSION:
> > > Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48
> > > Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on
> Windows
> > > NT 5.1 (Build 2600: Service Pack 1)
> > >
> > > SERVERPROPERTY:
> > > RTM
> > >
> > >
> > > After installing sql2ksp3 and sql2kasp3 I get:
> > >
> > > VERSION:
> > > Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> > > Copyright (c) 1988-2003 Microsoft Corporation Developer Edition on
> Windows
> > > NT 5.1 (Build 2600: Service Pack 1)
> > >
> > > SERVERPROPERTY:
> > > SP3
> > >
> > >
> > > I am having difficulty installing sql2kdesksp3 and was wondering if
I
> > was
> > > trying to install it where it is not required?
> > >
> > > I have an MSDN copy of SQL Server 2000 Developer Edition.
> > >
> > >
> > >
> > >
> > >
> > >
> >
> >
>|||Sql2kdesksp3 is for the Desktop Edition of SQL Server 2000. It appears
that you have the Developer Edition. These are not the same thing. You
already have service pack 3 (or 3a) on the SQL Server you posted the
@.@.version information from. If this is the one you are attempting to apply
sql2kdesksp3 to then it will not apply and if it did you probably do not
need it.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||You can also check your machine and/or network for all SQL Server instances
that are running. See the following URL (it may wrap):
http://www.microsoft.com/downloads/details.aspx?FamilyId=9552D43B-04EB-4AF9-9E24-6CDE4D933600&displaylang=en|||Do you really have Analysis Services running?
Yes, I hope so anyrate, something wrong?
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:%23xFJjOsMEHA.3348@.TK2MSFTNGP09.phx.gbl...
> > After installing sql2ksp3 and sql2kasp3 I get:
> Do you really have Analysis Services running? That's what sql2kasp3.exe
is
> for.
> > I am having difficulty installing sql2kdesksp3
> Probably because you don't need it. This file is for MSDE (desktop
> edition).
> Please read http://www.aspfaq.com/2440
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||> Yes, I hope so anyrate
Are you sure you know the difference between SQL Server and Analysis
Services? I think if you had any use for Analysis Services, you'd know
whether or not it was installed, instead of "I hope so"...|||Well, I had an idea I was going to use DTS to pump data into a data
warehouse consisting of data-marts, data tables and dimension tables and
then extract static and dynamic cubes using Analysis Services (or OLAP as I
think it used to be called). I might be all wrong about this but one of my
contracts was for a major UK supermarket chain that produced a lot of data
and I figure larning how to do this kind of thing might be useful.
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OG9uussMEHA.1348@.TK2MSFTNGP12.phx.gbl...
> > Yes, I hope so anyrate
> Are you sure you know the difference between SQL Server and Analysis
> Services? I think if you had any use for Analysis Services, you'd know
> whether or not it was installed, instead of "I hope so"...
>|||> Well, I had an idea I was going to use DTS to pump data into a data
> warehouse consisting of data-marts, data tables and dimension tables and
> then extract static and dynamic cubes using Analysis Services (or OLAP as
I
> think it used to be called). I might be all wrong about this but one of
my
> contracts was for a major UK supermarket chain that produced a lot of data
> and I figure larning how to do this kind of thing might be useful.
My original question was "do you have analysis services running?" to which
you said "I hope so."
I'm not questioning whether or not you think you can make use of Analysis
Services.
I'm questioning whether you should have even considered installing
sql2kasp3.exe.
A
bobbins wrote:
