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 ***
