Error While Upgrading From MSDE 2000 SP3 To SP4

May 15, 2008

Having some trouble running the SP4 upgrade on a MSDE 2k named instance.Its working for one instance but give me error for the second instance.

- MSDE 2k sp3 currently installed
- Windows XP Pro
- Non-null SA pw
- Executing setup.exe /UpgradeSP SQLRUN


The install runs for a bit and then disappears. Here's what the very
bottom of the log reads:

=== Logging stopped: 08/05/15 11:44:29 ===
MSI (c) (64:F8) [11:44:29:698]: Note: 1: 1729
MSI (c) (64:F8) [11:44:29:698]: Product: Microsoft SQL Server Desktop Engine -- Configuration failed.

MSI (c) (64:F8) [11:44:29:713]: Grabbed execution mutex.
MSI (c) (64:F8) [11:44:29:713]: Cleaning up uninstalled install packages, if any exist
MSI (c) (64:F8) [11:44:29:713]: MainEngineThread is returning 1603
=== Verbose logging stopped: 08/05/15 11:44:29 ===


the only other error I can see is this:

Action start 11:44:29: RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B.
MSI (s) (A8:B4) [11:44:29:651]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI19E.tmp, Entrypoint: RestoreSetupParams
SOFTWAREMicrosoftMicrosoft SQL Server Setup.{FE7E950B-220A-4182-B5CA-19397244DCFD}
Entering Function MyMsiEvaluateCondition
MsiEvaluateCondition for SQLMSDEInstalled returned TRUE
End Function MyMsiEvaluateCondition
Error reading setup parameters
Action ended 11:44:29: RestoreSetupParams.2D02443E_7002_4C0B_ABC9_EAB2C06 4397B. Return value 3.
Action ended 11:44:29: INSTALL. Return value 3.

SYNTAX Used is : setup.exe /upgradesp sqlrun INSTANCENAME= SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=MyPwd BLANKSAPWD=1 /L*v D:MSDE.log

Please note that I am using BLANKSAPWD=1 because BUILTINAdministrators right is not present, the above syntax is working for one named instance but is failing in second named instance.:eek:

I'll post the full log if that helps. Any ideas?

Thanks,
Onkar

View 10 Replies


ADVERTISEMENT

Upgrading MSDE 2000 To SQL 2005 Standard

Apr 10, 2007

Does anyone know of a resource that describes the steps to upgrade an instance of MSDE(2000) to SQL 2005 Standard?



We found something on a MS site that indirectly indicated you could upgrade the MSDE to SQL Express and then upgrade Express to the full version of 2005, but that method created quite a bit of problems(System databases), which we were not able to resolve short of uninstalling MSDE and the apps and installing SQL 2005 and re-installing the apps; but I have to believe there is a better way.



Thanks! Bob McEuen

View 4 Replies View Related

Problems Upgrading Msde 2000 To SQL Express 2005

Apr 4, 2007

I am having issues trying to do an in place upgrade of msde 2000 to sql express 2005. When I try to upgrade it bombs when it reaches "Running action to shutdown instance(Run As Normal User)" with the following error:
Service 'computername' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386).
I've tried an upgrade on a clean test machine, and it goes through without any problems. I am logged into an account with local admin permissions. If any one has any ideas, they would be appreciated.

View 1 Replies View Related

Error Upgrading MSDE (SP3) To SP4

Jun 13, 2006

I am trying to upgrade my MSDE 2000 (SP3)to SP4, but it is giving an error of "invalid instance".

Here is what is on the machine (before running any commands):

I do not see any SQL Server installation on my machine under Start-All Programs. But, I have a directory for SQL Server under:
C:Program FilesMicrosoft SQL ServerMSSQL

The sqlserver.exe is in C:Program FilesMicrosoft SQL ServerMSSQLBinn and version = 2000.80.760.0

To upgrade MSDE 2000 (SP3) to MSDE SP4, I downloaded this file from Microsoft's website: SQL2000.MSDE-KB884525-SP4-x86-ENU.EXE

I ran the above .exe and extracted the files on my hard drive. Now, I have the C:SQL2KSP4MSDE directory and the Setup.exe is in the MSDE directory.

I looked in the services and stopped the following service:
MSSQLSERVER

Now, I ran this command:

setup SAPWD="ourpassword" SECURITYMODE=SQL
/L*v C:MSDELog.log

This came with the error - Invalid Instance

I tried running:
setup /upgradesp sqlrun /L*v C:MSDELog.log
This command ran and did not show any error. I then rebooted the machine, checked that the MSSQLSERVER service is running and checked the version of sqlserver.exe but it was still the same (2000.80.760.0). It should have been 8.00.2039

I am not sure what am I missing. All I want to do is update the MSDE Service Pack on our company machines to SP4.

Please help !

View 6 Replies View Related

Error Upgrading Sql 2000 To Sql 2005

Dec 5, 2007



We are in the process of going through all test steps for upgrading one of our servers with SQL 2000 to SQL 2005. Currently Server 2000, which we will be upgrading as well after SQL is upgraded and running properly. We have Reporting Services installed as well. I am using a test server which is an exact mirrored image of the live server but is not added to the domain.

I am going through the steps of selecting the components, selecting the instance, and then selecting the installed components I want to upgrade (SQL Server 8.0.??? and Reporting Services 8.0.???) and click next.

The upgrade analysis begins. Everything is ok through the SQL Server analysis but when I click next to start the upgrade analysis on Reporting Services I get this error message, "SQL Server Setup requires administrator permissions for the upgraded SQL Server instance. To continue, log in with an administrator account." I am logged in as the local admin which should have the required permissions to upgrade Reporting Services, plus the local admin was ok for the SQL Server upgrade anaylis

I have no idea what could be causing this permissions issue. I did run the SQL 2005 Updrade Analyzer utility and performed all the "before" steps. What could be the issue?

View 2 Replies View Related

Upgrading MSDE With SP4

May 3, 2006

Hi,

I'm trying to upgrade MSDE with SP4.

I used the following in command prompt.

setup /upgradesp sqlrun INSTANCENAME= MSDE1 SECURITYMODE=SQL
UPGRADEUSER=sa UPGRADEPWD=12345678 /L*v C:MSDELog.log

i got the message "Please go the control panel to install and configure system components."

What does it mean?

How to upgrade it?

Thank U!

View 4 Replies View Related

Upgrading To SQL2000 From MSDE 1.0, Sp2

Mar 28, 2002

I'm confused. Will SQL200 run on NT4.0, SP6a or do I need to upgrade to Microsoft Server 2000 first??? My MSDE is dying...

View 1 Replies View Related

Upgrading Multiple Msde Instances

Nov 4, 2005

Himy first post in the data access forums, I really hope, someone can enlighten me here...I have a windows server 2003 running with 15 MSDE instances. No I would like to upgrade to SQL Server 2000 without crashing the existing instances... My perfect scenario woudl be- install sql server as new instance- move existing databases via detach / attach to the new instanceWill that work?

View 2 Replies View Related

Ot: Upgrading Msde To SQL Server 2005 Express Edition

Nov 7, 2005

has anybody tried to do that yet? any experiences? how-tos?

View 3 Replies View Related

Trouble Upgrading An MSDE 1.0 Engine To SQL Express 2005

Jul 13, 2006

I am creating an install for our product and as part of the changes I
am making, I want to upgrade a user's DB engine, if they are still
using MSDE 1.0, to SQL Express 2005.



The upgrade path we have chosen is the following.....

MSDE 1.0 --> MSDE 1.0 sp4 --> SQL Express 2005



I believe this should work, yes? Anywho, I am trying to run a
"passive" install of SQL Express and I am using the following parameter
list:



/qb
UPGRADE=SQL_Engine INSTANCENAME=MSSQLSERVER ADDLOCAL=ALL
DISABLENETWORKPROTOCOLS=0 SECURITYMODE=SQL SQLAUTOSTART=1
SQLBROWSERAUTOSTART=1 SQLACCOUNT="NT AUTHORITYSYSTEM"
SQLBROWSERACCOUNT="NT AUTHORITYSYSTEM"



When SQL Express is installing, everything installs properly except the
backward compatibility component....any idea why this is happening?



I'm certain that some of the above parameters (in red) are wrong because if I install all the engines (above in blue) manually then it all works.





Thanks

View 1 Replies View Related

Upgrading Localized MSDE-server To The English Version Of SQL Server Express 2005?

Aug 6, 2007

Hello,

at the moment I have the following problem:
We have installed a version of the MSDE 2000 Sp3 with our software since 2005. Now we install SQL Server Express 2005 in order to use the latest version and to be compatible with Vista.
We have never had any problems with the MSDE, so it was no problem that we installed the german version (by mistake) because there never was any output at installation time.
When we now upgrade the existing MSDE installing the new version of our software, there are often problems and there are error messages, unfortunately in german, which cannot be read by most of our international users.

The problem is, that there seems to be no possibility to upgrade the existing (german) MSDE with the english version of SQL Server Express 2005.
My question is, if it is possible to upgrade the german MSDE to the english SQL Server 2005 to enable our international users to read the error messages at installation time in english?

Thanks in advance.

Best regards,
Peter

View 4 Replies View Related

How Do SQL 2000 Service Packs Play A Role In Upgrading?i.e.Can SQL 2000 Standard With No SP Be Upgraded To SQL 2005 Standard

Aug 2, 2006

How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??

View 1 Replies View Related

Upgrading From Sql 7 To 2000

Jul 18, 2001

Has anyone attempted an upgrade from sql7 to 2000? is it a difficult process? what happens to the users. Is there a good site i can go to to get this info ?

Thanks in advance

View 1 Replies View Related

Upgrading From 7.0 To 2000

Feb 13, 2002

Anyone know of any issues I should be aware of when upgrading from sql 7.0 to 2000? Is it a problematic proccess?

liz

View 2 Replies View Related

Upgrading To SQL 2000

Apr 19, 2002

We are currently still running SQL6.0 on NT4 server, and we want to upgrade to SQL2000. My question: how easy is it to upgrade from SQL6.0 to SQL2000?

View 3 Replies View Related

Upgrading SQL 7 To SQL 2000

Nov 2, 2001

Currently running SQL Server 7, and have databases. I want to upgrade to SQL Server 2000. How can achieve it without delete or losing my databases. This is NOT a production server, BUT I still want to keep my databases. Ideally I would like to uninstall and reinstall so that there are no SQL Server 7 files lying around when I have SQL 2000 running. Thanks.

View 1 Replies View Related

Upgrading V7.0 To 2000

Dec 3, 2004

Hi,

We are trying to upgrade from SQL Server v7.0 to SQL Server 2000. Here's our set up,

Current Server: Win NT, SQL Server v7.0
New Server : Win 2000, SQL Server 2000
Client (my PC): Win XP, SQL Server 2000

The New Server is designated SQL Server machine -- company-wide. That is, all the apps/projects uses this machine as the SQL Server. It only has one instance of SQL Server running.

Different project are assigned a dedicated 'Drive' (logical only) and allocated certain disk size as the work space. We (my team) will be the new entry for this server.

Q: When doing the Copy Wizard (from my PC) to upgrade/copy the existing v7.0 db (from Current Server) to New SQL Server 2000, do I need to specify the physicall 'Data' folder? Or, can I copy the database to the selected path -- which is my dedicated drive?

Thanks in Advance.

_msd_

View 1 Replies View Related

Upgrading From 7.0 To 2000

Oct 3, 2006

Have an old PII server running Windows 2000 and SQL 7.0.



We just got a new box, Windows 2003 and SQL 2000.



Is there some kind of upgrade advisor or anything for me to read so I can prepare for this upgrade?



I'm most curious about how to properly transfer my data from the old box to the new.



View 1 Replies View Related

Upgrading SQL 7 Cluster TO SQL 2000 ?

Mar 30, 2004

I am currently running an active/passive cluster NT4 with SQL7 clustered. I am trying to upgrade SQL to a clustered 2000 version. I have a san disk area allocated as a Z: drive. These are the following steps I have taken:
1. Used cluster wizard to uncluster the SQL 7 instance.
2. Using the SQL 2000 Enterprise cd created a new virtual server (with the same IP address and name as the previous SQL 7 server) I have left the install as a default instance.
3. Part way through the install I am asked to browse to the data area. The data area is Z:mssql7data.
On completion of the install I now have the following data path Z:mssql7datamssqldata and all the databases are still SQL7 databases.
My questions are:

How can I get the install to update/convert the databases to SQL 2000 as it doesnt seem to recognise them?

Will the install always suffix the data path with mssqldata

Any assistance appreciated.

View 1 Replies View Related

Upgrading SQL 7.0 To SQL Server 2000

Apr 14, 2004

Hi,
I'm planning an upgrade of SQL 7.0 on NT 4.0 to SQL 2000 and of course I will attempt to upgrade the OS to Windows 2000 first.
Can anyone tell me of any issues I may run across during this upgrade?
Can I assume that SQL 7.0 will run ok on Windows 2000?

thanks much,
Robert

View 4 Replies View Related

Upgrading From 2000 To 2005

Nov 19, 2007

Ok another "I Don't crap about SQL and should read the book" question:

I am purchasing new servers for a company that currently runs SQL 2000 in a Windows 2k3 environment. Not sure why, but they want to upgrade to SQL 2005. The have 4 SQL 2000 Standard editions. Three with 1 processor licensing and 1 with per device licensing. The new servers will have 2 x Quad core processors. Since I know licensing is per "Physical Processor" I need to purchase an additional license for a second processor on each machine that has two. How do I purchase a second one? Can do this online? Whats the cost? Another question I have is: Do I need to buy SQL 2005 Standard (Full Standard Version) install on the new machine and migrate by databases from SQL 2000 over to the new ones? Or is there like an upgrade kit where I install SQL 2000 on the new ones then buy a update to SQL 2005 disc? Please don't laugh at my questions, I am by no means a SQL GURU. Thanks in advance.

View 1 Replies View Related

Upgrading From 6.5 To 7 Or 2000 With 6.5 Software

Jul 20, 2005

I have a backup of SQL Server 6.5 database, but can no longer locatemy 6.5 server software. I would like to upgrade this backup to SQLServer 7 or 2000 ( i do have this software!) , does anyone know ifthis is posisble without the 6.5 software?If the answer is no, does anyone know where i could find/buy SQLServer 6.5, so that i can do this ?Thanks for any help.Rob

View 1 Replies View Related

Upgrading SQLServer 2000 STD Sp1 To Sp4

Jul 28, 2006

Hello

After installing Sql server 2000 STD Sp1 on a server with Windows 2003 server, i have upgrade my Sql server to Sp4.

All the setup has been terminated without errors, but if i execute on Q.Analyser : "Select @@version" on the end of line of my query result , i have ....(Service Pack 1)

I donŽt know , if effectively the upgrade has been terminated with sucess.I try to restart my server several time , but the result of my query is always the same "....(Service Pack 1)"

Also, on my firewall server , i Žam create an UDP port 1434, because my ODBC client machine was enable to connect to my server.

Could you give me an explanation about, this question, and if i really done the upgrade to my sqlserver.

Many Thanks

Luis





View 3 Replies View Related

Upgrading From SQL 2000 To SQL 2005

May 28, 2008

I was with online chat with Microsoft, and the guy said there is no upgrade option between SQL versions like there is from Windows XP home to Pro, or 2000 to XP. Is this true? Has anyone else done this before? I'm wanting to upgrade from SQL 2000 to SQL 2005. I was hoping there was a 32-bit to 64-bit upgrade as well within the versions, but that doesn't seem available either. I will settle for SQL 2005 32-bit if I can upgrade, but if I have to buy a whole other license for it, I might as well get x64. If anyone has done this or has experience in this, any information would be much appreciated!

View 1 Replies View Related

Need Help On Upgrading Sql 2000 To Sql 2005.

Aug 7, 2007

Any expert in the house willing to show me how to upgrade from SQL2000 to SQL2005?

Thanks!

View 4 Replies View Related

Upgrading From SQL 2000 To 2005

Dec 11, 2007



Hi everyone,

I want to upgrade SQL server 2000 to SQL server2005, what are the issues which I have to look at during my upgrading process, what sort of problems might be faced during the upgrading?

Lot of thanx

View 1 Replies View Related

Upgrading From SQL 2000 To SQL 2005

Aug 8, 2007


Please recommend best learning material for quickly upgrading skill sets from SQL 2000 to SQL 2005

View 5 Replies View Related

Upgrading From SQL 2000 SP3 To SQL 2005 SP2

May 21, 2008

Hey all!
I currently am running 8.00.760 which is the Standard Edition of SQL 2000 SP3 (or it might be 3A - no way to tell)

I have downloaded and am preparing to install 9.0.3042.1 SQL 2005 SP2 but when I run the exe file it informs me that "This machine does not have a product that matches this installation package."

Both are 32 bit versions and the precise exe I'm attempting to run is: SQLServer2005SP2-KB921896-x86-ENU.exe

I'm logged on as the server admin.
The server is running Windows Server 2003 Standard Edition SP2.
It has dual Xeon 3.2ghz dual core processors and 4gb of RAM

All of the documentation indicates that this upgrade path is acceptable.

The only thing I have noticed in the Sys Requirements (http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en)
is that the supported OS is Windows 2003 SP1 (and no sign of SP2 in the list!) could that be what the issue is?

Does anyone have any advice on where I should look to tackle this issue? I'd like to explore all free avenues before dropping any money for the paid SQL support services.
Thanks for any help.
Geoff Garcia
March of Dimes
ggarcia@marchofdimes.com
914-997-4275

View 3 Replies View Related

Upgrading Replicated Databases To 2000

Jan 17, 2005

I am planning on upgrading one of my SQL 7 servers to SQL 2000. This server is currently and will continue to replicate with a SQL 7 server.

I want to view our current replication jobs & schedules in plan text so I can check when I recreate the replication that I haven't missed anything. Does anyone know if this is possible?

Jon

View 4 Replies View Related

Upgrading From Sybase Sql Anywhere 5.5.04 To SQL Server 2000

Jul 20, 2005

Has anybody had any experience of this??We have over 2000 stored procs to convert from Watcom SQL to SQLServer 2000. Any automated tools would be much appreciated!!Also any known issues.

View 1 Replies View Related

Upgrading SQL Server 2000 SP3 To SP4 - In A SQL Cluster

Mar 26, 2008



We have 2 SQL servers in a failover cluster environment. SQL1 and SQL2. Currently SQL1 is the primary in the cluster, and we need to upgrade from Service Pack 3 to Service Pack 4.

Our setup:

Both servers are Windows 2003 Server Enterprise Edition.
Both servers have SQL Server 2000 Service Pack 3.

My question is:

Which upgrade plan do I take? Do I:

1. Upgrade the backup (offline) server in the cluster (SQL2) first, reboot, then failover from SQL1 to SQL2? Then do the other server?

2. Upgrade the primary (online) server in the cluster (SQL1) first and see if it replicates to the backup?

Any advice or tips would be most appreciated.

Thanks.

View 6 Replies View Related

Upgrading From SQL Server 2000 To 2005

Nov 29, 2006

I restored a 2000 database back up in to my 2005 database and it works fine. THe only problem is that I cannot create diagrams.

I get the following message:

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

I have checked the db_owner and that is a valid owner.

I changed a few times to different owners and still could not install the diagrams..



Any ideas?

thanks

View 1 Replies View Related

Upgrading SQL Server 2000 To 2005

May 9, 2006

I have to upgrade and move SQL Server 2000 databases from a platform using Server 2000 to one running SQL Server 2005. The server nameinstances will need to be the same so that a number of third party applications and front end systems that connect, and are outside of my control, will not need any data source changes. The servers will be on the same network and can't co-exist with the same name so I guess that I have to go "big bang".

Does anyone have any suggestions for a strategy that I can use?
Does anyone know of any issues that I should be aware of?

I have run the SQL Server 2005 Upgrade Advisor and it tells me the databases should upgrade OK with a few minor issues that can be fixed after.

Thanks,

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved