DB Engine :: Unexpected Update / Delete On OLTP Database In 2005

Jun 17, 2015

We had one of the major issues where one of the table on a heavily used OLTP database seems to have updated the records which were not expected.

Scenario:

We got around more than 12K contracts updated to status expired even though the expiry date is not set to be so:

for E.G : Below table has a column contract status which overnight seems to have updated the values to expired.

Even though the start and expiry date does not follow the logic for above.

We had the above working for past 3 years via a SP scheduled via SQL agent Job which Expire active contracts whose expiration date is less than today's 12:00AM.There has been no change in SP.

How can i track how it happened and what caused it?

View 28 Replies


ADVERTISEMENT

Delete Update Behavior Of The SSEv Engine

Sep 14, 2006

Can someone on the team tell me if a delete or update orphans a row in the SQL Server Everywhere database that must be compacted out to free the space? I understand that Compact runs automatically when the last connection is closed but does this create another copy of the database as it does with JET or is this an update-in-place. Is this an opportunity to corrupt the database if the process is interrupted by power-failure or a truck running over the device from right-to-left?

View 1 Replies View Related

DB Engine :: Bulk Update Is Recorded As Delete And Insert In CDC Tables?

Nov 18, 2015

I have a fundamental problem with how CDC works for bulk updates.When CDC enabled table is updated for single row - My CDC system tables its recording it as update (3 & 4)  which is perfect and what it should be. No Complains!But when I do a bulk update in the same CDC enabled tables for the same columns - My CDC system tables its recording as delete and then insert (1 & 2). This is not correct and this is what my problem is.  We used triggers before CDC we did not face this problem with triggers every thing was fine with triggers other than performance.The way how the CDC  is handling the bulk update is  a big problem for me because based on the output of CDC system tables we are doing some migration work to legacy system.

It will be impossible  for me to go and change my migration logic scripts because we have 100's or procedures in it.Is it a know problem with CDC? Is there any solution in CDC when a bulk update happens on a table the CDC system tables record it as updates. I don't think CDC 'net changes' in this situation because the net change would show as single inserted row.If this can't be done with CDC then I have to completely abandon CDC and go back to triggers..

View 5 Replies View Related

DB Engine :: In-Memory OLTP Use With Existing Tables / Index / Procedures

Nov 10, 2015

1. I need to make use of in memory engine for my pr-existed develop procedures ,tables ,index.  do I need and code changes for application and how to store tables /indexes in OLTP memory

Assume table index may have primary key index as well.

2. If table with one primary index and 2 foreign constraints, 3 non clusters indexed. which one able o load to memory area and how t do that.

3. In memory is lock free zone. usually locks will happpen in RDMS context . how this works without locks.

View 3 Replies View Related

Update Statement Using Declared Variable Produces Unexpected Results On SQL Server 2005

Aug 7, 2007

We are getting unexpected results from the following update statement when it is executed on SQL Server 2005.


The strange thing is that we get duplicated values for QM_UID (although when run under SQL Server 2000 we don't get duplicated values)


Can anyone explain why this happens or suggest another way of populating this column without using a cursor or adding a temporary autoincrement column and copying the values over?


declare @NextID int;

set @NextID = 1;

update tmp set QM_UID=@NextID, @NextID = @NextID + 1;

select QM_UID, count(*) from tmp group by QM_UID having count(*) > 1 order by QM_UID


QM_UID count(*)

25 2
26 3
27 4
28 4
29 4
30 4
31 4
32 4
33 4
34 4
35 5
36 4
37 4
38 4
39 4
40 3

...



--- Script to replicate problem



-- NB: The number of rows that must be added to tmp before this problem will occur is machine dependant

-- 100000 rows is sufficient on one of our servers but another (faster) server doesn't show the error

-- at 100000 rows but does at 1000000 rows.



-- Create a table

CREATE TABLE tmp (
[QM_ADD_OP] [char](6) DEFAULT '' NOT NULL,
[QM_ADD_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_ADD_TIME] [int] DEFAULT -1 NOT NULL,
[QM_EDIT_OP] [char](6) DEFAULT '' NOT NULL,
[QM_EDIT_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_EDIT_TIME] [int] DEFAULT -1 NOT NULL,
[QM_LOCK_OP] [char](6) DEFAULT '' NOT NULL,
[QM_QUOTE_JOB] [smallint] DEFAULT 0 NOT NULL,
[QM_QUOTE_NUM] [char](12) DEFAULT '' NOT NULL,
[QM_JOB_NUM] [char](12) DEFAULT '' NOT NULL,
[QM_PRJ_NUM] [char](12) DEFAULT '' NOT NULL,
[QM_NUMBER] [char](12) DEFAULT '' NOT NULL,
[QM_REV_NUM] [char](6) DEFAULT '' NOT NULL,
[QM_REV_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_REV_TIME] [int] DEFAULT -1 NOT NULL,
[QM_REV_OPR] [char](6) DEFAULT '' NOT NULL,
[QM_STYLE_CODE] [char](4) DEFAULT '' NOT NULL,
[QM_REP_JOB_NUM] [char](12) DEFAULT '' NOT NULL,
[QM_REP_COLUMN] [smallint] DEFAULT 0 NOT NULL,
[QM_REP_PART] [char](6) DEFAULT '' NOT NULL,
[QM_REP_MODEL] [smallint] DEFAULT 0 NOT NULL,
[QM_REP_TYPE] [smallint] DEFAULT 0 NOT NULL,
[QM_MODEL_QUOTE] [char](12) DEFAULT '' NOT NULL,
[QM_RUN_NUM] [int] DEFAULT 0 NOT NULL,
[QM_SOURCE_QUOTE] [char](12) DEFAULT '' NOT NULL,
[QM_SOURCE_VAR] [smallint] DEFAULT 0 NOT NULL,
[QM_SOURCE_QTY] [char](12) DEFAULT '' NOT NULL,
[QM_SOURCE_PART] [char](6) DEFAULT '' NOT NULL,
[QM_SOURCE_MODEL] [smallint] DEFAULT 0 NOT NULL,
[QM_ORIG_QUOTE] [char](12) DEFAULT '' NOT NULL,
[QM_ORIG_VAR] [smallint] DEFAULT 0 NOT NULL,
[QM_ORIG_QTY] [char](12) DEFAULT '' NOT NULL,
[QM_ORIG_PART] [char](6) DEFAULT '' NOT NULL,
[QM_COPY_JOB] [char](12) DEFAULT '' NOT NULL,
[QM_COPY_COLUMN] [smallint] DEFAULT 0 NOT NULL,
[QM_COPY_J_PART] [char](6) DEFAULT '' NOT NULL,
[QM_COPY_QUOTE] [char](12) DEFAULT '' NOT NULL,
[QM_COPY_VAR] [smallint] DEFAULT 0 NOT NULL,
[QM_COPY_QTY] [char](12) DEFAULT '' NOT NULL,
[QM_COPY_Q_PART] [char](6) DEFAULT '' NOT NULL,
[QM_JOINT_STATUS] [smallint] DEFAULT 0 NOT NULL,
[QM_QUOTE_STATUS] [smallint] DEFAULT 0 NOT NULL,
[QM_JOB_STATUS] [smallint] DEFAULT 0 NOT NULL,
[QM_LIVE_STATUS] [smallint] DEFAULT 0 NOT NULL,
[QM_USER_STATUS] [smallint] DEFAULT 0 NOT NULL,
[QM_DEL_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_IS_CONVERTED] [smallint] DEFAULT 0 NOT NULL,
[QM_PRINTED] [smallint] DEFAULT 0 NOT NULL,
[QM_COPY_RATES] [smallint] DEFAULT 0 NOT NULL,
[QM_IMPORT_UPDATE] [smallint] DEFAULT 0 NOT NULL,
[QM_CRED_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_CRED_TIME] [int] DEFAULT -1 NOT NULL,
[QM_CRED_AMT] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_CRED_OP] [char](6) DEFAULT '' NOT NULL,
[QM_HELD] [smallint] DEFAULT 0 NOT NULL,
[QM_PROOF] [char](12) DEFAULT '' NOT NULL,
[QM_DELIV_METHOD] [char](12) DEFAULT '' NOT NULL,
[QM_ART_METHOD] [char](12) DEFAULT '' NOT NULL,
[QM_DES_TYPE] [smallint] DEFAULT 0 NOT NULL,
[QM_REC_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_REC_TIME] [int] DEFAULT -1 NOT NULL,
[QM_OWN_OP] [char](6) DEFAULT '' NOT NULL,
[QM_RESP_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_RESP_TIME] [int] DEFAULT -1 NOT NULL,
[QM_RESP_OP] [char](6) DEFAULT '' NOT NULL,
[QM_RESP_OP_1] [char](6) DEFAULT '' NOT NULL,
[QM_RESP_OP_2] [char](6) DEFAULT '' NOT NULL,
[QM_RESP_OP_3] [char](6) DEFAULT '' NOT NULL,
[QM_RESP_OP_4] [char](6) DEFAULT '' NOT NULL,
[QM_RESP_OP_5] [char](6) DEFAULT '' NOT NULL,
[QM_RECONTACT] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_REQ_FLAG] [smallint] DEFAULT 0 NOT NULL,
[QM_ORIG_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_ORIG_TIME] [int] DEFAULT -1 NOT NULL,
[QM_PREF_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_PREF_TIME] [int] DEFAULT -1 NOT NULL,
[QM_LATE_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_LATE_TIME] [int] DEFAULT -1 NOT NULL,
[QM_TITLE] [char](72) DEFAULT '' NOT NULL,
[QM_DELIV_CODE] [char](12) DEFAULT '' NOT NULL,
[QM_CLT_SPEC] [char](12) DEFAULT '' NOT NULL,
[QM_TAX_REF] [char](22) DEFAULT '' NOT NULL,
[QM_CONTACT] [char](36) DEFAULT '' NOT NULL,
[QM_PHONE] [char](22) DEFAULT '' NOT NULL,
[QM_FAX] [char](22) DEFAULT '' NOT NULL,
[QM_ORDER] [char](20) DEFAULT '' NOT NULL,
[QM_ORDER_CFM] [smallint] DEFAULT 0 NOT NULL,
[QM_ORDER_REL] [char](6) DEFAULT '' NOT NULL,
[QM_REP] [char](12) DEFAULT '' NOT NULL,
[QM_REP_1] [char](12) DEFAULT '' NOT NULL,
[QM_REP_2] [char](12) DEFAULT '' NOT NULL,
[QM_REP_3] [char](12) DEFAULT '' NOT NULL,
[QM_REP_4] [char](12) DEFAULT '' NOT NULL,
[QM_REP_5] [char](12) DEFAULT '' NOT NULL,
[QM_COORDINATOR] [char](12) DEFAULT '' NOT NULL,
[QM_PRIORITY] [smallint] DEFAULT 0 NOT NULL,
[QM_TYPE_CODE] [char](12) DEFAULT '' NOT NULL,
[QM_GRADE] [smallint] DEFAULT 0 NOT NULL,
[QM_FIN_SIZE_CODE] [char](12) DEFAULT '' NOT NULL,
[QM_FIN_WID] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_FIN_LEN] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_FIN_DEP] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_FIN_GUSS] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_FIN_GSM] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_FIN_UNIT] [char](12) DEFAULT '' NOT NULL,
[QM_ORIENT] [smallint] DEFAULT 0 NOT NULL,
[QM_PROD_CODE] [char](22) DEFAULT '' NOT NULL,
[QM_FIN_GOOD] [char](22) DEFAULT '' NOT NULL,
[QM_CUST_CODE] [char](12) DEFAULT '' NOT NULL,
[QM_CUST_CODE_1] [char](12) DEFAULT '' NOT NULL,
[QM_CUST_CODE_2] [char](12) DEFAULT '' NOT NULL,
[QM_CUST_PROS] [smallint] DEFAULT 0 NOT NULL,
[QM_REQD_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_REQD_TIME] [int] DEFAULT -1 NOT NULL,
[QM_FOLIO] [char](12) DEFAULT '' NOT NULL,
[QM_FOLIO_1] [char](12) DEFAULT '' NOT NULL,
[QM_FOLIO_2] [char](12) DEFAULT '' NOT NULL,
[QM_PACK_QTY] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_USAGE] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_REORDER] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_EACH_WGT] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_WGT_UNIT] [char](12) DEFAULT '' NOT NULL,
[QM_RFQ_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_RFQ_TIME] [int] DEFAULT -1 NOT NULL,
[QM_RFQ_OPR] [char](6) DEFAULT '' NOT NULL,
[QM_SALES_TYPE] [smallint] DEFAULT 0 NOT NULL,
[QM_SALES_SRC] [char](12) DEFAULT '' NOT NULL,
[QM_SALES_RSN] [char](12) DEFAULT '' NOT NULL,
[QM_PROFILE] [char](12) DEFAULT '' NOT NULL,
[QM_JOB_QTY] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_PREV_QTY] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_JOB_UNIT] [char](12) DEFAULT '' NOT NULL,
[QM_PO_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_PO_TIME] [int] DEFAULT -1 NOT NULL,
[QM_PO_OP] [char](6) DEFAULT '' NOT NULL,
[QM_DLY_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_DLY_TIME] [int] DEFAULT -1 NOT NULL,
[QM_QTY_DESP] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_TOTAL_DLY] [int] DEFAULT 0 NOT NULL,
[QM_SCHED_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_SCHED_TIME] [int] DEFAULT -1 NOT NULL,
[QM_CLOSE_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_CLOSE_TIME] [int] DEFAULT -1 NOT NULL,
[QM_INV_NUM] [char](12) DEFAULT '' NOT NULL,
[QM_PACK_NUM] [char](12) DEFAULT '' NOT NULL,
[QM_DOWN_LOAD] [smallint] DEFAULT 0 NOT NULL,
[QM_TRACK_CODE] [char](4) DEFAULT '' NOT NULL,
[QM_TAX_TYPE] [smallint] DEFAULT 0 NOT NULL,
[QM_TAX_CODE] [char](6) DEFAULT '' NOT NULL,
[QM_CURR] [char](6) DEFAULT '' NOT NULL,
[QM_EXCH_RATE] numeric(18,8) DEFAULT 0 NOT NULL,
[QM_UNIT_QTY] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_UNIT_FLAG] [smallint] DEFAULT 0 NOT NULL,
[QM_RUNON_QTY] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_SPEC_QTY] numeric(26,8) DEFAULT 0 NOT NULL,
[QM_CHARGEABLE] [smallint] DEFAULT 0 NOT NULL,
[QM_NC_REASON] [char](22) DEFAULT '' NOT NULL,
[QM_CUST_MKUP] numeric(18,8) DEFAULT 0 NOT NULL,
[QM_JOB_MKUP] numeric(18,8) DEFAULT 0 NOT NULL,
[QM_BROKERAGE] numeric(18,8) DEFAULT 0 NOT NULL,
[QM_CUST_DISC] numeric(18,8) DEFAULT 0 NOT NULL,
[QM_INVOKED_BTNS] [int] DEFAULT 0 NOT NULL,
[QM_IMPORTED] [smallint] DEFAULT 0 NOT NULL,
[QM_IMPORT_RECALC] [smallint] DEFAULT 0 NOT NULL,
[QM_IMPORT_CONVERT] [smallint] DEFAULT 0 NOT NULL,
[QM_BRANCH] [char](6) DEFAULT '' NOT NULL,
[QM_CODE] [char](36) DEFAULT '' NOT NULL,
[QM_TEMPLATE] [smallint] DEFAULT 0 NOT NULL,
[QM_REPEAT_PERIOD] [int] DEFAULT 0 NOT NULL,
[QM_REOPEN_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_CAT_OPTION] [char](16) DEFAULT '' NOT NULL,
[QM_UNIT_ID] [char](10) DEFAULT '' NOT NULL,
[QM_PROD_BRANCH] [char](6) DEFAULT '' NOT NULL,
[QM_UID] [int] DEFAULT 0 NOT NULL,
[QM_AVAIL_DATE] [smalldatetime] DEFAULT ('1900-01-01') NOT NULL,
[QM_AVAIL_TIME] [int] DEFAULT -1 NOT NULL
) ON [PRIMARY]


GO

-- Create an index on the table

CREATE unique INDEX [QM_NUMBER_ORDER] ON tmp([QM_QUOTE_JOB], [QM_NUMBER]) ON [PRIMARY]

GO



-- Populate the table

declare @Counter as int

SET NOCOUNT ON

set @Counter = 1

while @Counter < 100000

begin

insert into tmp (QM_ADD_TIME, QM_NUMBER) values (1,@Counter);

set @Counter = @Counter + 1

end

GO

-- Update QM_UID to a sequential value

declare @NextID int;

set @NextID = 1;

update tmp set QM_UID=@NextID, @NextID = @NextID + 1;



-- Find rows with a duplicate QM_UID (there should be no duplicate)

select QM_UID, count(*) from tmp group by QM_UID having count(*) > 1 order by QM_UID

--drop table tmp



-- output from select @@VERSION

-- Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52 Copyright (c) 1988-2005 Microsoft Corporation Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

View 4 Replies View Related

Problems Upgrading Database Engine 2005 Express To 2005 Standard

Nov 7, 2006

I'm having problems upgrading the SQL express 2005 database engine services to 2005 standard 32 bit. I've also tried to install sql 2005 service pack 1 "SQLServer2005SP1-KB913090-x86-ENU.exe" and it did the same thing, upgraded everything except the database engine services. After that I tried another install from the run command "Z:Setup.exe SKUUPGRADE=1" and that failed at the same place as well.

My windows version is is 5.2 (build 3790.srv03_sp1_rtm.050324-1447:service pack 1

Below is a copy of the error log file from the install, any help would be greatly appreciated.



=== Verbose logging started: 11/7/2006 9:06:34 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (68:CC) [09:06:34:789]: Resetting cached policy values
MSI (c) (68:CC) [09:06:34:789]: Machine policy value 'Debug' is 0
MSI (c) (68:CC) [09:06:34:789]: ******* RunEngine:
******* Product: z:SetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (c) (68:CC) [09:06:34:789]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (68:CC) [09:06:34:789]: Grabbed execution mutex.
MSI (c) (68:CC) [09:06:34:805]: Cloaking enabled.
MSI (c) (68:CC) [09:06:34:805]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (68:CC) [09:06:34:805]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (A0:24) [09:06:34:805]: Grabbed execution mutex.
MSI (s) (A0:E0) [09:06:34:805]: Resetting cached policy values
MSI (s) (A0:E0) [09:06:34:805]: Machine policy value 'Debug' is 0
MSI (s) (A0:E0) [09:06:34:805]: ******* RunEngine:
******* Product: z:SetupSqlRun_SQL.msi
******* Action:
******* CommandLine: **********
MSI (s) (A0:E0) [09:06:34:867]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (A0:E0) [09:06:34:867]: Machine policy value 'TransformsSecure' is 1
MSI (s) (A0:E0) [09:06:34:899]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (A0:E0) [09:06:34:977]: File will have security applied from OpCode.
MSI (s) (A0:E0) [09:06:44:055]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (s) (A0:E0) [09:06:44:086]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'z:SetupSqlRun_SQL.msi' against software restriction policy
MSI (s) (A0:E0) [09:06:44:086]: SOFTWARE RESTRICTION POLICY: z:SetupSqlRun_SQL.msi has a digital signature
MSI (s) (A0:E0) [09:06:53:289]: SOFTWARE RESTRICTION POLICY: z:SetupSqlRun_SQL.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (A0:E0) [09:06:53:289]: End dialog not enabled
MSI (s) (A0:E0) [09:06:53:289]: Original package ==> z:SetupSqlRun_SQL.msi
MSI (s) (A0:E0) [09:06:53:289]: Package we're running from ==> C:WINDOWSInstaller4cc6a2.msi
MSI (s) (A0:E0) [09:06:53:367]: APPCOMPAT: looking for appcompat database entry with ProductCode '{778634FA-DB0F-4D0F-B55F-FB0461B36C44}'.
MSI (s) (A0:E0) [09:06:53:367]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (A0:E0) [09:06:53:367]: Detected that this product uses a multiple instance transform.
MSI (s) (A0:E0) [09:06:53:367]: MSCOREE already loaded, using loaded copy
MSI (s) (A0:E0) [09:06:53:367]: Applying multiple instance transform ':SqlRun01.mst'...
MSI (s) (A0:E0) [09:06:53:367]: Looking for storage transform: SqlRun01.mst
MSI (s) (A0:E0) [09:06:53:367]: Validating transform 'SqlRun01.mst' with validation bits 0x809
MSI (s) (A0:E0) [09:06:53:367]: Transform 'SqlRun01.mst' is valid.
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: Patch
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary.
MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: Applying regular transform to database.
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Validation 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RegLocator 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AppSearch 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CompLocator 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Directory 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Registry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CreateFolder 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Icon 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: InstallUISequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdminUISequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ReserveCost 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: TypeLib 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Feature 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiAssembly 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ServiceControl 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleDependency 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleSignature 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ServiceInstall 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlGroup 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlConfig 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlScript 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ActionText 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlSku 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlStart 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Dialog 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlCollation 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlProducts 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: FeatureComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Control 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ControlEvent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ControlCondition 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ListView 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CheckBox 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: EventMapping 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RadioButton 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Upgrade 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: TextStyle 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: UIText 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Shortcut 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RemoveFile 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Environment 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Machine policy value 'DisablePatch' is 0
MSI (s) (A0:E0) [09:06:53:367]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (A0:E0) [09:06:53:367]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (A0:E0) [09:06:53:367]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (A0:E0) [09:06:53:367]: Looking for storage transform: InstID01.mst
MSI (s) (A0:E0) [09:06:53:367]: Validating transform 'InstID01.mst' with validation bits 0
MSI (s) (A0:E0) [09:06:53:367]: Transform 'InstID01.mst' is valid.
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: Patch
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary.
MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: Applying regular transform to database.
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Property 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Validation 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RegLocator 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AppSearch 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CompLocator 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Directory 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Registry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CreateFolder 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Icon 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: InstallUISequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdminUISequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ReserveCost 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: TypeLib 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Feature 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiAssembly 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ServiceControl 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleDependency 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleSignature 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ModuleComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ServiceInstall 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlGroup 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlConfig 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlScript 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ActionText 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlSku 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlStart 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Dialog 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlPerfCounters 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlCollation 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlProducts 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: FeatureComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Control 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ControlEvent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ControlCondition 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ListView 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CheckBox 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: EventMapping 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RadioButton 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Upgrade 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: TextStyle 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: UIText 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Shortcut 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RemoveFile 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Environment 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: #_BaselineCost 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: #_BaselineFile 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: #_BaselineData 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: #_PatchCache 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Looking for storage transform: InstName02.mst
MSI (s) (A0:E0) [09:06:53:367]: Validating transform 'InstName02.mst' with validation bits 0
MSI (s) (A0:E0) [09:06:53:367]: Transform 'InstName02.mst' is valid.
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: Patch
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: 'PatchPackage' table is missing or empty. No pre-transform fixup necessary.
MSI (s) (A0:E0) [09:06:53:367]: TRANSFORM: Applying regular transform to database.
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Tables 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Columns 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Property 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _Validation 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: File 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: MsiFileHash 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: RegLocator 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: AppSearch 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CompLocator 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: DrLocator 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Binary 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CustomAction 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Directory 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Registry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: CreateFolder 3: -2147287038
MSI (s) (A0:E0) [09:06:53:367]: Note: 1: 2262 2: _sqlObjectSecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Icon 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: InstallExecuteSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: InstallUISequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdminExecuteSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdminUISequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdvtExecuteSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdvtUISequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlAction 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlActionsModule 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlDriveType 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ReserveCost 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: TypeLib 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Feature 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: MsiAssembly 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ServiceControl 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ModuleDependency 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ModuleSignature 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ModuleExclusion 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ModuleComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlBuiltInAccounts 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: MsiAssemblyName 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ServiceInstall 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlNativeImage 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlPropertyValues 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUserSecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlRegistry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceControl 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlHiveCopy 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlRegSecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlGroup 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlGroupMember 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlConfig 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeScript 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlHotfixScript 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlScript 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ActionText 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlSku 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlStart 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceAccount 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlDelimitProperty 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlEquivalent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlWizardSequence 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Dialog 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlMofcomp 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlWMISecurity 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlInstanceProperty 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlInstanceComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlAssembly 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlCollation 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlExecutable 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlFileSR 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUnmanagedComponent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeComponent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlProducts 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlTopLevelFeatureProducts 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlFileRename 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlFollowComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlLocalServers 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlVerIndependentProgID 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceState 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceProperty 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlServiceConfig 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlSupportFiles 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlDomainGroup 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: FeatureComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Control 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ControlEvent 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ControlCondition 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ListBox 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ListView 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: ComboBox 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: CheckBox 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: EventMapping 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: RadioButton 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Upgrade 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: TextStyle 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: UIText 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Media 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Shortcut 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: SxsMsmGenComponents 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: MsiSFCBypass 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: RemoveFile 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: RemoveRegistry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Environment 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeFile 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeRegistry 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _sqlUpgradeFolders 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: _MsiPatchTransformView 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: #_BaselineCost 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: #_BaselineFile 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: #_BaselineData 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: #_PatchCache 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: APPCOMPAT: looking for appcompat database entry with ProductCode '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}'.
MSI (s) (A0:E0) [09:06:53:382]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (A0:E0) [09:06:53:382]: Transforms are not secure.
MSI (s) (A0:E0) [09:06:53:382]: Transforming table Property.

MSI (s) (A0:E0) [09:06:53:382]: Transforming table Property.

MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Property 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Transforming table Property.

MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: Property 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Command Line: USERNAME=NW COMPANYNAME=WSDOT PIDKEY=********** INSTALLSQLSHAREDDIR=C:Program FilesMicrosoft SQL Server INSTANCENAME=AUTODESKVAULT INSTALLSQLDIR=F:Program FilesMicrosoft SQL Server INSTALLSQLDATADIR=F:Program FilesMicrosoft SQL Server SECURITYMODE=SQL UPGRADEUSER=sa UPGRADEPWD=********** ENABLERANU=1 STPSETUPTHREADID=5032 STPSETUPPROCESSID=5992 EXTERNALCONTROL=1 ADDLOCAL=SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_SharedTools,SQL_BC_DEP TRANSFORMS=:SqlRun01.mst;:InstID01.mst;:InstName02.mst MSINEWINSTANCE=1 UPGRADE=SQL_Engine REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=5992
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{3185FC73-41E0-43F4-97DF-2254C4D7C667}'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding TRANSFORMS property. Its value is ':SqlRun01.mst;:InstID01.mst;:InstName02.mst'.
MSI (s) (A0:E0) [09:06:53:382]: Product Code passed to Engine.Initialize: ''
MSI (s) (A0:E0) [09:06:53:382]: Product Code from property table before transforms: '{778634FA-DB0F-4D0F-B55F-FB0461B36C44}'
MSI (s) (A0:E0) [09:06:53:382]: Product Code from property table after multiple instance transforms: '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}'
MSI (s) (A0:E0) [09:06:53:382]: Product Code from property table after transforms: '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}'
MSI (s) (A0:E0) [09:06:53:382]: Product not registered: beginning first-time install
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding ProductState property. Its value is '-1'.
MSI (s) (A0:E0) [09:06:53:382]: Entering CMsiConfigurationManager::SetLastUsedSource.
MSI (s) (A0:E0) [09:06:53:382]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (A0:E0) [09:06:53:382]: Adding new sources is allowed.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding PackagecodeChanging property. Its value is '1'.
MSI (s) (A0:E0) [09:06:53:382]: Package name extracted from package path: 'SqlRun_SQL.msi'
MSI (s) (A0:E0) [09:06:53:382]: Package to be registered: 'SqlRun_SQL.msi'
MSI (s) (A0:E0) [09:06:53:382]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (A0:E0) [09:06:53:382]: Machine policy value 'DisableMsi' is 1
MSI (s) (A0:E0) [09:06:53:382]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (A0:E0) [09:06:53:382]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (A0:E0) [09:06:53:382]: Product installation will be elevated because user is admin and product is being installed per-machine.
MSI (s) (A0:E0) [09:06:53:382]: Running product '{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}' with elevated privileges: Product is assigned.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'NW'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding COMPANYNAME property. Its value is 'WSDOT'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding INSTANCENAME property. Its value is 'AUTODESKVAULT'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding INSTALLSQLDIR property. Its value is 'F:Program FilesMicrosoft SQL Server'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding INSTALLSQLDATADIR property. Its value is 'F:Program FilesMicrosoft SQL Server'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding SECURITYMODE property. Its value is 'SQL'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding UPGRADEUSER property. Its value is 'sa'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding UPGRADEPWD property. Its value is '**********'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding ENABLERANU property. Its value is '1'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '5032'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '5992'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'SQL_Engine,SQL_Data_Files,SQL_Replication,SQL_FullText,SQL_SharedTools,SQL_BC_DEP'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding MSINEWINSTANCE property. Its value is '1'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding UPGRADE property. Its value is 'SQL_Engine'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'.
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '5992'.
MSI (s) (A0:E0) [09:06:53:382]: TRANSFORMS property is now: :SqlRun01.mst;:InstID01.mst;:InstName02.mst
MSI (s) (A0:E0) [09:06:53:382]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '150'.
MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccApplication Data
MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccFavorites
MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccNetHood
MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccMy Documents
MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccPrintHood
MSI (s) (A0:E0) [09:06:53:398]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccRecent
MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccSendTo
MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccTemplates
MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data
MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccLocal SettingsApplication Data
MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccMy DocumentsMy Pictures
MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup
MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms
MSI (s) (A0:E0) [09:06:53:414]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu
MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersDesktop
MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccStart MenuProgramsAdministrative Tools
MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccStart MenuProgramsStartup
MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccStart MenuPrograms
MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccStart Menu
MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingswprimaccDesktop
MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersTemplates
MSI (s) (A0:E0) [09:06:53:429]: SHELL32::SHGetFolderPath returned: C:WINDOWSFonts
MSI (s) (A0:E0) [09:06:53:429]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller4cc6a2.msi'.
MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'z:SetupSqlRun_SQL.msi'.
MSI (s) (A0:E0) [09:06:53:429]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (A0:E0) [09:06:53:429]: Machine policy value 'DisableRollback' is 0
MSI (s) (A0:E0) [09:06:53:429]: User policy value 'DisableRollback' is 0
MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'.
=== Logging started: 11/7/2006 9:06:53 ===
MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'.
MSI (s) (A0:E0) [09:06:53:429]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (s) (A0:E0) [09:06:53:429]: Doing action: INSTALL
MSI (s) (A0:E0) [09:06:53:445]: Running ExecuteSequence
MSI (s) (A0:E0) [09:06:53:445]: Doing action: ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C
Action start 9:06:53: INSTALL.
MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C property. Its value is 'C:Program Files'.
Action start 9:06:53: ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C.
MSI (s) (A0:E0) [09:06:53:445]: Doing action: CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128
Action ended 9:06:53: ProgramFilesFolder.68C6D15C_77E0_11D5_8528_00C04F68155C. Return value 1.
MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128 property. Its value is 'C:Program FilesCommon Files'.
Action start 9:06:53: CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128.
MSI (s) (A0:E0) [09:06:53:445]: Doing action: SystemFolder.291EAD4C_0726_4504_A2A1_C9FF1E711B8C
Action ended 9:06:53: CommonFilesFolder.D9BC9C10_2DCD_44D3_AACC_9C58CAF76128. Return value 1.
MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding SystemFolder.291EAD4C_0726_4504_A2A1_C9FF1E711B8C property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.291EAD4C_0726_4504_A2A1_C9FF1E711B8C.
MSI (s) (A0:E0) [09:06:53:445]: Doing action: SystemFolder.7188DA12_A95E_46B7_8623_9D93B5260E2A
Action ended 9:06:53: SystemFolder.291EAD4C_0726_4504_A2A1_C9FF1E711B8C. Return value 1.
MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding SystemFolder.7188DA12_A95E_46B7_8623_9D93B5260E2A property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.7188DA12_A95E_46B7_8623_9D93B5260E2A.
MSI (s) (A0:E0) [09:06:53:445]: Doing action: SystemFolder.7F92F353_B3A2_4AE0_A288_5B746146B1B8
Action ended 9:06:53: SystemFolder.7188DA12_A95E_46B7_8623_9D93B5260E2A. Return value 1.
MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding SystemFolder.7F92F353_B3A2_4AE0_A288_5B746146B1B8 property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.7F92F353_B3A2_4AE0_A288_5B746146B1B8.
MSI (s) (A0:E0) [09:06:53:445]: Doing action: ProgramFilesFolder.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF
Action ended 9:06:53: SystemFolder.7F92F353_B3A2_4AE0_A288_5B746146B1B8. Return value 1.
MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding ProgramFilesFolder.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF property. Its value is 'C:Program Files'.
Action start 9:06:53: ProgramFilesFolder.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF.
MSI (s) (A0:E0) [09:06:53:445]: Doing action: CommonFilesFolder.808C44A0_9EC0_4446_A4CB_3E51F5C5D59F
Action ended 9:06:53: ProgramFilesFolder.EAD22282_F1AF_4119_B1F9_C9F1DCBC62FF. Return value 1.
MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding CommonFilesFolder.808C44A0_9EC0_4446_A4CB_3E51F5C5D59F property. Its value is 'C:Program FilesCommon Files'.
Action start 9:06:53: CommonFilesFolder.808C44A0_9EC0_4446_A4CB_3E51F5C5D59F.
MSI (s) (A0:E0) [09:06:53:445]: Doing action: CommonFilesFolder.1887A514_D285_4653_98A1_6B7128517683
Action ended 9:06:53: CommonFilesFolder.808C44A0_9EC0_4446_A4CB_3E51F5C5D59F. Return value 1.
MSI (s) (A0:E0) [09:06:53:445]: PROPERTY CHANGE: Adding CommonFilesFolder.1887A514_D285_4653_98A1_6B7128517683 property. Its value is 'C:Program FilesCommon Files'.
Action start 9:06:53: CommonFilesFolder.1887A514_D285_4653_98A1_6B7128517683.
MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F
Action ended 9:06:53: CommonFilesFolder.1887A514_D285_4653_98A1_6B7128517683. Return value 1.
MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F.
MSI (s) (A0:E0) [09:06:53:461]: Doing action: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E
Action ended 9:06:53: SystemFolder.60A85CA1_D9D8_43FA_9DD5_574BEF970F9F. Return value 1.
MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 9:06:53: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E
Action ended 9:06:53: WindowsFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:461]: Doing action: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E
Action ended 9:06:53: SystemFolder.D2730D3F_3C41_5884_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 9:06:53: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E
Action ended 9:06:53: WindowsFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:461]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action ended 9:06:53: SystemFolder.68B7C6D9_1DF2_54C1_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 9:06:53: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action ended 9:06:53: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:461]: Doing action: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E
Action ended 9:06:53: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 9:06:53: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:461]: Doing action: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E
Action ended 9:06:53: WindowsFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:461]: PROPERTY CHANGE: Adding SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:476]: Doing action: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E
Action ended 9:06:53: SystemFolder.66332652_9C28_58B1_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 9:06:53: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:476]: Doing action: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E
Action ended 9:06:53: WindowsFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:476]: Doing action: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E
Action ended 9:06:53: SystemFolder.74FD3CE6_2A8D_0E9C_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 9:06:53: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:476]: Doing action: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E
Action ended 9:06:53: WindowsFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:476]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 9:06:53: SystemFolder.9BAE13A2_E7AF_D6C3_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 9:06:53: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:476]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 9:06:53: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:476]: Doing action: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E
Action ended 9:06:53: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 9:06:53: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:476]: Doing action: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E
Action ended 9:06:53: WindowsFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 9:06:53: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E.
MSI (s) (A0:E0) [09:06:53:476]: Doing action: ProgramMenuFolder.ConfigurationTools1033
Action ended 9:06:53: SystemFolder.97F81AF1_0E47_DC99_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (A0:E0) [09:06:53:476]: PROPERTY CHANGE: Adding ProgramMenuFolder.ConfigurationTools1033 property. Its value is 'C:Documents and SettingsAll UsersStart MenuPrograms'.
Action start 9:06:53: ProgramMenuFolder.ConfigurationTools1033.
MSI (s) (A0:E0) [09:06:53:492]: Doing action: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 9:06:53: ProgramMenuFolder.ConfigurationTools1033. Return value 1.
MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2 property. Its value is 'C:Program Files'.
Action start 9:06:53: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetMDACSxS
Action ended 9:06:53: ProgramFilesFolder.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding MDACSXS property. Its value is '1'.
Action start 9:06:53: SetMDACSxS.
MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetInstanceName
Action ended 9:06:53: SetMDACSxS. Return value 1.
MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding SqlInstanceName property. Its value is 'AUTODESKVAULT'.
Action start 9:06:53: SetInstanceName.
MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetCollation
Action ended 9:06:53: SetInstanceName. Return value 1.
Action start 9:06:53: SetCollation.
MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetSecurityMode
Action ended 9:06:53: SetCollation. Return value 1.
MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding SqlSecurityMode property. Its value is 'SQL'.
Action start 9:06:53: SetSecurityMode.
MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetUpgradeUser
Action ended 9:06:53: SetSecurityMode. Return value 1.
MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding SqlUpgradeUser property. Its value is 'sa'.
Action start 9:06:53: SetUpgradeUser.
MSI (s) (A0:E0) [09:06:53:492]: Skipping action: ErrorDisableNetworkProtocols (condition is false)
MSI (s) (A0:E0) [09:06:53:492]: Skipping action: SetCluster (condition is false)
MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetClusterSec
Action ended 9:06:53: SetUpgradeUser. Return value 1.
Action start 9:06:53: SetClusterSec.
MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetSaPwd
Action ended 9:06:53: SetClusterSec. Return value 1.
Action start 9:06:53: SetSaPwd.
MSI (s) (A0:E0) [09:06:53:492]: Doing action: SetUpgradePwd
Action ended 9:06:53: SetSaPwd. Return value 1.
MSI (s) (A0:E0) [09:06:53:492]: PROPERTY CHANGE: Adding SqlUpgradePwd property. Its value is '**********'.
Action start 9:06:53: SetUpgradePwd.
MSI (s) (A0:E0) [09:06:53:492]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 9:06:53: SetUpgradePwd. Return value 1.
MSI (s) (A0:D0) [09:06:53:523]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI40E.tmp, Entrypoint: StreamSupportFiles
MSI (s) (A0:C8) [09:06:53:523]: Generating random cookie.
MSI (s) (A0:C8) [09:06:53:523]: Created Custom Action Server with PID 4592 (0x11F0).
MSI (s) (A0:A8) [09:06:53:554]: Running as a service.
MSI (s) (A0:A8) [09:06:53:554]: Hello, I'm your 32bit Impersonated custom action server.
Action start 9:06:53: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2.
Property(SQL): Setup Bootstrap Directory = C:Program FilesMicrosoft SQL Server90Setup Bootstrap
1: 0 2: Iterating through _sqlSupportFiles entries
Streamed sqlca.D20239D7_E87C_40C9_9837_E70B8D4882C2 to C:Program FilesMicrosoft SQL Server90Setup Bootstrapin{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}sqlca.dll
MSI (s) (A0:E0) [09:06:53:664]: Doing action: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 9:06:53: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (A0:90) [09:06:53:679]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI40F.tmp, Entrypoint: Do_LogInstallStart
Action start 9:06:53: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2.
Property(SQL): Setup Bootstrap Directory = C:Program FilesMicrosoft SQL Server90Setup Bootstrap
Property(SQL): CA DLL Path = C:Program FilesMicrosoft SQL Server90Setup BootstrapBin{130A3BE1-85CC-4135-8EA7-5A724EE6CE2C}sqlca.dll
<Func Name='LaunchFunction'>
Function=Do_LogInstallStart
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_LogInstallStart
PerfTime Start: Do_LogInstallStart : Tue Nov 07 09:06:53 2006
<Func Name='Do_LogInstallStart'>
<EndFunc Name='Do_LogInstallStart' Return='0' GetLastError='203'>
PerfTime Stop: Do_LogInstallStart : Tue Nov 07 09:06:53 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A0:E0) [09:06:53:773]: Doing action: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 9:06:53: Do_LogInstallStart.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (A0:04) [09:06:53:804]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI410.tmp, Entrypoint: GetDefaultDomain
Action start 9:06:53: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=GetDefaultDomain
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: GetDefaultDomain
PerfTime Start: GetDefaultDomain : Tue Nov 07 09:06:53 2006
<Func Name='GetDefaultDomain'>
MSI (s) (A0!F4) [09:06:53:820]: PROPERTY CHANGE: Adding DefaultDomain property. Its value is 'WSDOT'.
MSI (s) (A0!F4) [09:06:53:820]: PROPERTY CHANGE: Adding QuotedDefaultDomain property. Its value is 'WSDOT'.
MSI (s) (A0!F4) [09:06:53:820]: PROPERTY CHANGE: Adding QuotedComputerName property. Its value is 'NWUCWFAUTODESK'.
PerfTime Stop: GetDefaultDomain : Tue Nov 07 09:06:53 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A0:E0) [09:06:53:820]: Doing action: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 9:06:53: GetDefaultDomain.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (A0:8C) [09:06:53:851]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI411.tmp, Entrypoint: RestoreSetupParams
Action start 9:06:53: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=RestoreSetupParams
Skipping Action: RestoreSetupParams (Condition is false)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A0:E0) [09:06:53:867]: Doing action: LaunchConditions
Action ended 9:06:53: RestoreSetupParams.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (A0:E0) [09:06:53:867]: Note: 1: 2205 2: 3: LaunchCondition
MSI (s) (A0:E0) [09:06:53:867]: Note: 1: 2228 2: 3: LaunchCondition 4: SELECT `Condition`, `Description` FROM `LaunchCondition`
Action start 9:06:53: LaunchConditions.
MSI (s) (A0:E0) [09:06:53:867]: Skipping action: Collation.CC1A8C58_27D1_4D38_BF1B_C0A5CBB90616 (condition is false)
MSI (s) (A0:E0) [09:06:53:867]: Doing action: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 9:06:53: LaunchConditions. Return value 0.
MSI (s) (A0:C0) [09:06:53:882]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI412.tmp, Entrypoint: ShutdownServiceManager
Action start 9:06:53: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=ShutdownServiceManager
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: ShutdownServiceManager
PerfTime Start: ShutdownServiceManager : Tue Nov 07 09:06:53 2006
<Func Name='ShutdownServiceManager'>
<EndFunc Name='ShutdownServiceManager' Return='0' GetLastError='2'>
PerfTime Stop: ShutdownServiceManager : Tue Nov 07 09:06:53 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A0:E0) [09:06:53:914]: Doing action: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 9:06:53: ShutdownServiceManager.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (A0:D4) [09:06:53:929]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI413.tmp, Entrypoint: Write_sqlWellKnownAccountNames
Action start 9:06:53: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=Write_sqlWellKnownAccountNames
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: Write_sqlWellKnownAccountNames
PerfTime Start: Write_sqlWellKnownAccountNames : Tue Nov 07 09:06:53 2006
<Func Name='Write_sqlWellKnownAccountNames'>
MSI (s) (A0!10) [09:06:53:945]: PROPERTY CHANGE: Adding AdministratorsGroup property. Its value is 'BUILTINAdministrators'.
MSI (s) (A0!10) [09:06:53:945]: PROPERTY CHANGE: Adding PerformanceMontiorUsersGroup property. Its value is 'BUILTINPerformance Monitor Users'.
MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding PerformanceLogUsersGroup property. Its value is 'BUILTINPerformance Log Users'.
MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding UsersGroup property. Its value is 'BUILTINUsers'.
MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding NetworkServiceAccount property. Its value is 'NT AUTHORITYNETWORK SERVICE'.
MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding SCMNetworkServiceAccount property. Its value is 'NT AUTHORITYNetworkService'.
MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding LocalSystemAccount property. Its value is 'NT AUTHORITYSYSTEM'.
MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding LocalServiceAccount property. Its value is 'NT AUTHORITYLOCAL SERVICE'.
MSI (s) (A0!10) [09:06:53:961]: PROPERTY CHANGE: Adding SCMLocalServiceAccount property. Its value is 'NT AUTHORITYLocalService'.
<EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='0'>
PerfTime Stop: Write_sqlWellKnownAccountNames : Tue Nov 07 09:06:53 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (A0:E0) [09:06:53:961]: Skipping action: PropSetSQLAutoStart.D20239D7_E87C_40C9_9837_E70B8D4882C2 (condition is false)
MSI (s) (A0:E0) [09:06:53:961]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action ended 9:06:53: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (s) (A0:A8) [09:06:53:976]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI414.tmp, Entrypoint: CheckIIS
Action start 9:06:53: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2.
<Func Name='LaunchFunction'>
Function=CheckIIS
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: CheckIIS
PerfTime Start: CheckIIS : Tue Nov 07 09:06:54 2006
<Func Name='CheckIIS'>
MSI (s) (A0!6C) [

View 5 Replies View Related

Update , Insert ,delete Option From The Database ? Help

Feb 11, 2006

Hello,



Where can i give on the sql server Management studio that i can insert and update, delete.

Thenks for you help

View 1 Replies View Related

Insert, Delete, Update Data In Database

Mar 14, 2006

hi. i'm trying to create a c# application which would insert, update and delete data from a database. could anyone pls point me to the right direction in which i should take? thanks in advance.

View 1 Replies View Related

Writeback To The Source OLTP Database.

Apr 22, 2008

I was wondering if it is possible to use SQL Server Reporting Services 2005 with the 'writeback' feature to the source OLTP database?

I have seen article's that refer to using SQL Server Analyses Services (SSAS) and writing back to the ROLAP/MOLAP database, however this is not desirable for our case.

I have almost come to the conclusion that it is not possible without SSAS.

Cheers,

View 3 Replies View Related

How To Use Update/delete Feature Of VS 2005 For Working With A SQL Server Table.

May 1, 2008

 Hi all,
i m using VS 2005 and I have to  display records with feature of INSERT / DELETE ITEMS But when i connect to Sql Server Database and select * from columns but here when clicking the "Advance" button , i do not get "Advance Sql generation Option "  highlighted. Instead , it is turned off. i.e
 The Following options are not highlighting
------ Generate Insert, Update, Delete  statements
------ use optimistic concurrency
Plz guide me anyone..... is anything wrong with our VS 2005 software installed?
Bilal

View 4 Replies View Related

Best Backup/restore (OLTP/OLAP) Practices In 2005

Aug 14, 2007

We have a live OLTP database for which we create full backups every week and differential backups every day. Recently we added an OLAP database, which we need to update daily with changes from the live database.

This is the process we are planning to use.
1. Restore last full OLTP backup.
2. Apply the last differential OLTP backup.
At this point we should have a replica of the live OLTP database.
3. Update OLAP database based on the OLTP replica database.
4. Delete the OLTP replica database.

Two questions.
1. If different from the process above, how is this OLTP-to-OLAP transformation typically done in the industry?
2. What is the best way to implement this process with SQL Server 2005?

Thanks.

View 3 Replies View Related

How To Insert, Update, Delete And View Database Values

Apr 5, 2007

I am creating a website.
i have completed the GUI. i have labels on the left side of the form and a text box for each of those labels on the right side of the form. i have the two dropdown boxes that you have helped me create and bind. now im stuck on how to start the code to get this all working. i know what i need it to do (pseudocode) but dont know how to write the code for it. these books and online sources, really dont say where to put things, they just give examples, not stating where to place it.
I am using a SQL database called Manufacturers
i would like to insert or update, but not delete records wtih this tool
pixelsyndicate mentioned using the GUI to do the code for me, would love to know how to do this.
any help would be awesome, or any good beginner resources would help too
 
Thanks

View 1 Replies View Related

Tracing Insert, Update Or Delete For Entire Database

Jul 16, 1999

I need to create some kind of log file or table that will record whenever an insert, update or delete is made to any table in a database. I have seen triggers that do this kind of thing on a table level. Can this be done with a trigger or a stored procedure on a database level? If so some kind of example or syntax would be great.

TIA.

Mike

View 1 Replies View Related

OLTP Database Design Help For Bank's Customer Table

Aug 9, 2007


Hello,friends

1) CustomerID
2) FirstName
3) MiddleName
4) SurName
5) Title
6) Marital Status
7) Education
8) Occupation
9) Annual Income
10) Line of Business
11) DOB
12) Father Name
13) Mother Name
14) SpouseName
15) Gender
16) Email
17) MainTel
18) Home Tel
19) Passport Number
20)----------------------
21)- - - - - - - - - - -


100)-------------------
Above mentioned list is a snapshot of our customer master table ,which contain approximately 100 attributes related to a customer.

We are designing an application for banking sector (but NOT Core banking solution),for which we may need to capture variable number of addresses for bank's customer,i.e more then three types of addresses Fixed,Temporary and Communication addresses(which is generally the case with all banks).
A single address includes address1/address2/city/country/state/pincode fields.
In context of OLTP database,We have option to put multiple addresses in child table but that involves various joins at the time of data retrival and slow down the query.


As another option we can can create redundent addresses columns(address1/address2/city/country/state/pincode) in master table that will accumulate addresses if demand for more then three type addresses arises(although there is reasonable numer of extra addresses is expected, i.e 10)

Database is expected to serve the records of 25 million(approx) bank's customer,so does someone can suggest me how to maintan the balance between two approches.

View 2 Replies View Related

SQL Server 2012 :: Update Statement Bringing Unexpected Results

Nov 25, 2014

I have a simple update statement (see example below) that when runs, I expect to see the number of records updated in the Results tab. This information shows up in the Messages tab; however, what is displayed in the Results tab is (No column name) 40. From where the 40 is being generated. I have tried restarting SSMS 2012, restarting my computer, turning NOCOUNT on and off.

"UPDATE TableA
SET Supervisor = 'A123'
WHERE PersonnelNumber = 'B456'"

View 4 Replies View Related

OLTP Vs OLAP (Data Warehouse) As A DataSource In Analysis Services 2005

Jul 3, 2007

Hello,Can I import an OLTP (Reltional DB) as a Data Source into SQL ServerAnalysis Services 2005 and then use the Cube Wizard and the new DataSource View feature to create the OLAP model ?Or do I have to first design an OLAP Data Warehouse with a Star Schemaand then import this DW as a Data Source into my Analysis ServicesProject.With SQL Server 2000 , OLAP would be the way to go..but with SQLServer 2005 , it seems as though the wizard and data source viewfeatures do half the work for you.I have an OLTP DB and am not sure which route I should take ! Anysuggestions / input would be much appreciated.Thanks in Advance...RegardsRusszee

View 1 Replies View Related

SQL Server 2008 :: Find All Transaction (insert / Delete / Update) On A Database For A Day?

May 8, 2015

i would like to know it's possible to find all transaction(insert, delete,update) on a database for a day. if yes what can i do.

View 2 Replies View Related

SQL Server 2005 Cannot Connect To Database Engine...!

Sep 24, 2007

Hello
I've just installed 'SQL server 2005' and it installed the components like .Net2.0 and visual studio 2005 . before installing them I had uninstalled sql server2000 . I ran SQL management studio and tried to connect and makin' servers it doesn't allow me to connect or making any new servers...... it gives me this error
Cannot connect to local.
Additional information:
An error has occured while establishing a connection to the server. ......
error:53)
 
need to solve it....
 
 

View 3 Replies View Related

Problem While Installing Database Engine Of SQL 2005.

Nov 16, 2007



Hi,

I am getting the following error while installing a SQL 2005 on a standalone machine with Win2k3

Product: Microsoft SQL Server 2005 -- Error 29515. SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]SSL Provider: The client and server cannot communicate, because they do not possess a common algorithm.

any help to resolve this problem will be highly appreciated.

Regards
Nimesh

View 5 Replies View Related

New Installation Of MSSQL Database Engine 2005

Nov 6, 2007



I have a MS 2003 server where the os adminstrator has loaded the tools for a MSSQL 2005 but not the instance.

I went in to add the component via the Add & remove programs and selected Microsoft SQL Server 2005.
Selected change

I entered the path for the cd but only get the setup.exe for the components; sql mangement studio....

what is the path to install the Database Engine component.... inorder to load a new default instance?


osbornet

View 4 Replies View Related

No More Able To Connect To My SQL Server 2005 Database Engine

Mar 12, 2007

Hello,
I have installed SQL Server 2005 in my PC and during the installation I
have created a predefined instance (I have used Windows autentication).
I could use correctly SQL Server till some days ago, when I changed the
password of my PC login profile.
Now, when I open SQL Server, if I click on the "Connect" button,
the following error message appears (I translate it from italian version)

Unable to connect to "CARLO"
Further information:
An error has occurred while you were trying to establish a connection to
the server. When you connect to SQL Server 2005, this error can be generated
because SQL Server doesn't allow remote connections under the predefined
settings. (provider: Provider Named Pipes, error: 40 - Unable to open a
connection to SQL Server) (Micorsoft SQL Server, error:2)

I'm sure that the error raises because I have changed my PC access
password (the program worked correctly before), but in the "Connect to
Server" window the user name and the password text boxes are disabled, so
I can't insert the new password...
Can you suggest what have I to do?

Thank you very much

View 5 Replies View Related

Could Not Start The Database Engine Service In Sql Server 2005

Jul 16, 2007



Dear All,



I am not able to start the sql server 2005 database engine services...

Sql server 2005 server is installed in one machine(SERVER) and we have 10 client machine connecting to the server





When i try to start the service from the Service.msc in the SERVER i am getting the following error



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

Cannot connect to KEYSKILL.

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

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider)

------------------------------
Error Number: 2
Severity: 20
State: 0


------------------------------
Program Location:

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ObjectExplorer.ValidateConnection(UIConnectionInfo ci, IServerType server)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()





Could any one help me to resolve the error

Thanks in Advance



Lalitha



View 6 Replies View Related

HELP!! Cannot Connect To SQL Server 2005 Developer Database Engine

Oct 19, 2007

OK.

I'm using Microsoft SQL Server 2005 Developer Edition and I installed it under "Local System" on Microsoft Windows Vista Ultimate.

I understand that there are issues of course that occur with this, however I can't seem to understand why what I'm doing isn't working. I'm not using this on any server, just to test out ASP.NET 2.0 applications - nothing more.

I'm getting this error:


TITLE: Connect to Server
------------------------------

Cannot connect to RUSSPC.

------------------------------
ADDITIONAL INFORMATION:

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

I've installed this via a mixed authentication (as suggested by www.wrox.com).


I tried enabling the TCP/IP and named pipe connections, just as previous people have done, but it hasn't worked. Nor has enabling the SQL Browser.

I'm really at a loss on what to do.

View 3 Replies View Related

DataSet Rows Being Deleted, But After The Update , The Sql Database Is Not Updated. The Delete Rows Still In The Database.

Jun 4, 2007

 Stepping thru the code with the debugger shows the dataset rows being deleted.
 
After executing the code, and getting to the page presentation. Then I stop the debug and start the
page creation process again ( Page_Load ).    The database still has the original deleted dataset rows.
Adding rows works, then updating works fine, but deleting rows, does not seem to work.
 
The dataset is configured to send the DataSet updates to the database. Use the standard wizard to create the dataSet.
 
 
cDependChildTA.Fill(cDependChildDs._ClientDependentChild, UserId);        rowCountDb = cDependChildDs._ClientDependentChild.Count;               for (row = 0; row < rowCountDb; row++)        {           dr_dependentChild = cDependChildDs._ClientDependentChild.Rows[0];           dr_dependentChild.Delete();                      //cDependChildDs._ClientDependentChild.Rows.RemoveAt(0);           //cDependChildDs._ClientDependentChild.Rows.Remove(0);            /* update the Client Process Table Adapter*/          // cDependChildTA.Update(cDependChildDs._ClientDependentChild);      //     cDependChildTA.Update(cDependChildDs._ClientDependentChild);        }
        /* zero rows in the DataSet at this point */        /* update the Child  Table Adapter */       cDependChildTA.Update(cDependChildDs._ClientDependentChild);

View 1 Replies View Related

How To Debug Database Engine Stored Procedures On SQL Server 2005?

Mar 19, 2007

1). When you right click stored procedure in the Query Analyzer on 2000 you can select debug from the list of menues.

I can't find this functionality in the SQL Server Management studio.

2). By the way I also can't find where went the output of my print statement.

3). Does server cursor functionality is still working in 2k5?

View 3 Replies View Related

Connecting Database Engine (SQl Server 2005 File .*mdf) From Win CE 5.0 Platform

Jun 26, 2006

Is this possible to connect do the Database Engine (on sql server 2005 on XP platorm - file *.mdf (not mobile *.sdf)) from win CE 5.0?

I tried to do this :
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS;Initial Catalog=dbMachines;Integrated Security=False;Password=Panel;User ID=Panel";

SqlCeConnectionCE = new SqlConnection(ConnectionStringSQLServerCE);

SqlCeConnectionCE.Open();

but I catch error:
catch (PlatformNotSupportedException ex)
€žPlatformNotSupportedException€?
I noticed that I see server because when I use:
ConnectionStringSQLServerCE = "Data Source=WORK_STATION\SQLEXPRESS";

zwraca błąd typu

catch (SqlException ex)
€œLogin failed for user ''. The user is not associated with a trusted SQL Server connection.€?

I used
using System.Data.SqlClient;

from Compact Framework 2.0 under Visual Studio 2005 Device Application Windows CE 5.0

can anyone help me?

View 1 Replies View Related

Database Engine Tuning Advisor Gives Non Existent Errors In SQL 2005

Aug 14, 2006

Hello,

I am sure you have heard of Community server - if not you are just using it ;)

I decided to try to optimise the performance of my site, run a trace and then DETA.

And I am getting errors like these:



E000 exec dbo.cs_user_Get @UserName=N'jded',@UserID=0,@IsOnline=0,@LastAction=N'',@SettingsID=1000 122 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_user_Get'.
exec dbo.cs_thread_IsTracked @ThreadID=5969,@UserID=28236,@SettingsID=1000,@IsTracked=@p4 output
select @p4 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_thread_IsTracked'.
E000 declare @p4 bit
set @p4=0
exec dbo.cs_thread_IsTracked @ThreadID=414,@UserID=1001,@SettingsID=1000,@IsTracked=@p4 output
select @p4 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_thread_IsTracked'.
E000 exec dbo.cs_Section_GetSectionIDByPostID @SettingsID=1000,@PostID=44641 1 [Microsoft][SQL Native Client][SQL Server]Could not find stored procedure 'dbo.cs_Section_GetSectionIDByPostID'.





The "trouble" is that those sprocs do exist and that the site apparently is working fine. But not for DETA. As far as DETA is concerned... 54% of my processing power is used to serve syntax errors!

A couple of hints.
The database was an upgrade from 2000.:
- I changed the compatibility level to 2005 but no luck there. I tried with a brand new database, and the errors keep cropping up.
B. The errors were observed in a kit that comprises of a 32bit IIS and 64bit SQL2005 and thought that it had to do with the connectivity of those two.
- I run the traces in one (32bit) server that hosts both IIS and SQL and I am getting the same errors.


Any help will be greatly appreciated.

Thank you.


View 7 Replies View Related

Unexpected Exceptions In SQL/COM+ Since Converting To VS 2005

Nov 11, 2005

We are running a COM+ DLL that handles transactions and security with a SQL Server back-end.  This project was started in VS 2003, but we just converted it to VS 2005.  Since the conversion, creating a number of transactions in a row generates errors at consistent, but moving, locations in the code (i.e. the location where the failure occurs changes when I do things such as add additional try/catch statements, so it is not random but also clearly not associated with any particular line of code).

View 8 Replies View Related

SQL Server 2005 SP2 Cannot Be Installed Because The Database Engine Setup Remains In Suspended Installation Mode

Feb 23, 2007

SP2 refuses to install for the Database Engine because €œthe previous upgrade did not complete€?, i.e. it detects a suspended installation. The same thing happened to me when I installed SP1. I then remember opening the maintenance dialog and completing the setup, after which SP1 installed just fine.

When I try to do the same thing this time, I€™m presented with the €?complete the suspended installation€? option, which when I run it reports the installation completed successfully. However, in reality the installation still remains in suspended mode for whatever reason. If I reboot and open the maintenance dialog, I€™m still presented with the €?complete the suspended installation€? option. I€™ve even tried to run it more than once, but it doesn€™t help. Needless to say, SP2 still refuses to install.

I don't know why the installation is in a suspended state. I know every part of SP1 installed successfully in the end, and the computer never crashed during the installation. I've been using it every day since then, without any problems. All other parts of SP2 did install successfully.

I created a feedback entry on Microsoft Connect, where you can find the log files created by Windows Installer. The URL is:
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=259606

Any ideas what I can do to resolve this problem?

View 1 Replies View Related

DB Engine :: Delete All Remote Table Contents

Jun 24, 2015

I'm copying date from a  sql server 2000 table to a sql server 2008 R2 table using a Linked Server.I need to be sure the remote table is correct before processing it.I first delete all the remote table contents and after that, I insert into remote_table from local_tableWhat happens if the communication is interrupted during the insert?I mean, Can I be sure all records were copied just checking if record count > 0 ?

View 3 Replies View Related

SQL 2005 SP2 - Unexpected Results With Snapshot Replication - Should Get An Error

Jun 25, 2007

I am using snapshot replication to copy data from one database to another. I truncate the destination table first. The publisher and the subscriber are different databases on the same server. The data turns into 1 unrecognizable row.



Here is what the source table looks like:
displayTypeID, displayType
1, Title List Formats
2, Title Details
3, Title List Export
4, Pricing Notes
5, clone Mask 001
6, clone Mask 002
7, clone Mask 004
8, clone Mask 008
9, hide From Admin
10, not Common Attr
11, Insert Title
12, title Types



The resulting data looks like this:
DisplayType, displayTypeId
, 1660953600
I see no errors in replication and nothing in the source table looks like bad data that could cause such a malady. I see the problem on two different servers now and identified the source of the problem, the column order is reversed in the source and destination tables. The data types do not even match so I would at the very least expect an error from bcp.

View 2 Replies View Related

Unable To Install SQl Server 2005 SP2 - Unexpected Error

Feb 20, 2007

I am trying to install SQl Server 2005 SP2 but it was throwing an unexpected error when trying to install "setup support files".

O/s: Windows Server 2003 SP1

Product: SQL Server 2005 Standard Edition

Log file shows:

+++++++++++++++++++

=== Verbose logging started: 2/20/2007 16:05:42 Build type: SHIP UNICODE 3.01.4000.2435 Calling process: F:SQL2005sp2hotfix.exe ===
MSI (c) (74:68) [16:05:42:635]: Resetting cached policy values
MSI (c) (74:68) [16:05:42:635]: Machine policy value 'Debug' is 0
MSI (c) (74:68) [16:05:42:635]: ******* RunEngine:
******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (c) (74:68) [16:05:42:635]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (74:68) [16:05:42:635]: Grabbed execution mutex.
MSI (c) (74:68) [16:05:42:729]: Cloaking enabled.
MSI (c) (74:68) [16:05:42:729]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (74:68) [16:05:42:745]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (20:70) [16:05:42:792]: Grabbed execution mutex.
MSI (s) (20:68) [16:05:42:792]: Resetting cached policy values
MSI (s) (20:68) [16:05:42:792]: Machine policy value 'Debug' is 0
MSI (s) (20:68) [16:05:42:792]: ******* RunEngine:
******* Product: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
******* Action:
******* CommandLine: **********
MSI (s) (20:68) [16:05:42:792]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (20:68) [16:05:42:823]: File will have security applied from OpCode.
MSI (s) (20:68) [16:05:42:901]: SOFTWARE RESTRICTION POLICY: Verifying package --> 'C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi' against software restriction policy
MSI (s) (20:68) [16:05:42:901]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi has a digital signature
MSI (s) (20:68) [16:05:43:151]: SOFTWARE RESTRICTION POLICY: C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi is permitted to run at the 'unrestricted' authorization level.
MSI (s) (20:68) [16:05:43:151]: End dialog not enabled
MSI (s) (20:68) [16:05:43:151]: Original package ==> C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
MSI (s) (20:68) [16:05:43:151]: Package we're running from ==> C:WINDOWSInstaller1348fe1.msi
MSI (s) (20:68) [16:05:43:151]: APPCOMPAT: looking for appcompat database entry with ProductCode '{53F5C3EE-05ED-4830-994B-50B2F0D50FCE}'.
MSI (s) (20:68) [16:05:43:151]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (20:68) [16:05:43:167]: MSCOREE not loaded loading copy from system32
MSI (s) (20:68) [16:05:43:182]: Opening existing patch 'C:WINDOWSInstaller1553df86.msp'.
MSI (s) (20:68) [16:05:43:182]: Note: 1: 2203 2: C:WINDOWSInstaller1553df86.msp 3: -2147287038
MSI (s) (20:68) [16:05:43:182]: Couldn't find local patch 'C:WINDOWSInstaller1553df86.msp'. Looking for it at its source.
MSI (s) (20:68) [16:05:43:182]: Resolving Patch source.
MSI (s) (20:68) [16:05:43:182]: User policy value 'SearchOrder' is 'nmu'
MSI (s) (20:68) [16:05:43:182]: User policy value 'DisableMedia' is 0
MSI (s) (20:68) [16:05:43:182]: Machine policy value 'AllowLockdownMedia' is 0
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Media enabled only if package is safe.
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Looking for sourcelist for product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Adding {EE92F683-5F5C-4970-BB0B-9AC591B60268}; to potential sourcelist list (pcode;disk;relpath).
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Now checking product {EE92F683-5F5C-4970-BB0B-9AC591B60268}
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Media is enabled for product.
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Attempting to use LastUsedSource from source list.
MSI (s) (20:68) [16:05:43:182]: SOURCEMGMT: Trying source \TESTf$cff417a74df5a718124f2a95bdecdc32HotFixSqlSupportFiles.
MSI (s) (20:68) [16:05:43:213]: Note: 1: 2203 2: \TESTf$cff417a74df5a718124f2a95bdecdc32HotFixSqlSupportFilesSqlSupport.msp 3: -2147287037
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (20:68) [16:05:43:213]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msp
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Processing net source list.
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Trying source \TESTf$a81c0730a34f964148HotFixSqlSupportFiles.
MSI (s) (20:68) [16:05:43:213]: Note: 1: 2203 2: \TESTf$a81c0730a34f964148HotFixSqlSupportFilesSqlSupport.msp 3: -2147287037
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Source is invalid due to missing/inaccessible package.
MSI (s) (20:68) [16:05:43:213]: Note: 1: 1706 2: -2147483647 3: SqlSupport.msp
MSI (s) (20:68) [16:05:43:213]: SOURCEMGMT: Processing media source list.
MSI (s) (20:68) [16:05:44:245]: SOURCEMGMT: Resolved source to: 'SqlSupport.msp'
MSI (s) (20:68) [16:06:14:619]: Note: 1: 1314 2: SqlSupport.msp
MSI (s) (20:68) [16:06:14:619]: Unable to create a temp copy of patch 'SqlSupport.msp'.
MSI (s) (20:68) [16:06:14:619]: Note: 1: 1708
MSI (s) (20:68) [16:06:14:619]: Note: 1: 2729
MSI (s) (20:68) [16:06:14:619]: Note: 1: 2729
MSI (s) (20:68) [16:06:14:619]: Product: Microsoft SQL Server Setup Support Files (English) -- Installation failed.

MSI (s) (20:68) [16:06:14:619]: MainEngineThread is returning 1635
This patch package could not be opened. Verify that the patch package exists and that you can access it, or contact the application vendor to verify that this is a valid Windows Installer patch package.
C:Program FilesMicrosoft SQL Server90Setup BootstrapCacheSQLSupportx861033SqlSupport.msi
MSI (c) (74:68) [16:06:14:729]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (74:68) [16:06:14:729]: MainEngineThread is returning 1635
=== Verbose logging stopped: 2/20/2007 16:06:14 ===

+++++++++++++++++++++++

View 168 Replies View Related

Unexpected Error While Removing Backup Files In Sql 2005 Setup

Dec 18, 2007


I was trying an edition upgrade from SQL 2005 standard x64 to SQL 2005 enterprise x64 using the "setup SKUUPGRADE=1" from the command line. The SO is W2003 server R2 enterprise and I have a SQL clustered environment with 2 nodes (active/passive).

I select to upgrade the SQL module and I mark the checkbox for the cluster installation. The installation seems to work properly untill setup is doing the task "removing backup files". Then 2 "unexpected error" message appears as follows. The 2 above windows appear when you click on the help icon.





Link to screen capture

The following is the end of the SQL setup log file:

________________________________________________________________________

Property(S): OutOfDiskSpace = 0
Property(S): OutOfNoRbDiskSpace = 0
Property(S): PrimaryVolumeSpaceAvailable = 0
Property(S): PrimaryVolumeSpaceRequired = 0
Property(S): PrimaryVolumeSpaceRemaining = 0
Property(S): RSVirtualDirectoryManager = Reports
Property(S): RSVirtualDirectoryServer = ReportServer
Property(S): SqlActionManaged = 3
Property(S): SqlStateManaged = 2
Property(S): Sql_sqlSqlUpgradeSequence = 387709900
Property(S): SOURCEDIR = I:Setup
Property(S): SourcedirProduct = {79F1B65E-8FC0-4D03-954D-F9E71C85AEC7}
Property(S): HotfixScript = 1
Property(S): DebugClsid.B2156BC9_6CE8_422F_A957_E99A65256B1D = {A42D1020-AA4C-401D-B7BD-26C333C0D627}
Property(S): SQLBROWSERACCOUNT = HEREISTHEDOMAINheretheclusteraccount
Property(S): ProductToBeRegistered = 1
MSI (s) (84:F8) [00:32:10:598]: Product: Microsoft SQL Server 2005 (64-bit) - Update 'Hotfix 3024 for SQL Server Database Services 2005 (64-bit) ENU (KB000000)' could not be installed. Error code 1603. Additional information is available in the log file C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0024_SV00010-2_SQL.log.
MSI (s) (84:F8) [00:32:10:613]: Note: 1: 1708
MSI (s) (84:F8) [00:32:10:613]: Product: Microsoft SQL Server 2005 (64-bit) -- Installation failed.
MSI (s) (84:F8) [00:32:10:613]: Attempting to delete file C:WINDOWSInstaller75d5c.msp
MSI (s) (84:F8) [00:32:10:613]: Unable to delete the file. LastError = 32
MSI (s) (84:F8) [00:32:10:645]: Cleaning up uninstalled install packages, if any exist
MSI (s) (84:F8) [00:32:10:645]: MainEngineThread is returning 1603
MSI (s) (84:CC) [00:32:10:754]: Destroying RemoteAPI object.
MSI (s) (84:74) [00:32:10:754]: Custom Action Manager thread ending.
=== Logging stopped: 18/12/2007 0:32:10 ===
MSI (c) (34:B4) [00:32:10:832]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied. Counter after decrement: -1
MSI (c) (34:B4) [00:32:10:832]: MainEngineThread is returning 1603
=== Verbose logging stopped: 18/12/2007 0:32:10 ===

_______________________________________________________________________

Does anyone have any clue or idea about the possible problem?

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved