Microsoft KB Archive/323059

= MSN Installer Stops Responding If SQL Server Services Are Not Running =

Article ID: 323059

Article Last Modified on 6/25/2003

-

APPLIES TO


 * Microsoft TV Server 2.0 Service Pack 1

-



This article was previously published under Q323059



SYMPTOMS
The MSN installer stops responding (hangs) during database installation if the SQL Server Agent is stopped or has not been started.



CAUSE
The installer does not verify that all SQL Server services are running before the installation of the databases. You can see the resulting failure error in the log file that is generated.



WORKAROUND
To work around this issue, start the SQL Server Agent before you start the MSN installer.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem will be fixed in a later version.



MORE INFORMATION
A log entry similar to the following will created for this issue:

1:38:21 PM - ************* InstallChatDb.log ***********

1:38:21 PM - Log file for Microsoft TV Server Chat Database Setup. Created 4/11/2002 1:38:10 PM

1:38:21 PM - Input parameters follow:

1:38:21 PM - bShowDialogs = False

1:38:21 PM - sServerName = KENGRE21

1:38:21 PM - sUserName = sa

1:38:21 PM - sPassword = SAPASSWORD

1:38:21 PM - CHAT = True

1:38:21 PM - CHATDB = True

1:38:21 PM - DTS = True

1:38:21 PM - CHATVD = True

1:38:21 PM - EPG = True

1:38:21 PM - Getting all database components needed to be installed

1:38:21 PM - Executing Chat.sql

1:38:21 PM - Executing chatdata_drop_db.sql

1:38:21 PM - Deleting database file 'd:\SQLDATA\MSSQL\data\chatdata_log.LDF'.

1:38:21 PM - Deleting database file 'd:\SQLDATA\MSSQL\data\chatdata.mdf'.

1:38:21 PM - Executing chatdata_create_db.sql

1:38:21 PM - The CREATE DATABASE process is allocating 0.63 MB on disk 'chatdata'.

1:38:21 PM - The CREATE DATABASE process is allocating 0.49 MB on disk 'chatdata_log'.

1:38:21 PM - Granted database access to 'wtv_service'.

1:38:21 PM - 'wtv_service' added to role 'db_owner'.

1:38:21 PM - Executing TablesandStoredProcedures.sql

1:38:21 PM - Executing CHAT_Import_Category_and_Channel.sql

1:38:21 PM - SQLServerAgent is not currently running so it cannot be notified of this

1:38:21 PM - action.

1:38:21 PM - SQLServerAgent is not currently running so it cannot be notified of this

1:38:21 PM - action.

1:38:21 PM - Executing CHAT_Import_config.sql

1:38:21 PM - SQLServerAgent is not currently running so it cannot be notified of this

1:38:21 PM - action.

1:38:21 PM - SQLServerAgent is not currently running so it cannot be notified of this

1:38:21 PM - action.

1:38:21 PM - Executing CHAT_Import_Data_on_Start.sql

1:38:21 PM - SQLServerAgent is not currently running so it cannot be notified of this

1:38:21 PM - action.

1:38:21 PM - SQLServerAgent is not currently running so it cannot be notified of this

1:38:21 PM - action.

1:38:21 PM - Loading &quot;CHAT- Import Category and Channel&quot;

1:38:21 PM - Deleting existing dts package

1:38:21 PM - Writing package to SQL Server.

1:38:21 PM - Package Saved.

1:38:21 PM -

1:38:21 PM - Loading &quot;CHAT- Import config&quot;

1:38:21 PM - Deleting existing dts package

1:38:21 PM - Writing package to SQL Server.

1:38:21 PM - Package Saved.

1:38:21 PM -

1:38:21 PM - ERROR

1:38:21 PM - ERROR

1:38:21 PM - >>>>>

1:38:21 PM - Executing sp_start_job

1:38:21 PM - Msg 22022, Level 16, State 1:

1:38:21 PM - SQLServerAgent is not currently running so it cannot be notified of this

1:38:21 PM - action.

1:38:21 PM - >>>>>

1:38:21 PM - ERROR

1:38:21 PM - ERROR

1:38:21 PM -

1:38:21 PM - ERROR

1:38:21 PM - ERROR

1:38:21 PM - >>>>> Could not run sp_start_job >>>>>

1:38:21 PM - ERROR

1:38:21 PM - ERROR

1:38:21 PM - *********************************************************

1:38:21 PM -

1:38:21 PM - Running cmd /c call cmd /C del C:\WINNT\TEMP\InstallChatDb.log

2:09:19 PM - Deleting the folder: C:\WINNT\TEMP\MSNConfigSet

2:09:19 PM - Successfully deleted the folder: C:\WINNT\TEMP\MSNConfigSet

2:09:19 PM - Running cmd /c call cmd /C del C:\WINNT\TEMP\servers.tmp

2:09:20 PM - Running cmd /c call cmd /C del C:\WINNT\TEMP\list-servers.tmp

2:09:20 PM -

=
===========================================================

MSN Server Setup Log file closed: 4/11/2002 2:09:20 PM

=
===========================================================

=
===========================================================

MSN Server Setup Log Started: 4/11/2002 2:18:20 PM

=
===========================================================

2:18:20 PM - Setup is Showing the RemoveAll\Reinstall Screen...

Additional query words: MSN Installer, SQL, database installation

Keywords: kbprb KB323059

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.