PRB: Service Pack Setup May Fail If Probe Login or User DeletedID: Q169603
|
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.
Adding logins and users for replication.
Msg 4604, Level 16, State 1, Server XYZ, Line 1
There is no such user probe.
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.
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
Keywords : kbenv kbsetup SSrvAdmin SSrvInst SSrvISQL
Version : 6.5
Platform : winnt
Issue type : kbprb
Last Reviewed: April 16, 1999