MSDE SP4 Install problems - invalid instance name

Hi,
Seen this question posted in several places, but none of the fixes stated
have done the trick. I'm trying to patch several MSDE instances installed by
Sharepoint. Instance names are SHAREPOINT.All three instances are installed
on W2k3 Servers. When I run the install from the cmd prompt, I use:
<install Dir>\setup /upgradesp sqlrun INSTANCENAME=SHAREPOINT /L*v
c:\MSDELog.log
I have also tried
<install Dir>\setup /upgradesp sqlrun INSTANCENAME=SHAREPOINT
DISABLENETWORKPROTOCOLS=0 /L*v c:\MSDELog.log
Same thing happens. I get an errors that states:"The instance name specified
is invalid". I know this to be untrue - I can query the databases in it
using SQL Client tools (Query analyser)
I've checked out the install package that was used in the registry(
HKEY_CLASSES_ROOT\Installer\Products\95C756568A324 7948B0EAB40BE0DE4F4\SourceList)
which suggests SQLRUN16.msi was used for the install. As this is the case,
all the documentation says I can use SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE
for the installation. However, it still fails.
I have also had to install SP4 onto several instances created by the MS CRM
Outlook client. To do this I have used the following cmd in the cmd prompt:
<install Dir>\setup /upgradesp sqlrun INSTANCENAME=CRM /L*v c:\MSDELog.log
This works perfectly.However, I cannot do this on any of my SHAREPOINT
Instances.
Can anyone assist please?
Many Thanks
John
hi John,
John wrote:
> Hi,
> Seen this question posted in several places, but none of the fixes
> stated have done the trick. I'm trying to patch several MSDE
> instances installed by Sharepoint. Instance names are SHAREPOINT.All
> three instances are installed on W2k3 Servers. When I run the install
> from the cmd prompt, I use:
from the sp4 readme file,
"MSDE 2000 SP4 updates instances of SQL Server 2000 MSDE 2000 and MSDE 2000
Release A. "
Share Point installs a different version of MSDE, known as WMSDE where some
intrinsic MSDE limits has been removed (2gb data file per database) in order
to fullfill Share Point needs and requirements...
so, in my understanding, I think you have to get the new WMSDE package to
upgrade your Share Point instances...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea
First of all, many thanks for the reply. Could you post a URL to where I can
download the new WMSDE Patch? I've searched, but all I could find was a
Critical Update and a service pack for Sharepoint. Do I need to install the
who service pack? I thought I had already done that, and my SMS 2003 is not
telling me that the Service Pack is required, only the msde instance
requires updating
Many Thanks
Regards,
John
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3h8f6oFfh31iU1@.individual.net...
> hi John,
> John wrote:
> from the sp4 readme file,
> "MSDE 2000 SP4 updates instances of SQL Server 2000 MSDE 2000 and MSDE
> 2000 Release A. "
> Share Point installs a different version of MSDE, known as WMSDE where
> some intrinsic MSDE limits has been removed (2gb data file per database)
> in order to fullfill Share Point needs and requirements...
> so, in my understanding, I think you have to get the new WMSDE package to
> upgrade your Share Point instances...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
|||hi John,
John wrote:
> Hi Andrea
> First of all, many thanks for the reply. Could you post a URL to
> where I can download the new WMSDE Patch? I've searched, but all I
> could find was a Critical Update and a service pack for Sharepoint.
> Do I need to install the who service pack? I thought I had already
> done that, and my SMS 2003 is not telling me that the Service Pack is
> required, only the msde instance requires updating
>
unfortunately I'm not a Share Point guy... have you tried asking in its NG
hyerarchy?
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea. Thanks for all your help, I'll try there.
Regards,
John
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:3hb3r4Fg7op9U1@.individual.net...
> hi John,
> John wrote:
> unfortunately I'm not a Share Point guy... have you tried asking in its NG
> hyerarchy?
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.12.0 - DbaMgr ver 0.58.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>