I know that SQL SERVER is by default case insensitive but all my searches are case sensitive.....I also tried the ALTER DATABASE COLLATE ..... Still no luck...Please help!!!!
thanks in advance,
jPlease clarify: do you mean that SQL server is using case-sensitive searches despite the default, or do you mean that you WANT all your searches to be case-sensitive?
blindman
Showing posts with label default. Show all posts
Showing posts with label default. Show all posts
Tuesday, March 27, 2012
Case Sensitivity on a non case sensitive DB
Hi,
I'm running into an issue with case sensitivity. Here is the setup: I have
SQL Server instance that is CS AS by default. Create new database that is
CI AS. Run a file of SQL against this database to create triggers and get
an error on a variable name in one of the triggers. The variable is
declared as @.szName but used as @.szname. I would have thought that since
this is a trigger on the CI database that it would not matter but the
trigger create must somehow interact with Master or MSDB and since they are
CS this causes a problem? Any options on how to easily make this go away
other than the obvious - changing all triggers (and I would guess stored
procedure code as well). Thanks in advance for any help.
Wayne Antinore> SQL Server instance that is CS AS by default. Create new database that is
> CI AS.
I think you should decide to either (a) use CS only or CI only or (b) use a
different instance for CI. Just wait until you start doing any work that
requires tempdb... you will get collation conflicts all over the place.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Thanks Aaron,
Yikes! Never even got into using tempdb yet. I can only imagine what I
would come across there.
Thanks again,
Wayne
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23rGSiMsBEHA.1380@.TK2MSFTNGP10.phx.gbl...
is
> I think you should decide to either (a) use CS only or CI only or (b) use
a
> different instance for CI. Just wait until you start doing any work that
> requires tempdb... you will get collation conflicts all over the place.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
I'm running into an issue with case sensitivity. Here is the setup: I have
SQL Server instance that is CS AS by default. Create new database that is
CI AS. Run a file of SQL against this database to create triggers and get
an error on a variable name in one of the triggers. The variable is
declared as @.szName but used as @.szname. I would have thought that since
this is a trigger on the CI database that it would not matter but the
trigger create must somehow interact with Master or MSDB and since they are
CS this causes a problem? Any options on how to easily make this go away
other than the obvious - changing all triggers (and I would guess stored
procedure code as well). Thanks in advance for any help.
Wayne Antinore> SQL Server instance that is CS AS by default. Create new database that is
> CI AS.
I think you should decide to either (a) use CS only or CI only or (b) use a
different instance for CI. Just wait until you start doing any work that
requires tempdb... you will get collation conflicts all over the place.
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||Thanks Aaron,
Yikes! Never even got into using tempdb yet. I can only imagine what I
would come across there.
Thanks again,
Wayne
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:%23rGSiMsBEHA.1380@.TK2MSFTNGP10.phx.gbl...
is
> I think you should decide to either (a) use CS only or CI only or (b) use
a
> different instance for CI. Just wait until you start doing any work that
> requires tempdb... you will get collation conflicts all over the place.
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
Monday, March 19, 2012
Cascading Parameters with no default
Let's say I have 3 dropdown Sites->Depts->Areas
Each ones have their dataset, and use from query.
How can I only have Sites with a default and not Depts?
If Sites has a default, it populates Depts automatically with values and
<Select a value>. That's fine. But in order to make the report work, I also
have to put a default to Depts so Areas gets something with <Select a value>
otherwise I get an error "The value provided for the report parameter
'AreaId' is not valid for its type".
I don't want that, I want something like this:
Sites Depts Areas
<Site A> <Select a value> <Select a value>
ThanksHello joe,
When you use the Cascading Parameters, how you query for the Areas?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.|||From query.
"Wei Lu [MSFT]" wrote:
> Hello joe,
> When you use the Cascading Parameters, how you query for the Areas?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> 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.
>|||hello,
I would like to get your query.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.|||Sites
--
ALTER PROCEDURE [dbo].[repGetSites]
(
@.parentid int=null
)
AS
BEGIN
SET NOCOUNT ON;
-- Insert statements for procedure here
if @.parentid is null
Select * from sites
else
Select * from sites where parentid=@.parentid
END
Depts
--
ALTER PROCEDURE [dbo].[repGetDepts]
(
@.siteid int=null
)
AS
BEGIN
SET NOCOUNT ON;
if @.siteid is null
Select DeptId,DeptName,parentid from Departments
else
Select DeptId,DeptName,parentid from Departments where parentid=@.siteid
END
Areas
--
ALTER PROCEDURE [dbo].[repGetAreas]
(
@.parentid int=null
)
AS
BEGIN
SET NOCOUNT ON;
if @.parentid is null
select Null as AreaId,'Any' as AreaName
union
Select AreaId,AreaName from Areas
else
if exists(Select AreaId,AreaName from Areas where parentid=@.parentid)
select Null as AreaId,'Any' as AreaName
union
Select AreaId,AreaName from Areas where parentid=@.parentid
else
select Null as AreaId,'Any' as AreaName
END
Parameters definition
--
<ReportParameter Name="siteid">
<DataType>Integer</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>Sites</DataSetName>
<ValueField>SiteId</ValueField>
</DataSetReference>
</DefaultValue>
<Prompt>Site:</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>Sites</DataSetName>
<ValueField>SiteId</ValueField>
<LabelField>SiteName</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
<ReportParameter Name="deptid">
<DataType>Integer</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>Departments</DataSetName>
<ValueField>DeptId</ValueField>
</DataSetReference>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Department:</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>Departments</DataSetName>
<ValueField>DeptId</ValueField>
<LabelField>DeptName</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
<ReportParameter Name="Areaid">
<DataType>Integer</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>Area:</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>Areas</DataSetName>
<ValueField>AreaId</ValueField>
<LabelField>AreaName</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
By the way, is there any way I can change the layout of how Parameters are
displayed?
Thanks for your help. Much appreciated.
"Wei Lu [MSFT]" wrote:
> hello,
> I would like to get your query.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> 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.
>|||Hello Joe,
I tested on my side.
The report server could not valid for the third cascading parameter if the
second one did not have default value.
Also, why your Area dataset is using the @.parentId parameter?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.|||Yes Wei, each parameter in the chain must get a valid param from previous.
The thing is why the report engine is not letting the user doing the
selection one at the time? It is so common behaviour!! You select one value
from first dropdown (parent), the second dropdown(child) gets the param
value, execute the query and populate its list. You select a value from
second dropdown(parent for third dropdown), the third dropdown(child) gets
the param value, execute the query and populate its list. You select a value
from third dropdown and there you go, report generates! I can't imagine that
it is not feasible! What a big flaw it is if we can't do it! I will have to
use the ReportViewer Web Control and handle this myself and pass the
parameters to the report and I don't like that. Reporting Services is
suppose to save me time... well... it is not.
I am surprised not seeing many posts complaining about that. Anyway I do.
Not counting the fact that we cannot disposed the parameters the way we want
on that toolbar...
About the Area parent id, it is there because I reused the query from
something else.
> ==================================================> 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.
>|||Hello, Joe
Please submit your idea to the http://connect.microsoft.com/sqlserver.
The product team would monitor this issue.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.
Each ones have their dataset, and use from query.
How can I only have Sites with a default and not Depts?
If Sites has a default, it populates Depts automatically with values and
<Select a value>. That's fine. But in order to make the report work, I also
have to put a default to Depts so Areas gets something with <Select a value>
otherwise I get an error "The value provided for the report parameter
'AreaId' is not valid for its type".
I don't want that, I want something like this:
Sites Depts Areas
<Site A> <Select a value> <Select a value>
ThanksHello joe,
When you use the Cascading Parameters, how you query for the Areas?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.|||From query.
"Wei Lu [MSFT]" wrote:
> Hello joe,
> When you use the Cascading Parameters, how you query for the Areas?
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> 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.
>|||hello,
I would like to get your query.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.|||Sites
--
ALTER PROCEDURE [dbo].[repGetSites]
(
@.parentid int=null
)
AS
BEGIN
SET NOCOUNT ON;
-- Insert statements for procedure here
if @.parentid is null
Select * from sites
else
Select * from sites where parentid=@.parentid
END
Depts
--
ALTER PROCEDURE [dbo].[repGetDepts]
(
@.siteid int=null
)
AS
BEGIN
SET NOCOUNT ON;
if @.siteid is null
Select DeptId,DeptName,parentid from Departments
else
Select DeptId,DeptName,parentid from Departments where parentid=@.siteid
END
Areas
--
ALTER PROCEDURE [dbo].[repGetAreas]
(
@.parentid int=null
)
AS
BEGIN
SET NOCOUNT ON;
if @.parentid is null
select Null as AreaId,'Any' as AreaName
union
Select AreaId,AreaName from Areas
else
if exists(Select AreaId,AreaName from Areas where parentid=@.parentid)
select Null as AreaId,'Any' as AreaName
union
Select AreaId,AreaName from Areas where parentid=@.parentid
else
select Null as AreaId,'Any' as AreaName
END
Parameters definition
--
<ReportParameter Name="siteid">
<DataType>Integer</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>Sites</DataSetName>
<ValueField>SiteId</ValueField>
</DataSetReference>
</DefaultValue>
<Prompt>Site:</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>Sites</DataSetName>
<ValueField>SiteId</ValueField>
<LabelField>SiteName</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
<ReportParameter Name="deptid">
<DataType>Integer</DataType>
<DefaultValue>
<DataSetReference>
<DataSetName>Departments</DataSetName>
<ValueField>DeptId</ValueField>
</DataSetReference>
</DefaultValue>
<AllowBlank>true</AllowBlank>
<Prompt>Department:</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>Departments</DataSetName>
<ValueField>DeptId</ValueField>
<LabelField>DeptName</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
<ReportParameter Name="Areaid">
<DataType>Integer</DataType>
<Nullable>true</Nullable>
<AllowBlank>true</AllowBlank>
<Prompt>Area:</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>Areas</DataSetName>
<ValueField>AreaId</ValueField>
<LabelField>AreaName</LabelField>
</DataSetReference>
</ValidValues>
</ReportParameter>
By the way, is there any way I can change the layout of how Parameters are
displayed?
Thanks for your help. Much appreciated.
"Wei Lu [MSFT]" wrote:
> hello,
> I would like to get your query.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================> 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.
>|||Hello Joe,
I tested on my side.
The report server could not valid for the third cascading parameter if the
second one did not have default value.
Also, why your Area dataset is using the @.parentId parameter?
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.|||Yes Wei, each parameter in the chain must get a valid param from previous.
The thing is why the report engine is not letting the user doing the
selection one at the time? It is so common behaviour!! You select one value
from first dropdown (parent), the second dropdown(child) gets the param
value, execute the query and populate its list. You select a value from
second dropdown(parent for third dropdown), the third dropdown(child) gets
the param value, execute the query and populate its list. You select a value
from third dropdown and there you go, report generates! I can't imagine that
it is not feasible! What a big flaw it is if we can't do it! I will have to
use the ReportViewer Web Control and handle this myself and pass the
parameters to the report and I don't like that. Reporting Services is
suppose to save me time... well... it is not.
I am surprised not seeing many posts complaining about that. Anyway I do.
Not counting the fact that we cannot disposed the parameters the way we want
on that toolbar...
About the Area parent id, it is there because I reused the query from
something else.
> ==================================================> 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.
>|||Hello, Joe
Please submit your idea to the http://connect.microsoft.com/sqlserver.
The product team would monitor this issue.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
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.
Sunday, March 11, 2012
Cascading Parameter issue with RS2005... It worked in RS2000
Our company is attempting to convert several RS2000 reports to RS2005. We have 4 default parameters on every report.
1) Date Range (dropdown) – populated via Non-Queried Available values (Ex. Today, Week to Date, Month to Date, Fiscal Period)
2) Fiscal Period (cascading dropdown) – populated via Query Available values (if Date Range = ‘Fiscal Period’, select the last 24 fiscal months, else select Date Range value)
3) Start Date (cascading textbox) – populated via Query Default values (depending on Fiscal Period value calculate Start Date)
4) End Date (cascading textbox) – populated via Query Default values (depending on Fiscal Period value calculate End Date)
The user starts by selecting a Date Range which auto populates the Fiscal Period the auto populates the 2 Date textboxes. This works great in RS2000; however it’s not 100% in RS2005. Here’s what happens:
If a user selects ‘Today’ or ‘Month to Date’ in Date Range, everything works fine. At this point there is only 1 value in Fiscal Period dropdown. If the user selects ‘Fiscal Period’ in the Date Range, the Fiscal Period is populated with 24 values (1 for the last 24 fiscal months) and is set to the top value (June – 2006). The 2 Date textboxes are also populated correctly.
The problem is when the user changes the value in the Fiscal Period dropdown. Let's say the pick 'Mar - 2004'. The 2 Date fields are not refreshed or updated. If the user changes the selection back in the first dropdown (Date Range), everything is refreshed and updated appropriately. I don’t under stand why the first dropdown will refresh all the dependent parameters but the second dropdown won’t refresh the 2 Date fields below it?
Any input would be very helpful. I’ve tested this on 3 different development boxes and 2 different RS2005 servers. All tests had the same results.
Thanks,
Nick
Any ideas why this thing works in RS2000, but not in RS2005? Any input would be valued. Thanks,
Nick
Friday, February 24, 2012
Capture time alone in SQL Server database
Is there any data type in SQL Server 2005 which captures only the TIME in default DATETIME type?
For example, if the datatime field has a value2007-12-11 12:31:00.000, i need a datatype which can capture12:31:00.000 alone. The data type should be in a fashion so that i can find differences in time also...
Any ideas??
Hi,
SQL Server does not have any type which can store only time. One way is to store it as datetime, and when fetching these times, you can convert them to only show time.
|||
venkatesh_ur:
Is there any data type in SQL Server 2005 which captures only the TIME in default DATETIME type?
I'm afraid there is no Datatype to fetch the time only. But of course there are some functions that can be used to get the time part out of any datatime value. Below query will get you the time (converted as varchar):
select getdate() , convert ( varchar , getdate() , 8 )
he data type should be in a fashion so that i can find differences in time also...
To compare date and time values theDatepartandDateNamefunctions can be useful. They both are quite similar to each other. Read Books Online for more help on these functions.
Sunday, February 12, 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/...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)