Case Statement Within A Select Where 2 or More Instances Of The Record Exist.

Ok,
I have a data warehouse that I am pulling records from using Oracle
SQL. I have a select statement that looks like the one below. Now what
I need to do is where the astrics are **** create a case statement or
whatever it is in Oracle to say that for this record if a 1/19/2005
record exists then End_Date needs to be=1/19/2005 else get
End_Date=12/31/9999. Keep in mind that a record could have both a
1/19/2005 and 12/31/9999 instance of that account record. If 1/19
exists that takes presedent if it doesnt then 12/31/9999. The problem
is that the fields I pull from the table where the end_date is in
question change based on which date I pull(12/31/9999 being the most
recient which in some cases as you see I dont want.) so they are not
identical. This is tricky.
Please let me know if you can help.

SELECT
COLLECTOR_RESULTS.USER_ID,
COLLECTOR_RESULTS.LETTER_CODE,
COLLECTOR_RESULTS.ACCT_NUM AS ACCT_NUM,
COLLECTOR_RESULTS.ACTIVITY_DATE,
COLLECTOR_RESULTS.BEGIN_DATE,
COLLECTOR_RESULTS.COLLECTION_ACTIVITY_CODE,
COLLECTOR_RESULTS.PLACE_CALLED,
COLLECTOR_RESULTS.PARTY_CONTACTED_CODE,
COLLECTOR_RESULTS.ORIG_FUNC_AREA,
COLLECTOR_RESULTS.ORIG_STATE_NUMBER,
COLLECTOR_RESULTS.CACS_FUNCTION_CODE,
COLLECTOR_RESULTS.CACS_STATE_NUMBER,
COLLECTOR_RESULTS.STATE_POSITION,
COLLECTOR_RESULTS.TIME_OBTAINED,
COLLECTOR_RESULTS.TIME_RELEASED,
COLLECT_ACCT_SYS_DATA.DAYS_DELINQUENT_NUM,
sum(WMB.COLLECT_ACCT_SYS_DATA.PRINCIPAL_AMT)As PBal,
FROM
COLLECTOR_RESULTS,
COLLECT_ACCT_SYS_DATA,
COLLECT_ACCOUNT
WHERE
COLLECT_ACCOUNT.ACCT_NUM=COLLECT_ACCT_SYS_DATA.ACC T_NUM(+)
AND
COLLECT_ACCOUNT.LOCATION_CODE=COLLECT_ACCT_SYS_DAT A.LOCATION_CODE(+)
AND COLLECT_ACCOUNT.ACCT_NUM=COLLECTOR_RESULTS.ACCT_NU M(+)
AND COLLECT_ACCOUNT.LOCATION_CODE=COLLECTOR_RESULTS.LO CATION_CODE(+)
AND COLLECTOR_RESULTS.ACTIVITY_DATE =
to_date(''01/19/2005'',''mm/dd/yyyy'')
AND COLLECT_ACCOUNT.END_DATE = to_date(''12/31/9999'',''mm/dd/yyyy'')
AND COLLECT_ACCT_SYS_DATA.END_DATE = *****************On 20 Jan 2005 11:13:31 -0800, philipdm@.msn.com wrote:

>Ok,
>I have a data warehouse that I am pulling records from using Oracle
>SQL.

Hi philipdm,

You posted this question in a newsgroup for MS SQL Server. I doubt you'll
get any specific Oracle help here.

But if I understand your requirements correctly, I think you can solve it
using only ANSI-standard SQL: correlated subquery, group by and aggregate
functions. I assume Oracle will have no trouble running those! I'm not
sure if the NULL handling requires sppecial attention (see notes down
below).

First, let me check if I correctly understand your requirements:

> Keep in mind that a record could have both a
>1/19/2005 and 12/31/9999 instance of that account record. If 1/19
>exists that takes presedent if it doesnt then 12/31/9999.

The way I read this is: check collect_acct_sys_data for a particular
acct_num / location_code combinations. If there's a row for 1/19/2005, use
that. If there's a row for 12/31/9999 but no row for 1/19/2005, use the
12/31/9999 row. If there's no row for 1/19/2005 and no row for 12/31/9999,
use no row at all - the join will fail and the rows for the other tables
that use this acct_num / location_code combination won't be included in
the result set either.

I'd use something like the following. Note: I've used table aliasses and
converted the table and column names to lower case to improve readability;
I kept the (+) symbols you included and didn't change the format of the
to_date function calls - neither of these are known in MS SQL Server, so I
have no idea if they're right or wrong.

SELECT CR.User_ID,
... (lots of other columns)
FROM Collector_Results AS CR,
Collector_Acct_Sys_Date AS CASD,
Collect_Account AS CA
WHERE CA.Acct_Num = CASD.Acct_Num(+)
AND CA.Location_Code = CASD.Location_Code(+)
AND CA.Acct_Num = CR.Acct_Num(+)
AND CA.Location_Code = CR.Location_Code(+)
AND CR.Activity_Date = to_date(''01/19/2005'',''mm/dd/yyyy'')
AND CA.End_Date = to_date(''12/31/9999'',''mm/dd/yyyy'')
AND CASD.End_Date =
(SELECT MIN(CASD2.End_Date)
FROM Collector_Acct_Sys_Date AS CASD2
WHERE CASD2.Acct_Num = CASD.Acct_Num(+)-- Do you need the
(+) here?
AND CASD2.Location_Code = CASD.Location_Code(+)-- Do you
need the (+) here?
AND ( CASD2.End_Date = to_date(''01/19/2005'',''mm/dd/yyyy'')
OR CASD2.End_Date = to_date(''12/31/9999'',''mm/dd/yyyy'')))

Final note: if the possibility exists that no row in CASD for a given
acct_num / location_code with either of the two dates, the subquery should
return NULL; the clause "AND CASD.End_Date = (subquery)" will evaluate to
"AND CASD.End_Date = NULL", which should not be true for any value of
CASD.End_Date (not even if CASD.End_Date is NULL!!). This is how NULLS
should be treated according to ANSI standard. If Oracle treats the result
of an empty subquery or comparison to NULL differently, then you should
tweak the query to get the correct results.

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)sql

Can't update default instance of SQL 2000 to SP4. Not recognized.

I have a SQL server 2000 server with two instances running. One the
default, one named.
I tried to upgrade the server to SP4, and I was prompted to choose
which instance to upgrade. I chose the default.
SP4 refused to upgrade the default instance with this message:
"MSSQLSERVER is not a SQL Server 2000 instance."
Stranger, it had no problems upgrading the named instance.
I can't find anything about this in the MSKB and I'm a bit of a babe
in the wood when it comes to SQL Server.
The default instance runs our new accounting server, so 'd sure like
to get it up to date. Thanks for any ideas.
Jim Helfer
Computer Systems Administrator
WTW Architects
Timber Court
127 Andesron St.
Pittsburgh PA 15212
412-321-0551 x330
jhelfer@.wtwarch.comJim
Can put in here a result of @.@.VERSION from both instances?
"Jim Helfer" <JimHelfer@.newsgroup.nospam> wrote in message
news:OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl...
> I have a SQL server 2000 server with two instances running. One the
> default, one named.
> I tried to upgrade the server to SP4, and I was prompted to choose which
> instance to upgrade. I chose the default.
> SP4 refused to upgrade the default instance with this message:
> "MSSQLSERVER is not a SQL Server 2000 instance."
> Stranger, it had no problems upgrading the named instance.
> I can't find anything about this in the MSKB and I'm a bit of a babe in
> the wood when it comes to SQL Server.
> The default instance runs our new accounting server, so 'd sure like to
> get it up to date. Thanks for any ideas.
>
> --
> Jim Helfer
> Computer Systems Administrator
> WTW Architects
> Timber Court
> 127 Andesron St.
> Pittsburgh PA 15212
> 412-321-0551 x330
> jhelfer@.wtwarch.com|||Dear Jim,
Thank you for posting here.
From the problem description of the post you submitted, my understanding
is: When attempting to apply the SQL Server 2000 Service Pack 4 to the
default instance, the error message saying "MSSQLSERVER is not a SQL
Server 2000 instance" is received. However, we are able to successfully
apply the Service Pack 4 update onto the named instance. If I have
misunderstood about your concern, feel free to let me know.
Based on the current status, I would like to confirm whether your SQL
Server default instance is installed by MSDE components of SQL Server 2000.
If so, we can conclude that we need the MSDE specific Service Pack 4.
You may use the below link for the download the file
"SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download link:
Microsoft SQL Server 2000 Service Pack 4
http://www.microsoft.com/downloads/...fc8d-c20e-4446-
99a9-b7f0213f8bc5&DisplayLang=en
"
NOTE: To determine whether the version is Desktop Engine, we can use the
command "select @.@.version" to manually check the SQL version.
If the issue still persists, please help me to collect the following log
file to me at v-adamqu@.microsoft.com
%windir%\sqlsp.log
If anything is unclear in my post, please don't hesitate to let me know and
I will be glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Date: Wed, 27 Jun 2007 19:43:26 -0400
| From: Jim Helfer <JimHelfer@.newsgroup.nospam>
| User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| MIME-Version: 1.0
| Subject: Can't update default instance of SQL 2000 to SP4. Not recognized.
| Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| Content-Transfer-Encoding: 7bit
| Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: wtwarch.com 66.212.142.243
| Lines: 1
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have a SQL server 2000 server with two instances running. One the
| default, one named.
|
| I tried to upgrade the server to SP4, and I was prompted to choose
| which instance to upgrade. I chose the default.
|
| SP4 refused to upgrade the default instance with this message:
|
| "MSSQLSERVER is not a SQL Server 2000 instance."
|
| Stranger, it had no problems upgrading the named instance.
|
| I can't find anything about this in the MSKB and I'm a bit of a babe
| in the wood when it comes to SQL Server.
|
| The default instance runs our new accounting server, so 'd sure like
| to get it up to date. Thanks for any ideas.
|
|
| --
| Jim Helfer
| Computer Systems Administrator
| WTW Architects
| Timber Court
| 127 Andesron St.
| Pittsburgh PA 15212
| 412-321-0551 x330
| jhelfer@.wtwarch.com
||||Uri Dimant wrote:
> Jim
> Can put in here a result of @.@.VERSION from both instances?
This is the Default instance (which would not install sp4):
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows
NT 5.2 (Build 3790: Service Pack 2)
This is the "WTW1" instance (which would install SP4):
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard
Edition on Windows NT 5.2 (Build 3790: Service Pack 2)|||Adams Qu [MSFT] wrote:
> Based on the current status, I would like to confirm whether your SQL
> Server default instance is installed by MSDE components of SQL Server 2000
.
> If so, we can conclude that we need the MSDE specific Service Pack 4.
OK, but I don't quite understand what "installed by MSDE components"
means. I did not originally set up the server.

> You may use the below link for the download the file
> "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download link:
>
Got it.

> NOTE: To determine whether the version is Desktop Engine, we can use the
> command "select @.@.version" to manually check the SQL version.
This is the result:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows
NT 5.2 (Build 3790: Service Pack 2)
So, it does appear that my default instance is "MSDE" (whatever that
means), and I will need to apply the service pack specific for that.
Thank you for your help
JAMES A. HELFER | COMPUTER SYSTEMS ADMINISTRATOR | 412-321-0551 EXT
330 | JHELFER@.WTWARCH.COM | WTW ARCHITECTS | TIMBER COURT |
127 ANDERSON STREET | PITTSBURGH, PA 15212|||The default instance is MSDE (what we nowadays call SQL Server Express). MSD
E had a separate
installer, so you need to service pack it using an MSDE sp, not SQL Server s
p. You should be able to
find MSDE service packs at MS similar to finding SQL Server sp.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jim Helfer" <JimHelfer@.newsgroup.nospam> wrote in message
news:eOQsHKZuHHA.484@.TK2MSFTNGP06.phx.gbl...
> Uri Dimant wrote:
> This is the Default instance (which would not install sp4):
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows N
T 5.2 (Build 3790:
> Service Pack 2)
>
> This is the "WTW1" instance (which would install SP4):
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38
Copyright (c)
> 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build
3790: Service Pack 2)
>|||Adams Qu [MSFT] wrote:
> Dear Jim,
> Thank you for posting here.
>
I obtained the MSDE specific SP, but when I run setup I get "The
Instance Name Specified is Invalid"
Jim Helfer

> From the problem description of the post you submitted, my understanding
> is: When attempting to apply the SQL Server 2000 Service Pack 4 to the
> default instance, the error message saying "MSSQLSERVER is not a SQL
> Server 2000 instance" is received. However, we are able to successfully
> apply the Service Pack 4 update onto the named instance. If I have
> misunderstood about your concern, feel free to let me know.
> Based on the current status, I would like to confirm whether your SQL
> Server default instance is installed by MSDE components of SQL Server 2000
.
> If so, we can conclude that we need the MSDE specific Service Pack 4.
> You may use the below link for the download the file
> "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download link:
> Microsoft SQL Server 2000 Service Pack 4
> [url]http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-[/ur
l]
> 99a9-b7f0213f8bc5&DisplayLang=en
> "
> NOTE: To determine whether the version is Desktop Engine, we can use the
> command "select @.@.version" to manually check the SQL version.
> If the issue still persists, please help me to collect the following log
> file to me at v-adamqu@.microsoft.com
> %windir%\sqlsp.log
> If anything is unclear in my post, please don't hesitate to let me know an
d
> I will be glad to help. Thank you for your efforts and time.
> Have a nice day!
> Best regards,
> Adams Qu, MCSE, MCDBA, MCTS
> Microsoft Online Support
> Microsoft Global Technical Support Center
> Get Secure! - www.microsoft.com/security
> ========================================
=============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
=============
> This posting is provided "AS IS" with no warranties, and confers no rights
.
> --
> | Date: Wed, 27 Jun 2007 19:43:26 -0400
> | From: Jim Helfer <JimHelfer@.newsgroup.nospam>
> | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
> | MIME-Version: 1.0
> | Subject: Can't update default instance of SQL 2000 to SP4. Not recognize
d.
> | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> | Content-Transfer-Encoding: 7bit
> | Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: wtwarch.com 66.212.142.243
> | Lines: 1
> | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
> | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I have a SQL server 2000 server with two instances running. One the
> | default, one named.
> |
> | I tried to upgrade the server to SP4, and I was prompted to choose
> | which instance to upgrade. I chose the default.
> |
> | SP4 refused to upgrade the default instance with this message:
> |
> | "MSSQLSERVER is not a SQL Server 2000 instance."
> |
> | Stranger, it had no problems upgrading the named instance.
> |
> | I can't find anything about this in the MSKB and I'm a bit of a babe
> | in the wood when it comes to SQL Server.
> |
> | The default instance runs our new accounting server, so 'd sure like
> | to get it up to date. Thanks for any ideas.
> |
> |
> | --
> | Jim Helfer
> | Computer Systems Administrator
> | WTW Architects
> | Timber Court
> | 127 Andesron St.
> | Pittsburgh PA 15212
> | 412-321-0551 x330
> | jhelfer@.wtwarch.com
> |
>|||Dear Jim,
Thank you for your reply.
I understand that we receive the new error "The Instance Name Specified is
Invalid" when attempting to install the specified MSDE Service Pack 4.
Based on my experience, this error usually happens if you double click the
setup package without adding the /upgradesp command line.
Please run your SP4 setup from the command line as follows:
Setup.exe /upgradesp SQLRUN UPGRADEUSER=sa UPGRADEPWD= sa_password /l*v
C:\MsdeVerboseLog.txt
If the SP4 package still fails to install, please send the log file
"C:\MsdeVerboseLog.txt" to me at v-adamqu@.microsoft.com
Have a nice day!
Best regards,
Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| Date: Thu, 28 Jun 2007 17:40:52 -0400
| From: Jim Helfer <jhelfer@.wtwarch.com>
| User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| MIME-Version: 1.0
| Subject: Re: Can't update default instance of SQL 2000 to SP4. Not
recognized.
| References: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
<f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| In-Reply-To: <f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| Content-Transfer-Encoding: 7bit
| Message-ID: <eH#4A0cuHHA.5036@.TK2MSFTNGP03.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: wtwarch.com 66.212.142.243
| Lines: 1
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19298
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Adams Qu [MSFT] wrote:
| > Dear Jim,
| >
| > Thank you for posting here.
| >
|
|
|
| I obtained the MSDE specific SP, but when I run setup I get "The
| Instance Name Specified is Invalid"
|
|
| Jim Helfer
|
|
| > From the problem description of the post you submitted, my
understanding
| > is: When attempting to apply the SQL Server 2000 Service Pack 4 to the
| > default instance, the error message saying "MSSQLSERVER is not a SQL
| > Server 2000 instance" is received. However, we are able to successfully
| > apply the Service Pack 4 update onto the named instance. If I have
| > misunderstood about your concern, feel free to let me know.
| >
| > Based on the current status, I would like to confirm whether your SQL
| > Server default instance is installed by MSDE components of SQL Server
2000.
| > If so, we can conclude that we need the MSDE specific Service Pack 4.
| >
| > You may use the below link for the download the file
| > "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download
link:
| >
| > Microsoft SQL Server 2000 Service Pack 4
| >
http://www.microsoft.com/downloads/...fc8d-c20e-4446-
| > 99a9-b7f0213f8bc5&DisplayLang=en
| > "
| > NOTE: To determine whether the version is Desktop Engine, we can use
the
| > command "select @.@.version" to manually check the SQL version.
| >
| > If the issue still persists, please help me to collect the following
log
| > file to me at v-adamqu@.microsoft.com
| >
| > %windir%\sqlsp.log
| >
| > If anything is unclear in my post, please don't hesitate to let me know
and
| > I will be glad to help. Thank you for your efforts and time.
| >
| > Have a nice day!
| >
| > Best regards,
| >
| > Adams Qu, MCSE, MCDBA, MCTS
| > Microsoft Online Support
| >
| > Microsoft Global Technical Support Center
| >
| > Get Secure! - www.microsoft.com/security
| > ========================================
=============
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| > ========================================
=============
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| > --
| > | Date: Wed, 27 Jun 2007 19:43:26 -0400
| > | From: Jim Helfer <JimHelfer@.newsgroup.nospam>
| > | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| > | MIME-Version: 1.0
| > | Subject: Can't update default instance of SQL 2000 to SP4. Not
recognized.
| > | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| > | Content-Transfer-Encoding: 7bit
| > | Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: wtwarch.com 66.212.142.243
| > | Lines: 1
| > | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | I have a SQL server 2000 server with two instances running. One the
| > | default, one named.
| > |
| > | I tried to upgrade the server to SP4, and I was prompted to choose
| > | which instance to upgrade. I chose the default.
| > |
| > | SP4 refused to upgrade the default instance with this message:
| > |
| > | "MSSQLSERVER is not a SQL Server 2000 instance."
| > |
| > | Stranger, it had no problems upgrading the named instance.
| > |
| > | I can't find anything about this in the MSKB and I'm a bit of a
babe
| > | in the wood when it comes to SQL Server.
| > |
| > | The default instance runs our new accounting server, so 'd sure
like
| > | to get it up to date. Thanks for any ideas.
| > |
| > |
| > | --
| > | Jim Helfer
| > | Computer Systems Administrator
| > | WTW Architects
| > | Timber Court
| > | 127 Andesron St.
| > | Pittsburgh PA 15212
| > | 412-321-0551 x330
| > | jhelfer@.wtwarch.com
| > |
| >
||||Dear Jim,
How's everything going?
I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
| X-Tomcat-ID: 96360692
| References: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
<f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
<eH#4A0cuHHA.5036@.TK2MSFTNGP03.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Fri, 29 Jun 2007 07:35:32 GMT
| Subject: Re: Can't update default instance of SQL 2000 to SP4. Not
recognized.
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <bgQnYAiuHHA.3972@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 153
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19309
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Jim,
|
| Thank you for your reply.
|
| I understand that we receive the new error "The Instance Name Specified
is
| Invalid" when attempting to install the specified MSDE Service Pack 4.
|
| Based on my experience, this error usually happens if you double click
the
| setup package without adding the /upgradesp command line.
|
| Please run your SP4 setup from the command line as follows:
|
| Setup.exe /upgradesp SQLRUN UPGRADEUSER=sa UPGRADEPWD= sa_password /l*v
| C:\MsdeVerboseLog.txt
|
| If the SP4 package still fails to install, please send the log file
| "C:\MsdeVerboseLog.txt" to me at v-adamqu@.microsoft.com
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu, MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ========================================
=============
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ========================================
=============
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
| --
| | Date: Thu, 28 Jun 2007 17:40:52 -0400
| | From: Jim Helfer <jhelfer@.wtwarch.com>
| | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| | MIME-Version: 1.0
| | Subject: Re: Can't update default instance of SQL 2000 to SP4. Not
| recognized.
| | References: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| <f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| | In-Reply-To: <f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | Content-Transfer-Encoding: 7bit
| | Message-ID: <eH#4A0cuHHA.5036@.TK2MSFTNGP03.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: wtwarch.com 66.212.142.243
| | Lines: 1
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19298
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | Adams Qu [MSFT] wrote:
| | > Dear Jim,
| | >
| | > Thank you for posting here.
| | >
| |
| |
| |
| | I obtained the MSDE specific SP, but when I run setup I get "The
| | Instance Name Specified is Invalid"
| |
| |
| | Jim Helfer
| |
| |
| | > From the problem description of the post you submitted, my
| understanding
| | > is: When attempting to apply the SQL Server 2000 Service Pack 4 to
the
| | > default instance, the error message saying "MSSQLSERVER is not a
SQL
| | > Server 2000 instance" is received. However, we are able to
successfully
| | > apply the Service Pack 4 update onto the named instance. If I have
| | > misunderstood about your concern, feel free to let me know.
| | >
| | > Based on the current status, I would like to confirm whether your SQL
| | > Server default instance is installed by MSDE components of SQL Server
| 2000.
| | > If so, we can conclude that we need the MSDE specific Service Pack 4.
| | >
| | > You may use the below link for the download the file
| | > "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download
| link:
| | >
| | > Microsoft SQL Server 2000 Service Pack 4
| | >
|
http://www.microsoft.com/downloads/...fc8d-c20e-4446-
| | > 99a9-b7f0213f8bc5&DisplayLang=en
| | > "
| | > NOTE: To determine whether the version is Desktop Engine, we can use
| the
| | > command "select @.@.version" to manually check the SQL version.
| | >
| | > If the issue still persists, please help me to collect the following
| log
| | > file to me at v-adamqu@.microsoft.com
| | >
| | > %windir%\sqlsp.log
| | >
| | > If anything is unclear in my post, please don't hesitate to let me
know
| and
| | > I will be glad to help. Thank you for your efforts and time.
| | >
| | > Have a nice day!
| | >
| | > Best regards,
| | >
| | > Adams Qu, MCSE, MCDBA, MCTS
| | > Microsoft Online Support
| | >
| | > Microsoft Global Technical Support Center
| | >
| | > Get Secure! - www.microsoft.com/security
| | > ========================================
=============
| | > When responding to posts, please "Reply to Group" via your newsreader
| so
| | > that others may learn and benefit from your issue.
| | > ========================================
=============
| | > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| | >
| | > --
| | > | Date: Wed, 27 Jun 2007 19:43:26 -0400
| | > | From: Jim Helfer <JimHelfer@.newsgroup.nospam>
| | > | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| | > | MIME-Version: 1.0
| | > | Subject: Can't update default instance of SQL 2000 to SP4. Not
| recognized.
| | > | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | > | Content-Transfer-Encoding: 7bit
| | > | Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| | > | Newsgroups: microsoft.public.sqlserver.server
| | > | NNTP-Posting-Host: wtwarch.com 66.212.142.243
| | > | Lines: 1
| | > | Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| | > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
| | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| | > |
| | > | I have a SQL server 2000 server with two instances running. One
the
| | > | default, one named.
| | > |
| | > | I tried to upgrade the server to SP4, and I was prompted to
choose
| | > | which instance to upgrade. I chose the default.
| | > |
| | > | SP4 refused to upgrade the default instance with this message:
| | > |
| | > | "MSSQLSERVER is not a SQL Server 2000 instance."
| | > |
| | > | Stranger, it had no problems upgrading the named instance.
| | > |
| | > | I can't find anything about this in the MSKB and I'm a bit of a
| babe
| | > | in the wood when it comes to SQL Server.
| | > |
| | > | The default instance runs our new accounting server, so 'd sure
| like
| | > | to get it up to date. Thanks for any ideas.
| | > |
| | > |
| | > | --
| | > | Jim Helfer
| | > | Computer Systems Administrator
| | > | WTW Architects
| | > | Timber Court
| | > | 127 Andesron St.
| | > | Pittsburgh PA 15212
| | > | 412-321-0551 x330
| | > | jhelfer@.wtwarch.com
| | > |
| | >
| |
|
||||Hello,
I am running into a different issue and I am unable to resolve it. Here
is what happened:
1- I had SQLServer 2000 Client Tools installed on my laptop
2- I installed SQLServer 2005 on the laptop.
3- In order to be able to edit DTS components from SSIS I installed the
DTS Designer Components from the SQL 2005 Feature Pack :
SQLServer2005_DTS.msi
4- Once that is installed, I tried to run SQL Enterprise Manager and now
it can not run. the error message is:
"The procedure entry point ?processExecute@.@.YAXPAUHWND__@.@.PBG1@.Z could
not be located in the dynamic link library SEMSFC.dll"
5- Looking at different website people who encountered this issue
installed SQL2000 Server SP 4 and that fixed it for them.
6- However, when I try to install SP4 I can't figure out how to provide
the instance SA password since I don't believe I have one installed
since this is not the database engine server.
Do you have any suggestions or a solution so that I can run EM again?
Thanks.
*** Sent via Developersdex http://www.codecomments.com ***

Can't update default instance of SQL 2000 to SP4. Not recognized.

I have a SQL server 2000 server with two instances running. One the
default, one named.
I tried to upgrade the server to SP4, and I was prompted to choose
which instance to upgrade. I chose the default.
SP4 refused to upgrade the default instance with this message:
"MSSQLSERVER is not a SQL Server 2000 instance."
Stranger, it had no problems upgrading the named instance.
I can't find anything about this in the MSKB and I'm a bit of a babe
in the wood when it comes to SQL Server.
The default instance runs our new accounting server, so 'd sure like
to get it up to date. Thanks for any ideas.
--
Jim Helfer
Computer Systems Administrator
WTW Architects
Timber Court
127 Andesron St.
Pittsburgh PA 15212
412-321-0551 x330
jhelfer@.wtwarch.comJim
Can put in here a result of @.@.VERSION from both instances?
"Jim Helfer" <JimHelfer@.newsgroup.nospam> wrote in message
news:OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl...
> I have a SQL server 2000 server with two instances running. One the
> default, one named.
> I tried to upgrade the server to SP4, and I was prompted to choose which
> instance to upgrade. I chose the default.
> SP4 refused to upgrade the default instance with this message:
> "MSSQLSERVER is not a SQL Server 2000 instance."
> Stranger, it had no problems upgrading the named instance.
> I can't find anything about this in the MSKB and I'm a bit of a babe in
> the wood when it comes to SQL Server.
> The default instance runs our new accounting server, so 'd sure like to
> get it up to date. Thanks for any ideas.
>
> --
> Jim Helfer
> Computer Systems Administrator
> WTW Architects
> Timber Court
> 127 Andesron St.
> Pittsburgh PA 15212
> 412-321-0551 x330
> jhelfer@.wtwarch.com|||Dear Jim,
Thank you for posting here.
From the problem description of the post you submitted, my understanding
is: When attempting to apply the SQL Server 2000 Service Pack 4 to the
default instance, the error message saying "MSSQLSERVER is not a SQL
Server 2000 instance" is received. However, we are able to successfully
apply the Service Pack 4 update onto the named instance. If I have
misunderstood about your concern, feel free to let me know.
Based on the current status, I would like to confirm whether your SQL
Server default instance is installed by MSDE components of SQL Server 2000.
If so, we can conclude that we need the MSDE specific Service Pack 4.
You may use the below link for the download the file
"SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download link:
Microsoft SQL Server 2000 Service Pack 4
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-
99a9-b7f0213f8bc5&DisplayLang=en
"
NOTE: To determine whether the version is Desktop Engine, we can use the
command "select @.@.version" to manually check the SQL version.
If the issue still persists, please help me to collect the following log
file to me at v-adamqu@.microsoft.com
%windir%\sqlsp.log
If anything is unclear in my post, please don't hesitate to let me know and
I will be glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
--
| Date: Wed, 27 Jun 2007 19:43:26 -0400
| From: Jim Helfer <JimHelfer@.newsgroup.nospam>
| User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| MIME-Version: 1.0
| Subject: Can't update default instance of SQL 2000 to SP4. Not recognized.
| Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| Content-Transfer-Encoding: 7bit
| Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: wtwarch.com 66.212.142.243
| Lines: 1
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have a SQL server 2000 server with two instances running. One the
| default, one named.
|
| I tried to upgrade the server to SP4, and I was prompted to choose
| which instance to upgrade. I chose the default.
|
| SP4 refused to upgrade the default instance with this message:
|
| "MSSQLSERVER is not a SQL Server 2000 instance."
|
| Stranger, it had no problems upgrading the named instance.
|
| I can't find anything about this in the MSKB and I'm a bit of a babe
| in the wood when it comes to SQL Server.
|
| The default instance runs our new accounting server, so 'd sure like
| to get it up to date. Thanks for any ideas.
|
|
| --
| Jim Helfer
| Computer Systems Administrator
| WTW Architects
| Timber Court
| 127 Andesron St.
| Pittsburgh PA 15212
| 412-321-0551 x330
| jhelfer@.wtwarch.com
||||Uri Dimant wrote:
> Jim
> Can put in here a result of @.@.VERSION from both instances?
This is the Default instance (which would not install sp4):
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows
NT 5.2 (Build 3790: Service Pack 2)
This is the "WTW1" instance (which would install SP4):
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard
Edition on Windows NT 5.2 (Build 3790: Service Pack 2)|||Adams Qu [MSFT] wrote:
> Based on the current status, I would like to confirm whether your SQL
> Server default instance is installed by MSDE components of SQL Server 2000.
> If so, we can conclude that we need the MSDE specific Service Pack 4.
OK, but I don't quite understand what "installed by MSDE components"
means. I did not originally set up the server.
> You may use the below link for the download the file
> "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download link:
>
Got it.
> NOTE: To determine whether the version is Desktop Engine, we can use the
> command "select @.@.version" to manually check the SQL version.
This is the result:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows
NT 5.2 (Build 3790: Service Pack 2)
So, it does appear that my default instance is "MSDE" (whatever that
means), and I will need to apply the service pack specific for that.
Thank you for your help
JAMES A. HELFER | COMPUTER SYSTEMS ADMINISTRATOR | 412-321-0551 EXT
330 | JHELFER@.WTWARCH.COM | WTW ARCHITECTS | TIMBER COURT |
127 ANDERSON STREET | PITTSBURGH, PA 15212|||The default instance is MSDE (what we nowadays call SQL Server Express). MSDE had a separate
installer, so you need to service pack it using an MSDE sp, not SQL Server sp. You should be able to
find MSDE service packs at MS similar to finding SQL Server sp.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jim Helfer" <JimHelfer@.newsgroup.nospam> wrote in message
news:eOQsHKZuHHA.484@.TK2MSFTNGP06.phx.gbl...
> Uri Dimant wrote:
>> Jim
>> Can put in here a result of @.@.VERSION from both instances?
> This is the Default instance (which would not install sp4):
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.2 (Build 3790:
> Service Pack 2)
>
> This is the "WTW1" instance (which would install SP4):
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c)
> 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
>|||Adams Qu [MSFT] wrote:
> Dear Jim,
> Thank you for posting here.
>
I obtained the MSDE specific SP, but when I run setup I get "The
Instance Name Specified is Invalid"
Jim Helfer
> From the problem description of the post you submitted, my understanding
> is: When attempting to apply the SQL Server 2000 Service Pack 4 to the
> default instance, the error message saying "MSSQLSERVER is not a SQL
> Server 2000 instance" is received. However, we are able to successfully
> apply the Service Pack 4 update onto the named instance. If I have
> misunderstood about your concern, feel free to let me know.
> Based on the current status, I would like to confirm whether your SQL
> Server default instance is installed by MSDE components of SQL Server 2000.
> If so, we can conclude that we need the MSDE specific Service Pack 4.
> You may use the below link for the download the file
> "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download link:
> Microsoft SQL Server 2000 Service Pack 4
> http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-
> 99a9-b7f0213f8bc5&DisplayLang=en
> "
> NOTE: To determine whether the version is Desktop Engine, we can use the
> command "select @.@.version" to manually check the SQL version.
> If the issue still persists, please help me to collect the following log
> file to me at v-adamqu@.microsoft.com
> %windir%\sqlsp.log
> If anything is unclear in my post, please don't hesitate to let me know and
> I will be glad to help. Thank you for your efforts and time.
> Have a nice day!
> Best regards,
> Adams Qu, MCSE, MCDBA, MCTS
> Microsoft Online Support
> Microsoft Global Technical Support Center
> Get Secure! - www.microsoft.com/security
> =====================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> =====================================================> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> | Date: Wed, 27 Jun 2007 19:43:26 -0400
> | From: Jim Helfer <JimHelfer@.newsgroup.nospam>
> | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
> | MIME-Version: 1.0
> | Subject: Can't update default instance of SQL 2000 to SP4. Not recognized.
> | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> | Content-Transfer-Encoding: 7bit
> | Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: wtwarch.com 66.212.142.243
> | Lines: 1
> | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
> | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I have a SQL server 2000 server with two instances running. One the
> | default, one named.
> |
> | I tried to upgrade the server to SP4, and I was prompted to choose
> | which instance to upgrade. I chose the default.
> |
> | SP4 refused to upgrade the default instance with this message:
> |
> | "MSSQLSERVER is not a SQL Server 2000 instance."
> |
> | Stranger, it had no problems upgrading the named instance.
> |
> | I can't find anything about this in the MSKB and I'm a bit of a babe
> | in the wood when it comes to SQL Server.
> |
> | The default instance runs our new accounting server, so 'd sure like
> | to get it up to date. Thanks for any ideas.
> |
> |
> | --
> | Jim Helfer
> | Computer Systems Administrator
> | WTW Architects
> | Timber Court
> | 127 Andesron St.
> | Pittsburgh PA 15212
> | 412-321-0551 x330
> | jhelfer@.wtwarch.com
> |
>|||Dear Jim,
Thank you for your reply.
I understand that we receive the new error "The Instance Name Specified is
Invalid" when attempting to install the specified MSDE Service Pack 4.
Based on my experience, this error usually happens if you double click the
setup package without adding the /upgradesp command line.
Please run your SP4 setup from the command line as follows:
Setup.exe /upgradesp SQLRUN UPGRADEUSER=sa UPGRADEPWD= sa_password /l*v
C:\MsdeVerboseLog.txt
If the SP4 package still fails to install, please send the log file
"C:\MsdeVerboseLog.txt" to me at v-adamqu@.microsoft.com
Have a nice day!
Best regards,
Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| Date: Thu, 28 Jun 2007 17:40:52 -0400
| From: Jim Helfer <jhelfer@.wtwarch.com>
| User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| MIME-Version: 1.0
| Subject: Re: Can't update default instance of SQL 2000 to SP4. Not
recognized.
| References: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
<f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| In-Reply-To: <f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| Content-Transfer-Encoding: 7bit
| Message-ID: <eH#4A0cuHHA.5036@.TK2MSFTNGP03.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: wtwarch.com 66.212.142.243
| Lines: 1
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19298
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Adams Qu [MSFT] wrote:
| > Dear Jim,
| >
| > Thank you for posting here.
| >
|
|
|
| I obtained the MSDE specific SP, but when I run setup I get "The
| Instance Name Specified is Invalid"
|
|
| Jim Helfer
|
|
| > From the problem description of the post you submitted, my
understanding
| > is: When attempting to apply the SQL Server 2000 Service Pack 4 to the
| > default instance, the error message saying "MSSQLSERVER is not a SQL
| > Server 2000 instance" is received. However, we are able to successfully
| > apply the Service Pack 4 update onto the named instance. If I have
| > misunderstood about your concern, feel free to let me know.
| >
| > Based on the current status, I would like to confirm whether your SQL
| > Server default instance is installed by MSDE components of SQL Server
2000.
| > If so, we can conclude that we need the MSDE specific Service Pack 4.
| >
| > You may use the below link for the download the file
| > "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download
link:
| >
| > Microsoft SQL Server 2000 Service Pack 4
| >
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-
| > 99a9-b7f0213f8bc5&DisplayLang=en
| > "
| > NOTE: To determine whether the version is Desktop Engine, we can use
the
| > command "select @.@.version" to manually check the SQL version.
| >
| > If the issue still persists, please help me to collect the following
log
| > file to me at v-adamqu@.microsoft.com
| >
| > %windir%\sqlsp.log
| >
| > If anything is unclear in my post, please don't hesitate to let me know
and
| > I will be glad to help. Thank you for your efforts and time.
| >
| > Have a nice day!
| >
| > Best regards,
| >
| > Adams Qu, MCSE, MCDBA, MCTS
| > Microsoft Online Support
| >
| > Microsoft Global Technical Support Center
| >
| > Get Secure! - www.microsoft.com/security
| > =====================================================| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| > =====================================================| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| > --
| > | Date: Wed, 27 Jun 2007 19:43:26 -0400
| > | From: Jim Helfer <JimHelfer@.newsgroup.nospam>
| > | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| > | MIME-Version: 1.0
| > | Subject: Can't update default instance of SQL 2000 to SP4. Not
recognized.
| > | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| > | Content-Transfer-Encoding: 7bit
| > | Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: wtwarch.com 66.212.142.243
| > | Lines: 1
| > | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | I have a SQL server 2000 server with two instances running. One the
| > | default, one named.
| > |
| > | I tried to upgrade the server to SP4, and I was prompted to choose
| > | which instance to upgrade. I chose the default.
| > |
| > | SP4 refused to upgrade the default instance with this message:
| > |
| > | "MSSQLSERVER is not a SQL Server 2000 instance."
| > |
| > | Stranger, it had no problems upgrading the named instance.
| > |
| > | I can't find anything about this in the MSKB and I'm a bit of a
babe
| > | in the wood when it comes to SQL Server.
| > |
| > | The default instance runs our new accounting server, so 'd sure
like
| > | to get it up to date. Thanks for any ideas.
| > |
| > |
| > | --
| > | Jim Helfer
| > | Computer Systems Administrator
| > | WTW Architects
| > | Timber Court
| > | 127 Andesron St.
| > | Pittsburgh PA 15212
| > | 412-321-0551 x330
| > | jhelfer@.wtwarch.com
| > |
| >
||||Dear Jim,
How's everything going?
I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
=====================================================When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.
| X-Tomcat-ID: 96360692
| References: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
<f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
<eH#4A0cuHHA.5036@.TK2MSFTNGP03.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Fri, 29 Jun 2007 07:35:32 GMT
| Subject: Re: Can't update default instance of SQL 2000 to SP4. Not
recognized.
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <bgQnYAiuHHA.3972@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 153
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19309
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Jim,
|
| Thank you for your reply.
|
| I understand that we receive the new error "The Instance Name Specified
is
| Invalid" when attempting to install the specified MSDE Service Pack 4.
|
| Based on my experience, this error usually happens if you double click
the
| setup package without adding the /upgradesp command line.
|
| Please run your SP4 setup from the command line as follows:
|
| Setup.exe /upgradesp SQLRUN UPGRADEUSER=sa UPGRADEPWD= sa_password /l*v
| C:\MsdeVerboseLog.txt
|
| If the SP4 package still fails to install, please send the log file
| "C:\MsdeVerboseLog.txt" to me at v-adamqu@.microsoft.com
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu, MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| =====================================================| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| =====================================================| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
| --
| | Date: Thu, 28 Jun 2007 17:40:52 -0400
| | From: Jim Helfer <jhelfer@.wtwarch.com>
| | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| | MIME-Version: 1.0
| | Subject: Re: Can't update default instance of SQL 2000 to SP4. Not
| recognized.
| | References: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| <f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| | In-Reply-To: <f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | Content-Transfer-Encoding: 7bit
| | Message-ID: <eH#4A0cuHHA.5036@.TK2MSFTNGP03.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: wtwarch.com 66.212.142.243
| | Lines: 1
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP03.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19298
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | Adams Qu [MSFT] wrote:
| | > Dear Jim,
| | >
| | > Thank you for posting here.
| | >
| |
| |
| |
| | I obtained the MSDE specific SP, but when I run setup I get "The
| | Instance Name Specified is Invalid"
| |
| |
| | Jim Helfer
| |
| |
| | > From the problem description of the post you submitted, my
| understanding
| | > is: When attempting to apply the SQL Server 2000 Service Pack 4 to
the
| | > default instance, the error message saying "MSSQLSERVER is not a
SQL
| | > Server 2000 instance" is received. However, we are able to
successfully
| | > apply the Service Pack 4 update onto the named instance. If I have
| | > misunderstood about your concern, feel free to let me know.
| | >
| | > Based on the current status, I would like to confirm whether your SQL
| | > Server default instance is installed by MSDE components of SQL Server
| 2000.
| | > If so, we can conclude that we need the MSDE specific Service Pack 4.
| | >
| | > You may use the below link for the download the file
| | > "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download
| link:
| | >
| | > Microsoft SQL Server 2000 Service Pack 4
| | >
|
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-
| | > 99a9-b7f0213f8bc5&DisplayLang=en
| | > "
| | > NOTE: To determine whether the version is Desktop Engine, we can use
| the
| | > command "select @.@.version" to manually check the SQL version.
| | >
| | > If the issue still persists, please help me to collect the following
| log
| | > file to me at v-adamqu@.microsoft.com
| | >
| | > %windir%\sqlsp.log
| | >
| | > If anything is unclear in my post, please don't hesitate to let me
know
| and
| | > I will be glad to help. Thank you for your efforts and time.
| | >
| | > Have a nice day!
| | >
| | > Best regards,
| | >
| | > Adams Qu, MCSE, MCDBA, MCTS
| | > Microsoft Online Support
| | >
| | > Microsoft Global Technical Support Center
| | >
| | > Get Secure! - www.microsoft.com/security
| | > =====================================================| | > When responding to posts, please "Reply to Group" via your newsreader
| so
| | > that others may learn and benefit from your issue.
| | > =====================================================| | > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| | >
| | > --
| | > | Date: Wed, 27 Jun 2007 19:43:26 -0400
| | > | From: Jim Helfer <JimHelfer@.newsgroup.nospam>
| | > | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| | > | MIME-Version: 1.0
| | > | Subject: Can't update default instance of SQL 2000 to SP4. Not
| recognized.
| | > | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | > | Content-Transfer-Encoding: 7bit
| | > | Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| | > | Newsgroups: microsoft.public.sqlserver.server
| | > | NNTP-Posting-Host: wtwarch.com 66.212.142.243
| | > | Lines: 1
| | > | Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
| | > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
| | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| | > |
| | > | I have a SQL server 2000 server with two instances running. One
the
| | > | default, one named.
| | > |
| | > | I tried to upgrade the server to SP4, and I was prompted to
choose
| | > | which instance to upgrade. I chose the default.
| | > |
| | > | SP4 refused to upgrade the default instance with this message:
| | > |
| | > | "MSSQLSERVER is not a SQL Server 2000 instance."
| | > |
| | > | Stranger, it had no problems upgrading the named instance.
| | > |
| | > | I can't find anything about this in the MSKB and I'm a bit of a
| babe
| | > | in the wood when it comes to SQL Server.
| | > |
| | > | The default instance runs our new accounting server, so 'd sure
| like
| | > | to get it up to date. Thanks for any ideas.
| | > |
| | > |
| | > | --
| | > | Jim Helfer
| | > | Computer Systems Administrator
| | > | WTW Architects
| | > | Timber Court
| | > | 127 Andesron St.
| | > | Pittsburgh PA 15212
| | > | 412-321-0551 x330
| | > | jhelfer@.wtwarch.com
| | > |
| | >
| |
|
|

Can't update default instance of SQL 2000 to SP4. Not recognized.

I have a SQL server 2000 server with two instances running. One the
default, one named.
I tried to upgrade the server to SP4, and I was prompted to choose
which instance to upgrade. I chose the default.
SP4 refused to upgrade the default instance with this message:
"MSSQLSERVER is not a SQL Server 2000 instance."
Stranger, it had no problems upgrading the named instance.
I can't find anything about this in the MSKB and I'm a bit of a babe
in the wood when it comes to SQL Server.
The default instance runs our new accounting server, so 'd sure like
to get it up to date. Thanks for any ideas.
Jim Helfer
Computer Systems Administrator
WTW Architects
Timber Court
127 Andesron St.
Pittsburgh PA 15212
412-321-0551 x330
jhelfer@.wtwarch.com
Jim
Can put in here a result of @.@.VERSION from both instances?
"Jim Helfer" <JimHelfer@.newsgroup.nospam> wrote in message
news:OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl...
> I have a SQL server 2000 server with two instances running. One the
> default, one named.
> I tried to upgrade the server to SP4, and I was prompted to choose which
> instance to upgrade. I chose the default.
> SP4 refused to upgrade the default instance with this message:
> "MSSQLSERVER is not a SQL Server 2000 instance."
> Stranger, it had no problems upgrading the named instance.
> I can't find anything about this in the MSKB and I'm a bit of a babe in
> the wood when it comes to SQL Server.
> The default instance runs our new accounting server, so 'd sure like to
> get it up to date. Thanks for any ideas.
>
> --
> Jim Helfer
> Computer Systems Administrator
> WTW Architects
> Timber Court
> 127 Andesron St.
> Pittsburgh PA 15212
> 412-321-0551 x330
> jhelfer@.wtwarch.com
|||Dear Jim,
Thank you for posting here.
From the problem description of the post you submitted, my understanding
is: When attempting to apply the SQL Server 2000 Service Pack 4 to the
default instance, the error message saying "MSSQLSERVER is not a SQL
Server 2000 instance" is received. However, we are able to successfully
apply the Service Pack 4 update onto the named instance. If I have
misunderstood about your concern, feel free to let me know.
Based on the current status, I would like to confirm whether your SQL
Server default instance is installed by MSDE components of SQL Server 2000.
If so, we can conclude that we need the MSDE specific Service Pack 4.
You may use the below link for the download the file
"SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download link:
Microsoft SQL Server 2000 Service Pack 4
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-
99a9-b7f0213f8bc5&DisplayLang=en
"
NOTE: To determine whether the version is Desktop Engine, we can use the
command "select @.@.version" to manually check the SQL version.
If the issue still persists, please help me to collect the following log
file to me at v-adamqu@.microsoft.com
%windir%\sqlsp.log
If anything is unclear in my post, please don't hesitate to let me know and
I will be glad to help. Thank you for your efforts and time.
Have a nice day!
Best regards,
Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Date: Wed, 27 Jun 2007 19:43:26 -0400
| From: Jim Helfer <JimHelfer@.newsgroup.nospam>
| User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| MIME-Version: 1.0
| Subject: Can't update default instance of SQL 2000 to SP4. Not recognized.
| Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| Content-Transfer-Encoding: 7bit
| Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: wtwarch.com 66.212.142.243
| Lines: 1
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP05.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| I have a SQL server 2000 server with two instances running. One the
| default, one named.
|
| I tried to upgrade the server to SP4, and I was prompted to choose
| which instance to upgrade. I chose the default.
|
| SP4 refused to upgrade the default instance with this message:
|
| "MSSQLSERVER is not a SQL Server 2000 instance."
|
| Stranger, it had no problems upgrading the named instance.
|
| I can't find anything about this in the MSKB and I'm a bit of a babe
| in the wood when it comes to SQL Server.
|
| The default instance runs our new accounting server, so 'd sure like
| to get it up to date. Thanks for any ideas.
|
|
| --
| Jim Helfer
| Computer Systems Administrator
| WTW Architects
| Timber Court
| 127 Andesron St.
| Pittsburgh PA 15212
| 412-321-0551 x330
| jhelfer@.wtwarch.com
|
|||Uri Dimant wrote:
> Jim
> Can put in here a result of @.@.VERSION from both instances?
This is the Default instance (which would not install sp4):
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows
NT 5.2 (Build 3790: Service Pack 2)
This is the "WTW1" instance (which would install SP4):
Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005
23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Standard
Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
|||Adams Qu [MSFT] wrote:
> Based on the current status, I would like to confirm whether your SQL
> Server default instance is installed by MSDE components of SQL Server 2000.
> If so, we can conclude that we need the MSDE specific Service Pack 4.
OK, but I don't quite understand what "installed by MSDE components"
means. I did not originally set up the server.

> You may use the below link for the download the file
> "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download link:
>
Got it.

> NOTE: To determine whether the version is Desktop Engine, we can use the
> command "select @.@.version" to manually check the SQL version.
This is the result:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows
NT 5.2 (Build 3790: Service Pack 2)
So, it does appear that my default instance is "MSDE" (whatever that
means), and I will need to apply the service pack specific for that.
Thank you for your help
JAMES A. HELFER | COMPUTER SYSTEMS ADMINISTRATOR | 412-321-0551 EXT
330 | JHELFER@.WTWARCH.COM | WTW ARCHITECTS | TIMBER COURT |
127 ANDERSON STREET | PITTSBURGH, PA 15212
|||The default instance is MSDE (what we nowadays call SQL Server Express). MSDE had a separate
installer, so you need to service pack it using an MSDE sp, not SQL Server sp. You should be able to
find MSDE service packs at MS similar to finding SQL Server sp.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Jim Helfer" <JimHelfer@.newsgroup.nospam> wrote in message
news:eOQsHKZuHHA.484@.TK2MSFTNGP06.phx.gbl...
> Uri Dimant wrote:
> This is the Default instance (which would not install sp4):
> Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation Desktop Engine on Windows NT 5.2 (Build 3790:
> Service Pack 2)
>
> This is the "WTW1" instance (which would install SP4):
> Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c)
> 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
>
|||Adams Qu [MSFT] wrote:
> Dear Jim,
> Thank you for posting here.
>
I obtained the MSDE specific SP, but when I run setup I get "The
Instance Name Specified is Invalid"
Jim Helfer

> From the problem description of the post you submitted, my understanding
> is: When attempting to apply the SQL Server 2000 Service Pack 4 to the
> default instance, the error message saying "MSSQLSERVER is not a SQL
> Server 2000 instance" is received. However, we are able to successfully
> apply the Service Pack 4 update onto the named instance. If I have
> misunderstood about your concern, feel free to let me know.
> Based on the current status, I would like to confirm whether your SQL
> Server default instance is installed by MSDE components of SQL Server 2000.
> If so, we can conclude that we need the MSDE specific Service Pack 4.
> You may use the below link for the download the file
> "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download link:
> Microsoft SQL Server 2000 Service Pack 4
> http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-
> 99a9-b7f0213f8bc5&DisplayLang=en
> "
> NOTE: To determine whether the version is Desktop Engine, we can use the
> command "select @.@.version" to manually check the SQL version.
> If the issue still persists, please help me to collect the following log
> file to me at v-adamqu@.microsoft.com
> %windir%\sqlsp.log
> If anything is unclear in my post, please don't hesitate to let me know and
> I will be glad to help. Thank you for your efforts and time.
> Have a nice day!
> Best regards,
> Adams Qu, MCSE, MCDBA, MCTS
> Microsoft Online Support
> Microsoft Global Technical Support Center
> Get Secure! - www.microsoft.com/security
> ================================================== ===
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ================================================== ===
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> | Date: Wed, 27 Jun 2007 19:43:26 -0400
> | From: Jim Helfer <JimHelfer@.newsgroup.nospam>
> | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
> | MIME-Version: 1.0
> | Subject: Can't update default instance of SQL 2000 to SP4. Not recognized.
> | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
> | Content-Transfer-Encoding: 7bit
> | Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
> | Newsgroups: microsoft.public.sqlserver.server
> | NNTP-Posting-Host: wtwarch.com 66.212.142.243
> | Lines: 1
> | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP05.phx.gbl
> | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
> | X-Tomcat-NG: microsoft.public.sqlserver.server
> |
> | I have a SQL server 2000 server with two instances running. One the
> | default, one named.
> |
> | I tried to upgrade the server to SP4, and I was prompted to choose
> | which instance to upgrade. I chose the default.
> |
> | SP4 refused to upgrade the default instance with this message:
> |
> | "MSSQLSERVER is not a SQL Server 2000 instance."
> |
> | Stranger, it had no problems upgrading the named instance.
> |
> | I can't find anything about this in the MSKB and I'm a bit of a babe
> | in the wood when it comes to SQL Server.
> |
> | The default instance runs our new accounting server, so 'd sure like
> | to get it up to date. Thanks for any ideas.
> |
> |
> | --
> | Jim Helfer
> | Computer Systems Administrator
> | WTW Architects
> | Timber Court
> | 127 Andesron St.
> | Pittsburgh PA 15212
> | 412-321-0551 x330
> | jhelfer@.wtwarch.com
> |
>
|||Dear Jim,
Thank you for your reply.
I understand that we receive the new error "The Instance Name Specified is
Invalid" when attempting to install the specified MSDE Service Pack 4.
Based on my experience, this error usually happens if you double click the
setup package without adding the /upgradesp command line.
Please run your SP4 setup from the command line as follows:
Setup.exe /upgradesp SQLRUN UPGRADEUSER=sa UPGRADEPWD= sa_password /l*v
C:\MsdeVerboseLog.txt
If the SP4 package still fails to install, please send the log file
"C:\MsdeVerboseLog.txt" to me at v-adamqu@.microsoft.com
Have a nice day!
Best regards,
Adams Qu, MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| Date: Thu, 28 Jun 2007 17:40:52 -0400
| From: Jim Helfer <jhelfer@.wtwarch.com>
| User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| MIME-Version: 1.0
| Subject: Re: Can't update default instance of SQL 2000 to SP4. Not
recognized.
| References: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
<f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| In-Reply-To: <f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| Content-Transfer-Encoding: 7bit
| Message-ID: <eH#4A0cuHHA.5036@.TK2MSFTNGP03.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: wtwarch.com 66.212.142.243
| Lines: 1
| Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP03.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19298
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Adams Qu [MSFT] wrote:
| > Dear Jim,
| >
| > Thank you for posting here.
| >
|
|
|
| I obtained the MSDE specific SP, but when I run setup I get "The
| Instance Name Specified is Invalid"
|
|
| Jim Helfer
|
|
| > From the problem description of the post you submitted, my
understanding
| > is: When attempting to apply the SQL Server 2000 Service Pack 4 to the
| > default instance, the error message saying "MSSQLSERVER is not a SQL
| > Server 2000 instance" is received. However, we are able to successfully
| > apply the Service Pack 4 update onto the named instance. If I have
| > misunderstood about your concern, feel free to let me know.
| >
| > Based on the current status, I would like to confirm whether your SQL
| > Server default instance is installed by MSDE components of SQL Server
2000.
| > If so, we can conclude that we need the MSDE specific Service Pack 4.
| >
| > You may use the below link for the download the file
| > "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download
link:
| >
| > Microsoft SQL Server 2000 Service Pack 4
| >
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-
| > 99a9-b7f0213f8bc5&DisplayLang=en
| > "
| > NOTE: To determine whether the version is Desktop Engine, we can use
the
| > command "select @.@.version" to manually check the SQL version.
| >
| > If the issue still persists, please help me to collect the following
log
| > file to me at v-adamqu@.microsoft.com
| >
| > %windir%\sqlsp.log
| >
| > If anything is unclear in my post, please don't hesitate to let me know
and
| > I will be glad to help. Thank you for your efforts and time.
| >
| > Have a nice day!
| >
| > Best regards,
| >
| > Adams Qu, MCSE, MCDBA, MCTS
| > Microsoft Online Support
| >
| > Microsoft Global Technical Support Center
| >
| > Get Secure! - www.microsoft.com/security
| > ================================================== ===
| > When responding to posts, please "Reply to Group" via your newsreader
so
| > that others may learn and benefit from your issue.
| > ================================================== ===
| > This posting is provided "AS IS" with no warranties, and confers no
rights.
| >
| > --
| > | Date: Wed, 27 Jun 2007 19:43:26 -0400
| > | From: Jim Helfer <JimHelfer@.newsgroup.nospam>
| > | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| > | MIME-Version: 1.0
| > | Subject: Can't update default instance of SQL 2000 to SP4. Not
recognized.
| > | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| > | Content-Transfer-Encoding: 7bit
| > | Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| > | Newsgroups: microsoft.public.sqlserver.server
| > | NNTP-Posting-Host: wtwarch.com 66.212.142.243
| > | Lines: 1
| > | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP05.phx.gbl
| > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
| > | X-Tomcat-NG: microsoft.public.sqlserver.server
| > |
| > | I have a SQL server 2000 server with two instances running. One the
| > | default, one named.
| > |
| > | I tried to upgrade the server to SP4, and I was prompted to choose
| > | which instance to upgrade. I chose the default.
| > |
| > | SP4 refused to upgrade the default instance with this message:
| > |
| > | "MSSQLSERVER is not a SQL Server 2000 instance."
| > |
| > | Stranger, it had no problems upgrading the named instance.
| > |
| > | I can't find anything about this in the MSKB and I'm a bit of a
babe
| > | in the wood when it comes to SQL Server.
| > |
| > | The default instance runs our new accounting server, so 'd sure
like
| > | to get it up to date. Thanks for any ideas.
| > |
| > |
| > | --
| > | Jim Helfer
| > | Computer Systems Administrator
| > | WTW Architects
| > | Timber Court
| > | 127 Andesron St.
| > | Pittsburgh PA 15212
| > | 412-321-0551 x330
| > | jhelfer@.wtwarch.com
| > |
| >
|
|||Dear Jim,
How's everything going?
I'm wondering if the suggestion has helped or if you have any further
questions. Please feel free to respond to the newsgroups if you need any
additional help.
Have a nice day!
Best regards,
Adams Qu
MCSE, MCDBA, MCTS
Microsoft Online Support
Microsoft Global Technical Support Center
Get Secure! - www.microsoft.com/security
================================================== ===
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.
| X-Tomcat-ID: 96360692
| References: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
<f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
<eH#4A0cuHHA.5036@.TK2MSFTNGP03.phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain
| Content-Transfer-Encoding: 7bit
| From: v-adamqu@.online.microsoft.com (Adams Qu [MSFT])
| Organization: Microsoft
| Date: Fri, 29 Jun 2007 07:35:32 GMT
| Subject: Re: Can't update default instance of SQL 2000 to SP4. Not
recognized.
| X-Tomcat-NG: microsoft.public.sqlserver.server
| Message-ID: <bgQnYAiuHHA.3972@.TK2MSFTNGHUB02.phx.gbl>
| Newsgroups: microsoft.public.sqlserver.server
| Lines: 153
| Path: TK2MSFTNGHUB02.phx.gbl
| Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19309
| NNTP-Posting-Host: tomcatimport2.phx.gbl 10.201.218.182
|
| Dear Jim,
|
| Thank you for your reply.
|
| I understand that we receive the new error "The Instance Name Specified
is
| Invalid" when attempting to install the specified MSDE Service Pack 4.
|
| Based on my experience, this error usually happens if you double click
the
| setup package without adding the /upgradesp command line.
|
| Please run your SP4 setup from the command line as follows:
|
| Setup.exe /upgradesp SQLRUN UPGRADEUSER=sa UPGRADEPWD= sa_password /l*v
| C:\MsdeVerboseLog.txt
|
| If the SP4 package still fails to install, please send the log file
| "C:\MsdeVerboseLog.txt" to me at v-adamqu@.microsoft.com
|
| Have a nice day!
|
| Best regards,
|
| Adams Qu, MCSE, MCDBA, MCTS
| Microsoft Online Support
|
| Microsoft Global Technical Support Center
|
| Get Secure! - www.microsoft.com/security
| ================================================== ===
| When responding to posts, please "Reply to Group" via your newsreader so
| that others may learn and benefit from your issue.
| ================================================== ===
| This posting is provided "AS IS" with no warranties, and confers no
rights.
|
|
|
| --
| | Date: Thu, 28 Jun 2007 17:40:52 -0400
| | From: Jim Helfer <jhelfer@.wtwarch.com>
| | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| | MIME-Version: 1.0
| | Subject: Re: Can't update default instance of SQL 2000 to SP4. Not
| recognized.
| | References: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| <f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| | In-Reply-To: <f#50M#UuHHA.360@.TK2MSFTNGHUB02.phx.gbl>
| | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | Content-Transfer-Encoding: 7bit
| | Message-ID: <eH#4A0cuHHA.5036@.TK2MSFTNGP03.phx.gbl>
| | Newsgroups: microsoft.public.sqlserver.server
| | NNTP-Posting-Host: wtwarch.com 66.212.142.243
| | Lines: 1
| | Path: TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP03.phx.gbl
| | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19298
| | X-Tomcat-NG: microsoft.public.sqlserver.server
| |
| | Adams Qu [MSFT] wrote:
| | > Dear Jim,
| | >
| | > Thank you for posting here.
| | >
| |
| |
| |
| | I obtained the MSDE specific SP, but when I run setup I get "The
| | Instance Name Specified is Invalid"
| |
| |
| | Jim Helfer
| |
| |
| | > From the problem description of the post you submitted, my
| understanding
| | > is: When attempting to apply the SQL Server 2000 Service Pack 4 to
the
| | > default instance, the error message saying "MSSQLSERVER is not a
SQL
| | > Server 2000 instance" is received. However, we are able to
successfully
| | > apply the Service Pack 4 update onto the named instance. If I have
| | > misunderstood about your concern, feel free to let me know.
| | >
| | > Based on the current status, I would like to confirm whether your SQL
| | > Server default instance is installed by MSDE components of SQL Server
| 2000.
| | > If so, we can conclude that we need the MSDE specific Service Pack 4.
| | >
| | > You may use the below link for the download the file
| | > "SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE" from the following download
| link:
| | >
| | > Microsoft SQL Server 2000 Service Pack 4
| | >
|
http://www.microsoft.com/downloads/details.aspx?FamilyID=8e2dfc8d-c20e-4446-
| | > 99a9-b7f0213f8bc5&DisplayLang=en
| | > "
| | > NOTE: To determine whether the version is Desktop Engine, we can use
| the
| | > command "select @.@.version" to manually check the SQL version.
| | >
| | > If the issue still persists, please help me to collect the following
| log
| | > file to me at v-adamqu@.microsoft.com
| | >
| | > %windir%\sqlsp.log
| | >
| | > If anything is unclear in my post, please don't hesitate to let me
know
| and
| | > I will be glad to help. Thank you for your efforts and time.
| | >
| | > Have a nice day!
| | >
| | > Best regards,
| | >
| | > Adams Qu, MCSE, MCDBA, MCTS
| | > Microsoft Online Support
| | >
| | > Microsoft Global Technical Support Center
| | >
| | > Get Secure! - www.microsoft.com/security
| | > ================================================== ===
| | > When responding to posts, please "Reply to Group" via your newsreader
| so
| | > that others may learn and benefit from your issue.
| | > ================================================== ===
| | > This posting is provided "AS IS" with no warranties, and confers no
| rights.
| | >
| | > --
| | > | Date: Wed, 27 Jun 2007 19:43:26 -0400
| | > | From: Jim Helfer <JimHelfer@.newsgroup.nospam>
| | > | User-Agent: Thunderbird 2.0.0.4 (Windows/20070604)
| | > | MIME-Version: 1.0
| | > | Subject: Can't update default instance of SQL 2000 to SP4. Not
| recognized.
| | > | Content-Type: text/plain; charset=ISO-8859-1; format=flowed
| | > | Content-Transfer-Encoding: 7bit
| | > | Message-ID: <OwVO2TRuHHA.4972@.TK2MSFTNGP05.phx.gbl>
| | > | Newsgroups: microsoft.public.sqlserver.server
| | > | NNTP-Posting-Host: wtwarch.com 66.212.142.243
| | > | Lines: 1
| | > | Path:
TK2MSFTNGHUB02.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSF TNGP05.phx.gbl
| | > | Xref: TK2MSFTNGHUB02.phx.gbl microsoft.public.sqlserver.server:19220
| | > | X-Tomcat-NG: microsoft.public.sqlserver.server
| | > |
| | > | I have a SQL server 2000 server with two instances running. One
the
| | > | default, one named.
| | > |
| | > | I tried to upgrade the server to SP4, and I was prompted to
choose
| | > | which instance to upgrade. I chose the default.
| | > |
| | > | SP4 refused to upgrade the default instance with this message:
| | > |
| | > | "MSSQLSERVER is not a SQL Server 2000 instance."
| | > |
| | > | Stranger, it had no problems upgrading the named instance.
| | > |
| | > | I can't find anything about this in the MSKB and I'm a bit of a
| babe
| | > | in the wood when it comes to SQL Server.
| | > |
| | > | The default instance runs our new accounting server, so 'd sure
| like
| | > | to get it up to date. Thanks for any ideas.
| | > |
| | > |
| | > | --
| | > | Jim Helfer
| | > | Computer Systems Administrator
| | > | WTW Architects
| | > | Timber Court
| | > | 127 Andesron St.
| | > | Pittsburgh PA 15212
| | > | 412-321-0551 x330
| | > | jhelfer@.wtwarch.com
| | > |
| | >
| |
|
|
|||Hello,
I am running into a different issue and I am unable to resolve it. Here
is what happened:
1- I had SQLServer 2000 Client Tools installed on my laptop
2- I installed SQLServer 2005 on the laptop.
3- In order to be able to edit DTS components from SSIS I installed the
DTS Designer Components from the SQL 2005 Feature Pack :
SQLServer2005_DTS.msi
4- Once that is installed, I tried to run SQL Enterprise Manager and now
it can not run. the error message is:
"The procedure entry point ?processExecute@.@.YAXPAUHWND__@.@.PBG1@.Z could
not be located in the dynamic link library SEMSFC.dll"
5- Looking at different website people who encountered this issue
installed SQL2000 Server SP 4 and that fixed it for them.
6- However, when I try to install SP4 I can't figure out how to provide
the instance SA password since I don't believe I have one installed
since this is not the database engine server.
Do you have any suggestions or a solution so that I can run EM again?
Thanks.
*** Sent via Developersdex http://www.codecomments.com ***