Microsoft KB Archive/169603

= PRB: Service Pack Setup May Fail If Probe Login or User Deleted =

Article ID: 169603

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q169603



SYMPTOMS
The SQL Server service pack Setup program may fail if the 'probe' user has been removed from the master database or if the 'probe' login does not exist. The failure message is:

Setup initialization could not be successfully completed.

ISQL.EXE could not be executed. Please check the relevant .OUT file.

In the Instrepl.out file, you will find the following output:

  Adding logins and users for replication.

Msg 4604, Level 16, State 1, Server XYZ, Line 1 There is no such user probe.



CAUSE
The Instrepl.sql script attempts to grant permissions to execute a replication stored procedure. If the probe user does not exist, this GRANT fails, causing the service pack Setup to fail as well.



WORKAROUND
To work around this problem, add the probe login and user to the master database, using the following process:

use master go  exec sp_addlogin probe, NULL, master exec sp_adduser probe go

From ISQL/w, open the Procsyst.sql script in the Mssql\Install directory and run this stored procedure. This will grant other permissions to the probe that are necessary for using Performance Monitor.

Keywords: kbenv kbsetup kbprb KB169603

-

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

© Microsoft Corporation. All rights reserved.