I am trying to use a case statement to pull bad phone numbers out of my
company table into a readable format. I am using SQL Server 2000 SP4.
The phone numbers, in my inherited database, are in any number of formats,
not complete, etc, and I need to pull a report showing only the good phone
numbers.
My Case statement returns the error below the statement.
-- SELECT SUBSTRING((RTRIM(phone) + ' '+
RTRIM(phone) + ' '), 1, 25) AS Name, phone,
Phone =
CASE
WHEN SUBSTRING(phone, 1, 2) > len(10) THEN 'Phone'
WHEN SUBSTRING(phone, 1, 2) < len(10) THEN 'Phone'
END
FROM company
Server: Msg 245, Level 16, State 1, Line 1
Syntax error converting the varchar value '+(' to a column of data type int.
RayRay wrote on Fri, 11 Nov 2005 07:05:07 -0800:
> I am trying to use a case statement to pull bad phone numbers out of my
> company table into a readable format. I am using SQL Server 2000 SP4.
> The phone numbers, in my inherited database, are in any number of formats,
> not complete, etc, and I need to pull a report showing only the good phone
> numbers.
> My Case statement returns the error below the statement.
> -- SELECT SUBSTRING((RTRIM(phone) + ' '+
> RTRIM(phone) + ' '), 1, 25) AS Name, phone,
> Phone =
> CASE
> WHEN SUBSTRING(phone, 1, 2) > len(10) THEN 'Phone'
> WHEN SUBSTRING(phone, 1, 2) < len(10) THEN 'Phone'
> END
> FROM company
> Server: Msg 245, Level 16, State 1, Line 1
> Syntax error converting the varchar value '+(' to a column of data type
> int.
SUBSTRING(phone, 1, 2) > len(10) is the problem
This takes the first 2 characters of the phone column, and compares it to
the length of the string '10' (implicit conversion of the LEN expression to
a string). The first 2 characters are '(+', and due to implicit conversion
will try to convert that to an integer to compare to the value 2.. What
exactly are you trying to achieve here? It makes no sense.
Dan|||I am trying to pull good phone numbers from a list of bad numbers.
For Example:+ () -
+ () -3681
+ () -8544
+ () ?
+ () ?
+ () 0-+00-00
+ () 0-00
+ () 0-00
+ () 0-00--00
+ () 0-00-00
+ () 0-00-00
+ () 0-00-00
+ () 0-00-00
+ () 0-00-00
+ () 0-00-00
+ () 0-00-00
+ () 0-00-00
+ () 0-00-000
+ () 00-000
+ () 011-1-4756-6900
+ () 011-234-1266-89
+ () 011-2711-320-50
+ () 011-2711-377-38
+ () 011-322-545-252
+ () 011-331-4323-20
+ () 011-358-013360
+ () 011-418-643-307
+ () 011-44-002-7551
+ () 011-45-4468-446
+ () 011-468-719-500
+ () 011-495-254-991
+ () 011-603-707-449
+ () 011-612-4655-24
I inhereted this database from someone who just put stuff in anyway they
wanted. Now I need to pull out the ones formatted corrected so they can be
inputted into a new system.
Ray
"Daniel Crichton" wrote:
> Ray wrote on Fri, 11 Nov 2005 07:05:07 -0800:
>
> SUBSTRING(phone, 1, 2) > len(10) is the problem
> This takes the first 2 characters of the phone column, and compares it to
> the length of the string '10' (implicit conversion of the LEN expression t
o
> a string). The first 2 characters are '(+', and due to implicit conversion
> will try to convert that to an integer to compare to the value 2.. What
> exactly are you trying to achieve here? It makes no sense.
> Dan
>
>|||Ray wrote on Fri, 11 Nov 2005 07:39:16 -0800:
> I am trying to pull good phone numbers from a list of bad numbers.
Sorry, I guess I wasn't being clear enough. From the SELECT statement you
provided I can't figure out what you're trying to do. I can only guess that
you're looking for strings of at least 10 characters after the +( at the
start, but as to what you want returned it makes no sense - why would you
display the first 25 characters of the phone number concatentated to itself
as the name column, and then show the phone number again as phone, and then
appear to just put the string 'Phone' into another column called Phone? A
long list of numbers doesn't explain anything. What is a well formatted
phone number? None of those I would consider well formatted, but then again
I'm a UK resident and we have a different number format here.
Dan|||Daniel Crichton wrote:
> Ray wrote on Fri, 11 Nov 2005 07:39:16 -0800:
>
> Sorry, I guess I wasn't being clear enough. From the SELECT statement
> you provided I can't figure out what you're trying to do. I can only
> guess that you're looking for strings of at least 10 characters after
> the +( at the start, but as to what you want returned it makes no
> sense - why would you display the first 25 characters of the phone
> number concatentated to itself as the name column, and then show the
> phone number again as phone, and then appear to just put the string
> 'Phone' into another column called Phone? A long list of numbers
> doesn't explain anything. What is a well formatted phone number? None
> of those I would consider well formatted, but then again I'm a UK
> resident and we have a different number format here.
Another idea thrown into the mix: write a user defined function that
either maps a given phone number to a valid one or maps phone numbers to
something like "ok", "maybe", "crap". Then you can easily select
your_function(phone) = 'ok'.
Kind regards
robert
Showing posts with label sp4. Show all posts
Showing posts with label sp4. Show all posts
Thursday, March 29, 2012
Sunday, February 12, 2012
can't upgrade msde sp4
i'm trying to upgrade to sp4 using the following command:
<setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
UPGRADEPWD=password /L*v C:\MSDELog.log>
it starts, then stops, without giving me an error.
Please help!!
hi,
ak9408 wrote:
> i'm trying to upgrade to sp4 using the following command:
> <setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
> UPGRADEPWD=password /L*v C:\MSDELog.log>
> it starts, then stops, without giving me an error.
> Please help!!
inspect the C:\MSDELog.log text file for
RETURN VALUE 3
entries... about 10 lines before each entry some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
<setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
UPGRADEPWD=password /L*v C:\MSDELog.log>
it starts, then stops, without giving me an error.
Please help!!
hi,
ak9408 wrote:
> i'm trying to upgrade to sp4 using the following command:
> <setup /upgradesp sqlrun SECURITYMODE=SQL UPGRADEUSER=username
> UPGRADEPWD=password /L*v C:\MSDELog.log>
> it starts, then stops, without giving me an error.
> Please help!!
inspect the C:\MSDELog.log text file for
RETURN VALUE 3
entries... about 10 lines before each entry some (sometime cryptic)
description of the problem will be reported..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.18.0 - DbaMgr ver 0.62.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
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 ***
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 ***
Friday, February 10, 2012
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
| | > |
| | >
| |
|
|
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 ***
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 ***
Subscribe to:
Posts (Atom)