Showing posts with label standard. Show all posts
Showing posts with label standard. Show all posts

Tuesday, March 27, 2012

Error when SQL 2000 start

When starting my SQL Server 2000 generate error and stop. This is the log:
Standard Edition on Windows NT 4.0 (Build 1381: Service Pack 6)

2004-01-20 11:05:36.59 server Copyright (C) 1988-2000 Microsoft Corporation.
2004-01-20 11:05:36.59 server All rights reserved.
2004-01-20 11:05:36.59 server Server Process ID is 115.
2004-01-20 11:05:36.59 server Logging SQL Server messages in file 'C:\MSSQL7\log\ERRORLOG'.
2004-01-20 11:05:36.63 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2004-01-20 11:05:36.66 server SQL Server configured for thread mode processing.
2004-01-20 11:05:36.66 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2004-01-20 11:05:36.67 server Attempting to initialize Distributed Transaction Coordinator.
2004-01-20 11:05:38.69 spid3 Starting up database 'master'.
2004-01-20 11:05:38.85 spid3 Server name is 'DB_SERVER'.
2004-01-20 11:05:38.85 server Using 'SSNETLIB.DLL' version '8.0.194'.
2004-01-20 11:05:38.87 server SQL server listening on TCP, Shared Memory, Named Pipes.
2004-01-20 11:05:38.87 server SQL server listening on 192.168.1.29:1433, 172.16.48.10:1433, 127.0.0.1:1433.
2004-01-20 11:05:38.87 server SQL Server is ready for client connections
2004-01-20 11:05:38.87 spid5 Starting up database 'model'.
2004-01-20 11:05:38.87 spid8 Starting up database 'msdb'.
2004-01-20 11:05:38.87 spid9 Starting up database 'pubs'.
2004-01-20 11:05:38.87 spid10 Starting up database 'Northwind'.
2004-01-20 11:05:38.87 spid11 Starting up database 'SIM'.
2004-01-20 11:05:39.21 spid5 Error: 9003, Severity: 20, State: 1
2004-01-20 11:05:39.21 spid5 The LSN (5:377:1) passed to log scan in database 'model' is invalid..
2004-01-20 11:05:39.31 spid8 Bypassing recovery for database 'msdb' because it is marked SUSPECT.
2004-01-20 11:05:39.39 spid11 Starting up database 'GMS'.
2004-01-20 11:05:39.39 spid8 Starting up database 'euro'.
2004-01-20 11:05:40.14 spid10 Starting up database 'TigrisDB'.have you moved your system's devices around recently?|||Originally posted by ms_sql_dba
have you moved your system's devices around recently?

No, but 2 weeks before, I receive a message (Administrator alert) from PC with installed on SQL 2000.

"Drive Z: is nearly full. 1216688128 bytes are available.
Please warn users and delete unneeded files."

On "drive Z:" there is 9GB free space ...

Thanks for reading.
Best Regards|||looks like your system databases is having some problem.
try restarting sql server in single user mode and do a dbcc checkdb on model and msdb.

If this do not work, you might have to rebuild them

amit

Monday, March 26, 2012

Error when perform an update on Immediate Updating Subscriber

I have transaction replication setup between two servers running SQL Server
2000 (standard edition). The subscriber is an immediate updating subscriber.
I am having an issue when I try to update two tables from the subscriber.
When I attempt to perform an update on either table, I receive an error like
the following:
Server: Msg 170, Level 15, State 1, Line 2
Line 2: Incorrect syntax near ')'.
Server: Msg 137, Level 15, State 1, Line 5
Must declare the variable '@.c120o'.
I looked at the syntax of the trg_MSsync_upd_<tablename> trigger and cannot
see any problem with the trigger's syntax.
Any help anyone can provide would be greatly appreciated.
Michael Conway
Calltower, Inc.
Database Administrator
Can you post the name and schema of your problem article?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"mconway" <mconway@.calltower.com.(donotspam)> wrote in message
news:33FA51A4-1FE7-494F-B992-20C644B3F0E2@.microsoft.com...
>I have transaction replication setup between two servers running SQL Server
> 2000 (standard edition). The subscriber is an immediate updating
> subscriber.
>
> I am having an issue when I try to update two tables from the subscriber.
> When I attempt to perform an update on either table, I receive an error
> like
> the following:
> Server: Msg 170, Level 15, State 1, Line 2
> Line 2: Incorrect syntax near ')'.
> Server: Msg 137, Level 15, State 1, Line 5
> Must declare the variable '@.c120o'.
> I looked at the syntax of the trg_MSsync_upd_<tablename> trigger and
> cannot
> see any problem with the trigger's syntax.
> Any help anyone can provide would be greatly appreciated.
>
> --
> Michael Conway
> Calltower, Inc.
> Database Administrator
|||I am having the issue with two articles so I am going to post the schema for
both tables. I am posting the schema as it is in production. There are
spaces in some of the column names, and at first I thought that this was the
cause of the problem, however I removed the spaces in the column names and
still received the same error.
CREATE TABLE [dbo].[Accounts] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[FName] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LName] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SSN] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone2] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone3] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Street] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[City] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[State] [nvarchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Zip] [nvarchar] (5) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Status] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Grid] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Install Start Time] [int] NULL ,
[Install Duration] [int] NULL ,
[Sale Date] [smalldatetime] NULL ,
[Install Date] [smalldatetime] NULL ,
[Charge Back] [smalldatetime] NULL ,
[Who Entered] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[timeentered] [smalldatetime] NULL ,
[Lead Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Rep Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tech Name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lead ID] [int] NULL ,
[Rep ID] [int] NULL ,
[Technician ID] [int] NULL ,
[Leadpaid] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Reppaid] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Techpaid] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lead pay] [float] NULL ,
[Lead holdback] [float] NULL ,
[Lead bonus] [float] NULL ,
[Rep pay] [float] NULL ,
[Rep holdback] [float] NULL ,
[Rep bonus] [float] NULL ,
[Tech pay] [float] NULL ,
[Tech holdback] [float] NULL ,
[Tech bonus] [float] NULL ,
[AreaID] [int] NULL ,
[CC Number] [nvarchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Promotion] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Promotion ID] [int] NULL ,
[Kit ID] [int] NULL ,
[Shipping Vendor] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tracking Number] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Certificate Number] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Virtual Certificate] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[Wiring] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Channels] [nvarchar] (40) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Structure] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Story] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Roof] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Cable] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Home Type] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Ala Carte] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[General] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Local] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Payment Type] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Receivers] [tinyint] NULL ,
[Payment] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Account Number] [nvarchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R001] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R002] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R003] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R004] [nvarchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Claim ID] [nvarchar] (11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Owe] [float] NULL ,
[Tax] [float] NULL ,
[Collected] [float] NULL ,
[Autodebit] [tinyint] NULL ,
[Processed] [tinyint] NULL ,
[Submitted] [tinyint] NULL ,
[Paid] [tinyint] NULL ,
[Follow Up] [tinyint] NULL ,
[Processed Date] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Submitted Date] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Paid Date] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[collections] [tinyint] NULL ,
[campaignid] [int] NULL ,
[satelliteprovider] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS
NULL ,
[basepackageid] [int] NULL ,
[programmingquote] [float] NULL ,
[dishlocals] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[directlocals] [varchar] (150) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[numbertvs] [int] NULL ,
[subscriberid] [varchar] (16) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[contactdate] [datetime] NULL ,
[progreceivers] [int] NULL ,
[progprovider] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[progpackage] [int] NULL ,
[progpromotionid] [int] NULL ,
[confirminstallation] [tinyint] NULL ,
[arrival] [datetime] NULL ,
[departure] [datetime] NULL ,
[arrivalcode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[departurecode] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R005] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[R006] [varchar] (9) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Promo Code] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[confirminstalldate] [datetime] NULL ,
[received] [tinyint] NULL ,
[receiveddate] [datetime] NULL ,
[cancelled] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Fullfillment] [tinyint] NULL ,
[UpgradeID] [int] NULL ,
[leadreceivers] [float] NULL ,
[repreceivers] [float] NULL ,
[techreceivers] [float] NULL ,
[techmaterials] [float] NULL ,
[leadequipment] [float] NULL ,
[repequipment] [float] NULL ,
[techequipment] [float] NULL ,
[chargebackpaid] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[claimupdated] [float] NULL ,
[claimupdateddate] [datetime] NULL ,
[ScheduleSlotID] [bigint] NULL ,
[Warranty] [tinyint] NULL ,
[PreviousProvider] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Gender] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Employer] [varchar] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DOB] [datetime] NULL ,
[ReferralID] [bigint] NULL ,
[ReferralName] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Installed] [tinyint] NULL ,
[OldKitID] [bigint] NULL ,
[OldPromotionID] [bigint] NULL ,
[ClaimID2] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[OldUpgradeID] [bigint] NULL ,
[BoundType] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[street2] [varchar] (60) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[UpgradeOptions] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DriversLicense] [varchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DLState] [varchar] (2) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ChargebackReason] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ConvertDate] [datetime] NULL ,
[ConverTempID] [bigint] NULL ,
[LastUpdate] [datetime] NULL ,
[LastUpdateEmpID] [bigint] NULL ,
[msrepl_tran_version] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[Employee] (
[ID] [int] IDENTITY (1, 1) NOT FOR REPLICATION NOT NULL ,
[FName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[LName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone2] [nvarchar] (15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Phone3] [nvarchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Inactive] [smallint] NULL ,
[Lead Plan] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Rep Plan] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Tech Plan] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[user] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[password] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[expiration date] [smalldatetime] NULL ,
[street] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[city] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[zip] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[state] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[ssn] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[email] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Type] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[Lead Rep] [tinyint] NULL ,
[Rep] [tinyint] NULL ,
[Tech] [tinyint] NULL ,
[links] [tinyint] NULL ,
[add] [tinyint] NULL ,
[update] [tinyint] NULL ,
[delete] [tinyint] NULL ,
[lookup] [tinyint] NULL ,
[scheduler] [tinyint] NULL ,
[accounts] [tinyint] NULL ,
[openticket] [tinyint] NULL ,
[openbilling] [tinyint] NULL ,
[leadcenter] [tinyint] NULL ,
[creditcard] [tinyint] NULL ,
[employee] [tinyint] NULL ,
[areas] [tinyint] NULL ,
[promotions] [tinyint] NULL ,
[promocodes] [tinyint] NULL ,
[makekits] [tinyint] NULL ,
[equipment] [tinyint] NULL ,
[payplans] [tinyint] NULL ,
[preferences] [tinyint] NULL ,
[commissions] [tinyint] NULL ,
[admin] [tinyint] NULL ,
[reports] [tinyint] NULL ,
[receivers] [tinyint] NULL ,
[export] [tinyint] NULL ,
[payments] [tinyint] NULL ,
[production] [tinyint] NULL ,
[route] [tinyint] NULL ,
[statistics] [tinyint] NULL ,
[status] [tinyint] NULL ,
[leadaccounts] [tinyint] NULL ,
[leadpayroll] [tinyint] NULL ,
[repaccounts] [tinyint] NULL ,
[reppayroll] [tinyint] NULL ,
[techpayroll] [tinyint] NULL ,
[techaccounts] [tinyint] NULL ,
[top] [tinyint] NULL ,
[installed] [tinyint] NULL ,
[pending] [tinyint] NULL ,
[cancelled] [tinyint] NULL ,
[chargeback] [tinyint] NULL ,
[reconciliation] [tinyint] NULL ,
[accounting] [tinyint] NULL ,
[receiveables] [tinyint] NULL ,
[reserviced] [tinyint] NULL ,
[rescheduled] [tinyint] NULL ,
[notscheduled] [tinyint] NULL ,
[channels] [tinyint] NULL ,
[churn] [tinyint] NULL ,
[r00] [tinyint] NULL ,
[missing payments] [tinyint] NULL ,
[deactivations] [tinyint] NULL ,
[disconnects] [tinyint] NULL ,
[salestax] [tinyint] NULL ,
[residuals] [tinyint] NULL ,
[exceptions] [tinyint] NULL ,
[servicecalls] [tinyint] NULL ,
[ra] [tinyint] NULL ,
[individualstatistics] [tinyint] NULL ,
[allstatus] [tinyint] NULL ,
[process] [tinyint] NULL ,
[campaigns] [tinyint] NULL ,
[adcampaignreport] [tinyint] NULL ,
[equipmentsalesreport] [tinyint] NULL ,
[missingcertsreport] [tinyint] NULL ,
[undepositedfunds] [tinyint] NULL ,
[Inventory] [tinyint] NULL ,
[TechArriveDepart] [tinyint] NULL ,
[TechInventoryReport] [tinyint] NULL ,
[btnR00] [tinyint] NULL ,
[btnNotes] [tinyint] NULL ,
[btnInvoices] [tinyint] NULL ,
[btnProgramming] [tinyint] NULL ,
[btnReceivables] [tinyint] NULL ,
[btnCreditCard] [tinyint] NULL ,
[btnBankInfo] [tinyint] NULL ,
[btnBilling] [tinyint] NULL ,
[btnContract] [tinyint] NULL ,
[btnService] [tinyint] NULL ,
[btnQuote] [tinyint] NULL ,
[quickbooks] [tinyint] NULL ,
[dataexport] [tinyint] NULL ,
[dataimport] [tinyint] NULL ,
[fake1] [tinyint] NULL ,
[fake2] [tinyint] NULL ,
[fake3] [tinyint] NULL ,
[fake4] [tinyint] NULL ,
[hours] [tinyint] NULL ,
[payrolladministrator] [tinyint] NULL ,
[servicepay] [float] NULL ,
[timeoff] [tinyint] NULL ,
[installation] [tinyint] NULL ,
[negativecommissions] [tinyint] NULL ,
[collections] [tinyint] NULL ,
[WarrantySalesReport] [tinyint] NULL ,
[EmployeeSalesReport] [tinyint] NULL ,
[CommissionsReport] [tinyint] NULL ,
[UserType] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[TextMessage] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[btnCreditCardView] [tinyint] NULL ,
[btnMoveToLead] [tinyint] NULL ,
[btnManualSchedule] [tinyint] NULL ,
[CancelledReasonReport] [tinyint] NULL ,
[ReferralsReport] [tinyint] NULL ,
[callbacknotes] [tinyint] NULL ,
[toptechs] [tinyint] NULL ,
[LeadLedger] [tinyint] NULL ,
[RepLedger] [tinyint] NULL ,
[TechLedger] [tinyint] NULL ,
[Forecasting] [tinyint] NULL ,
[UserLogin] [tinyint] NULL ,
[POs] [tinyint] NULL ,
[AddEquipment] [tinyint] NULL ,
[EquipmentInventory] [tinyint] NULL ,
[AdjustInventory] [tinyint] NULL ,
[EquipmentLookup] [tinyint] NULL ,
[Aging] [tinyint] NULL ,
[DishCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[DirectCode] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
[SalesByVendor] [tinyint] NULL ,
[InstalledReceivers] [tinyint] NULL ,
[TopOffice] [tinyint] NULL ,
[RepInvoices] [tinyint] NULL ,
[msrepl_tran_version] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
"Hilary Cotter" wrote:

> Can you post the name and schema of your problem article?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "mconway" <mconway@.calltower.com.(donotspam)> wrote in message
> news:33FA51A4-1FE7-494F-B992-20C644B3F0E2@.microsoft.com...
>
>
|||I tried unsubscribing to the publication. Then I removed any spaces in the
column names and changed any column names that were using reserved words.
Then I recreated the subscription and subscriber database. However, I still
received the same errors when I tried to update the two tables.
"Hilary Cotter" wrote:

> Can you post the name and schema of your problem article?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> "mconway" <mconway@.calltower.com.(donotspam)> wrote in message
> news:33FA51A4-1FE7-494F-B992-20C644B3F0E2@.microsoft.com...
>
>

Wednesday, March 7, 2012

Error using Db Engine Tuning Advisor

I am running SQL 2005 Standard, obtained from a recent Launch event.
I got the Database Engine Tuning Advisor to run only once. Everytime after
that I get a runtime error: "R6031 Attempt to initialize the CRT more than
once. This indicates a bug in your application."
I had the same problem with the Sept. CTP release. Re-booting the machine
does not solve this problem. Basicaly, this is a useless tool if I need to
un-install and re-install it everytime I need to use it. I have tried
deleting all the sessions and creating a new one, re-booting.
Any ideas how to solve this? Do I need to wait for a Service Pack?
We are looking at the issue currently. It has been reported by a few other
people. Please gi ve us some more detail:
- does this happen immiediately after you start DTA UI or after you connect
to the server and the connection dialog goes away?
- if this is the second case (error after connecting) does the problem occur
if you simply Cancel the connection dialog?
- have you tried command-line DTA to see if it work? Run 'dta.exe /?' to see
the options if you have not seen it yet.
- does the error message contain any more information?
- can you check if at the time you see the error there is a dtaengine90.exe
process running on your system?
Thanks,
Maciek
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:438AAABC-1BA2-4677-B272-5D7766BEF9E2@.microsoft.com...
>I am running SQL 2005 Standard, obtained from a recent Launch event.
> I got the Database Engine Tuning Advisor to run only once. Everytime after
> that I get a runtime error: "R6031 Attempt to initialize the CRT more than
> once. This indicates a bug in your application."
> I had the same problem with the Sept. CTP release. Re-booting the machine
> does not solve this problem. Basicaly, this is a useless tool if I need to
> un-install and re-install it everytime I need to use it. I have tried
> deleting all the sessions and creating a new one, re-booting.
> Any ideas how to solve this? Do I need to wait for a Service Pack?
|||Is this TechNet discussion forum the best place to correspond regarding tech
support and error information?
I would be happy to supply any information you need. Can you e-mail me a
valid address so that we can take this 'off-line'?
Thank you.
todd_dot_chittenden_at_morantug_dot_com
"Maciek Sarnowicz [MSFT]" wrote:

> We are looking at the issue currently. It has been reported by a few other
> people. Please gi ve us some more detail:
> - does this happen immiediately after you start DTA UI or after you connect
> to the server and the connection dialog goes away?
> - if this is the second case (error after connecting) does the problem occur
> if you simply Cancel the connection dialog?
> - have you tried command-line DTA to see if it work? Run 'dta.exe /?' to see
> the options if you have not seen it yet.
> - does the error message contain any more information?
> - can you check if at the time you see the error there is a dtaengine90.exe
> process running on your system?
> Thanks,
> Maciek
>
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:438AAABC-1BA2-4677-B272-5D7766BEF9E2@.microsoft.com...
>
>
|||I will take this off-line as Todd requested. We will post back to the group
once we know the root cause of the issue.
Thanks,
Maciek
"Todd C" <ToddC@.discussions.microsoft.com> wrote in message
news:F4881BF8-E66B-403B-9DA0-1BC4020DDF7F@.microsoft.com...[vbcol=seagreen]
> Is this TechNet discussion forum the best place to correspond regarding
> tech
> support and error information?
> I would be happy to supply any information you need. Can you e-mail me a
> valid address so that we can take this 'off-line'?
> Thank you.
> todd_dot_chittenden_at_morantug_dot_com
> "Maciek Sarnowicz [MSFT]" wrote:
|||I'm experiencing the same problem. See my answers below.
"Maciek Sarnowicz [MSFT]" <macies@.online.microsoft.com> wrote in message
news:OnFxcW0$FHA.2392@.TK2MSFTNGP09.phx.gbl...
> We are looking at the issue currently. It has been reported by a few other
> people. Please gi ve us some more detail:
> - does this happen immiediately after you start DTA UI or after you
> connect to the server and the connection dialog goes away?
It happens after I connect to the server and the connection dialog goes
away.

> - if this is the second case (error after connecting) does the problem
> occur if you simply Cancel the connection dialog?
The problem does not occur if I press the Cancel button at the connection
dialog. But the problem does occur if I thereafter attempt to connect from
within the DTA.

> - have you tried command-line DTA to see if it work? Run 'dta.exe /?' to
> see the options if you have not seen it yet.
I tried using the command-line and had the same problem.

> - does the error message contain any more information?
It's a very vague message. Similar to Todd, I get the following:
Microsoft Visual C++ Runtime Library
Runtime Error!
Program: C:\Progr...
R6031 Attempt to initialize the CRT more than once. This indicates a bug in
your application.

> - can you check if at the time you see the error there is a
> dtaengine90.exe process running on your system?
Yes, both dtaengine90.exe and DTASHELL.EXE are loaded. My only recourse is
to kill both processes.
Chris

> Thanks,
> Maciek
>
> "Todd C" <ToddC@.discussions.microsoft.com> wrote in message
> news:438AAABC-1BA2-4677-B272-5D7766BEF9E2@.microsoft.com...
>
|||>> - have you tried command-line DTA to see if it work? Run 'dta.exe /?' to
> I tried using the command-line and had the same problem.
BTW, after returning to the command line, I see the following:
"Failed to initialize MSDB database for tuning (exit code: 1)."
Chris
|||Thanks Chris.
This confirms what Todd has reported. We are closing down on the issue,
please stay tuned.
Regards,
Maciek Sarnowicz
SQL Server SDE
This posting is provided "AS IS" with no warranties, and confers no rights
"Chris" <chris@.newsgroup.nospam> wrote in message
news:erbS$VRAGHA.2132@.TK2MSFTNGP14.phx.gbl...
> BTW, after returning to the command line, I see the following:
> "Failed to initialize MSDB database for tuning (exit code: 1)."
> Chris
>
|||I am having the same exact problem. I de-installed everything and
re-installed to no avail. All other tools and services are working fine so
far. I have never been able to "connect to the database using DTA". If I
hit cancel at the login, there is no error. When I try to connect the same
error is thrown on my machine. What is interesting is I just did a very
clean install on my computer less than 30 days ago. The only install issue
was that I was not running IIS for reporting services as it is not needed for
me.
I am running XP Pro with all SP and updates and .Net/updates prior to SQL
2005 Developer Install.
Software would be Office 03 and misc business apps.
Hope the problem is solved soon.
Thank you,
kirk
"Maciek Sarnowicz [MSFT]" wrote:

> Thanks Chris.
> This confirms what Todd has reported. We are closing down on the issue,
> please stay tuned.
>
> Regards,
> Maciek Sarnowicz
> --
> SQL Server SDE
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Chris" <chris@.newsgroup.nospam> wrote in message
> news:erbS$VRAGHA.2132@.TK2MSFTNGP14.phx.gbl...
>
>
|||Anything new to report on this? Thanks.
"Maciek Sarnowicz [MSFT]" <macies@.online.microsoft.com> wrote in message
news:OctJ8zTAGHA.3976@.TK2MSFTNGP09.phx.gbl...
> Thanks Chris.
> This confirms what Todd has reported. We are closing down on the issue,
> please stay tuned.
>
> Regards,
> Maciek Sarnowicz
> --
> SQL Server SDE
> This posting is provided "AS IS" with no warranties, and confers no rights
>
> "Chris" <chris@.newsgroup.nospam> wrote in message
> news:erbS$VRAGHA.2132@.TK2MSFTNGP14.phx.gbl...
>
|||Hi Chris
This issue is being investigated presently and is probably a
consequence of a filed windows/appcompat bug
(issue due to appcompat shimming and nothing to do with DTA process
itself -).
1.Can you check if you have registry entries corresponding to
HKLM\Software\Microsoft\Windows
NT\CurrentVersion\AppCompatFlags\Layers?
In the past we have seen "explorer.exe " as an entry and removing that
fixed the problem
2.Also please check if an environment variable __COMPAT_LAYER is set?
"set __COMPAT_LAYER=" , basically disabled the compat layer and dta
ran OK
Please note that none of these are set by the tuning advisor exe - At
this point i am not sure what app does this
Manoj
Chris wrote:[vbcol=seagreen]
> Anything new to report on this? Thanks.
> "Maciek Sarnowicz [MSFT]" <macies@.online.microsoft.com> wrote in message
> news:OctJ8zTAGHA.3976@.TK2MSFTNGP09.phx.gbl...

Friday, February 24, 2012

Error trying to create Maintenance plan

We have a SQL server installation on a managed hosting environment and last night they upgraded our version from standard to enterprise. It looks as if they uninstalled, and then reinstalled. So now I need to re-configure our maintenance plans but when I try right-click on Maintenance Plans and select New Maintenance Plan in Management Studio I get the following error: An OLE DB error 0x800004005 occured while enumerating packages. A SQL statement was issued and failed.

I thought it had something to do with the new installation not running as a particular user/system account and the account it wass running under didnt have the proper permissions. As a smoke test I made the user it's running as (sqlservice) an admin in SQL Server, but that didnt fix the problem

Any help would be appreciated.Have you installed SSIS too in this case if that was also available previouslY?

Wednesday, February 15, 2012

Error running script:sp1_serv_uni.sql(1)

I have a SQL 2000 Server Standard Edition. When I tried to install service
pack 1, 2, or 3, it stopped the installation itself with the above error.
Can anyone help me please?
Thanks and regards,
Jacky
jackykit@.hotmail.com
Keroppi,
Can you post the log file, or preferably, the relevant portions of the
log? The file should be called sqlstp.log and their may be some
information in the SQL Server ERRORLOG file.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Keroppi wrote:
> I have a SQL 2000 Server Standard Edition. When I tried to install service
> pack 1, 2, or 3, it stopped the installation itself with the above error.
> Can anyone help me please?
> Thanks and regards,
> Jacky
> jackykit@.hotmail.com
|||Sorry, I locate the sqlstp.log but it's not the updated one so I extract some
information from errorlog in C:\Program Files\Microsoft SQL Server\MSSQL\LOG.
2005-01-06 14:06:19.21 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
2005-01-06 14:06:19.21 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-01-06 14:06:19.21 server All rights reserved.
2005-01-06 14:06:19.21 server Server Process ID is 4072.
2005-01-06 14:06:19.21 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-01-06 14:06:19.23 server SQL Server is starting at priority class
'high'(1 CPU detected).
2005-01-06 14:06:19.28 server SQL Server configured for thread mode
processing.
2005-01-06 14:06:19.28 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2005-01-06 14:06:19.29 server Attempting to initialize Distributed
Transaction Coordinator.
2005-01-06 14:06:21.35 spid3 Starting up database 'master'.
2005-01-06 14:06:21.53 spid5 Starting up database 'model'.
2005-01-06 14:06:21.53 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-01-06 14:06:21.56 spid3 Server name is 'SUN426'.
2005-01-06 14:06:21.68 spid8 Starting up database 'msdb'.
2005-01-06 14:06:21.68 spid9 Starting up database 'pubs'.
2005-01-06 14:06:21.68 spid10 Starting up database 'Northwind'.
2005-01-06 14:06:21.68 spid11 Starting up database 'SUNDB'.
2005-01-06 14:06:21.81 server SQL server listening on 10.168.1.11: 1433.
2005-01-06 14:06:21.81 server SQL server listening on 127.0.0.1: 1433.
2005-01-06 14:06:21.87 server SQL server listening on TCP, Named Pipes.
2005-01-06 14:06:21.87 server SQL Server is ready for client connections
2005-01-06 14:06:22.29 spid5 Clearing tempdb database.
2005-01-06 14:06:22.32 spid9 Starting up database 'db_ControlManager'.
2005-01-06 14:06:23.68 spid5 Starting up database 'tempdb'.
2005-01-06 14:06:23.96 spid3 Recovery complete.
2005-01-06 14:06:23.96 spid3 SQL global counter collection task is
created.
2005-01-06 14:06:37.71 spid52 Using 'xpsqlbot.dll' version '2000.80.194'
to execute extended stored procedure 'xp_qv'.
2005-01-06 16:24:14.71 spid68 Starting up database 'sqlbpa'.
2005-01-06 16:50:36.17 spid68 Using 'xpstar.dll' version '2000.80.760' to
execute extended stored procedure 'sp_MSgetversion'.
2005-01-06 16:50:42.60 spid68 Error: 15457, Severity: 0, State: 1
2005-01-06 16:50:42.60 spid68 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2005-01-06 16:50:42.79 spid68 Using 'xplog70.dll' version '2000.80.760'
to execute extended stored procedure 'xp_msver'.
"Mark Allison" wrote:

> Keroppi,
> Can you post the log file, or preferably, the relevant portions of the
> log? The file should be called sqlstp.log and their may be some
> information in the SQL Server ERRORLOG file.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Keroppi wrote:
>
|||I also attached 2 files for your reference.
Thanks in advance.
Keroppi
"Keroppi" <Keroppi@.discussions.microsoft.com> glsD:C7E6819B-824B-40EC-BF57-4FC2F4B35580@.microsoft.com...[vbcol=seagreen]
> Sorry, I locate the sqlstp.log but it's not the updated one so I extract some
> information from errorlog in C:\Program Files\Microsoft SQL Server\MSSQL\LOG.
>
> 2005-01-06 14:06:19.21 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> 2005-01-06 14:06:19.21 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2005-01-06 14:06:19.21 server All rights reserved.
> 2005-01-06 14:06:19.21 server Server Process ID is 4072.
> 2005-01-06 14:06:19.21 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2005-01-06 14:06:19.23 server SQL Server is starting at priority class
> 'high'(1 CPU detected).
> 2005-01-06 14:06:19.28 server SQL Server configured for thread mode
> processing.
> 2005-01-06 14:06:19.28 server Using dynamic lock allocation. [2500] Lock
> Blocks, [5000] Lock Owner Blocks.
> 2005-01-06 14:06:19.29 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2005-01-06 14:06:21.35 spid3 Starting up database 'master'.
> 2005-01-06 14:06:21.53 spid5 Starting up database 'model'.
> 2005-01-06 14:06:21.53 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2005-01-06 14:06:21.56 spid3 Server name is 'SUN426'.
> 2005-01-06 14:06:21.68 spid8 Starting up database 'msdb'.
> 2005-01-06 14:06:21.68 spid9 Starting up database 'pubs'.
> 2005-01-06 14:06:21.68 spid10 Starting up database 'Northwind'.
> 2005-01-06 14:06:21.68 spid11 Starting up database 'SUNDB'.
> 2005-01-06 14:06:21.81 server SQL server listening on 10.168.1.11: 1433.
> 2005-01-06 14:06:21.81 server SQL server listening on 127.0.0.1: 1433.
> 2005-01-06 14:06:21.87 server SQL server listening on TCP, Named Pipes.
> 2005-01-06 14:06:21.87 server SQL Server is ready for client connections
> 2005-01-06 14:06:22.29 spid5 Clearing tempdb database.
> 2005-01-06 14:06:22.32 spid9 Starting up database 'db_ControlManager'.
> 2005-01-06 14:06:23.68 spid5 Starting up database 'tempdb'.
> 2005-01-06 14:06:23.96 spid3 Recovery complete.
> 2005-01-06 14:06:23.96 spid3 SQL global counter collection task is
> created.
> 2005-01-06 14:06:37.71 spid52 Using 'xpsqlbot.dll' version '2000.80.194'
> to execute extended stored procedure 'xp_qv'.
> 2005-01-06 16:24:14.71 spid68 Starting up database 'sqlbpa'.
> 2005-01-06 16:50:36.17 spid68 Using 'xpstar.dll' version '2000.80.760' to
> execute extended stored procedure 'sp_MSgetversion'.
> 2005-01-06 16:50:42.60 spid68 Error: 15457, Severity: 0, State: 1
> 2005-01-06 16:50:42.60 spid68 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> 2005-01-06 16:50:42.79 spid68 Using 'xplog70.dll' version '2000.80.760'
> to execute extended stored procedure 'xp_msver'.
>
> "Mark Allison" wrote:

Error running script:sp1_serv_uni.sql(1)

I have a SQL 2000 Server Standard Edition. When I tried to install service
pack 1, 2, or 3, it stopped the installation itself with the above error.
Can anyone help me please?
Thanks and regards,
Jacky
jackykit@.hotmail.comKeroppi,
Can you post the log file, or preferably, the relevant portions of the
log? The file should be called sqlstp.log and their may be some
information in the SQL Server ERRORLOG file.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Keroppi wrote:
> I have a SQL 2000 Server Standard Edition. When I tried to install servic
e
> pack 1, 2, or 3, it stopped the installation itself with the above error.
> Can anyone help me please?
> Thanks and regards,
> Jacky
> jackykit@.hotmail.com|||Sorry, I locate the sqlstp.log but it's not the updated one so I extract som
e
information from errorlog in C:\Program Files\Microsoft SQL Server\MSSQL\LOG
.
2005-01-06 14:06:19.21 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
2005-01-06 14:06:19.21 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-01-06 14:06:19.21 server All rights reserved.
2005-01-06 14:06:19.21 server Server Process ID is 4072.
2005-01-06 14:06:19.21 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-01-06 14:06:19.23 server SQL Server is starting at priority class
'high'(1 CPU detected).
2005-01-06 14:06:19.28 server SQL Server configured for thread mode
processing.
2005-01-06 14:06:19.28 server Using dynamic lock allocation. [2500] L
ock
Blocks, [5000] Lock Owner Blocks.
2005-01-06 14:06:19.29 server Attempting to initialize Distributed
Transaction Coordinator.
2005-01-06 14:06:21.35 spid3 Starting up database 'master'.
2005-01-06 14:06:21.53 spid5 Starting up database 'model'.
2005-01-06 14:06:21.53 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-01-06 14:06:21.56 spid3 Server name is 'SUN426'.
2005-01-06 14:06:21.68 spid8 Starting up database 'msdb'.
2005-01-06 14:06:21.68 spid9 Starting up database 'pubs'.
2005-01-06 14:06:21.68 spid10 Starting up database 'Northwind'.
2005-01-06 14:06:21.68 spid11 Starting up database 'SUNDB'.
2005-01-06 14:06:21.81 server SQL server listening on 10.168.1.11: 1433.
2005-01-06 14:06:21.81 server SQL server listening on 127.0.0.1: 1433.
2005-01-06 14:06:21.87 server SQL server listening on TCP, Named Pipes.
2005-01-06 14:06:21.87 server SQL Server is ready for client connections
2005-01-06 14:06:22.29 spid5 Clearing tempdb database.
2005-01-06 14:06:22.32 spid9 Starting up database 'db_ControlManager'.
2005-01-06 14:06:23.68 spid5 Starting up database 'tempdb'.
2005-01-06 14:06:23.96 spid3 Recovery complete.
2005-01-06 14:06:23.96 spid3 SQL global counter collection task is
created.
2005-01-06 14:06:37.71 spid52 Using 'xpsqlbot.dll' version '2000.80.194'
to execute extended stored procedure 'xp_qv'.
2005-01-06 16:24:14.71 spid68 Starting up database 'sqlbpa'.
2005-01-06 16:50:36.17 spid68 Using 'xpstar.dll' version '2000.80.760' to
execute extended stored procedure 'sp_MSgetversion'.
2005-01-06 16:50:42.60 spid68 Error: 15457, Severity: 0, State: 1
2005-01-06 16:50:42.60 spid68 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2005-01-06 16:50:42.79 spid68 Using 'xplog70.dll' version '2000.80.760'
to execute extended stored procedure 'xp_msver'.
"Mark Allison" wrote:

> Keroppi,
> Can you post the log file, or preferably, the relevant portions of the
> log? The file should be called sqlstp.log and their may be some
> information in the SQL Server ERRORLOG file.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Keroppi wrote:
>|||I also attached 2 files for your reference.
Thanks in advance.
Keroppi
"Keroppi" <Keroppi@.discussions.microsoft.com> glsD:C7E6819B-824B-40EC-BF57-4FC2F4B
35580@.microsoft.com...[vbcol=seagreen]
> Sorry, I locate the sqlstp.log but it's not the updated one so I extract s
ome
> information from errorlog in C:\Program Files\Microsoft SQL Server\MSSQL\L
OG.
>
>
> 2005-01-06 14:06:19.21 server Microsoft SQL Server 2000 - 8.00.760
> (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
>
> 2005-01-06 14:06:19.21 server Copyright (C) 1988-2002 Microsoft
> Corporation.
> 2005-01-06 14:06:19.21 server All rights reserved.
> 2005-01-06 14:06:19.21 server Server Process ID is 4072.
> 2005-01-06 14:06:19.21 server Logging SQL Server messages in file
> 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2005-01-06 14:06:19.23 server SQL Server is starting at priority class
> 'high'(1 CPU detected).
> 2005-01-06 14:06:19.28 server SQL Server configured for thread mode
> processing.
> 2005-01-06 14:06:19.28 server Using dynamic lock allocation. [2500]
Lock
> Blocks, [5000] Lock Owner Blocks.
> 2005-01-06 14:06:19.29 server Attempting to initialize Distributed
> Transaction Coordinator.
> 2005-01-06 14:06:21.35 spid3 Starting up database 'master'.
> 2005-01-06 14:06:21.53 spid5 Starting up database 'model'.
> 2005-01-06 14:06:21.53 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2005-01-06 14:06:21.56 spid3 Server name is 'SUN426'.
> 2005-01-06 14:06:21.68 spid8 Starting up database 'msdb'.
> 2005-01-06 14:06:21.68 spid9 Starting up database 'pubs'.
> 2005-01-06 14:06:21.68 spid10 Starting up database 'Northwind'.
> 2005-01-06 14:06:21.68 spid11 Starting up database 'SUNDB'.
> 2005-01-06 14:06:21.81 server SQL server listening on 10.168.1.11: 1433
.
> 2005-01-06 14:06:21.81 server SQL server listening on 127.0.0.1: 1433.
> 2005-01-06 14:06:21.87 server SQL server listening on TCP, Named Pipes.
> 2005-01-06 14:06:21.87 server SQL Server is ready for client connection
s
> 2005-01-06 14:06:22.29 spid5 Clearing tempdb database.
> 2005-01-06 14:06:22.32 spid9 Starting up database 'db_ControlManager'.
> 2005-01-06 14:06:23.68 spid5 Starting up database 'tempdb'.
> 2005-01-06 14:06:23.96 spid3 Recovery complete.
> 2005-01-06 14:06:23.96 spid3 SQL global counter collection task is
> created.
> 2005-01-06 14:06:37.71 spid52 Using 'xpsqlbot.dll' version '2000.80.194
'
> to execute extended stored procedure 'xp_qv'.
> 2005-01-06 16:24:14.71 spid68 Starting up database 'sqlbpa'.
> 2005-01-06 16:50:36.17 spid68 Using 'xpstar.dll' version '2000.80.760'
to
> execute extended stored procedure 'sp_MSgetversion'.
> 2005-01-06 16:50:42.60 spid68 Error: 15457, Severity: 0, State: 1
> 2005-01-06 16:50:42.60 spid68 Configuration option 'show advanced
> options' changed from 1 to 1. Run the RECONFIGURE statement to install..
> 2005-01-06 16:50:42.79 spid68 Using 'xplog70.dll' version '2000.80.760'
> to execute extended stored procedure 'xp_msver'.
>
>
>
> "Mark Allison" wrote:
>

Error running script:sp1_serv_uni.sql(1)

I have a SQL 2000 Server Standard Edition. When I tried to install service
pack 1, 2, or 3, it stopped the installation itself with the above error.
Can anyone help me please?
Thanks and regards,
Jacky
jackykit@.hotmail.comKeroppi,
Can you post the log file, or preferably, the relevant portions of the
log? The file should be called sqlstp.log and their may be some
information in the SQL Server ERRORLOG file.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Keroppi wrote:
> I have a SQL 2000 Server Standard Edition. When I tried to install service
> pack 1, 2, or 3, it stopped the installation itself with the above error.
> Can anyone help me please?
> Thanks and regards,
> Jacky
> jackykit@.hotmail.com|||Sorry, I locate the sqlstp.log but it's not the updated one so I extract some
information from errorlog in C:\Program Files\Microsoft SQL Server\MSSQL\LOG.
2005-01-06 14:06:19.21 server Microsoft SQL Server 2000 - 8.00.760
(Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
2005-01-06 14:06:19.21 server Copyright (C) 1988-2002 Microsoft
Corporation.
2005-01-06 14:06:19.21 server All rights reserved.
2005-01-06 14:06:19.21 server Server Process ID is 4072.
2005-01-06 14:06:19.21 server Logging SQL Server messages in file
'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2005-01-06 14:06:19.23 server SQL Server is starting at priority class
'high'(1 CPU detected).
2005-01-06 14:06:19.28 server SQL Server configured for thread mode
processing.
2005-01-06 14:06:19.28 server Using dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2005-01-06 14:06:19.29 server Attempting to initialize Distributed
Transaction Coordinator.
2005-01-06 14:06:21.35 spid3 Starting up database 'master'.
2005-01-06 14:06:21.53 spid5 Starting up database 'model'.
2005-01-06 14:06:21.53 server Using 'SSNETLIB.DLL' version '8.0.766'.
2005-01-06 14:06:21.56 spid3 Server name is 'SUN426'.
2005-01-06 14:06:21.68 spid8 Starting up database 'msdb'.
2005-01-06 14:06:21.68 spid9 Starting up database 'pubs'.
2005-01-06 14:06:21.68 spid10 Starting up database 'Northwind'.
2005-01-06 14:06:21.68 spid11 Starting up database 'SUNDB'.
2005-01-06 14:06:21.81 server SQL server listening on 10.168.1.11: 1433.
2005-01-06 14:06:21.81 server SQL server listening on 127.0.0.1: 1433.
2005-01-06 14:06:21.87 server SQL server listening on TCP, Named Pipes.
2005-01-06 14:06:21.87 server SQL Server is ready for client connections
2005-01-06 14:06:22.29 spid5 Clearing tempdb database.
2005-01-06 14:06:22.32 spid9 Starting up database 'db_ControlManager'.
2005-01-06 14:06:23.68 spid5 Starting up database 'tempdb'.
2005-01-06 14:06:23.96 spid3 Recovery complete.
2005-01-06 14:06:23.96 spid3 SQL global counter collection task is
created.
2005-01-06 14:06:37.71 spid52 Using 'xpsqlbot.dll' version '2000.80.194'
to execute extended stored procedure 'xp_qv'.
2005-01-06 16:24:14.71 spid68 Starting up database 'sqlbpa'.
2005-01-06 16:50:36.17 spid68 Using 'xpstar.dll' version '2000.80.760' to
execute extended stored procedure 'sp_MSgetversion'.
2005-01-06 16:50:42.60 spid68 Error: 15457, Severity: 0, State: 1
2005-01-06 16:50:42.60 spid68 Configuration option 'show advanced
options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2005-01-06 16:50:42.79 spid68 Using 'xplog70.dll' version '2000.80.760'
to execute extended stored procedure 'xp_msver'.
"Mark Allison" wrote:
> Keroppi,
> Can you post the log file, or preferably, the relevant portions of the
> log? The file should be called sqlstp.log and their may be some
> information in the SQL Server ERRORLOG file.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
> Keroppi wrote:
> > I have a SQL 2000 Server Standard Edition. When I tried to install service
> > pack 1, 2, or 3, it stopped the installation itself with the above error.
> > Can anyone help me please?
> >
> > Thanks and regards,
> > Jacky
> >
> > jackykit@.hotmail.com
>|||This is a multi-part message in MIME format.
--=_NextPart_000_0017_01C4F433.0380D220
Content-Type: text/plain;
charset="big5"
Content-Transfer-Encoding: quoted-printable
I also attached 2 files for your reference.
Thanks in advance.
Keroppi
"Keroppi" <Keroppi@.discussions.microsoft.com> ==BC=B6=BCg=A9=F3=B6l=A5=F3=B7s=BBD:C7E6819B-824B-40EC-BF57-4FC2F4B35580@.m=icrosoft.com...
> Sorry, I locate the sqlstp.log but it's not the updated one so I =extract some > information from errorlog in C:\Program Files\Microsoft SQL =Server\MSSQL\LOG.
> > > 2005-01-06 14:06:19.21 server Microsoft SQL Server 2000 - 8.00.760 =
> (Intel X86) > Dec 17 2002 14:22:05 > Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> > 2005-01-06 14:06:19.21 server Copyright (C) 1988-2002 Microsoft > Corporation.
> 2005-01-06 14:06:19.21 server All rights reserved.
> 2005-01-06 14:06:19.21 server Server Process ID is 4072.
> 2005-01-06 14:06:19.21 server Logging SQL Server messages in file > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
> 2005-01-06 14:06:19.23 server SQL Server is starting at priority =class > 'high'(1 CPU detected).
> 2005-01-06 14:06:19.28 server SQL Server configured for thread mode =
> processing.
> 2005-01-06 14:06:19.28 server Using dynamic lock allocation. [2500] =Lock > Blocks, [5000] Lock Owner Blocks.
> 2005-01-06 14:06:19.29 server Attempting to initialize Distributed > Transaction Coordinator.
> 2005-01-06 14:06:21.35 spid3 Starting up database 'master'.
> 2005-01-06 14:06:21.53 spid5 Starting up database 'model'.
> 2005-01-06 14:06:21.53 server Using 'SSNETLIB.DLL' version ='8.0.766'.
> 2005-01-06 14:06:21.56 spid3 Server name is 'SUN426'.
> 2005-01-06 14:06:21.68 spid8 Starting up database 'msdb'.
> 2005-01-06 14:06:21.68 spid9 Starting up database 'pubs'.
> 2005-01-06 14:06:21.68 spid10 Starting up database 'Northwind'.
> 2005-01-06 14:06:21.68 spid11 Starting up database 'SUNDB'.
> 2005-01-06 14:06:21.81 server SQL server listening on 10.168.1.11: =1433.
> 2005-01-06 14:06:21.81 server SQL server listening on 127.0.0.1: =1433.
> 2005-01-06 14:06:21.87 server SQL server listening on TCP, Named =Pipes.
> 2005-01-06 14:06:21.87 server SQL Server is ready for client =connections
> 2005-01-06 14:06:22.29 spid5 Clearing tempdb database.
> 2005-01-06 14:06:22.32 spid9 Starting up database ='db_ControlManager'.
> 2005-01-06 14:06:23.68 spid5 Starting up database 'tempdb'.
> 2005-01-06 14:06:23.96 spid3 Recovery complete.
> 2005-01-06 14:06:23.96 spid3 SQL global counter collection task is =
> created.
> 2005-01-06 14:06:37.71 spid52 Using 'xpsqlbot.dll' version ='2000.80.194' > to execute extended stored procedure 'xp_qv'.
> 2005-01-06 16:24:14.71 spid68 Starting up database 'sqlbpa'.
> 2005-01-06 16:50:36.17 spid68 Using 'xpstar.dll' version ='2000.80.760' to > execute extended stored procedure 'sp_MSgetversion'.
> 2005-01-06 16:50:42.60 spid68 Error: 15457, Severity: 0, State: 1
> 2005-01-06 16:50:42.60 spid68 Configuration option 'show advanced > options' changed from 1 to 1. Run the RECONFIGURE statement to =install..
> 2005-01-06 16:50:42.79 spid68 Using 'xplog70.dll' version ='2000.80.760' > to execute extended stored procedure 'xp_msver'.
> > > > "Mark Allison" wrote:
> >> Keroppi,
>> >> Can you post the log file, or preferably, the relevant portions of =the >> log? The file should be called sqlstp.log and their may be some >> information in the SQL Server ERRORLOG file.
>> >> --
>> Mark Allison, SQL Server MVP
>> http://www.markallison.co.uk
>> >> Looking for a SQL Server replication book?
>> http://www.nwsu.com/0974973602m.html
>> >> >> Keroppi wrote:
>> > I have a SQL 2000 Server Standard Edition. When I tried to install =service >> > pack 1, 2, or 3, it stopped the installation itself with the above =error. >> > Can anyone help me please?
>> > >> > Thanks and regards,
>> > Jacky
>> > >> > jackykit@.hotmail.com
--=_NextPart_000_0017_01C4F433.0380D220
Content-Type: application/octet-stream;
name="sp1_serv_uni.out"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="sp1_serv_uni.out"
//5bAEQAQgBOAEUAVABMAEkAQgBdAEcAZQBuAGUAcgBhAGwAIABuAGUAdAB3AG8AcgBrACAAZQBy
AHIAbwByAC4AIABDAGgAZQBjAGsAIAB5AG8AdQByACAAbgBlAHQAdwBvAHIAawAgAGQAbwBjAHUA
bQBlAG4AdABhAHQAaQBvAG4ALgANAAoAWwBEAEIATgBFAFQATABJAEIAXQBDAG8AbgBuAGUAYwB0
AGkAbwBuAFIAZQBhAGQAIAAoAFcAcgBhAHAAcABlAHIAUgBlAGEAZAAoACkAKQAuAA0ACgA=--=_NextPart_000_0017_01C4F433.0380D220
Content-Type: application/octet-stream;
name="sqlsp.log"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: attachment;
filename="sqlsp.log"
20:55:30 Begin Setup
20:55:30 Version on Media: 8.00.534
20:55:30 Mode =3D Normal
20:55:30 ModeType =3D NORMAL
20:55:30 Begin: SetupInitialize() 20:55:30 End: SetupInitialize()
20:55:30 Begin: CheckFixedRequirements()
20:55:30 Platform ID: 0xf00
20:55:30 Version: 5.0.2195
20:55:30 File Version - C:\WINNT\system32\shdocvw.dll: 6.0.2800.1400
20:55:30 End: CheckFixedRequirements()
20:55:30 Begin Action: CheckRequirements
20:55:30 Processor Architecture: x86 (Pentium)
20:55:30 Service Pack: 1024
20:55:30 ComputerName: SUN426
20:55:30 User Name: Administrator
20:55:30 IsAllAccessAllowed returned: 1
20:55:30 OS Language: 0x409
20:55:30 End Action CheckRequirements
20:55:30 CreateSetupTopology(SUN426), Handle : 0x1883e60, returned : 0
20:55:30 CreateSetupTopology returned : 0, Handle : 0x1883e60
20:55:30 Topology Type : 1, Return Value : 0
20:55:30 ST_GetPhysicalNode returned : 0, PNHandle : 0x1883e88
20:55:31 PN_EnumerateEx returned : 0
20:55:31 PN_GetSQLStates returned : 0, SqlStates : 0x88008225
20:55:31 PN_StartScan [0x1883e88] returned : 0
20:55:31 PN_GetNext [0x1883e88] returned : 0, Handle: [0x1884418]
20:55:31 SQLI_GetPackageId [0x1884418] returned : 0, PackageId =3D 0x2
20:55:31 SQLI_GetVersion [0x1884418] returned : 0, Version =3D 8.00.194
20:55:31 PN_GetNext [0x1883e88] returned : 18, Handle: [0x0]
20:55:31 ReleaseSetupTopology
20:55:31 This combination of Package and Operating System allows a full =product install.
20:55:31 Begin: SetupInstall()
20:55:31 Reading =Software\Microsoft\Windows\CurrentVersion\CommonFilesDir ...
20:55:31 CommonFilesDir=3DC:\Program Files\Common Files
20:55:31 Windows Directory=3DC:\WINNT\
20:55:31 Program Files=3DC:\Program Files\
20:55:31 TEMPDIR=3DC:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\
20:55:31 End: SetupInstall()
20:55:31 Begin: ShowDialogs()
20:55:31 Initial Dialog Mask: 0x8300037, Disable Back=3D0x1
20:55:31 Begin Action ShowDialogsHlpr: 0x1
20:55:31 Begin Action: DialogShowSdWelcome
20:55:33 End Action DialogShowSdWelcome
20:55:33 Dialog 0x1 returned: 1
20:55:33 End Action ShowDialogsHlpr
20:55:33 ShowDialogsGetDialog returned: nCurrent=3D0x2,index=3D1
20:55:33 Begin Action ShowDialogsHlpr: 0x2
20:55:33 Begin Action: DialogShowSdMachineName
20:55:33 ShowDlgMachine returned: 1
20:55:33 Name =3D SUN426, Type =3D 0x1
20:55:33 End Action DialogShowSdMachineName
20:55:33 begin ShowDialogsUpdateMask
20:55:33 nFullMask =3D 0x8300037, nCurrent =3D 0x2, nDirection =3D 0
20:55:33 Updated Dialog Mask: 0xbf00035, Disable Back =3D 0x1
20:55:33 Dialog 0x2 returned: 0
20:55:33 End Action ShowDialogsHlpr
20:55:33 ShowDialogsGetDialog returned: nCurrent=3D0x4,index=3D2
20:55:33 Begin Action ShowDialogsHlpr: 0x4
20:55:33 Begin Action: DialogShowSdInstallMode
20:55:33 ShowDlgInstallMode returned: 1
20:55:33 InstallMode : 0x2
20:55:33 End Action DialogShowSdInstallMode
20:55:33 begin ShowDialogsUpdateMask
20:55:33 nFullMask =3D 0xbf00035, nCurrent =3D 0x4, nDirection =3D 1
20:55:33 Updated Dialog Mask: 0xb000627, Disable Back =3D 0x1
20:55:33 Dialog 0x4 returned: 1
20:55:33 End Action ShowDialogsHlpr
20:55:33 ShowDialogsGetDialog returned: nCurrent=3D0x20,index=3D5
20:55:33 Begin Action ShowDialogsHlpr: 0x20
20:55:33 Begin Action: DialogShowSdLicense
20:55:34 End Action DialogShowSdLicense
20:55:34 Dialog 0x20 returned: 1
20:55:34 End Action ShowDialogsHlpr
20:55:34 ShowDialogsGetDialog returned: nCurrent=3D0x200,index=3D9
20:55:34 Begin Action ShowDialogsHlpr: 0x200
20:55:34 Begin Action: DialogShowSdInstanceName
20:55:34 Begin Action: ShowDlgInstanceName
20:55:35 =Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\CSDVersionNumbe=r key not found, no SP installed
20:55:35 The language on the CD is 1033 and installed is 1033
20:55:35 End Action : Verify Language
20:55:35 SKU is : Standard Edition
20:55:35 End Action: ShowDlgInstanceName
20:55:35 ShowDlgInstanceName returned : 0
20:55:35 InstanceName : MSSQLSERVER
20:55:35 End Action DialogShowSdInstanceName
20:55:35 begin ShowDialogsUpdateMask
20:55:35 nFullMask =3D 0xb000627, nCurrent =3D 0x200, nDirection =3D 0
20:55:35 Updated Dialog Mask: 0xbc00627, Disable Back =3D 0x1
20:55:35 Dialog 0x200 returned: 0
20:55:35 End Action ShowDialogsHlpr
20:55:35 ShowDialogsGetDialog returned: nCurrent=3D0x400,index=3D10
20:55:35 Begin Action ShowDialogsHlpr: 0x400
20:55:35 Begin Action: DialogShowSdMaintain
20:55:35 ShowDlgMaintainInstall returned : 1
20:55:35 Type : 0xc
20:55:35 CreateSetupTopology(SUN426), Handle : 0x1883e60, returned : 0
20:55:35 CreateSetupTopology returned : 0, Handle : 0x1883e60
20:55:35 Topology Type : 1, Return Value : 0
20:55:35 ST_GetPhysicalNode returned : 0, PNHandle : 0x1883e88
20:55:35 PN_EnumerateEx returned : 0
20:55:35 PN_GetSQLStates returned : 0, SqlStates : 0x88008225
20:55:35 PN_GetInstance for MSSQLSERVER [0x1883e88] returned : 0
20:55:35 SQLI_GetPackageId [0x1884418] returned : 0, PackageId =3D 0x2
20:55:35 SQLI_GetVersion [0x1884418] returned : 0, Version =3D 8.00.194
20:55:35 SQLI_GetSQLStates for MSSQLSERVER [0x1884418] returned : 0, =SQLStates: 0xc00205
20:55:35 SQLI_GetInstallPath [0x1884418] returned : 0, Path =3D =C:\Program Files\Microsoft SQL Server\MSSQL
20:55:35 SQLI_GetDataPath [0x1884418] returned : 0, DataPath =3D =C:\Program Files\Microsoft SQL Server\MSSQL
20:55:35 SQLI_GetVersion [0x1884418] returned : 0, Version =3D 8.00.194
20:55:35 SQLI_GetRegKeyRoot [0x1884418] returned : 0, RegKeyRoot =3D =Software\Microsoft\MSSQLServer
20:55:35 SQLI_GetPackageName [0x1884418] returned : 0, szPackage =3D =Standard Edition
20:55:35 SQLI_GetPackageId [0x1884418] returned : 0, PackageId =3D 0x2
20:55:35 Previous Install Path: C:\Program Files\Microsoft SQL =Server\MSSQL
20:55:35 Previous Install Data: C:\Program Files\Microsoft SQL =Server\MSSQL
20:55:35 Previous Install Version: 8.00.194
20:55:35 ReleaseSetupTopology
20:55:35 End Action DialogShowSdMaintain
20:55:35 begin ShowDialogsUpdateMask
20:55:35 nFullMask =3D 0xbc00627, nCurrent =3D 0x400, nDirection =3D 1
20:55:35 Updated Dialog Mask: 0xb002627, Disable Back =3D 0x1
20:55:35 Dialog 0x400 returned: 1
20:55:35 End Action ShowDialogsHlpr
20:55:35 ShowDialogsGetDialog returned: nCurrent=3D0x2000,index=3D13
20:55:35 Begin Action ShowDialogsHlpr: 0x2000
20:55:35 Begin Action: DialogShowSdUpgrade
20:55:35 ShowDlgUpgrade returned : 1
20:55:35 Checking databases on instance 'MSSQLSERVER'
20:55:35 Authenticate access
20:55:35 Begin SDPassword Dialog
20:55:46 End SDPassword Dialog
20:55:46 C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe =-Silent 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-m
20:55:47 Process Exit Code: (0) 20:55:47 C:\Temp\sql2ksp2\x86\BINN\osql.exe -S SUN426 -n -d master -Q ="exit" -U sa -P 20:55:49 Process Exit Code: (0) 20:55:49 Access authenticated
20:55:49 C:\Temp\sql2ksp2\x86\BINN\osql.exe -S SUN426 -n -b -d master =-o C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\~sqldb0.txt -i =C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\SqlSetup\Bin\dbverify.sql -U sa =-P 20:55:52 Process Exit Code: (0) 20:55:52 C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe =-Silent 1 -Action 6 -Service MSSQLSERVER 20:56:22 Process Exit Code: (0) 20:56:22 Setup Type: Custom (303)
20:56:22 Processing: SQLProg
20:56:22 Processing: SQLProg\SQLServr
20:56:22 Processing: SQLProg\UpgTools
20:56:22 Processing: SQLProg\ReplSupp
20:56:22 Processing: SQLProg\Install
20:56:22 Processing: SQLProg\System
20:56:22 Processing: SQLProg\SvrExt
20:56:22 Processing: SQLProg\Dat
20:56:22 Processing: SQLProg\DatSmpl
20:56:22 Processing: SQLProg\BaseSys
20:56:22 Processing: SQLProg\BaseBinn
20:56:22 Processing: SQLProg\MSSearch
20:56:22 Processing: SQLProg\BaseInst
20:56:22 Processing: SQLProg\UI
20:56:22 Processing: SQLProg\Symbols
20:56:22 Processing: SQLProg\Perfmon
20:56:22 Processing: SQLProg\Root
20:56:22 Processing: SQLProg\EXE
20:56:22 Processing: SQLProg\DLL
20:56:22 Processing: MgtTool
20:56:22 Processing: MgtTool\SEM
20:56:22 Processing: MgtTool\Profiler
20:56:22 Processing: MgtTool\Qryanlz
20:56:22 Processing: MgtTool\DTCCLi
20:56:22 Processing: MgtTool\Wzcnflct
20:56:22 Processing: MgtTool\UtilSys
20:56:22 Processing: MgtTool\UtilBinn
20:56:22 Processing: Connect
20:56:22 Processing: Connect\ConnSys
20:56:22 Processing: Books
20:56:22 Processing: Books\Bookso
20:56:22 Processing: DevTools
20:56:22 Processing: DevTools\Headers and Libraries
20:56:22 Processing: DevTools\MDAC SDKs
20:56:22 Processing: DevTools\VDI
20:56:22 Processing: DevTools\Dbg Int
20:56:22 Processing: Samples
20:56:22 Processing: Samples\ADO
20:56:22 Processing: Samples\DBLIB
20:56:22 Processing: Samples\Desktop
20:56:22 Processing: Samples\DTS
20:56:22 Processing: Samples\ESQLC
20:56:22 Processing: Samples\Misc
20:56:22 Processing: Samples\MSDTC
20:56:22 Processing: Samples\ODBC
20:56:22 Processing: Samples\ODS
20:56:22 Processing: Samples\OLEAut
20:56:22 Processing: Samples\Repl
20:56:22 Processing: Samples\SilverstoneDB
20:56:22 Processing: Samples\SQLDMO
20:56:22 Processing: Samples\SQLNS
20:56:22 Processing: Samples\Utils
20:56:23 Processing: Samples\XML
20:56:23 Processing: CoreRepl
20:56:23 Processing: CoreRepl\Res1033
20:56:23 Processing: CoreRepl\ResIntl
20:56:23 Processing: Core
20:56:23 Processing: Core\Res1033
20:56:23 Processing: Core\ResOther
20:56:23 Processing: Repostry
20:56:23 Processing: Repostry\RepstSys
20:56:23 Processing: Repostry\Res1033
20:56:23 Processing: Repostry\ResIntl
20:56:23 Processing: CoreMisc
20:56:23 Processing: CoreMisc\ActiveX
20:56:23 Processing: CoreMisc\Res1033
20:56:23 Processing: Monarch
20:56:23 Processing: Monarch\Monr1033
20:56:23 Processing: Monarch\MonrIntl
20:56:23 Processing: Jet
20:56:23 Processing: CoreInst
20:56:23 Processing: CoreCOM
20:56:23 Processing: CoreCOM\Res1033
20:56:23 Processing: CoreCOM\ResIntl
20:56:23 Processing: CoreTool
20:56:23 Processing: CoreTool\Res1033
20:56:23 Processing: CoreTool\ResOther
20:56:23 Processing: DBLibCli
20:56:23 Processing: SFExt
20:56:23 Processing: SFExt\ActiveX
20:56:23 Processing: SFExt\Res1033
20:56:23 Processing: SFExt\ResIntl
20:56:23 Processing: Trace
20:56:23 Processing: Trace\Res1033
20:56:23 Processing: Trace\ResOther
20:56:23 Processing: CnctBinn
20:56:23 Processing: MiscCore
20:56:23 Processing: MC
20:56:23 Processing: MC\MC1033
20:56:23 Processing: MC\MCIntl
20:56:23 Processing: MC\Help
20:56:23 Processing: UI
20:56:23 Processing: UI\UIHlp
20:56:23 Processing: UI\UI1033
20:56:23 Processing: UI\UIIntl
20:56:23 Processing: ClstSys
20:56:23 Processing: SQLMgr
20:56:23 Processing: SQLMgr\Res1033
20:56:23 Processing: SQLMgr\ResIntl
20:56:23 Processing: SvrTool
20:56:23 Processing: SvrTool\Res1033
20:56:23 Processing: SvrTool\ResIntl
20:56:23 Processing: DTSUI
20:56:23 Processing: DTSUI\Res1033
20:56:23 Processing: DTSUI\ResIntl
20:56:23 Processing: ClFTSys
20:56:23 Processing: ClFtdata
20:56:23 Processing: MSOlap
20:56:23 Processing: MSOlap\Res1033
20:56:23 Processing: MSOlap\ResIntl
20:56:23 Processing: ATL
20:56:23 Processing: ATL\winnt
20:56:23 Processing: ATL\win9x
20:56:23 Processing: MFC42U
20:56:23 Processing: VC
20:56:23 Processing: VB
20:56:23 Processing: OCX1
20:56:23 Processing: SQLAdHlp
20:56:23 Processing: SQLAdHlp\Res1033
20:56:23 Processing: SQLAdHlp\ResOther
20:56:23 Setup type: Custom
20:56:23 End Action DialogShowSdUpgrade
20:56:23 begin ShowDialogsUpdateMask
20:56:23 nFullMask =3D 0xb002627, nCurrent =3D 0x2000, nDirection =3D 1
20:56:23 Updated Dialog Mask: 0xb002627, Disable Back =3D 0x1
20:56:23 Dialog 0x2000 returned: 1
20:56:23 End Action ShowDialogsHlpr
20:56:23 ShowDialogsGetDialog returned: nCurrent=3D0x1000000,index=3D24
20:56:23 Begin Action ShowDialogsHlpr: 0x1000000
20:56:23 Begin Action: DlgCollation
20:56:23 ShowDlgCollation returned: 1
20:56:23 collation_name =3D SQL_Latin1_General_CP1_CI_AS,locale_name =3D =Latin1_General,lcid =3D 0x409,SortId =3D 52,dwCompFlags =3D 0x30001
20:56:23 End Action DlgCollation
20:56:23 begin ShowDialogsUpdateMask
20:56:23 nFullMask =3D 0xb002627, nCurrent =3D 0x1000000, nDirection =3D =1
20:56:23 Updated Dialog Mask: 0xb002627, Disable Back =3D 0x1
20:56:23 Dialog 0x1000000 returned: 1
20:56:23 End Action ShowDialogsHlpr
20:56:23 ShowDialogsGetDialog returned: nCurrent=3D0x2000000,index=3D25
20:56:23 Begin Action ShowDialogsHlpr: 0x2000000
20:56:23 Begin Action: DlgNetwork
20:56:23 ShowDlgNetwork returned: 1
20:56:23 [DlgServerNetwork]
20:56:23 NetworkLibs =3D 255
20:56:23 TCPPort =3D 1433
20:56:23 TCPPrxy =3D Default
20:56:23 NMPPipeName =3D \\.\pipe\sql\query
20:56:23 Result =3D 1
20:56:23 End Action DlgNetwork
20:56:23 begin ShowDialogsUpdateMask
20:56:23 nFullMask =3D 0xb002627, nCurrent =3D 0x2000000, nDirection =3D =1
20:56:23 Updated Dialog Mask: 0xb002627, Disable Back =3D 0x1
20:56:23 Dialog 0x2000000 returned: 1
20:56:23 End Action ShowDialogsHlpr
20:56:23 ShowDialogsGetDialog returned: nCurrent=3D0x8000000,index=3D27
20:56:23 Begin Action ShowDialogsHlpr: 0x8000000
20:56:23 Begin Action: DialogShowSdStartCopy
20:58:28 End Action DialogShowSdStartCopy
20:58:28 begin ShowDialogsUpdateMask
20:58:28 nFullMask =3D 0xb002627, nCurrent =3D 0x8000000, nDirection =3D =1
20:58:28 Updated Dialog Mask: 0xb002627, Disable Back =3D 0x1
20:58:28 Dialog 0x8000000 returned: 1
20:58:28 End Action ShowDialogsHlpr
20:58:28 ShowDialogsGetDialog returned: nCurrent=3D0x0,index=3D0
20:58:28 End: ShowDialogs()
20:58:28 Initializing Event Log
20:58:28 Begin Action : LogEvent
20:58:28 End Action : LogEvent
20:58:28 Begin: ProcessBeforeDataMove()
20:58:29 DeinstallStart returned (C:\Program Files\Microsoft SQL =Server\MSSQL): 0
20:58:29 End: ProcessBeforeDataMove()
20:58:29 Begin: SetToolsComponentSelection()
20:58:29 CreateSetupTopology(SUN426), Handle : 0x1883e60, returned : 0
20:58:29 CreateSetupTopology returned : 0, Handle : 0x1883e60
20:58:29 Topology Type : 1, Return Value : 0
20:58:29 ST_GetPhysicalNode returned : 0, PNHandle : 0x1883e88
20:58:29 PN_EnumerateEx returned : 0
20:58:29 PN_GetSQLStates returned : 0, SqlStates : 0x88008225
20:58:29 PN_StartScan [0x1883e88] returned : 0
20:58:29 PN_GetNext [0x1883e88] returned : 18, Handle: [0x0]
20:58:29 No more items in enumeration.
20:58:29 ReleaseSetupTopology
20:58:29 End: SetToolsComponentSelection()
20:58:29 Begin: ProcessComponentSelection()
20:58:29 End: ProcessComponentSelection()
20:58:29 Begin: LogSelectedComponents()
20:58:29 Processing: SQLProg
20:58:29 Selected: SQLProg
20:58:29 Processing: SQLProg\SQLServr
20:58:29 Selected: SQLProg\SQLServr
20:58:29 Processing: SQLProg\SQLServr\Help
20:58:29 Selected: SQLProg\SQLServr\Help
20:58:29 Processing: SQLProg\SQLServr\SCMDev
20:58:29 Selected: SQLProg\SQLServr\SCMDev
20:58:29 Processing: SQLProg\SQLServr\SCMDev\SCMh
20:58:29 Selected: SQLProg\SQLServr\SCMDev\SCMh
20:58:29 Processing: SQLProg\SQLServr\SCMDev\SCMX86Lb
20:58:29 Selected: SQLProg\SQLServr\SCMDev\SCMX86Lb
20:58:29 Processing: SQLProg\SQLServr\SCMDev\SCMALb
20:58:29 Selected: SQLProg\SQLServr\SCMDev\SCMALb
20:58:29 Processing: SQLProg\SQLServr\Rs1033
20:58:29 Selected: SQLProg\SQLServr\Rs1033
20:58:29 Processing: SQLProg\SQLServr\RsIntl
20:58:29 Selected: SQLProg\SQLServr\RsIntl
20:58:29 Processing: SQLProg\SQLServr\ActiveX
20:58:29 Selected: SQLProg\SQLServr\ActiveX
20:58:29 Processing: SQLProg\SQLServr\System
20:58:29 Selected: SQLProg\SQLServr\System
20:58:29 Processing: SQLProg\UpgTools
20:58:29 Selected: SQLProg\UpgTools
20:58:29 Processing: SQLProg\UpgTools\UpgSys
20:58:29 Selected: SQLProg\UpgTools\UpgSys
20:58:29 Processing: SQLProg\UpgTools\ActiveX
20:58:29 Selected: SQLProg\UpgTools\ActiveX
20:58:29 Processing: SQLProg\UpgTools\Res1033
20:58:29 Selected: SQLProg\UpgTools\Res1033
20:58:29 Processing: SQLProg\UpgTools\ResOther
20:58:29 Selected: SQLProg\UpgTools\ResOther
20:58:29 Processing: SQLProg\UpgTools\Resld
20:58:29 Selected: SQLProg\UpgTools\Resld
20:58:29 Processing: SQLProg\ReplSupp
20:58:29 Selected: SQLProg\ReplSupp
20:58:29 Processing: SQLProg\ReplSupp\ReplDat
20:58:29 Selected: SQLProg\ReplSupp\ReplDat
20:58:29 Processing: SQLProg\ReplSupp\RepComm
20:58:29 Selected: SQLProg\ReplSupp\RepComm
20:58:29 Processing: SQLProg\ReplSupp\RepNoDk
20:58:29 Selected: SQLProg\ReplSupp\RepNoDk
20:58:29 Processing: SQLProg\ReplSupp\ActiveX
20:58:29 Selected: SQLProg\ReplSupp\ActiveX
20:58:29 Processing: SQLProg\Install
20:58:29 Selected: SQLProg\Install
20:58:29 Processing: SQLProg\System
20:58:29 Selected: SQLProg\System
20:58:29 Processing: SQLProg\SvrExt
20:58:29 Selected: SQLProg\SvrExt
20:58:29 Processing: SQLProg\SvrExt\Help
20:58:29 Selected: SQLProg\SvrExt\Help
20:58:29 Processing: SQLProg\SvrExt\SvrExtRs
20:58:29 Selected: SQLProg\SvrExt\SvrExtRs
20:58:29 Processing: SQLProg\SvrExt\ResIntl
20:58:29 Selected: SQLProg\SvrExt\ResIntl
20:58:29 Processing: SQLProg\Dat
20:58:29 Processing: SQLProg\DatSmpl
20:58:29 Processing: SQLProg\BaseSys
20:58:29 Selected: SQLProg\BaseSys
20:58:29 Processing: SQLProg\BaseBinn
20:58:29 Selected: SQLProg\BaseBinn
20:58:29 Processing: SQLProg\MSSearch
20:58:29 Selected: SQLProg\MSSearch
20:58:29 Processing: SQLProg\MSSearch\Help
20:58:29 Selected: SQLProg\MSSearch\Help
20:58:29 Processing: SQLProg\MSSearch\ActiveX
20:58:29 Selected: SQLProg\MSSearch\ActiveX
20:58:29 Processing: SQLProg\BaseInst
20:58:29 Selected: SQLProg\BaseInst
20:58:29 Processing: SQLProg\UI
20:58:29 Processing: SQLProg\Symbols
20:58:29 Selected: SQLProg\Symbols
20:58:29 Processing: SQLProg\Symbols\EXE
20:58:29 Selected: SQLProg\Symbols\EXE
20:58:29 Processing: SQLProg\Symbols\DLL
20:58:29 Selected: SQLProg\Symbols\DLL
20:58:29 Processing: SQLProg\Perfmon
20:58:29 Selected: SQLProg\Perfmon
20:58:29 Processing: SQLProg\Perfmon\System
20:58:29 Selected: SQLProg\Perfmon\System
20:58:29 Processing: SQLProg\Root
20:58:29 Processing: SQLProg\EXE
20:58:29 Processing: SQLProg\DLL
20:58:29 Processing: MgtTool
20:58:29 Selected: MgtTool
20:58:29 Processing: MgtTool\SEM
20:58:29 Selected: MgtTool\SEM
20:58:29 Processing: MgtTool\SEM\HTML
20:58:29 Selected: MgtTool\SEM\HTML
20:58:29 Processing: MgtTool\SEM\MSD98
20:58:29 Selected: MgtTool\SEM\MSD98
20:58:29 Processing: MgtTool\SEM\MSD98SYS
20:58:29 Selected: MgtTool\SEM\MSD98SYS
20:58:29 Processing: MgtTool\SEM\MSD98Res
20:58:29 Selected: MgtTool\SEM\MSD98Res
20:58:29 Processing: MgtTool\SEM\MSD98Hlp
20:58:29 Selected: MgtTool\SEM\MSD98Hlp
20:58:29 Processing: MgtTool\SEM\Help
20:58:29 Selected: MgtTool\SEM\Help
20:58:29 Processing: MgtTool\SEM\Res1033
20:58:29 Selected: MgtTool\SEM\Res1033
20:58:29 Processing: MgtTool\SEM\ResIntl
20:58:29 Selected: MgtTool\SEM\ResIntl
20:58:29 Processing: MgtTool\SEM\MSD98RsI
20:58:29 Selected: MgtTool\SEM\MSD98RsI
20:58:29 Processing: MgtTool\SEM\ActiveX
20:58:29 Selected: MgtTool\SEM\ActiveX
20:58:29 Processing: MgtTool\SEM\ActiveX\Res1033
20:58:29 Selected: MgtTool\SEM\ActiveX\Res1033
20:58:29 Processing: MgtTool\SEM\ActiveX\ResIntl
20:58:29 Selected: MgtTool\SEM\ActiveX\ResIntl
20:58:29 Processing: MgtTool\SEM\Scripts
20:58:29 Selected: MgtTool\SEM\Scripts
20:58:29 Processing: MgtTool\SEM\OLEDB
20:58:29 Selected: MgtTool\SEM\OLEDB
20:58:29 Processing: MgtTool\SEM\OLEDB\Res1033
20:58:29 Selected: MgtTool\SEM\OLEDB\Res1033
20:58:29 Processing: MgtTool\SEM\OLEDB\ResIntl
20:58:29 Selected: MgtTool\SEM\OLEDB\ResIntl
20:58:29 Processing: MgtTool\Profiler
20:58:29 Selected: MgtTool\Profiler
20:58:29 Processing: MgtTool\Profiler\Help
20:58:29 Selected: MgtTool\Profiler\Help
20:58:29 Processing: MgtTool\Profiler\Res1033
20:58:29 Selected: MgtTool\Profiler\Res1033
20:58:29 Processing: MgtTool\Profiler\ResIntl
20:58:29 Selected: MgtTool\Profiler\ResIntl
20:58:29 Processing: MgtTool\Qryanlz
20:58:29 Selected: MgtTool\Qryanlz
20:58:29 Processing: MgtTool\Qryanlz\Help
20:58:29 Selected: MgtTool\Qryanlz\Help
20:58:29 Processing: MgtTool\Qryanlz\Res1033
20:58:29 Selected: MgtTool\Qryanlz\Res1033
20:58:29 Processing: MgtTool\Qryanlz\ResIntl
20:58:29 Selected: MgtTool\Qryanlz\ResIntl
20:58:29 Processing: MgtTool\DTCCLi
20:58:29 Selected: MgtTool\DTCCLi
20:58:29 Processing: MgtTool\Wzcnflct
20:58:29 Selected: MgtTool\Wzcnflct
20:58:29 Processing: MgtTool\Wzcnflct\WzcnHlp
20:58:29 Selected: MgtTool\Wzcnflct\WzcnHlp
20:58:29 Processing: MgtTool\Wzcnflct\Wzcn1033
20:58:29 Selected: MgtTool\Wzcnflct\Wzcn1033
20:58:29 Processing: MgtTool\Wzcnflct\WzcnOthr
20:58:29 Selected: MgtTool\Wzcnflct\WzcnOthr
20:58:29 Processing: MgtTool\Wzcnflct\WzcnCmn
20:58:29 Selected: MgtTool\Wzcnflct\WzcnCmn
20:58:29 Processing: MgtTool\UtilSys
20:58:29 Selected: MgtTool\UtilSys
20:58:29 Processing: MgtTool\UtilBinn
20:58:29 Selected: MgtTool\UtilBinn
20:58:29 Processing: Connect
20:58:29 Selected: Connect
20:58:29 Processing: Connect\ConnSys
20:58:29 Selected: Connect\ConnSys
20:58:29 Processing: Books
20:58:29 Selected: Books
20:58:29 Processing: Books\Bookso
20:58:29 Selected: Books\Bookso
20:58:29 Processing: Books\Bookso\Utils
20:58:29 Selected: Books\Bookso\Utils
20:58:29 Processing: DevTools
20:58:29 Selected: DevTools
20:58:29 Processing: DevTools\Headers and Libraries
20:58:29 Processing: DevTools\Headers and Libraries\Include
20:58:29 Processing: DevTools\Headers and Libraries\Libx86
20:58:29 Processing: DevTools\Headers and Libraries\LibAlpha
20:58:29 Processing: DevTools\Headers and Libraries\ESQLC
20:58:29 Processing: DevTools\MDAC SDKs
20:58:29 Processing: DevTools\VDI
20:58:29 Processing: DevTools\VDI\Inc
20:58:29 Processing: DevTools\VDI\Samples
20:58:29 Processing: DevTools\Dbg Int
20:58:29 Selected: DevTools\Dbg Int
20:58:29 Processing: DevTools\Dbg Int\Dbg Int Common
20:58:29 Selected: DevTools\Dbg Int\Dbg Int Common
20:58:29 Processing: DevTools\Dbg Int\EXE
20:58:29 Selected: DevTools\Dbg Int\EXE
20:58:29 Processing: Samples
20:58:29 Selected: Samples
20:58:29 Processing: Samples\ADO
20:58:29 Selected: Samples\ADO
20:58:29 Processing: Samples\DBLIB
20:58:29 Selected: Samples\DBLIB
20:58:30 Processing: Samples\Desktop
20:58:30 Selected: Samples\Desktop
20:58:30 Processing: Samples\DTS
20:58:30 Selected: Samples\DTS
20:58:30 Processing: Samples\ESQLC
20:58:30 Selected: Samples\ESQLC
20:58:30 Processing: Samples\Misc
20:58:30 Selected: Samples\Misc
20:58:30 Processing: Samples\MSDTC
20:58:30 Selected: Samples\MSDTC
20:58:30 Processing: Samples\ODBC
20:58:30 Selected: Samples\ODBC
20:58:30 Processing: Samples\ODS
20:58:30 Selected: Samples\ODS
20:58:30 Processing: Samples\OLEAut
20:58:30 Selected: Samples\OLEAut
20:58:30 Processing: Samples\Repl
20:58:30 Selected: Samples\Repl
20:58:30 Processing: Samples\SilverstoneDB
20:58:30 Processing: Samples\SQLDMO
20:58:30 Selected: Samples\SQLDMO
20:58:30 Processing: Samples\SQLNS
20:58:30 Selected: Samples\SQLNS
20:58:30 Processing: Samples\Utils
20:58:30 Selected: Samples\Utils
20:58:30 Processing: Samples\XML
20:58:30 Selected: Samples\XML
20:58:30 Processing: CoreRepl
20:58:30 Selected: CoreRepl
20:58:30 Processing: CoreRepl\Res1033
20:58:30 Selected: CoreRepl\Res1033
20:58:30 Processing: CoreRepl\ResIntl
20:58:30 Selected: CoreRepl\ResIntl
20:58:30 Processing: Core
20:58:30 Selected: Core
20:58:30 Processing: Core\Res1033
20:58:30 Selected: Core\Res1033
20:58:30 Processing: Core\ResOther
20:58:30 Selected: Core\ResOther
20:58:30 Processing: Repostry
20:58:30 Selected: Repostry
20:58:30 Processing: Repostry\RepstSys
20:58:30 Selected: Repostry\RepstSys
20:58:30 Processing: Repostry\Res1033
20:58:30 Selected: Repostry\Res1033
20:58:30 Processing: Repostry\ResIntl
20:58:30 Selected: Repostry\ResIntl
20:58:30 Processing: CoreMisc
20:58:30 Selected: CoreMisc
20:58:30 Processing: CoreMisc\ActiveX
20:58:30 Selected: CoreMisc\ActiveX
20:58:30 Processing: CoreMisc\ActiveX\Res1033
20:58:30 Selected: CoreMisc\ActiveX\Res1033
20:58:30 Processing: CoreMisc\ActiveX\ResIntl
20:58:30 Selected: CoreMisc\ActiveX\ResIntl
20:58:30 Processing: CoreMisc\Res1033
20:58:30 Selected: CoreMisc\Res1033
20:58:30 Processing: Monarch
20:58:30 Selected: Monarch
20:58:30 Processing: Monarch\Monr1033
20:58:30 Selected: Monarch\Monr1033
20:58:30 Processing: Monarch\MonrIntl
20:58:30 Selected: Monarch\MonrIntl
20:58:30 Processing: Jet
20:58:30 Selected: Jet
20:58:30 Processing: CoreInst
20:58:30 Selected: CoreInst
20:58:30 Processing: CoreCOM
20:58:30 Selected: CoreCOM
20:58:30 Processing: CoreCOM\Res1033
20:58:30 Selected: CoreCOM\Res1033
20:58:30 Processing: CoreCOM\ResIntl
20:58:30 Selected: CoreCOM\ResIntl
20:58:30 Processing: CoreTool
20:58:30 Selected: CoreTool
20:58:30 Processing: CoreTool\Res1033
20:58:30 Selected: CoreTool\Res1033
20:58:30 Processing: CoreTool\ResOther
20:58:30 Selected: CoreTool\ResOther
20:58:30 Processing: DBLibCli
20:58:30 Selected: DBLibCli
20:58:30 Processing: SFExt
20:58:30 Selected: SFExt
20:58:30 Processing: SFExt\ActiveX
20:58:30 Selected: SFExt\ActiveX
20:58:30 Processing: SFExt\ActiveX\Res1033
20:58:30 Selected: SFExt\ActiveX\Res1033
20:58:30 Processing: SFExt\ActiveX\ResIntl
20:58:30 Selected: SFExt\ActiveX\ResIntl
20:58:30 Processing: SFExt\Res1033
20:58:30 Selected: SFExt\Res1033
20:58:30 Processing: SFExt\ResIntl
20:58:30 Selected: SFExt\ResIntl
20:58:30 Processing: Trace
20:58:30 Selected: Trace
20:58:30 Processing: Trace\Res1033
20:58:30 Selected: Trace\Res1033
20:58:30 Processing: Trace\ResOther
20:58:30 Selected: Trace\ResOther
20:58:30 Processing: CnctBinn
20:58:30 Processing: MiscCore
20:58:30 Selected: MiscCore
20:58:30 Processing: MC
20:58:30 Selected: MC
20:58:30 Processing: MC\MC1033
20:58:30 Selected: MC\MC1033
20:58:30 Processing: MC\MCIntl
20:58:30 Selected: MC\MCIntl
20:58:30 Processing: MC\Help
20:58:30 Selected: MC\Help
20:58:30 Processing: UI
20:58:30 Processing: UI\UIHlp
20:58:30 Processing: UI\UI1033
20:58:30 Processing: UI\UIIntl
20:58:30 Processing: ClstSys
20:58:30 Processing: SQLMgr
20:58:30 Selected: SQLMgr
20:58:30 Processing: SQLMgr\Res1033
20:58:30 Selected: SQLMgr\Res1033
20:58:30 Processing: SQLMgr\ResIntl
20:58:30 Selected: SQLMgr\ResIntl
20:58:30 Processing: SvrTool
20:58:30 Selected: SvrTool
20:58:30 Processing: SvrTool\Res1033
20:58:30 Selected: SvrTool\Res1033
20:58:30 Processing: SvrTool\ResIntl
20:58:30 Selected: SvrTool\ResIntl
20:58:30 Processing: DTSUI
20:58:30 Selected: DTSUI
20:58:30 Processing: DTSUI\Res1033
20:58:30 Selected: DTSUI\Res1033
20:58:30 Processing: DTSUI\ResIntl
20:58:30 Selected: DTSUI\ResIntl
20:58:30 Processing: ClFTSys
20:58:30 Processing: ClFtdata
20:58:30 Processing: MSOlap
20:58:30 Selected: MSOlap
20:58:30 Processing: MSOlap\Res1033
20:58:30 Selected: MSOlap\Res1033
20:58:30 Processing: MSOlap\ResIntl
20:58:30 Selected: MSOlap\ResIntl
20:58:30 Processing: ATL
20:58:30 Selected: ATL
20:58:30 Processing: ATL\winnt
20:58:30 Selected: ATL\winnt
20:58:30 Processing: ATL\win9x
20:58:30 Selected: ATL\win9x
20:58:30 Processing: MFC42U
20:58:30 Selected: MFC42U
20:58:30 Processing: VC
20:58:30 Selected: VC
20:58:30 Processing: VB
20:58:30 Selected: VB
20:58:30 Processing: OCX1
20:58:30 Selected: OCX1
20:58:30 Processing: SQLAdHlp
20:58:30 Selected: SQLAdHlp
20:58:30 Processing: SQLAdHlp\Res1033
20:58:30 Selected: SQLAdHlp\Res1033
20:58:30 Processing: SQLAdHlp\ResOther
20:58:30 Selected: SQLAdHlp\ResOther
20:58:30 {E07FDDBE-5A21-11d2-9DAD-00C04F79D434}
20:58:30 {E07FDDC7-5A21-11d2-9DAD-00C04F79D434}
20:58:30 {E07FDDC0-5A21-11d2-9DAD-00C04F79D434}
20:58:30 {E07FDDBF-5A21-11d2-9DAD-00C04F79D434}
20:58:30 End: LogSelectedComponents()
20:58:30 Processing: SQLProg
20:58:30 Processing: SQLProg\SQLServr
20:58:30 Processing: SQLProg\SQLServr\Help
20:58:30 Processing: SQLProg\SQLServr\SCMDev
20:58:30 Processing: SQLProg\SQLServr\SCMDev\SCMh
20:58:30 Processing: SQLProg\SQLServr\SCMDev\SCMX86Lb
20:58:30 Processing: SQLProg\SQLServr\SCMDev\SCMALb
20:58:30 Processing: SQLProg\SQLServr\Rs1033
20:58:30 Processing: SQLProg\SQLServr\RsIntl
20:58:30 Processing: SQLProg\SQLServr\ActiveX
20:58:30 Processing: SQLProg\SQLServr\System
20:58:30 Processing: SQLProg\UpgTools
20:58:30 Processing: SQLProg\UpgTools\UpgSys
20:58:30 Processing: SQLProg\UpgTools\ActiveX
20:58:30 Processing: SQLProg\UpgTools\Res1033
20:58:30 Processing: SQLProg\UpgTools\ResOther
20:58:30 Processing: SQLProg\UpgTools\Resld
20:58:30 Processing: SQLProg\ReplSupp
20:58:30 Processing: SQLProg\ReplSupp\ReplDat
20:58:30 Processing: SQLProg\ReplSupp\RepComm
20:58:30 Processing: SQLProg\ReplSupp\RepNoDk
20:58:30 Processing: SQLProg\ReplSupp\ActiveX
20:58:30 Processing: SQLProg\Install
20:58:30 Processing: SQLProg\System
20:58:30 Processing: SQLProg\SvrExt
20:58:30 Processing: SQLProg\SvrExt\Help
20:58:30 Processing: SQLProg\SvrExt\SvrExtRs
20:58:30 Processing: SQLProg\SvrExt\ResIntl
20:58:30 Processing: SQLProg\Dat
20:58:30 Processing: SQLProg\DatSmpl
20:58:30 Processing: SQLProg\BaseSys
20:58:30 Processing: SQLProg\BaseBinn
20:58:30 Processing: SQLProg\MSSearch
20:58:30 Processing: SQLProg\MSSearch\Help
20:58:30 Processing: SQLProg\MSSearch\ActiveX
20:58:30 Processing: SQLProg\BaseInst
20:58:30 Processing: SQLProg\UI
20:58:30 Processing: SQLProg\Symbols
20:58:30 Processing: SQLProg\Symbols\EXE
20:58:30 Processing: SQLProg\Symbols\DLL
20:58:30 Processing: SQLProg\Perfmon
20:58:30 Processing: SQLProg\Perfmon\System
20:58:30 Processing: SQLProg\Root
20:58:30 Processing: SQLProg\EXE
20:58:30 Processing: SQLProg\DLL
20:58:30 Processing: MgtTool
20:58:30 Processing: MgtTool\SEM
20:58:30 Processing: MgtTool\SEM\HTML
20:58:30 Processing: MgtTool\SEM\MSD98
20:58:30 Processing: MgtTool\SEM\MSD98SYS
20:58:30 Processing: MgtTool\SEM\MSD98Res
20:58:30 Processing: MgtTool\SEM\MSD98Hlp
20:58:30 Processing: MgtTool\SEM\Help
20:58:30 Processing: MgtTool\SEM\Res1033
20:58:30 Processing: MgtTool\SEM\ResIntl
20:58:30 Processing: MgtTool\SEM\MSD98RsI
20:58:30 Processing: MgtTool\SEM\ActiveX
20:58:30 Processing: MgtTool\SEM\ActiveX\Res1033
20:58:30 Processing: MgtTool\SEM\ActiveX\ResIntl
20:58:30 Processing: MgtTool\SEM\Scripts
20:58:30 Processing: MgtTool\SEM\OLEDB
20:58:30 Processing: MgtTool\SEM\OLEDB\Res1033
20:58:30 Processing: MgtTool\SEM\OLEDB\ResIntl
20:58:30 Processing: MgtTool\Profiler
20:58:30 Processing: MgtTool\Profiler\Help
20:58:30 Processing: MgtTool\Profiler\Res1033
20:58:30 Processing: MgtTool\Profiler\ResIntl
20:58:30 Processing: MgtTool\Qryanlz
20:58:30 Processing: MgtTool\Qryanlz\Help
20:58:30 Processing: MgtTool\Qryanlz\Res1033
20:58:30 Processing: MgtTool\Qryanlz\ResIntl
20:58:30 Processing: MgtTool\DTCCLi
20:58:30 Processing: MgtTool\Wzcnflct
20:58:30 Processing: MgtTool\Wzcnflct\WzcnHlp
20:58:30 Processing: MgtTool\Wzcnflct\Wzcn1033
20:58:30 Processing: MgtTool\Wzcnflct\WzcnOthr
20:58:30 Processing: MgtTool\Wzcnflct\WzcnCmn
20:58:30 Processing: MgtTool\UtilSys
20:58:30 Processing: MgtTool\UtilBinn
20:58:30 Processing: Connect
20:58:30 Processing: Connect\ConnSys
20:58:30 Processing: Books
20:58:30 Processing: Books\Bookso
20:58:30 Processing: Books\Bookso\Utils
20:58:30 Processing: DevTools
20:58:30 Processing: DevTools\Headers and Libraries
20:58:30 Processing: DevTools\Headers and Libraries\Include
20:58:30 Processing: DevTools\Headers and Libraries\Libx86
20:58:30 Processing: DevTools\Headers and Libraries\LibAlpha
20:58:30 Processing: DevTools\Headers and Libraries\ESQLC
20:58:30 Processing: DevTools\MDAC SDKs
20:58:30 Processing: DevTools\VDI
20:58:30 Processing: DevTools\VDI\Inc
20:58:30 Processing: DevTools\VDI\Samples
20:58:30 Processing: DevTools\Dbg Int
20:58:30 Processing: DevTools\Dbg Int\Dbg Int Common
20:58:30 Processing: DevTools\Dbg Int\EXE
20:58:30 Processing: Samples
20:58:30 Processing: Samples\ADO
20:58:30 Processing: Samples\DBLIB
20:58:30 Processing: Samples\Desktop
20:58:30 Processing: Samples\DTS
20:58:30 Processing: Samples\ESQLC
20:58:30 Processing: Samples\Misc
20:58:30 Processing: Samples\MSDTC
20:58:30 Processing: Samples\ODBC
20:58:30 Processing: Samples\ODS
20:58:30 Processing: Samples\OLEAut
20:58:30 Processing: Samples\Repl
20:58:30 Processing: Samples\SilverstoneDB
20:58:30 Processing: Samples\SQLDMO
20:58:30 Processing: Samples\SQLNS
20:58:30 Processing: Samples\Utils
20:58:30 Processing: Samples\XML
20:58:30 Processing: CoreRepl
20:58:30 Processing: CoreRepl\Res1033
20:58:30 Processing: CoreRepl\ResIntl
20:58:30 Processing: Core
20:58:30 Processing: Core\Res1033
20:58:30 Processing: Core\ResOther
20:58:30 Processing: Repostry
20:58:30 Processing: Repostry\RepstSys
20:58:30 Processing: Repostry\Res1033
20:58:30 Processing: Repostry\ResIntl
20:58:30 Processing: CoreMisc
20:58:30 Processing: CoreMisc\ActiveX
20:58:30 Processing: CoreMisc\ActiveX\Res1033
20:58:30 Processing: CoreMisc\ActiveX\ResIntl
20:58:30 Processing: CoreMisc\Res1033
20:58:30 Processing: Monarch
20:58:30 Processing: Monarch\Monr1033
20:58:30 Processing: Monarch\MonrIntl
20:58:30 Processing: Jet
20:58:30 Processing: CoreInst
20:58:30 Processing: CoreCOM
20:58:30 Processing: CoreCOM\Res1033
20:58:30 Processing: CoreCOM\ResIntl
20:58:30 Processing: CoreTool
20:58:30 Processing: CoreTool\Res1033
20:58:30 Processing: CoreTool\ResOther
20:58:30 Processing: DBLibCli
20:58:30 Processing: SFExt
20:58:30 Processing: SFExt\ActiveX
20:58:30 Processing: SFExt\ActiveX\Res1033
20:58:30 Processing: SFExt\ActiveX\ResIntl
20:58:30 Processing: SFExt\Res1033
20:58:30 Processing: SFExt\ResIntl
20:58:30 Processing: Trace
20:58:30 Processing: Trace\Res1033
20:58:30 Processing: Trace\ResOther
20:58:30 Processing: CnctBinn
20:58:30 Processing: MiscCore
20:58:30 Processing: MC
20:58:30 Processing: MC\MC1033
20:58:30 Processing: MC\MCIntl
20:58:30 Processing: MC\Help
20:58:30 Processing: UI
20:58:30 Processing: UI\UIHlp
20:58:30 Processing: UI\UI1033
20:58:30 Processing: UI\UIIntl
20:58:30 Processing: ClstSys
20:58:30 Processing: SQLMgr
20:58:30 Processing: SQLMgr\Res1033
20:58:30 Processing: SQLMgr\ResIntl
20:58:30 Processing: SvrTool
20:58:30 Processing: SvrTool\Res1033
20:58:30 Processing: SvrTool\ResIntl
20:58:30 Processing: DTSUI
20:58:30 Processing: DTSUI\Res1033
20:58:30 Processing: DTSUI\ResIntl
20:58:30 Processing: ClFTSys
20:58:30 Processing: ClFtdata
20:58:30 Processing: MSOlap
20:58:30 Processing: MSOlap\Res1033
20:58:30 Processing: MSOlap\ResIntl
20:58:30 Processing: ATL
20:58:30 Processing: ATL\winnt
20:58:30 Processing: ATL\win9x
20:58:30 Processing: MFC42U
20:58:30 Processing: VC
20:58:30 Processing: VB
20:58:30 Processing: OCX1
20:58:30 Processing: SQLAdHlp
20:58:30 Processing: SQLAdHlp\Res1033
20:58:30 Processing: SQLAdHlp\ResOther
20:58:30 SQL program folder: C:\Program Files\Microsoft SQL Server\MSSQL
20:58:30 SQL data folder: C:\Program Files\Microsoft SQL Server\MSSQL
20:58:30 Windows system folder: C:\WINNT\system32\
20:58:30 Prog req: 32743, Data req: 3072, Sys req: 39014
20:58:30 Prog avail: 12835308, Data avail: 12835308, Sys avail: 12835308
20:58:30 Prog req vs. avail, 74829, 12835308
20:58:30 Data req vs. avail, 3072, 12835308
20:58:30 Sys req vs. avail, 42086, 12835308
20:58:30 SQLManagerApplicationClass found
20:58:30 C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe =-Silent 1 -Action 6 -Timeout 5000 -Service SQLSERVERAGENT
20:58:30 Process Exit Code: (0) 20:58:30 C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe =-Silent 1 -Action 6 -Timeout 5000 -Service MSSQLSERVER
20:58:31 Process Exit Code: (0) 20:58:31 Begin: InstallPkgs()
20:58:31 Begin Action: Locked Connectivity Files Check
20:58:31 ConnectivityLocked returned: 0
20:58:31 The operation completed successfully.
20:58:31 End Action: Locked Connectivity Files Check
20:58:31 Setup is installing Microsoft Data Access Components (MDAC) ...
20:58:31 C:\Temp\sql2ksp2\x86\Other\sqlredis.exe /q:a /C:"setupre.exe =WARN=3D1 -s -SMS"
20:58:53 ExitCode: 0
20:58:53 InstallMSSearch instance: MSSQLSERVER
20:58:53 Software\Microsoft\Search\Install:Version : 9.107.6815
20:58:53 MSSearch 2.0 or greater version check returned 1
20:58:53 Setup is installing the Microsoft Full-Text Search Engine ...
20:58:53 "C:\Temp\sql2ksp2\x86\FullText\MSSearch\Search\SearchStp.exe" =/s /a:SQLServer
20:58:53 Process Exit Code: (0) 20:58:53 End: InstallPkgs()
20:58:53 **** STARTING OPEN OP IN WRITE MODE ****
20:58:54 **** CLOSED OPEN OP IN WRITE MODE ****
20:58:54 Begin: MoveFileData()
20:58:54 Enabled SELFREGISTERBATCH
20:58:54 Enabled CORECOMPONENTHANDLING
20:58:58 Begin Action: MoveFileDataSpecial
20:58:58 End Action: MoveFileDataSpecial
20:58:58 End: MoveFileData()
20:58:58 Begin: ProcessAfterDataMove()
20:58:58 Begin Action : Installing Server Net
20:58:58 Server Instance : MSSQLSERVER 20:58:58 Server Net Will only be installed on server only in Enterprise =Editions
20:58:58 End: ProcessAfterDataMove()
20:58:58 Begin: BuildServer()
20:58:58 Begin Action: CreateRegistrySetSQL
20:58:58 End Action: CreateRegistrySetSQL
20:58:58 Begin Action: RegWriteSetupEntry
20:58:58 End Action: RegWriteSetupEntry
20:58:58 *** Unable to get RegisteredOwner to apply to Serial number
20:58:58 Begin Action: CreateSer
20:58:58 End Action: CreateSer
20:58:59 Upgrading databases
20:58:59 Upgrading databases on instance 'MSSQLSERVER'
20:58:59 C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe =-Silent 1 -Action 6 -Service MSSQLSERVER 20:59:00 Process Exit Code: (0) 20:59:00 C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe =-Silent 1 -Action 6 -Service MSSQLSERVER 20:59:01 Process Exit Code: (0) 20:59:01 C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe =-Silent 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 =\-T4010 \-m
20:59:31 Process Exit Code: (0) 20:59:31 C:\Temp\sql2ksp2\x86\BINN\osql.exe -Slpc:SUN426 -b -n -d =master -o "C:\Program Files\Microsoft SQL =Server\MSSQL\install\sp1_serv_uni.out" -i "C:\Program Files\Microsoft =SQL Server\MSSQL\install\sp1_serv_uni.sql" -U sa -P 20:59:32 Process Exit Code: (1) 20:59:48 Error running script: sp1_serv_uni.sql (1)
20:59:48 C:\DOCUME~1\ADMINI~1.MIF\LOCALS~1\Temp\1\SqlSetup\Bin\scm.exe =-Silent 1 -Action 6 -Service MSSQLSERVER 21:00:04 Process Exit Code: (0) 21:00:04 Action CleanUpInstall:
21:00:04 Installation Failed.
--=_NextPart_000_0017_01C4F433.0380D220--