Error when updating bigint columns using ADO

I am attempting to write a conversion of our product for Compact Edition; we already provide it based on SQL Server. The database interface uses ADO through a Python-win32com adaptor, and has worked fine so far. (Note: *not* ADO.net, just plain old COM)

Now, a curious thing happens. When inserting new data through a Recordset, everything works fine - except for columns defined as bigint. There are no exceptions thrown, but when you read the columns back they contain nothing but zeroes. Do the same to any other column type - I've tried integer, numeric, float, nvarchar and ntext so far, and they all seem to work just fine. It does not seem to be conversion-related either, since I've tested the exact same data to various column types. And using bigint on regular SQL Server works just fine.

The code involved is quite unspectacular, and simply switching the column types to integer would solve the immediate problem, but causes potential future issues since we normally store internal IDs in bigint columns, and the values may grow quite large.
This may indicate a problem with compatibility betweeen the 3rd party python ADO adaptor and the SQL CE OLEDB provider.

Error when trying to create "datasources"

Brand new at this !

I'm running VB 2005 express edition installed from full MS download which included the SQL2005 express server V9.00.1116

Have used the Video tutorial (video 8 & 9) to create a database and have followed instructiions faithfully

Problem.

From the Data / Add New Datasource menu everything proceeds ok - that is a "dataset.xsd" file is created but then I get an error message

" Could not get type information for .........myfilename dataset "

and so the process is not completed properly and a datasource is not created.

I'm unsure what the type information is and have been unsuccesful turning up anything from the help files or forum so hoping someone can maybe tell me whats happening and how to fix this.

Thanks

I also ran into this problem and got it solved by removing the connection strings in 'My Project - Settings'. I hope this also works for you.

Harmen.|||

Thanks for that idea

For the record had trouble removing strings however -

My problems have been solved by accident when I created a new windows user account and ran VB express from there. I believe the problem was to do with the connection address because my system name has an " & " in the name(stupid me when I set up Windows XP ) the ampersand maybe an illegal character in a path name.

Here's the full path i used

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\TB&MA\My Documents\Visual Studio 2005\Projects\MyDataBase\MyDataBase\Database1.mdf";Integrated Security=True;User Instance=True

I think this why running it from a new user account worked ok as the connection string would have new directory path name

Thanks again

sql

Error when trying to create "datasources"

Brand new at this !

I'm running VB 2005 express edition installed from full MS download which included the SQL2005 express server V9.00.1116

Have used the Video tutorial (video 8 & 9) to create a database and have followed instructiions faithfully

Problem.

From the Data / Add New Datasource menu everything proceeds ok - that is a "dataset.xsd" file is created but then I get an error message

" Could not get type information for .........myfilename dataset "

and so the process is not completed properly and a datasource is not created.

I'm unsure what the type information is and have been unsuccesful turning up anything from the help files or forum so hoping someone can maybe tell me whats happening and how to fix this.

Thanks

I also ran into this problem and got it solved by removing the connection strings in 'My Project - Settings'. I hope this also works for you.

Harmen.
|||

Thanks for that idea

For the record had trouble removing strings however -

My problems have been solved by accident when I created a new windows user account and ran VB express from there. I believe the problem was to do with the connection address because my system name has an " & " in the name(stupid me when I set up Windows XP ) the ampersand maybe an illegal character in a path name.

Here's the full path i used

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\TB&MA\My Documents\Visual Studio 2005\Projects\MyDataBase\MyDataBase\Database1.mdf";Integrated Security=True;User Instance=True

I think this why running it from a new user account worked ok as the connection string would have new directory path name

Thanks again

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

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...
>
>

Error when Logging on - Error: 18456, Severity: 14, State: 16

Hi All,
I am getting the following error in the ERRORLOG File when I am
trying
to connect to SQL Server 2005 Express Edition from the command line.
2007-03-23 07:30:05.54 Logon Error: 18456, Severity: 14, State:
16.
2007-03-23 07:30:05.54 Logon Login failed for user 'sa'.
[CLIENT: xx.xx.xx.xx]
I have a fresh install of SQL Server on my local machine, which is
probably the source of my angst, but I am trying to create a database
from scratch through using a batch file that is run from the command
line, the batch file looks like this:
<snip>
SQLCMD -U %USR% -P %PWD% -S %SVR% -d %DBF% -i CreateDatabase.sql
<snip>
The values of %USR% and %PWD% are correct as I frequently log into
Management Studio with the details, %SVR% is "<ComputerName>
\SQLEXPRESS,1433" and %DBF% is <DatabaseName>. The contents of
CreateDatabase.sql when run in Management Studio successfully creates
the database that I require so I know the error doesn't lie there.
The command line error that is showing reads as the following:
Msg 4060, Level 11, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
Cannot open database "<DatabaseName>" requested by the login. The
login failed.
Msg 18456, Level 14, State 1, Server <ComputerName>\SQLEXPRESS, Line
1
Login failed for user 'sa'.
I have a feeling that it is related to 'sa' not having the correct
permissions with regards to logging into or creating a database from
scratch, but I find it odd that I can login as 'sa' in Management
Studio and create the database from there, but when I try it from the
command-line (despite having TCP/IP enabled) it won't let me connect
to create a database.
Is there something I am missing here? I have been banging my head off
of walls for days over this and am unsure of the next steps to take.
If any of this screams "why the hell are you doing this?" then please
let me know as at the moment I am punching in the dark with this
problem, I have searched Usenet, Google Groups, the Web and although
I
have found potential solutions to this particular problem I am
having,
nothing I have done so far has actually managed to fix the issue.
Related articles I have followed are:
Login failed for user 'x'
http://msdn2.microsoft.com/en-us/library/ms366351.aspx
Change Server Authentication Mode
http://msdn2.microsoft.com/en-us/library/ms188670.aspx
Upgrading MSDE 2000 to SQL Server 2005 Express [Enabling network
protocols section]
http://www.microsoft.com/technet/pr...e2sqlexpress...
NOTE: I just listed these articles to show what path I am currently
looking at with regards to this problem, but again I stress I have
found nothing yet to get round this problem, and any further articles
or direction would be much appreciated.
Yours Distressingly
AlastairI'm still not clear on what database is used for -d
<DatabaseName> and this could be one of the problems. If you
are trying to log in using the database you are about to
create, then that's likely the issue as it doesn't exist
when logging in. Try specifying master for the initial login
database.
-Sue
On 23 Mar 2007 08:48:10 -0700, "Alastair"
<alastair_anderson@.hotmail.com> wrote:

>Hi All,
>I am getting the following error in the ERRORLOG File when I am
>trying
>to connect to SQL Server 2005 Express Edition from the command line.
>
>2007-03-23 07:30:05.54 Logon Error: 18456, Severity: 14, State:
>16.
>2007-03-23 07:30:05.54 Logon Login failed for user 'sa'.
>[CLIENT: xx.xx.xx.xx]
>
>I have a fresh install of SQL Server on my local machine, which is
>probably the source of my angst, but I am trying to create a database
>from scratch through using a batch file that is run from the command
>line, the batch file looks like this:
>
><snip>
>SQLCMD -U %USR% -P %PWD% -S %SVR% -d %DBF% -i CreateDatabase.sql
><snip>
>
>The values of %USR% and %PWD% are correct as I frequently log into
>Management Studio with the details, %SVR% is "<ComputerName>
>\SQLEXPRESS,1433" and %DBF% is <DatabaseName>. The contents of
>CreateDatabase.sql when run in Management Studio successfully creates
>the database that I require so I know the error doesn't lie there.
>
>The command line error that is showing reads as the following:
>
>Msg 4060, Level 11, State 1, Server <ComputerName>\SQLEXPRESS, Line 1
>Cannot open database "<DatabaseName>" requested by the login. The
>login failed.
>Msg 18456, Level 14, State 1, Server <ComputerName>\SQLEXPRESS, Line
>1
>Login failed for user 'sa'.
>
>I have a feeling that it is related to 'sa' not having the correct
>permissions with regards to logging into or creating a database from
>scratch, but I find it odd that I can login as 'sa' in Management
>Studio and create the database from there, but when I try it from the
>command-line (despite having TCP/IP enabled) it won't let me connect
>to create a database.
>
>Is there something I am missing here? I have been banging my head off
>of walls for days over this and am unsure of the next steps to take.
>
>If any of this screams "why the hell are you doing this?" then please
>let me know as at the moment I am punching in the dark with this
>problem, I have searched Usenet, Google Groups, the Web and although
>I
>have found potential solutions to this particular problem I am
>having,
>nothing I have done so far has actually managed to fix the issue.
>
>Related articles I have followed are:
>
>Login failed for user 'x'
>http://msdn2.microsoft.com/en-us/library/ms366351.aspx
>
>Change Server Authentication Mode
>http://msdn2.microsoft.com/en-us/library/ms188670.aspx
>
>Upgrading MSDE 2000 to SQL Server 2005 Express [Enabling network
>protocols section]
>http://www.microsoft.com/technet/pr...e2sqlexpress...
>
>NOTE: I just listed these articles to show what path I am currently
>looking at with regards to this problem, but again I stress I have
>found nothing yet to get round this problem, and any further articles
>or direction would be much appreciated.
>
>Yours Distressingly
>
>Alastair|||On 25 Mar, 16:17, Sue Hoegemeier <S...@.nomail.please> wrote:
> I'm still not clear on what database is used for -d
> <DatabaseName> and this could be one of the problems. If you
> are trying to log in using the database you are about to
> create, then that's likely the issue as it doesn't exist
> when logging in. Try specifying master for the initial login
> database.
> -Sue
> On 23 Mar 2007 08:48:10 -0700, "Alastair"
>
> <alastair_ander...@.hotmail.com> wrote:
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> - Show quoted text -
You managed to hit the nail on the head.
Running my current script when the new database already exists it
works fine, however for a fresh install of SQL Server, when it doesn't
currently exist then it doesn't work.
Thanks for your help
Alastair

Error when executing a distributed query on a linked server

Hi,
It's a repost of an old thread with more information included
I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits. I've
been trying to link a sql server 2000 SP4 to this but I'm having some
troubles. When creating the linked server from the Sql Server Management
Studio/New Linked Server I choosed Server type to be "SQL Server" for the 2K
linked server. The linked server was created. Then I go to
Properties/Security and configure the linked server to be accesed as sa. But
when I run a distributed query like
Select * from linkedserver.database.dbo.table I get the error:
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 2
Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
server "sqlservhpold". A four-part name was supplied, but the provider does
not expose the necessary interfaces to use a catalog or schema.
I tested the link by using sp_testlinkedserver and it returns no failure.
I also created a linked server in the reverse. I mean let server A be the
Sql Server 2005 64 bits Enterprise, and server B be a Sql Server 2000
Standard. I'm in A making B as linked server and trying to make a
distributed query from A to B (Select * from B.database.dbo.table) and this
fails. I tryed in B create A as a linked server. Then I made a distributed
query from B to A (Select * from A.database.dbo.table) and it works as
expected.
The most frustrating is the message that error 7399 returns: "The provider
did not give any information about the error." I cn not find nothing about
such an error message...
Any hint is welcomed
Thanks in advance
SammySammyBar (sammybar@.gmail.com) writes:
> I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits.
> I've been trying to link a sql server 2000 SP4 to this but I'm having
> some troubles. When creating the linked server from the Sql Server
> Management Studio/New Linked Server I choosed Server type to be "SQL
> Server" for the 2K linked server. The linked server was created. Then I
> go to Properties/Security and configure the linked server to be accesed
> as sa. But when I run a distributed query like
> Select * from linkedserver.database.dbo.table I get the error:
> Msg 7399, Level 16, State 1, Line 2
> The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
> error. The provider did not give any information about the error.
> Msg 7312, Level 16, State 1, Line 2
> Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
> server "sqlservhpold". A four-part name was supplied, but the provider
> does not expose the necessary interfaces to use a catalog or schema.
Can you double check the SQL 2000 instance, by doing SELECT @.@.version?
I seem to recall that to run linked queries from SQL 2005 to SQL 2000,
the latter needs some catalog procedures that comes with SP4, or possbly
SP2.
Also the exact command you use to create the linked server could be of
interest.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

Error when executing a distributed query on a linked server

Hi,
It's a repost of an old thread with more information included
I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits. I've
been trying to link a sql server 2000 SP4 to this but I'm having some
troubles. When creating the linked server from the Sql Server Management
Studio/New Linked Server I choosed Server type to be "SQL Server" for the 2K
linked server. The linked server was created. Then I go to
Properties/Security and configure the linked server to be accesed as sa. But
when I run a distributed query like
Select * from linkedserver.database.dbo.table I get the error:
Msg 7399, Level 16, State 1, Line 2
The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
error. The provider did not give any information about the error.
Msg 7312, Level 16, State 1, Line 2
Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
server "sqlservhpold". A four-part name was supplied, but the provider does
not expose the necessary interfaces to use a catalog or schema.
I tested the link by using sp_testlinkedserver and it returns no failure.
I also created a linked server in the reverse. I mean let server A be the
Sql Server 2005 64 bits Enterprise, and server B be a Sql Server 2000
Standard. I'm in A making B as linked server and trying to make a
distributed query from A to B (Select * from B.database.dbo.table) and this
fails. I tryed in B create A as a linked server. Then I made a distributed
query from B to A (Select * from A.database.dbo.table) and it works as
expected.
The most frustrating is the message that error 7399 returns: "The provider
did not give any information about the error." I cn not find nothing about
such an error message...
Any hint is welcomed
Thanks in advance
SammySammyBar (sammybar@.gmail.com) writes:
> I'm testing a Sql Server 2005 Enterprise Evaluation Edition 64 bits.
> I've been trying to link a sql server 2000 SP4 to this but I'm having
> some troubles. When creating the linked server from the Sql Server
> Management Studio/New Linked Server I choosed Server type to be "SQL
> Server" for the 2K linked server. The linked server was created. Then I
> go to Properties/Security and configure the linked server to be accesed
> as sa. But when I run a distributed query like
> Select * from linkedserver.database.dbo.table I get the error:
> Msg 7399, Level 16, State 1, Line 2
> The OLE DB provider "SQLNCLI" for linked server "sqlservhpold" reported an
> error. The provider did not give any information about the error.
> Msg 7312, Level 16, State 1, Line 2
> Invalid use of schema or catalog for OLE DB provider "SQLNCLI" for linked
> server "sqlservhpold". A four-part name was supplied, but the provider
> does not expose the necessary interfaces to use a catalog or schema.
Can you double check the SQL 2000 instance, by doing SELECT @.@.version?
I seem to recall that to run linked queries from SQL 2005 to SQL 2000,
the latter needs some catalog procedures that comes with SP4, or possbly
SP2.
Also the exact command you use to create the linked server could be of
interest.
--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Error trying to open Reporting Configuration Tool

I just installed SQL Server 2005 Express Edition and reporting services (followed the video tutorial). Whenever I try to open the Reporting Configuration Tool, it gives me the following error:

SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close. We are sorry for the inconvience.

My only options are to Debug or Close.

I'm not sure why I am getting this error. Can anyone help?

Thanks,

Amanda

mandercruso wrote:

I just installed SQL Server 2005 Express Edition and reporting services (followed the video tutorial). Whenever I try to open the Reporting Configuration Tool, it gives me the following error:

SQL Server 2005 Reporting Configuration Tool has encountered a problem and needs to close. We are sorry for the inconvience.

My only options are to Debug or Close.

I'm not sure why I am getting this error. Can anyone help?

Thanks,

Amanda

I would recommend reinstalling the reporting services components of SQL.

|||

thanks. how can I just reinstall that component? I've uninstalled and reinstalled SQL Server 2005 Express thinking that would solve the problem, but it didn't....|||

Hmmm...If reinstalling the whole kit and kabudle didn't solve it then I would doubt that reinstalling just that component would.

It almost sounds like an operating system conflict. What does it do when you click debug?

|||

it gives me the following error:

an unhandled exception ('System.ComponentModel.Win32Exception') occurred in RSConfigTool.exe [7680].

Then it gives me the possible debuggers to choose from

|||Have you applied SP1 or SP2?

|||

Just downloaded SP2 with Advanced Options. Not sure if it matters but I have SQL Server 2000 on my machine... Visual Studio 2003 and 2005...

|||OK so you have yet to install SP2? Let us know if you still get the error after installing it.

|||

No, I meant, that's what I have originally downloaded and installed.

|||

bump... still having this problem. Does anyone know what's wrong?

Error System.InvalidOperationException: Client found response cont

Hi, All.
I have a windows 2000 server machine with SQL Enterprise 2000 edition and
reporting service enterprise edition on it.
The Report Mangaer application and the Report Server Web service are both
working.
and i have a web application that makes calls against the reporting service
API.
and I get the following error regardless of any method I call.
System.InvalidOperationException: Client found response content type of
'text/html', but expected 'text/xml'. The request failed with the error
message: -- -2146893039 (0x80090311) --. at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall) at
System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters) at
ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
Recursive).
Can anyone help to explain what to do?
tksThe problem is you are getting back an html response rather then a SOAP
response (xml). Have you verified that the .Url property is correct set on
your proxy object?
The error you are seeing is:
No authority could be contacted for authentication.
Have you set the credentials property correctly?
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hang" <Hang@.discussions.microsoft.com> wrote in message
news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> Hi, All.
> I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> reporting service enterprise edition on it.
> The Report Mangaer application and the Report Server Web service are both
> working.
> and i have a web application that makes calls against the reporting
> service
> API.
> and I get the following error regardless of any method I call.
> System.InvalidOperationException: Client found response content type of
> 'text/html', but expected 'text/xml'. The request failed with the error
> message: -- -2146893039 (0x80090311) --. at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters) at
> ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> Recursive).
>
> Can anyone help to explain what to do?
> tks
>|||Thanks for replying, Daniel
Yes. the .Url property is correct. I explicitly set it once i create a proxy
object.
here is a sample code
Dim rs As sqlReport.ReportingService
rs = New ReportingService
rs.Url = "http://severName/ReportServer/ReportService.asmx"
rs.Credentials = New NetworkCredential
("userName", "password", "theDomainName")
Dim c As CatalogItem() = rs.ListChildren("/", True)
that is the code code that throws the exception
by the way, On the same server, I used to have reporting service evaluation
edition and my application worked fine.
Then I got that problem after installing the official version(I uninstalled
the evalutiaon edition and deleted all the database associated with it before
installing).
tks.
"Daniel Reib [MSFT]" wrote:
> The problem is you are getting back an html response rather then a SOAP
> response (xml). Have you verified that the .Url property is correct set on
> your proxy object?
> The error you are seeing is:
> No authority could be contacted for authentication.
> Have you set the credentials property correctly?
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Hang" <Hang@.discussions.microsoft.com> wrote in message
> news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > Hi, All.
> > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > reporting service enterprise edition on it.
> >
> > The Report Mangaer application and the Report Server Web service are both
> > working.
> > and i have a web application that makes calls against the reporting
> > service
> > API.
> > and I get the following error regardless of any method I call.
> >
> > System.InvalidOperationException: Client found response content type of
> > 'text/html', but expected 'text/xml'. The request failed with the error
> > message: -- -2146893039 (0x80090311) --. at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > at
> > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > methodName, Object[] parameters) at
> > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > Recursive).
> >
> >
> > Can anyone help to explain what to do?
> >
> > tks
> >
>
>|||Just to follow up on this. It turned out it was an credential problem in this
case.
The web server, which hosts the web application, needs to be in the same
domain as that of the web server hosting the reporting services web service.
And a proper domain account is needed for accessing the reporting services
web service in this case.
hope this helps others who have encountered similiar problems.
Tks
"Hang" wrote:
> Thanks for replying, Daniel
> Yes. the .Url property is correct. I explicitly set it once i create a proxy
> object.
> here is a sample code
> Dim rs As sqlReport.ReportingService
> rs = New ReportingService
> rs.Url = "http://severName/ReportServer/ReportService.asmx"
> rs.Credentials = New NetworkCredential
> ("userName", "password", "theDomainName")
> Dim c As CatalogItem() = rs.ListChildren("/", True)
> that is the code code that throws the exception
> by the way, On the same server, I used to have reporting service evaluation
> edition and my application worked fine.
> Then I got that problem after installing the official version(I uninstalled
> the evalutiaon edition and deleted all the database associated with it before
> installing).
>
> tks.
> "Daniel Reib [MSFT]" wrote:
> > The problem is you are getting back an html response rather then a SOAP
> > response (xml). Have you verified that the .Url property is correct set on
> > your proxy object?
> >
> > The error you are seeing is:
> >
> > No authority could be contacted for authentication.
> >
> > Have you set the credentials property correctly?
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> >
> > "Hang" <Hang@.discussions.microsoft.com> wrote in message
> > news:DC04C055-5821-4DC5-8A78-0519F2FDAA4E@.microsoft.com...
> > > Hi, All.
> > > I have a windows 2000 server machine with SQL Enterprise 2000 edition and
> > > reporting service enterprise edition on it.
> > >
> > > The Report Mangaer application and the Report Server Web service are both
> > > working.
> > > and i have a web application that makes calls against the reporting
> > > service
> > > API.
> > > and I get the following error regardless of any method I call.
> > >
> > > System.InvalidOperationException: Client found response content type of
> > > 'text/html', but expected 'text/xml'. The request failed with the error
> > > message: -- -2146893039 (0x80090311) --. at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> > > message, WebResponse response, Stream responseStream, Boolean asyncCall)
> > > at
> > > System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> > > methodName, Object[] parameters) at
> > > ADschedule.SQLreporting.ReportingService.ListChildren(String Item, Boolean
> > > Recursive).
> > >
> > >
> > > Can anyone help to explain what to do?
> > >
> > > tks
> > >
> >
> >
> >

Error starting svc at end of install

I get this error right at the end of installing the server
components.
Product: Microsoft SQL Server 2000 Reporting Services
Developer Edition -- Error 1920. Service 'ReportServer'
(ReportServer) failed to start. Verify that you have
sufficient privileges to start system services.
I am logged in as Administrator. It then decides to
rollback the install. My machine is Win2k2003 with IIS6.
Any ideas?
Thanks,
DaveOk, so i did a complete uninstall and reinstall and it
works. I guess if you do a client only install and then
try to install the service components you don't get any
prompts to select which account the reportservice runs
under.
>--Original Message--
>I get this error right at the end of installing the
server
>components.
>Product: Microsoft SQL Server 2000 Reporting Services
>Developer Edition -- Error 1920. Service 'ReportServer'
>(ReportServer) failed to start. Verify that you have
>sufficient privileges to start system services.
>I am logged in as Administrator. It then decides to
>rollback the install. My machine is Win2k2003 with IIS6.
>Any ideas?
>Thanks,
>Dave
>.
>

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--