Upgrading from MSDE 1.0 - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Upgrading from MSDE 1.0

Author

Topic

rrb
SQLTeam Poet Laureate

1479 Posts

Posted - 2003-02-25 : 23:50:35

I have an application that needs to be able to upgrade from MSDE 1.0 to MSDE 2000 automatically, but I have been having an occasional problem with the upgrading. Most machines seem to work most of the time (and in theory they should all be pretty much the same because they have all been ghosted with the same image).

It just looks like the last attempt to start the service fails. There are no errors in the event log and as far as I can see no evidence that MSSQLSERVER even tried to start as per the second to last line in the setup log file. If I try and start it manually once the installation has failed (via control panel/services) it starts just fine. But that's no good, because I won't be able to do this in the field.

Here are the details:

setup.ini:
[Options]
SECURITYMODE=SQL
TARGETDIR=C:
DATADIR=C:\BCSS\
UPGRADE=1
UPGRADEUSER=sa

The messages.out file in the Install folder says:
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect)).

The last line in errorlog in the Log folder says:
Server shutdown by request.

Here are the last 20 lines in the setup log file (/L*v):
RollbackCleanup: File: C:\Config.Msi\b50a96.rbf
RollbackCleanup: File: C:\Config.Msi\b50a97.rbf
RollbackCleanup: File: C:\Config.Msi\b50a98.rbf
MSI (s) (46:56): Unlocking Server
Action ended 20:35:48: InstallFinalize. Return value 1.
MSI (s) (46:56): Doing action: DetectReboot.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Action start 20:35:48: DetectReboot.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
MSI (s) (46:56): Creating MSIHANDLE (134) of type 790542 for thread 342
Action ended 20:35:48: DetectReboot.2D02443E_7002_4C0B_ABC9_EAB2C064397B. Return value 1.
MSI (s) (46:56): Doing action: UpgradeDatabases.2D02443E_7002_4C0B_ABC9_EAB2C064397B
Action start 20:35:48: UpgradeDatabases.2D02443E_7002_4C0B_ABC9_EAB2C064397B.
MSI (s) (46:56): Creating MSIHANDLE (135) of type 790542 for thread 342
Loading extended custom action library sqlcax.dll
Starting custom action UpgradeDatabases
Stopping service
Starting service
Upgrading master database
Stopping service
Starting service
Running upgrade script 1 of 18 (messages)

Any suggestions would be most welcome.

Cheers

Edited by - rrb on 02/27/2003 17:28:05

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-02-27 : 20:50:21

Well I don't know how to fix your problem, but in order to get around it, you could just create a batch file that does a NET START. Then just have the installer or whatever mechanism is pushing this out run this batch file after the MSDE upgrade.

chadmat
The Chadinator

1974 Posts

Posted - 2003-03-03 : 23:44:11

Is there anything relevant in the sqlstp.log file?

-Chad

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources