Push Replication To Multihomed Client Fails
Sep 11, 2007
Hi
We're having problems with push replication to multihomed clients. if the DNS contains multiple IP's and one of those are not reachable from the sql server. the replication fails. no matter order of IP adresses. i wrote a DNS proxy which re-ordered the IP's so that the "working" IP would come first in the list but no success until i filtered out so that the DNS proxy only replied with one, the working, IP.
the replication is part of a commercial application which we have no control over. are there any settings on the server side that can help here? I really want to fix the source of the problem and not patch it with a proxy.
any ideas are welcome. the server is sql 2005 standard and the clients are running 2005 express
Rgds
View 1 Replies
ADVERTISEMENT
Jun 7, 2007
I have a Merge publication that has multiple subscribers. They are all SQL Express, so it's all Push Subscriptions.
When I try to add a subscriber by it's IP address, the snapshot gets delivered. Schema created, data loaded, but I see the following error in Replication Monitor:
The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147201001)
Cannot find the object 'MSmerge_ctsv_E0801EECCA824BB29D48D36D64D2BAEA', because it does not exist or you do not have permission. (Source: MSSQLServer, Error number: 15151)
When I change the IP address in the script to the name of the machine it works perfectly. The ONLY thing I changed in the script was the IP address to the name.
The reason for this is that I have several client machines that will have connectivity, but NO name resolution back at the Server.
Please, Please, Please help!
Sample follows:
Code Snippet
exec sp_addmergesubscription
@publication = N'TestPub',
@subscriber = N'10.126.22.30',
@subscriber_db = N'dbTest',
@subscription_type = N'Push',
@sync_type = N'Automatic',
@subscriber_type = N'Local',
@subscription_priority = 0,
@description = null,
@use_interactive_resolver = N'False'
exec sp_addmergepushsubscription_agent
@publication = N'TestPub',
@subscriber = N'10.126.22.30',
@subscriber_db = N'dbTest',
@job_login = null, @job_password = null,
@subscriber_security_mode = 0,
@subscriber_login = N'Valid SQL LOGIN',
@subscriber_password = N'ValidPassword',
@publisher_security_mode = 1,
@frequency_type = 64,
@frequency_interval = 0,
@frequency_relative_interval = 0,
@frequency_recurrence_factor = 0,
@frequency_subday = 0,
@frequency_subday_interval = 0,
@active_start_time_of_day = 0,
@active_end_time_of_day = 235959,
@active_start_date = 20070607,
@active_end_date = 99991231,
@enabled_for_syncmgr = N'False'
View 3 Replies
View Related
Apr 17, 2007
Hello
I have a SQL Server 2005 (build 9.0.3050) database with tables belonging to
different schemas. I am in the process of developing a Windows Mobile 5.0
application that will work against this database, and I€™m planning to use
Remote Data Access with SQL Server 2005 CE to synch data.
I have my RDA all set up and working correctly IIS-wise, and have no problem
pulling a table from my database. However, when I attempt to push a modified
table back to the database, I get an €˜Internal error: Failure setting up
bindings, possibly caused by insufficient permissions.€™ error (which equates
to error 28621: SSCE_M_BINDINGS), which according to
http://msdn2.microsoft.com/en-us/library/ms172898.aspx is an internal error
which €œcannot be resolved by common troubleshooting techniques€?. The
€˜insufficient permissions€™ is a red herring I think, since the problem
persists even if the SQL Server login that is being used for RDA is in the
sysadmin role.
I€™ve attempted to identify the problem by starting from scratch with a new
database and a new table with a couple of test columns. With the table
freshly created as dbo.TableName RDA works fine. However, when I create a
schema and transfer the table to the schema, RDA push fails as above, so to
me it looks like the schema is causing the problem.
Anyone any ideas about this? All help greatly appreciated!
Thanks - Graham
View 3 Replies
View Related
Mar 10, 2006
Hi,
I'm converting a replication script from SQL 2000 to SQL 2005.
I am getting an error with push merge with no way to figure out what is wrong.
I've configured replication on a single XP server in SQL 2005 RTM version.
I have a push merge set up between A and B and between B and C. All 3 databases are 9.0 compatibility.
The snapshot and merge jobs for the A to B run fine with no errors, and merge replicates ok.
The snapshot for B to C fails with this message:
Message
2006-03-09 17:30:35.94 ---------------------------------------------
2006-03-09 17:30:35.94 -BcpBatchSize 100000
2006-03-09 17:30:35.94 -HistoryVerboseLevel 2
2006-03-09 17:30:35.94 -LoginTimeout 15
2006-03-09 17:30:35.94 -QueryTimeout 1800
2006-03-09 17:30:35.94 ---------------------------------------------
2006-03-09 17:30:35.95 Connecting to Publisher 'MyInstance'
2006-03-09 17:30:35.97 Publisher database compatibility level is set to 90.
2006-03-09 17:30:35.97 Retrieving publication and article information from the publisher database 'MyInstance.MyDB'
2006-03-09 17:30:36.22 [0%] The replication agent had encountered an exception.
2006-03-09 17:30:36.22 Source: Replication
2006-03-09 17:30:36.22 Exception Type: Microsoft.SqlServer.Replication.ReplicationAgentSqlException
2006-03-09 17:30:36.22 Exception Message: Data is Null. This method or property cannot be called on Null values.
2006-03-09 17:30:36.22 Message Code: 52006
2006-03-09 17:30:36.22
Love that exception message: "Data is Null" - very helpful to someone who is clairvoyant perhaps.
I checked the snapshot bcp files. The tables being merged all have data.
A sample add article command is:
exec sp_addmergearticle @publication = N'MyMerge', @article = N'Phone', @processing_order = 4, @source_owner = N'dbo', @source_object = N'Phone', @type = N'table', @description = null, @column_tracking = N'true', @pre_creation_cmd = N'drop', @creation_script = null, @schema_option = 0x000000004C42CDDF, @article_resolver = null, @subset_filterclause = null, @vertical_partition = N'false', @destination_owner = N'dbo', @verify_resolver_signature = 0, @allow_interactive_resolver = N'false', @fast_multicol_updateproc = N'true', @check_permissions = 0, @identityrangemanagementoption = N'none' ,@force_invalidate_snapshot = 1,@force_reinit_subscription = 1
If you have any ideas on how to fix this, I'd be most grateful. As it is after 6pm I probably won't read this again until morning. Thanks for any suggestions.
View 19 Replies
View Related
May 29, 2007
What is better to use, Push or Pull Replication? What are the advantages and disadvantages?
View 1 Replies
View Related
Jul 26, 2004
I am using merge replication with a push subscription type. I am wondering if the updates of the tables on the subscriber side are push to the publisher from the subscriber or pulled from the subscriber by the publisher when the syncronisation takes place. this makes a big diferrence for me and i can't find the answer to this question anywhere...
if anyone could answer it would be really appreciated
Thanks
View 3 Replies
View Related
Sep 19, 2007
Hi all,
I was wondering if someone could suggest a solution to my problem:
I have an in-house production database. I wanted to use Merge replication (push) to mirror parts of this data to our Internet server on the web which has a Public IP.
Steps I followed
1. Created an entry in €œC:WINNTsystem32driversetchosts€? file with IP
address of the Subscriber and just the €œServername€? of the Subscriber on
publisher machine (local server)
2. Created an Alias to the Subscriber
3. Connected to the remote server thru Mgt Studio
4. Created Merge Replication on the Local Database
5. Created Subscription to the remote server.
6. Started the Replication Agent
I receive following msg "The process could not connect to Subscriber 'ISVR'.
When I check the View Synchronization Status in Mgt studio it shows "The server 'ISVR' is not a Subscriber"
I presume that if we have a Public IP at our end, then the Merge Replication will be thru.
Is it possible to replicate without having a Public IP?
Any suggestions,
Thanks.
View 2 Replies
View Related
Jan 7, 2008
Hi all,
I've been looking for the right stored procedure to create a push subscription for publication but i haven't had much luck so far. So I was wondering if you guys know which SP is appropriate, that'd be super great!! thanks guys!
note. the sp should run on the subscriber database.
thanks again
View 2 Replies
View Related
Jun 21, 2007
Hi There,
I wonder if anyone has run into this problem before.
I have inherited a SQL Server 2000 box with what appears to be a push subscription set up on it. However, the original Subscription database has long since been removed, leaving that box with what is essentially an orphaned push subscription.
We are trying to remove the subscription, but do not understand how. All documentation I have found keeps insisting that this be done at the subscriber database (which is for all effective purposes, destroyed).
How do I get rid of it?
Any ideas would be dearly appreciated.
Thanks.
View 2 Replies
View Related
Jan 24, 2007
I am using SQL 2000. How can I get my transactional replication reinitialized after it has failed with several attempts.
I know one way of doing it through enterprise manager and specifying the subscription to reinitialize. But this will apply the snapshot and will take long time.
Is there a fast way of doing it?
-Nipul
View 1 Replies
View Related
Mar 8, 2007
Hiya,
Our current application which uses SQL 2000/CE uses a single Merge publication to populate numerous "read only" tables on the mobile device, and create the schema for a "transactions" table, which will be filled by the mobile device during work, then merged at sync.
Now, the master "transactions" table at the publisher has millions of rows, and the mobile device does not need any of them... so currently we have it "filtering" by a always false clause, so that none of the data is pushed to the client.
The problem with this is that we cannot archive any of the records in the transaction table, as doing so (say, removing 200k rows) would result in the mobile devices (of which there are about 15,000 active in the field) to attempt to reconcile each of those 200k rows when it is next synced, which takes way too long.
Now, what we would like to do is upgrade to SQL 2005/CE 2005, if the new features will allow us a PULL ONLY table in some way? I cannot find how to do this via the wizard, but am sure I am missing something. At least I hope so.
Can anyone give a suggestion?
Thanks!
Dave Borneman
View 2 Replies
View Related
Apr 28, 2015
SELECT
P.Publication
,P.Publication_type
,S.Subscriber_ID
,S.Update_Mode
FROM MSPublications P
INNER JOIN MSSubscriptions S
ON P.Publication_ID = S.Publication_ID
give me publication_type=0. So it is transactional replication but how do we know that is pull or push?
View 2 Replies
View Related
Mar 27, 2006
ERROR MESSAGE:
"Message: Incorrect syntax near 'NoteID'."
Here is a snipet from the output file:
2006-03-27 13:01:49.820 Skipping file 'NotesHistory_21.sch' because it has already been delivered for a previous article or by a previously interrupted snapshot.
2006-03-27 13:01:49.867 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET ANSI_NULLS ON
2006-03-27 13:01:49.898 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2006-03-27 13:01:49.945 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET QUOTED_IDENTIFIER ON
2006-03-27 13:01:50.008 [17%] OLE DB Subscriber 'LUZERNV4-PDOSQL4': CREATE TABLE [dbo].[MSmerge_conflict_EFILE_MERGE_NotesHistory](
[NoteID] [int] NOT NULL,
[CaseRefNum] [int] NOT NULL,
[KeyField] [varchar](500) NOT NULL,
[KeyValue] [varchar](500) NOT NULL,
[Note] [varchar](800) NULL,
[NoteField] [varchar](100) NULL,
[ScanDocID] [int] NULL,
[PDF_ID] [int] NULL,
[RescanCode] [int] NULL,
[RescanNote] [varchar](100) NULL,
[AuditID] [bigint] NOT NULL,
[rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL
)
ꜽśã¹? êœ?Å›B 27 13:01î–”Å›è›ªç —êœ?Å›é”?Ä€Percent Complete: 17
2006-03-27 13:01:50.086 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET ANSI_NULLS ON
2006-03-27 13:01:50.117 Preparing table 'NotesHistory' for merge replication
2006-03-27 13:01:50.164 OLE DB Subscriber 'LUZERNV4-PDOSQL4': SET QUOTED_IDENTIFIER ON
2006-03-27 13:01:50.195 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2006-03-27 13:01:50.258 OLE DB Subscriber 'LUZERNV4-PDOSQL4': if object_id('MSmerge_conflicts_info') is not NULL
alter table [MSmerge_conflict_EFILE_MERGE_NotesHistory] add origin_datasource_id uniqueidentifier NULL
2006-03-27 13:01:50.351 OLE DB Subscriber 'LUZERNV4-PDOSQL4': if object_id('MSmerge_conflicts_info') is not NULL
create nonclustered index [ncMSmerge_conflict_EFILE_MERGE_NotesHistory] on [MSmerge_conflict_EFILE_MERGE_NotesHistory] ([rowguid], origin_datasource_id)
2006-03-27 13:01:50.383 OLE DB Subscriber 'LUZERNV4-PDOSQL4': exec sp_MSsetconflicttable @article = N'NotesHistory', @conflict_table = N'MSmerge_conflict_EFILE_MERGE_NotesHistory'
2006-03-27 13:01:50.430 OLE DB Subscriber 'LUZERNV4-PDOSQL4': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2006-03-27 13:01:50.476 [17%] The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.Percent Complete: 17
2006-03-27 13:01:50.50é”?Ä€
2006-03-27 13:01:50.539 Applied script 'NotesHistory_21.cft'
2006-03-27 13:01:50.586 OLE DB Subscriber 'LUZERNV4-PDOSQL4': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2006-03-27 13:01:50.617 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2006-03-27 13:01:50.711 Percent Complete: 17
2006-03-27 13:01:50.742 {call sp_MSsetconflicttable (N'NotesHistory', N'MSmerge_conflict_EFILE_MERGE_NotesHistory', N'LARGOS00-SDI', N'EFILE', N'EFILE_MERGE')}
2006-03-27 13:01:50.773 OLE DB Distributor 'LARGOS00-SDI': {call sys.sp_MSadd_merge_history90 (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)}
2006-03-27 13:01:50.867 Percent Complete: 0
2006-03-27 13:01:50.898 Category:COMMAND
Source: Failed Command
Number: 0
Message: {call sp_MSsetconflicttable (N'NotesHistory', N'MSmerge_conflict_EFILE_MERGE_NotesHistory', N'LARGOS00-SDI', N'EFILE', N'EFILE_MERGE')}
2006-03-27 13:01:50.961 Percent Complete: 0
2006-03-27 13:01:50.992 Category:SQLSERVER
Source: LUZERNV4-PDOSQL4
Number: 102
Message: Incorrect syntax near 'NoteID'.
2006-03-27 13:01:51.039 Percent Complete: 0
2006-03-27 13:01:51.070 Category:NULL
Source: Merge Replication Provider
Number: -2147201001
Message: The merge process was unable to deliver the snapshot to the Subscriber. If using Web synchronization, the merge process may have been unable to create or write to the message file. When troubleshooting, restart the synchronization with verbose history logging and specify an output file to which to write.
2006-03-27 13:01:51.133 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4'
2006-03-27 13:01:51.180 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4'
2006-03-27 13:01:51.226 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4'
2006-03-27 13:01:51.258 Disconnecting from OLE DB Subscriber 'LUZERNV4-PDOSQL4'
2006-03-27 13:01:51.305 Disconnecting from OLE DB Publisher 'LARGOS00-SDI'
2006-03-27 13:01:51.336 Disconnecting from OLE DB Publisher 'LARGOS00-SDI'
2006-03-27 13:01:51.383 Disconnecting from OLE DB Publisher 'LARGOS00-SDI'
2006-03-27 13:01:51.414 Disconnecting from OLE DB Publisher 'LARGOS00-SDI'
2006-03-27 13:01:51.445 Disconnecting from OLE DB Distributor 'LARGOS00-SDI'
2006-03-27 13:01:51.492 Disconnecting from OLE DB Distributor 'LARGOS00-SDI'
2006-03-27 13:01:51.523 The merge process will restart after waiting 60 second(s)...
View 1 Replies
View Related
Mar 15, 2006
We need to configure a way to publish from development to testing and from testing to production. An easy, automated process would be best.
View 1 Replies
View Related
Feb 4, 2008
I cannot connect to my SQL2005 server using the old SQL ODBC drivers, I have to use the Native client drivers. The database I am trying to connect to is a SQL 2000 db I just attached. Its owner is a SQL user login, which works fine and can connect remotely.
Thoughts?
Possibly related: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=96732
View 1 Replies
View Related
Feb 2, 2007
Hi all... assisting with mass deployment of SQL 2005 Client Tools.
Multiple users are able to pass the System Configuration Check, and click Next. It is on the next screen they see the following:
Microsoft SQL Server 2005 Setup [_][X]
-------------------------------------------------------------------
Microsoft SQL Server Installation
Setup is preparing to continue with the installation.
-------------------------------------------------------------------
Please wait while setup prepares to continue with the installation.
Status: Extracting custom action file from stream
________________________________________________
[________________________________________________]
[Help] [< Back] [Next >] [Cancel]
After eight minutes, the install bombs, and sends an error report to Microsoft.
I saw a similar post here, but these are XP machines and Administrators appear to have the proper permissions. I also do not get the error message "Error writing to file".
Here is a section of the _WI log file generated by the install..
MSI (c) (48:A4) [09:20:49:208]: PROPERTY CHANGE: Adding ENABLERANU property. Its value is '1'.
Action ended 9:20:49: SetEnableRanuUI. Return value 1.
MSI (c) (48:A4) [09:20:49:208]: Skipping action: UnsetEnableRanuUI (condition is false)
MSI (c) (48:A4) [09:20:49:208]: Skipping action: SetSharedVolumePath (condition is false)
MSI (c) (48:A4) [09:20:49:208]: Skipping action: UnsetINSTALLSQLDATADIR (condition is false)
MSI (c) (48:A4) [09:20:49:208]: Doing action: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Extracting custom action file from stream
Action start 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (48:44) [09:20:49:223]: Invoking remote custom action. DLL: C:DOCUME~1axn4835aLOCALS~1TempMSI117.tmp, Entrypoint: StreamSupportFiles
MSI (c) (48:70) [09:20:49:223]: Cloaking enabled.
MSI (c) (48:70) [09:20:49:223]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (48:70) [09:20:49:223]: Connected to service for CA interface.
Action ended 9:20:49: StreamSupportFiles.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 3.
MSI (c) (48:A4) [09:20:49:301]: Skipping action: FatalError (condition is false)
Action ended 9:20:49: INSTALL. Return value 3.
MSI (c) (48:44) [09:28:50:859]: Destroying RemoteAPI object.
MSI (c) (48:70) [09:28:50:859]: Custom Action Manager thread ending.
And here is a section of the _Core(Local).log
Running: ReportChainingResults at: 2007/0/29 9:28:57
Error: Action "ReportChainingResults" threw an exception during execution.
DwLaunchMsiExec() returned : 1603
Error Code: 0x80070643 (1603)
Windows Error Text: Fatal error during installation.
Source File Name: sqlchainingsqlchainingactions.cpp
Compiler Timestamp: Thu Sep 1 22:23:05 2005
Function Name: sqls::ReportChainingResults::perform
Source Line Number: 2992
A section of _Core.log:
Running: LaunchLocalBootstrapAction at: 2007/0/29 9:19:37
Error: Action "LaunchLocalBootstrapAction" threw an exception during execution. Error information reported during run:
"C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe" finished and returned: 1603
Aborting queue processing as nested installer has completed
When the install fails, this is the event signature:
EventType: sql90setup
P1: unknown
P2: 0x643
P3: unknown
P4: 0x643
P5: unknown
P6: unknown
P7: sqlrun.msi@9.00.1399.06
View 5 Replies
View Related
Jul 20, 2005
I have created a DTS package that pulls data in from Oracle into SQLServer. When I run it directly on the server (from EnterpriseManager), it works fine. When I run it from Enterprise Manager on aclient machine that does not have the Oracle client software, it doesnot run, giving me the error: "The Oracle client and networkingcomponents were not found...". I was hoping I wouldn't need to havethe client software installed on a machine other than the server whereSql Server is running. The problem here is that there are a number ofmachines from where I would like to execute this DTS package that I donot want to install/configure the Oracle client software. I don'tquite understand why the configuration of the client is importanthere. In my mind, when I am using enterprise manager from a clientmachine, I am using it sort of like a terminal services client toconnect to the server. I guess there is a lot more happening in thebackground.Thanks for any feedback,Marcus
View 2 Replies
View Related
Jun 11, 2007
Hello all,
I'm trying to install "SQL Server 2005 Express Edition SP2" on a newly installed XP Pro SP2 machine. I downloaded "SQLEXPR32.EXE" (38,220,656 bytes) from the Microsoft site.
At the beginning of the setup the installation program scans my system -- no problems or warnings. Everything looks fine and ready to go.
During installation I uncheck, "Hide advanced configuration options" simply because I want to change the default instance name. Aside from changing the default instance name I make no other changes to the default installation configuration.
The installation begins but when it tries to comes to the "SQL Native Client" portion of the installation I get the following error dialog message:
"An installation package for the product Microsoft SQL Server Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'."
Below I've included the setup log file of the SQL Native Client portion of the setup. I've looked through the log file but didn't see anything obviously wrong until the error occurs toward the end.
Does anyone have an idea of what might be causing this to happen? I've install SSE many times in the past with no problems.
Thanks
Code Snippet
=== Verbose logging started: 6/10/2007 23:03:13 Build type: SHIP UNICODE 3.01.4000.4039 Calling process: C:Program FilesMicrosoft SQL Server90Setup Bootstrapsetup.exe ===
MSI (c) (C0:8C) [23:03:13:093]: Resetting cached policy values
MSI (c) (C0:8C) [23:03:13:093]: Machine policy value 'Debug' is 0
MSI (c) (C0:8C) [23:03:13:093]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (c) (C0:8C) [23:03:13:093]: Client-side and UI is none or basic: Running entire install on the server.
MSI (c) (C0:8C) [23:03:13:093]: Grabbed execution mutex.
MSI (c) (C0:8C) [23:03:13:093]: Cloaking enabled.
MSI (c) (C0:8C) [23:03:13:093]: Attempting to enable all disabled priveleges before calling Install on Server
MSI (c) (C0:8C) [23:03:13:093]: Incrementing counter to disable shutdown. Counter after increment: 0
MSI (s) (D0:94) [23:03:13:109]: Grabbed execution mutex.
MSI (s) (D0:B4) [23:03:13:109]: Resetting cached policy values
MSI (s) (D0:B4) [23:03:13:109]: Machine policy value 'Debug' is 0
MSI (s) (D0:B4) [23:03:13:109]: ******* RunEngine:
******* Product: {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
******* Action:
******* CommandLine: **********
MSI (s) (D0:B4) [23:03:13:109]: Machine policy value 'DisableUserInstalls' is 0
MSI (s) (D0:B4) [23:03:13:109]: End dialog not enabled
MSI (s) (D0:B4) [23:03:13:109]: Original package ==> C:WINDOWSInstaller1d32b7a.msi
MSI (s) (D0:B4) [23:03:13:109]: Package we're running from ==> C:WINDOWSInstaller1d32b7a.msi
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'.
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (D0:B4) [23:03:13:125]: MSCOREE already loaded, using loaded copy
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisablePatch' is 0
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'AllowLockdownPatch' is 0
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisableLUAPatching' is 0
MSI (s) (D0:B4) [23:03:13:125]: Machine policy value 'DisableFlyWeightPatching' is 0
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: looking for appcompat database entry with ProductCode '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'.
MSI (s) (D0:B4) [23:03:13:125]: APPCOMPAT: no matching ProductCode found in database.
MSI (s) (D0:B4) [23:03:13:125]: Transforms are not secure.
MSI (s) (D0:B4) [23:03:13:125]: Command Line: STPSETUPTHREADID=2000 STPSETUPPROCESSID=1472 EXTERNALCONTROL=1 ADDLOCAL=ALL SKIPPENDINGREBOOTCHECK=1 APPGUID={2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F} REBOOT=ReallySuppress CURRENTDIRECTORY=C:Program FilesMicrosoft SQL Server90Setup Bootstrap CLIENTUILEVEL=3 CLIENTPROCESSID=1472
MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding PackageCode property. Its value is '{8225F098-4183-422F-B208-3018904DFA0C}'.
MSI (s) (D0:B4) [23:03:13:125]: Product Code passed to Engine.Initialize: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'
MSI (s) (D0:B4) [23:03:13:125]: Product Code from property table before transforms: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'
MSI (s) (D0:B4) [23:03:13:125]: Product Code from property table after transforms: '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}'
MSI (s) (D0:B4) [23:03:13:125]: Product registered: entering maintenance mode
MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding ProductState property. Its value is '5'.
MSI (s) (D0:B4) [23:03:13:125]: PROPERTY CHANGE: Adding ProductToBeRegistered property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:125]: Package name retrieved from configuration data: 'sqlncli.msi'
MSI (s) (D0:B4) [23:03:13:125]: Determined that existing product (either this product or the product being upgraded with a patch) is installed per-machine.
MSI (s) (D0:B4) [23:03:13:140]: Note: 1: 2262 2: AdminProperties 3: -2147287038
MSI (s) (D0:B4) [23:03:13:140]: Machine policy value 'DisableMsi' is 0
MSI (s) (D0:B4) [23:03:13:140]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:140]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:140]: Product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} is admin assigned: LocalSystem owns the publish key.
MSI (s) (D0:B4) [23:03:13:140]: Product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D} is managed.
MSI (s) (D0:B4) [23:03:13:140]: Running product '{F9B3DD02-B0B3-42E9-8650-030DFF0D133D}' with elevated privileges: Product is assigned.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding STPSETUPTHREADID property. Its value is '2000'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding STPSETUPPROCESSID property. Its value is '1472'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding EXTERNALCONTROL property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding ADDLOCAL property. Its value is 'ALL'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding SKIPPENDINGREBOOTCHECK property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding APPGUID property. Its value is '{2AFFFDD7-ED85-4A90-8C52-5DA9EBDC9B8F}'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding REBOOT property. Its value is 'ReallySuppress'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CURRENTDIRECTORY property. Its value is 'C:Program FilesMicrosoft SQL Server90Setup Bootstrap'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CLIENTUILEVEL property. Its value is '3'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding CLIENTPROCESSID property. Its value is '1472'.
MSI (s) (D0:B4) [23:03:13:140]: TRANSFORMS property is now:
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding PRODUCTLANGUAGE property. Its value is '1033'.
MSI (s) (D0:B4) [23:03:13:140]: PROPERTY CHANGE: Adding VersionDatabase property. Its value is '301'.
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoApplication Data
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoFavorites
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoNetHood
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoMy Documents
MSI (s) (D0:B4) [23:03:13:140]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoPrintHood
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoRecent
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoSendTo
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoTemplates
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersApplication Data
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoLocal SettingsApplication Data
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoMy DocumentsMy Pictures
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsAdministrative Tools
MSI (s) (D0:B4) [23:03:13:156]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuProgramsStartup
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart MenuPrograms
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersStart Menu
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersDesktop
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuProgramsAdministrative Tools
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuProgramsStartup
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart MenuPrograms
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoStart Menu
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and Settings lapasoDesktop
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:Documents and SettingsAll UsersTemplates
MSI (s) (D0:B4) [23:03:13:171]: SHELL32::SHGetFolderPath returned: C:WINDOWSFonts
MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 2898 2: MS Sans Serif 3: MS Sans Serif 4: 0 5: 16
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Privileged property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding USERNAME property. Its value is 'Tony'.
MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 1402 2: HKEY_CURRENT_USERSoftwareMicrosoftMS Setup (ACME)User Info 3: 2
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Installed property. Its value is '00:00:00'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding DATABASE property. Its value is 'C:WINDOWSInstaller1d32b7a.msi'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding OriginalDatabase property. Its value is 'C:WINDOWSInstaller1d32b7a.msi'.
MSI (s) (D0:B4) [23:03:13:187]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:13:187]: Machine policy value 'DisableRollback' is 0
MSI (s) (D0:B4) [23:03:13:187]: User policy value 'DisableRollback' is 0
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding UILevel property. Its value is '2'.
=== Logging started: 6/10/2007 23:03:13 ===
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding Preselected property. Its value is '1'.
MSI (s) (D0:B4) [23:03:13:187]: PROPERTY CHANGE: Adding ACTION property. Its value is 'INSTALL'.
MSI (s) (D0:B4) [23:03:13:187]: Doing action: INSTALL
MSI (s) (D0:B4) [23:03:13:187]: Running ExecuteSequence
MSI (s) (D0:B4) [23:03:13:187]: Doing action: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action start 23:03:13: INSTALL.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 23:03:13: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
Action ended 23:03:13: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 23:03:13: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 23:03:13: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWS'.
Action start 23:03:13: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
Action ended 23:03:13: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: PROPERTY CHANGE: Adding SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSsystem32'.
Action start 23:03:13: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: LaunchConditions
Action ended 23:03:13: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E. Return value 1.
Action start 23:03:13: LaunchConditions.
MSI (s) (D0:B4) [23:03:13:203]: Doing action: FindRelatedProducts
Action ended 23:03:13: LaunchConditions. Return value 1.
MSI (s) (D0:B4) [23:03:13:203]: Skipping FindRelatedProducts action: not run in maintenance mode
Action start 23:03:13: FindRelatedProducts.
MSI (s) (D0:B4) [23:03:13:203]: Skipping action: CA_SetRefCountUpgradeFlag (condition is false)
MSI (s) (D0:B4) [23:03:13:203]: Skipping action: CA_SetRefCountNewerFoundFlag (condition is false)
MSI (s) (D0:B4) [23:03:13:203]: Doing action: IsPendingRebootKey
Action ended 23:03:13: FindRelatedProducts. Return value 0.
MSI (s) (D0:44) [23:03:13:218]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIA9.tmp, Entrypoint: IsPendingReboot
MSI (s) (D0:3C) [23:03:13:218]: Generating random cookie.
MSI (s) (D0:3C) [23:03:13:234]: Created Custom Action Server with PID 2372 (0x944).
MSI (s) (D0:70) [23:03:13:312]: Running as a service.
MSI (s) (D0:70) [23:03:13:328]: Hello, I'm your 32bit Impersonated custom action server.
Action start 23:03:13: IsPendingRebootKey.
No PendingFileRenameOperations
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: CA_ErrorDifferentLang (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOW (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWAppendCustomPath (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: SetWOWINSTALLSQLSHAREDDIR_CUSTOMPATH_ADD (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_ValidateAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RefCountAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_BackupAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RegisterAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Skipping action: Sqlmsirc_RestoreAppGuid_NewerFound.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:343]: Doing action: AppSearch
Action ended 23:03:13: IsPendingRebootKey. Return value 1.
Action start 23:03:13: AppSearch.
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Signature 3: -2147287038
MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding REDISTINSTALLEDVERSION property. Its value is '9.00.3042.00'.
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: SkipInstallCA (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: CA_ErrorPendingReboot (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: CCPSearch (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: RMCCPSearch (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Doing action: ValidateProductID
Action ended 23:03:13: AppSearch. Return value 1.
Action start 23:03:13: ValidateProductID.
MSI (s) (D0:B4) [23:03:13:359]: Skipping action: Sqlmsirc_CheckLanguage.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:359]: Doing action: CostInitialize
Action ended 23:03:13: ValidateProductID. Return value 1.
MSI (s) (D0:B4) [23:03:13:359]: Machine policy value 'MaxPatchCacheSize' is 10
Action start 23:03:13: CostInitialize.
MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding ROOTDRIVE property. Its value is 'D:'.
MSI (s) (D0:B4) [23:03:13:359]: PROPERTY CHANGE: Adding CostingComplete property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: MsiPatchHeaders
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: __MsiPatchFileList
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2228 2: 3: PatchPackage 4: SELECT `DiskId`, `PatchId`, `LastSequence` FROM `Media`, `PatchPackage` WHERE `Media`.`DiskId`=`PatchPackage`.`Media_` ORDER BY `DiskId`
MSI (s) (D0:B4) [23:03:13:359]: Doing action: FileCost
Action ended 23:03:13: CostInitialize. Return value 1.
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (D0:B4) [23:03:13:359]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 23:03:13: FileCost.
MSI (s) (D0:B4) [23:03:13:359]: Doing action: IsolateComponents
Action ended 23:03:13: FileCost. Return value 1.
Action start 23:03:13: IsolateComponents.
MSI (s) (D0:B4) [23:03:13:375]: Doing action: CostFinalize
Action ended 23:03:13: IsolateComponents. Return value 0.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding OutOfDiskSpace property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding OutOfNoRbDiskSpace property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceAvailable property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRequired property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding PrimaryVolumeSpaceRemaining property. Its value is '0'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its value is 'C:Program FilesMicrosoft SQL Server90EULA'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying SystemFolder property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'C:WINDOWSsystem32'.
MSI (s) (D0:B4) [23:03:13:375]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:13:375]: Note: 1: 2262 2: Condition 3: -2147287038
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding TARGETDIR property. Its value is 'D:'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying SystemFolder property. Its current value is 'C:WINDOWSsystem32'. Its new value: 'C:WINDOWSsystem32'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSINSTALLDIR property. Its value is 'C:Program FilesMicrosoft Visual Studio 8'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSINSTALLROOT property. Its value is 'C:Program FilesMicrosoft Visual Studio 8'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlShared property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding Ver.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDK.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDK'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDKLib.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKLib'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlSDKLibPlatformTarget.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKLibx86'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlInclude.06870705_8636_410E_B591_FEE8962A550E property. Its value is 'C:Program FilesMicrosoft SQL Server90SDKInclude'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding Ver90.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its value is 'C:Program FilesMicrosoft SQL Server90'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Modifying EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D property. Its current value is 'C:Program FilesMicrosoft SQL Server90EULA'. Its new value: 'C:Program FilesMicrosoft SQL Server90EULA'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding INSTALLSQLSHAREDDIR property. Its value is 'C:Program FilesMicrosoft SQL Server'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlVer property. Its value is 'C:Program FilesMicrosoft SQL Server90'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlTools property. Its value is 'C:Program FilesMicrosoft SQL Server90Tools'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding SqlToolsBin property. Its value is 'C:Program FilesMicrosoft SQL Server90ToolsBinn'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxs'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsManifests'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPolicies'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxs'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPolicies'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsManifests'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E property. Its value is 'C:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad'.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding VSRetarget property. Its value is 'C:Program FilesMicrosoft SQL Server90ToolsBinn'.
MSI (s) (D0:B4) [23:03:13:375]: Target path resolution complete. Dumping Directory table...
MSI (s) (D0:B4) [23:03:13:375]: Note: target paths subject to change (via custom actions or browsing)
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: TARGETDIR , Object: D:
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder , Object: C:WINDOWS
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder , Object: C:WINDOWSsystem32
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: ProgramFilesFolder , Object: C:Program Files
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSINSTALLDIR , Object: C:Program FilesMicrosoft Visual Studio 8
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSINSTALLROOT , Object: C:Program FilesMicrosoft Visual Studio 8
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlShared , Object: C:Program FilesMicrosoft SQL Server
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: Ver.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDK.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDK
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDKLib.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKLib
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlSDKLibPlatformTarget.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKLibx86
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlInclude.06870705_8636_410E_B591_FEE8962A550E , Object: C:Program FilesMicrosoft SQL Server90SDKInclude
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: Ver90.84118FFB_F307_45F3_B5BC_3A4F8261108D , Object: C:Program FilesMicrosoft SQL Server90
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: EULA.84118FFB_F307_45F3_B5BC_3A4F8261108D , Object: C:Program FilesMicrosoft SQL Server90EULA
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: INSTALLSQLSHAREDDIR , Object: C:Program FilesMicrosoft SQL Server
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlVer , Object: C:Program FilesMicrosoft SQL Server90
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlTools , Object: C:Program FilesMicrosoft SQL Server90Tools
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SqlToolsBin , Object: C:Program FilesMicrosoft SQL Server90ToolsBinn
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWS
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSsystem32
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsDirectory.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxs
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_51e427d4
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsManifests.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsManifests
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsPolicies.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPolicies
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPoliciesx86_policy.8.0.Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_77c24773
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload_ul.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_policy.8.0.microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_5c4003bc63e949f6
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WindowsFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWS
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: SystemFolder.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSsystem32
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsDirectory.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxs
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsPolicies.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPolicies
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: policydir.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsPoliciesx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_x-ww_4428b63a
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: WinSxsManifests.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsManifests
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_Microsoft.VC80.CRT_1fc8b3b9a1e18e3b_8.0.50727.42_x-ww_0de06acd
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: payload_ul.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E , Object: C:WINDOWSwinsxsx86_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.42_none_db5f52fb98cb24ad
MSI (s) (D0:B4) [23:03:13:375]: Dir (target): Key: VSRetarget , Object: C:Program FilesMicrosoft SQL Server90ToolsBinn
Action start 23:03:13: CostFinalize.
MSI (s) (D0:B4) [23:03:13:375]: Doing action: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD
Action ended 23:03:13: CostFinalize. Return value 1.
MSI (s) (D0:B4) [23:03:13:375]: PROPERTY CHANGE: Adding ARPINSTALLLOCATION property. Its value is 'C:WINDOWSsystem32'.
Action start 23:03:13: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD.
MSI (s) (D0:B4) [23:03:13:375]: Doing action: IsDotNet20Installed
Action ended 23:03:13: ARPInstallLocation.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD. Return value 1.
MSI (s) (D0:50) [23:03:13:390]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAA.tmp, Entrypoint: IsDotNetFramework20Installed
Action start 23:03:13: IsDotNet20Installed.
Feature SQL_SNAC_CORE install action does not match 2.
Not all features are being removed.
MSI (s) (D0!90) [23:03:13:421]: PROPERTY CHANGE: Deleting EnableDotNetCheck property. Its current value is '0'.
MSI (s) (D0!90) [23:03:13:421]: PROPERTY CHANGE: Adding DOTNETCOREPATH property. Its value is '1'.
Either there are no .NET Framework assemblies present in MsiAssembly table or they do not require the GAC, no need to check for the .NET Framework
MSI (s) (D0:B4) [23:03:13:421]: Skipping action: CA_ErrorPrereqDotNet (condition is false)
MSI (s) (D0:B4) [23:03:13:421]: Skipping action: CA_SetARPINSTALLLOCATION (condition is false)
MSI (s) (D0:B4) [23:03:13:421]: Doing action: SetODBCFolders
Action ended 23:03:13: IsDotNet20Installed. Return value 1.
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ODBCDriver
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2228 2: 3: ODBCDriver 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCDriver`, `Component` WHERE `ODBCDriver`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ODBCTranslator
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2228 2: 3: ODBCTranslator 4: SELECT `ComponentId`,`Description`,`Directory_`, `ActionRequest`, `Installed`, `Attributes` FROM `ODBCTranslator`, `Component` WHERE `ODBCTranslator`.`Component_` = `Component` AND (`ActionRequest` = 1 OR `ActionRequest` = 2)
Action start 23:03:13: SetODBCFolders.
MSI (s) (D0:B4) [23:03:13:421]: Doing action: MigrateFeatureStates
Action ended 23:03:13: SetODBCFolders. Return value 0.
MSI (s) (D0:B4) [23:03:13:421]: Skipping MigrateFeatureStates action: not run in maintenance mode
Action start 23:03:13: MigrateFeatureStates.
MSI (s) (D0:B4) [23:03:13:421]: Doing action: InstallValidate
Action ended 23:03:13: MigrateFeatureStates. Return value 0.
MSI (s) (D0:B4) [23:03:13:421]: Feature: SQL_SNAC_CORE; Installed: Local; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Feature: SQL_SNAC_SDK; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: RedistVersionReg.C3E5819B-5744-41E9-BEF2-12652D7B9053; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: Redist_Uninstall_RegKey.E63C6774-A4E8-4A1A-A090-567FE0DA2FBF; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: License_SQLNCLI_ENU.txt.84118FFB_F307_45F3_B5BC_3A4F8261108D; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.dll.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: RedistQFEKey.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlnclir.rll.A0C5BB09_6818_43E8_AF1C_A1C3C70B210C; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.chm.A0C5BB09_6818_43E8_AF1C_A1C3C70B210C; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E; Installed: Local; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: msmd.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: oledbdm.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: srv.h.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: sqlncli.lib.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: opends60.lib.06870705_8636_410E_B591_FEE8962A550E; Installed: Absent; Request: Local; Action: Local
MSI (s) (D0:B4) [23:03:13:421]: Component: __uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __Redist_Uninstall_RegKey.E63C6774-A4E8-4A65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __RedistVersionReg.C3E5819B-5744-41E9-BEF265; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __RedistQFEKey.9B634CFE_9A39_4508_9CA8_D8D65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __sqlncli.dll.9B634CFE_9A39_4508_9CA8_D8DE65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __sqlnclir.rll.A0C5BB09_6818_43E8_AF1C_A1C65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_payload.98CB24AD_52FB_DB5F_FF165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __nosxs.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E165; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_manifest.98CB24AD_52FB_DB5F_FF65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Component: __downlevel_manifest.63E949F6_03BC_5C40_FF65; Installed: Null; Request: Null; Action: Null
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: BindImage
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2262 2: Class 3: -2147287038
Action start 23:03:13: InstallValidate.
MSI (s) (D0:B4) [23:03:13:421]: Note: 1: 2205 2: 3: _RemoveFilePath
MSI (s) (D0:B4) [23:03:13:437]: PROPERTY CHANGE: Modifying CostingComplete property. Its current value is '0'. Its new value: '1'.
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: BindImage
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: PublishComponent 3: -2147287038
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: Extension 3: -2147287038
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2262 2: Class 3: -2147287038
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2727 2:
MSI (s) (D0:B4) [23:03:13:437]: Note: 1: 2727 2:
MSI (s) (D0:B4) [23:03:13:437]: Doing action: InstallInitialize
Action ended 23:03:13: InstallValidate. Return value 1.
MSI (s) (D0:B4) [23:03:13:437]: Machine policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:437]: User policy value 'AlwaysInstallElevated' is 0
MSI (s) (D0:B4) [23:03:13:437]: BeginTransaction: Locking Server
MSI (s) (D0:B4) [23:03:13:437]: SRSetRestorePoint skipped for this transaction.
MSI (s) (D0:B4) [23:03:13:437]: Server not locked: locking for product {F9B3DD02-B0B3-42E9-8650-030DFF0D133D}
Action start 23:03:13: InstallInitialize.
MSI (s) (D0:B4) [23:03:13:859]: Doing action: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1
Action ended 23:03:13: InstallInitialize. Return value 1.
MSI (s) (D0:70) [23:03:13:875]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAB.tmp, Entrypoint: Sqlmsirc_ValidateAppGuid
Action start 23:03:13: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1.
<Func Name='Sqlmsirc_ValidateAppGuid'>
<EndFunc Name='Sqlmsirc_ValidateAppGuid' Return='0' GetLastError='0'>
MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_RefCountAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_BackupAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:890]: Skipping action: Sqlmsirc_CheckAppDependency.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1 (condition is false)
MSI (s) (D0:B4) [23:03:13:890]: Doing action: SxsInstallCA
Action ended 23:03:13: Sqlmsirc_ValidateAppGuid.0D10D66A_FB58_4290_B8AC_58FF44A6C1F1. Return value 1.
MSI (s) (D0:88) [23:03:13:906]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSIAC.tmp, Entrypoint: CustomAction_SxsMsmInstall
Action start 23:03:13: SxsInstallCA.
1: sxsdelca 2: traceop 3: 1262 4: 0
1: sxsdelca 2: traceop 3: 1263 4: 0
1: sxsdelca 2: traceop 3: 1264 4: 0
1: sxsdelca 2: traceop 3: 1269 4: 0
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: uplevel.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: downlevel_manifest.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: downlevel_payload.98CB24AD_52FB_DB5F_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: uplevel.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 0
1: sxsdelca 2: traceop 3: 1292 4: 0
1: sxsdelca 2: traceop 3: 1293 4: 0
1: sxsdelca 2: traceop 3: 1294 4: 0
1: sxsdelca 2: traceop 3: 1296 4: 0
1: sxsdelca 2: traceop 3: 1322 4: 0
1: sxsdelca: Skipping component 2: downlevel_manifest.63E949F6_03BC_5C40_FF1F_C8B3B9A1E18E
1: sxsdelca 2: traceop 3: 1288 4: 259
1: sxsdelca 2: SxsMsmInstall completed 3: 0 4: 0
MSI (s) (D0:B4) [23:03:14:000]: Skipping action: AllocateRegistrySpace (condition is false)
MSI (s) (D0:B4) [23:03:14:000]: Doing action: ProcessComponents
Action ended 23:03:14: SxsInstallCA. Return value 1.
Action start 23:03:14: ProcessComponents.
MSI (s) (D0:B4) [23:03:14:000]: Doing action: UnpublishComponents
Action ended 23:03:14: ProcessComponents. Return value 1.
MSI (s) (D0:B4) [23:03:14:000]: Note: 1: 2262 2: PublishComponent 3: -2147287038
Action start 23:03:14: UnpublishComponents.
MSI (s) (D0:B4) [23:03:14:000]: Doing action: MsiUnpublishAssemblies
Action ended 23:03:14: UnpublishComponents. Return value 1.
Action start 23:03:14: MsiUnpublishAssemblies.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnpublishFeatures
Action ended 23:03:14: MsiUnpublishAssemblies. Return value 1.
Action start 23:03:14: UnpublishFeatures.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: StopServices
Action ended 23:03:14: UnpublishFeatures. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: ServiceControl 3: -2147287038
Action start 23:03:14: StopServices.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: DeleteServices
Action ended 23:03:14: StopServices. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: ServiceControl 3: -2147287038
Action start 23:03:14: DeleteServices.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterComPlus
Action ended 23:03:14: DeleteServices. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: Complus
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: Complus 4: SELECT `ComponentId`, `FileName`, `Component`.`Directory_`, `ExpType`, `Component`.`Action`, `Component`.`Installed` FROM `Complus`, `Component`, `File` WHERE `Complus`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND `Action` = 0
Action start 23:03:14: UnregisterComPlus.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: SelfUnregModules
Action ended 23:03:14: UnregisterComPlus. Return value 0.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: SelfReg 4: Select `File`.`FileName`,`Component`.`Directory_`,`Component`.`Installed`, `File`.`Component_`,`SelfReg`.`File_` From `SelfReg`, `File`, `Component` Where `SelfReg`.`File_` = `File`.`File` And `File`.`Component_` = `Component`.`Component` And `Component`.`Action` = 0
Action start 23:03:14: SelfUnregModules.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterTypeLibraries
Action ended 23:03:14: SelfUnregModules. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 23:03:14: UnregisterTypeLibraries.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: UnregisterFonts
Action ended 23:03:14: UnregisterTypeLibraries. Return value 1.
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:14:015]: Note: 1: 2228 2: 3: Font 4: SELECT `FontTitle`, `FileName`, `Directory_`, `Installed`From `Font`, `FileAction` Where `Font`.`File_` = `FileAction`.`File` And `FileAction`.`Action` = 0 ORDER BY `FileAction`.`Directory_`
Action start 23:03:14: UnregisterFonts.
MSI (s) (D0:B4) [23:03:14:015]: Doing action: RemoveRegistryValues
Action ended 23:03:14: UnregisterFonts. Return value 1.
Action start 23:03:14: RemoveRegistryValues.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterClassInfo
Action ended 23:03:14: RemoveRegistryValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2262 2: Class 3: -2147287038
Action start 23:03:14: UnregisterClassInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterExtensionInfo
Action ended 23:03:14: UnregisterClassInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2262 2: Extension 3: -2147287038
Action start 23:03:14: UnregisterExtensionInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterProgIdInfo
Action ended 23:03:14: UnregisterExtensionInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: ProgId 4: SELECT DISTINCT `BinaryType`, `ProgId`, `Class_`, `ProgId`.`Description`, `ProgId`.`Icon_`, `ProgId`.`IconIndex`, null, `Component`.`RuntimeFlags` , `Component`.`Component` FROM `ProgId`, `Class`, `Feature`, `Component` WHERE `ProgId`.`Class_` = `Class`.`CLSID` AND `Class`.`Feature_` = `Feature` AND `Class`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)))
Action start 23:03:14: UnregisterProgIdInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: UnregisterMIMEInfo
Action ended 23:03:14: UnregisterProgIdInfo. Return value 0.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: MIME
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: MIME 4: SELECT `BinaryType`, `ContentType`, `Extension`.`Extension`, `MIME`.`CLSID`, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `MIME`, `Extension`, `Feature`, `Component` WHERE `MIME`.`Extension_` = `Extension`.`Extension` AND `Feature_` = `Feature` AND `Extension`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)))
Action start 23:03:14: UnregisterMIMEInfo.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveIniValues
Action ended 23:03:14: UnregisterMIMEInfo. Return value 0.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: IniFile
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: IniFile 4: SELECT `FileName`,`IniFile`.`DirProperty`,`Section`,`IniFile`.`Key`,`IniFile`.`Value`,`IniFile`.`Action` FROM `IniFile`, `Component` WHERE `Component`=`Component_` AND `Component`.`Action`=0 ORDER BY `FileName`,`Section`
Action start 23:03:14: RemoveIniValues.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveShortcuts
Action ended 23:03:14: RemoveIniValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:14:031]: Note: 1: 2228 2: 3: Shortcut 4: SELECT `Name`, null, `Shortcut`.`Directory_`, `Component`.`RuntimeFlags`, `Feature`.`Action`, `Component`.`Action` From `Shortcut`, `Feature`, `Component` WHERE `Target` = `Feature` AND `Shortcut`.`Component_` = `Component` AND (`Feature`.`Action` = 0 OR (`Feature`.`Action` = 4 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)) OR ((`Feature`.`Action` = NULL OR `Feature`.`Action` = 3) AND `Component`.`Action` = 0 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2)))
Action start 23:03:14: RemoveShortcuts.
MSI (s) (D0:B4) [23:03:14:031]: Doing action: RemoveEnvironmentStrings
Action ended 23:03:14: RemoveShortcuts. Return value 0.
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: Environment
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: Environment 4: SELECT `Name`,`Value` FROM `Environment`,`Component` WHERE `Component_`=`Component` AND (`Component`.`Action` = 0)
Action start 23:03:14: RemoveEnvironmentStrings.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveDuplicateFiles
Action ended 23:03:14: RemoveEnvironmentStrings. Return value 1.
Action start 23:03:14: RemoveDuplicateFiles.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveFiles
Action ended 23:03:14: RemoveDuplicateFiles. Return value 1.
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: RemoveFile
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: RemoveFile
Action start 23:03:14: RemoveFiles.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: RemoveFolders
Action ended 23:03:14: RemoveFiles. Return value 0.
Action start 23:03:14: RemoveFolders.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: CreateFolders
Action ended 23:03:14: RemoveFolders. Return value 0.
Action start 23:03:14: CreateFolders.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: MoveFiles
Action ended 23:03:14: CreateFolders. Return value 0.
Action start 23:03:14: MoveFiles.
MSI (s) (D0:B4) [23:03:14:046]: Doing action: InstallFiles
Action ended 23:03:14: MoveFiles. Return value 1.
Action start 23:03:14: InstallFiles.
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: Patch 4: SELECT `Patch`.`File_`, `Patch`.`Header`, `Patch`.`Attributes`, `Patch`.`Sequence`, `Patch`.`StreamRef_` FROM `Patch` WHERE `Patch`.`File_` = ? AND `Patch`.`#_MsiActive`=? ORDER BY `Patch`.`Sequence`
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: MsiPatchHeaders
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2228 2: 3: MsiPatchHeaders 4: SELECT `Header` FROM `MsiPatchHeaders` WHERE `StreamRef` = ?
MSI (s) (D0:B4) [23:03:14:046]: Note: 1: 2205 2: 3: PatchPackage
MSI (s) (D0:B4) [23:03:14:062]: Doing action: DuplicateFiles
Action ended 23:03:14: InstallFiles. Return value 1.
Action start 23:03:14: DuplicateFiles.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: PatchFiles
Action ended 23:03:14: DuplicateFiles. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2205 2: 3: Patch
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2228 2: 3: Patch 4: SELECT `File`,`FileName`,`FileSize`,`Directory_`,`PatchSize`,`File`.`Attributes`,`Patch`.`Attributes`,`Patch`.`Sequence`,`Component`.`Component`,`Component`.`ComponentId` FROM `File`,`Component`,`Patch` WHERE `Patch`.`#_MsiActive`=? AND `File`=`File_` AND `Component`=`Component_` ORDER BY `Patch`.`Sequence`
Action start 23:03:14: PatchFiles.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: BindImage
Action ended 23:03:14: PatchFiles. Return value 0.
Action start 23:03:14: BindImage.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterClassInfo
Action ended 23:03:14: BindImage. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2262 2: Class 3: -2147287038
Action start 23:03:14: RegisterClassInfo.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterExtensionInfo
Action ended 23:03:14: RegisterClassInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2262 2: Extension 3: -2147287038
Action start 23:03:14: RegisterExtensionInfo.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterProgIdInfo
Action ended 23:03:14: RegisterExtensionInfo. Return value 1.
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2205 2: 3: ProgId
MSI (s) (D0:B4) [23:03:14:062]: Note: 1: 2228 2: 3: ProgId 4: SELECT DISTINCT `BinaryType`, `ProgId`, `Class_`, `ProgId`.`Description`, `ProgId`.`Icon_`, `ProgId`.`IconIndex`, null, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `ProgId`, `Class`, `Feature`, `Component` WHERE `ProgId`.`Class_` = `Class`.`CLSID` AND `Class`.`Feature_` = `Feature` AND `Class`.`Component_` = `Component` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND ((`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4))))
Action start 23:03:14: RegisterProgIdInfo.
MSI (s) (D0:B4) [23:03:14:062]: Doing action: RegisterMIMEInfo
Action ended 23:03:14: RegisterProgIdInfo. Return value 0.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: MIME
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: MIME 4: SELECT `BinaryType`, `ContentType`, `Extension`.`Extension`, `MIME`.`CLSID`, `Component`.`RuntimeFlags`, `Component`.`Component` FROM `MIME`, `Extension`, `Feature`, `Component` WHERE `MIME`.`Extension_` = `Extension`.`Extension` AND `Feature_` = `Feature` AND `Extension`.`Component_` = `Component` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND ((`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4))))
Action start 23:03:14: RegisterMIMEInfo.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteRegistryValues
Action ended 23:03:14: RegisterMIMEInfo. Return value 0.
Action start 23:03:14: WriteRegistryValues.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteIniValues
Action ended 23:03:14: WriteRegistryValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: IniFile
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: IniFile 4: SELECT `FileName`,`IniFile`.`DirProperty`,`Section`,`IniFile`.`Key`,`IniFile`.`Value`,`IniFile`.`Action` FROM `IniFile`, `Component` WHERE `Component`=`Component_` AND (`Component`.`Action`=1 OR `Component`.`Action`=2) ORDER BY `FileName`,`Section`
Action start 23:03:14: WriteIniValues.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: WriteEnvironmentStrings
Action ended 23:03:14: WriteIniValues. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: Environment
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: Environment 4: SELECT `Name`,`Value` FROM `Environment`,`Component` WHERE `Component_`=`Component` AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2)
Action start 23:03:14: WriteEnvironmentStrings.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterFonts
Action ended 23:03:14: WriteEnvironmentStrings. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: Font
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: Font 4: SELECT `FontTitle`, `FileName`, `Directory_`, `Action` From `Font`, `FileAction` Where `Font`.`File_` = `FileAction`.`File` And (`FileAction`.`Action` = 1 Or `FileAction`.`Action` = 2) ORDER BY `FileAction`.`Directory_`
Action start 23:03:14: RegisterFonts.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterTypeLibraries
Action ended 23:03:14: RegisterFonts. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2262 2: TypeLib 3: -2147287038
Action start 23:03:14: RegisterTypeLibraries.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: SelfRegModules
Action ended 23:03:14: RegisterTypeLibraries. Return value 1.
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2205 2: 3: SelfReg
MSI (s) (D0:B4) [23:03:14:078]: Note: 1: 2228 2: 3: SelfReg 4: Select `FileAction`.`FileName`,`FileAction`.`Directory_`,`FileAction`.`Action`, `FileAction`.`Component_`,`SelfReg`.`File_` From `SelfReg`, `FileAction` Where `SelfReg`.`File_` = `FileAction`.`File` And (`FileAction`.`Action` = 1 OR `FileAction`.`Action` = 2)
Action start 23:03:14: SelfRegModules.
MSI (s) (D0:B4) [23:03:14:078]: Doing action: RegisterComPlus
Action ended 23:03:14: SelfRegModules. Return value 1.
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2205 2: 3: Complus
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2228 2: 3: Complus 4: SELECT `ComponentId`, `FileName`, `Component`.`Directory_`, `ExpType`, `Component`.`Action`, `Component`.`Installed` FROM `Complus`, `Component`, `File` WHERE `Complus`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND (`Action` = 1 OR `Action` = 2)
Action start 23:03:14: RegisterComPlus.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: InstallServices
Action ended 23:03:14: RegisterComPlus. Return value 0.
MSI (s) (D0:B4) [23:03:14:093]: Detected older ServiceInstall table schema
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2205 2: 3: ServiceInstall
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2228 2: 3: ServiceInstall 4: SELECT `Name`,`DisplayName`,`ServiceType`,`StartType`,`ErrorControl`,`LoadOrderGroup`,`Dependencies`,`StartName`,`Password`,`ComponentId`,`Directory_`,`FileName`,`Arguments` FROM `ServiceInstall`, `Component`, `File` WHERE `ServiceInstall`.`Component_` = `Component`.`Component` AND (`Component`.`KeyPath` = `File`.`File`) AND (`Action` = 1 OR `Action` = 2)
Action start 23:03:14: InstallServices.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: StartServices
Action ended 23:03:14: InstallServices. Return value 1.
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2262 2: ServiceControl 3: -2147287038
Action start 23:03:14: StartServices.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: RegisterUser
Action ended 23:03:14: StartServices. Return value 1.
Action start 23:03:14: RegisterUser.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: RegisterProduct
Action ended 23:03:14: RegisterUser. Return value 0.
Action start 23:03:14: RegisterProduct.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: PublishComponents
Action ended 23:03:14: RegisterProduct. Return value 1.
MSI (s) (D0:B4) [23:03:14:093]: Note: 1: 2262 2: PublishComponent 3: -2147287038
Action start 23:03:14: PublishComponents.
MSI (s) (D0:B4) [23:03:14:093]: Doing action: MsiPublishAssemblies
Action ended 23:03:14: PublishComponents. Return value 1.
Action start 23:03:14: MsiPublishAssemblies.
MSI (s) (D0:B4) [23:03:14:109]: Doing action: PublishFeatures
Action ended 23:03:14: MsiPublishAssemblies. Return value 1.
Action start 23:03:14: PublishFeatures.
MSI (s) (D0:B4) [23:03:14:109]: Doing action: PublishProduct
Action ended 23:03:14: PublishFeatures. Return value 1.
Action start 23:03:14: PublishProduct.
MSI (s) (D0:B4) [23:03:14:109]: Doing action: CreateShortcuts
Action ended 23:03:14: PublishProduct. Return value 1.
MSI (s) (D0:B4) [23:03:14:109]: Note: 1: 2205 2: 3: Shortcut
MSI (s) (D0:B4) [23:03:14:109]: Note: 1: 2228 2: 3: Shortcut 4: SELECT `Name`, `FileName`, `Component`.`Directory_`, `Arguments`, `WkDir`, `Icon_`, `IconIndex`, `Hotkey`, `ShowCmd`, `Shortcut`.`Description`, `Shortcut`.`Directory_`, `Component`.`RuntimeFlags`, `Component`.`Action`, `Target`, `ComponentId`, `Feature`.`Action`, `Component`.`Installed` From `Shortcut`, `Feature`, `Component`, `File` WHERE `Target` = `Feature` AND `Shortcut`.`Component_` = `Component` AND `Component`.`KeyPath` = `File`.`File` AND ((`Feature`.`Action` = 1 OR `Feature`.`Action` = 2) OR (`Feature`.`Action` = 4 AND `Feature`.`Installed` = 0) OR (`Feature`.`Action` = 3 AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)) OR (`Feature`.`Action` = NULL AND (`Component`.`Action` = 1 OR `Component`.`Action` = 2) AND (`Feature`.`Installed` = 1 OR `Feature`.`Installed` = 2 OR `Feature`.`Installed` = 4)))
Action start 23:03:14: CreateShortcuts.
MSI (s) (D0:B4) [23:03:14:109]: Skipping action: SNAC_SetClientSSNLDefaults.9B634CFE_9A39_4508_9CA8_D8DE65A7B8AD (condition is false)
MSI (s) (D0:B4) [23:03:14:109]: Doing action: InstallFinalize
Action ended 23:03:14: CreateShortcuts. Return value 0.
MSI (s) (D0:B4) [23:03:14:109]: Running Script: C:WINDOWSInstallerMSIAD.tmp
MSI (s) (D0:B4) [23:03:14:109]: PROPERTY CHANGE: Adding UpdateStarted property. Its value is '1'.
MSI (s) (D0:B4) [23:03:14:109]: Machine policy value 'DisableRollback' is 0
MSI (s) (D0:B4) [23:03:14:125]: Note: 1: 1402 2: HKEY_LOCAL_MACHINESoftwareMicrosoftWindowsCurrentVersionInstallerRollbackScripts 3: 2
MSI (s) (D0:B4) [23:03:14:125]: Executing op: Header(Signature=1397708873,Version=301,Timestamp=919255143,LangId=1033,Platform=0,ScriptType=1,ScriptMajorVersion=21,ScriptMinorVersion=4,ScriptAttributes=1)
Action start 23:03:14: InstallFinalize.
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ProductInfo(ProductKey={F9B3DD02-B0B3-42E9-8650-030DFF0D133D},ProductName=Microsoft SQL Server Native Client,PackageName=sqlncli.msi,Language=1033,Version=150997986,Assignment=1,ObsoleteArg=0,ProductIcon=ARPIco,,PackageCode={8225F098-4183-422F-B208-3018904DFA0C},,,InstanceType=0,LUASetting=0,RemoteURTInstalls=0)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: DialogInfo(Type=0,Argument=1033)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: DialogInfo(Type=1,Argument=Microsoft SQL Server Native Client)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: RollbackInfo(,RollbackAction=Rollback,RollbackDescription=Rolling back action:,RollbackTemplate=[1],CleanupAction=RollbackCleanup,CleanupDescription=Removing backup files,CleanupTemplate=File: [1])
MSI (s) (D0:B4) [23:03:14:125]: Executing op: SetBaseline(Baseline=0,)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: SetBaseline(Baseline=1,)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ActionStart(Name=ProcessComponents,Description=Updating component registration,)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ProgressTotal(Total=6,Type=1,ByteEquivalent=24000)
MSI (s) (D0:B4) [23:03:14:125]: Executing op: ComponentRegister(ComponentId={B26AC90F-A196-4D67-A57D-FE81C9202A2C},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludemsmd.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={9E91B830-1D04-4B78-9244-ACA6C7790142},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludeoledbdm.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={A2F6B3E4-9050-4BD3-9C29-17E05509F383},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludesqlncli.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={7372B29A-8237-4C56-9E27-5DB074A8AD07},KeyPath=C:Program FilesMicrosoft SQL Server90SDKIncludesrv.h,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={AD0B21CC-B175-4F95-B728-2B5C6C0B65CE},KeyPath=C:Program FilesMicrosoft SQL Server90SDKLibx86sqlncli.lib,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:140]: Executing op: ComponentRegister(ComponentId={EE67DC7C-00F8-40A3-A6EB-62F764614040},KeyPath=C:Program FilesMicrosoft SQL Server90SDKLibx86opends60.lib,State=3,,Disk=1,SharedDllRefCount=0,BinaryType=0)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: ActionStart(Name=InstallFiles,Description=Copying new files,Template=File: [1], Directory: [9], Size: [6])
MSI (s) (D0:B4) [23:03:14:156]: Executing op: ProgressTotal(Total=193043,Type=0,ByteEquivalent=1)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: SetTargetFolder(Folder=C:Program FilesMicrosoft SQL Server90SDKInclude)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: SetSourceFolder(Folder=1PFilesMICROS~190SDKInclude|Program FilesMicrosoft SQL Server90SDKInclude)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: ChangeMedia(MediaVolumeLabel=SNAC,MediaPrompt=Please insert the disk: ,MediaCabinet=snac.cab,BytesPerTick=32768,CopierType=2,ModuleFileName=1sqlncli.msi,,,,,IsFirstPhysicalMedia=1)
MSI (s) (D0:B4) [23:03:14:156]: Executing op: FileCopy(Source
View 5 Replies
View Related
May 14, 2008
I am trying to execute an SSIS package from a client that contains an Analysis Services Processing Task in the package. The client that does not have SSIS and SSAS installed. We are getting an error
The task "Analysis Services Processing Task" cannot run on this edition of Integration Services. It requires a higher level edition. The same package runs from a server that has both SSIS and SSAS installed. Let me know if someone has come across the same problem.
Thanks
View 1 Replies
View Related
Apr 7, 2015
We have a database residing on a SQL Server 2012 Express system running under Windows Server 2012. I have installed the SQL 2012 Native Client on the user's workstation. I created the System DSN with the required settings and when I test the connection all tests pass. I am able to ping the server as well as connect to it via SQL Server Management Studio.
Now when the user launches the application he is presented with the dialog window as in Screenshot1 (see attached). After clicking on Ok he is next presented with the dialog window where he has to select the SQL server. See attached Screenshot2. The user selects the SQL server from the drop down list and he is then able to access the application and work normally. I cannot understand why this is happening because I have included the correct server instance in the DSN settings i.e. sqlserversqlexpress
Telling the user to select the server himself is not an option for us.
I have checked the settings on the SQL Server. TCP/IP is enabled, remote connections are allowed and there is no firewall blocking. Port 1433 has been set as the default port to use.
View 6 Replies
View Related
Nov 22, 2015
I am trying to obtain access to SQL Server Native Client OLE DB provider using :
hr = CoCreateInstance(CLSID_SQLNCLI11, NULL, CLSCTX_INPROC_SERVER, IID_IDBInitialize,
(void **) &PIDBInitialize);
and this fails with 80040154 error. I am using sqlserver 2012 and everything worked perfectly fine as long as my application was running on the same machine as sql server was installed but now that the app is deployed in a different environment in which the app runs on a separate server than the server which has the database and sql server I am failing with this error even though the sql server version on the target server is same as mine.
View 3 Replies
View Related
May 28, 2008
Dear all,
we have tables with many image columns. We fill these image columns via ODBC and SQLPutData as described in MSDN etc (using SQL_LEN_DATA_AT_EXEC(...), calling SQLParamData and sending the data in chunks of 4096 bytes when receiving SQL_NEED_DATA).
The SQLPutData call fails under the following conditions with sqlstate 08S01
- The database resides on SQL Server 2000
- The driver is SQL Native Client
- The table consists e.g. of one Identity column (key column) and nine image columns
- The data to be inserted are nine blocks of data with the following byte size:
1: 6781262
2: 119454
3: 269
4: 7611
5: 120054
6: 269
7: 8172
8: 120054
9: 269
The content of the data does not matter, (it happens also if only zero bytes are written), nor does the data origin (file or memory).
All data blocks including no 7 are inserted. If the first chunk of data block 8 should be written with SQLPutData the function fails and the connection is broken. There are errors such as "broken pipe" or "I/O error" depending on the used network protocol.
If data no 7 consists of 8173 bytes instead of 8172 all works again.
(Changing the 4096 chunk size length does not help)
Has anybody encountered this or a similar phenomenon?
Thank you
Eartha
View 7 Replies
View Related
Dec 5, 2006
I am currently trying to replicate a SQL Mobile 2005 database with a SQL Server 2005 database through web synchronization using SSL Server AND Client Certificates. On IIS, with "Require Client Certificates" unchecked, I can replicate fine. Once I turn it on, I get a message from replication saying "A Secure Socket Layer connection is required to access this site". I have installed a client certificate in IE, and can access the https://servername/Ojt/sqlcesa30.dll site (I tried removing the client certificate, and I was denied access, then reinstalled it and it worked - so I think that part is working). Does anyone have any experience with this? My production operating environment requires client-side certificates.
View 5 Replies
View Related
Aug 30, 2007
Try to do a snapshot replication. The field type on Publishier is char(1) and on Subscriber is varchar(1). The replication fails.
Getting the following error:
Error messages:
The process could not bulk copy into table '"GRS"."GRS_IMG_NAMES"'. (Source: MSSQL_REPL, Error number: MSSQL_REPL20037)
Get help: http://help/MSSQL_REPL20037
Data conversion failed
To obtain an error file with details on the errors encountered when initializing the subscribing table, execute the bcp command that appears below. Consult the BOL for more information on the bcp utility and its supported options. (Source: MSSQLServer, Error number: 20253)
Get help: http://help/20253
bcp "OneACS"."GRS"."GRS_IMG_NAMES" in "D:Microsoft SQL ServerMSSQLReplDatauncUSER-001_MA_HAMPSHIRE_MA_HAMPSHIRE20070829173640GRS_IMG_NAMES_2#1.bcp" -e "errorfile" -t"<x$3>" -r"<,@g>" -m10000 -SUSER-001 -T -w (Source: MSSQLServer, Error number: 20253)
Does anybody know if I can do that or structures have to be same?
Thanks in advance
TH
View 2 Replies
View Related
Sep 19, 2006
I am new to replication but I have a question, I have my server which is using a transaction replication process and a client with using SQL Express with replication turned on. I have the identical DB on both nodes yet when I subsrcibe to the server from the client, data is transfer but for some reason, all of my stored procedures are renamed with sp_MSDel_DBOxxxx. How do I keep SQL from renaming these SP's? The server maintains the origial names to the SPs its just happening on my client.
Thanks
View 5 Replies
View Related
Jun 3, 2008
I am trying to correctly configure a very small replication - one table - between two test machines. Publisher is Windows server 2000. Subscriber is Windows server 2003. Both machines run SQL Server 2005 Enterprise Edition, SP 2 has been applied. I have created an alias from Publisher to Subscriber. In SSMS, I am able to connect to both pub and sub databases (sub is Northwind, by the way).
I was receiving Error 18456, State 11; now I'm reverting back to state 5, which indicates an invalid userid.
HOW do I set appropriate userid for replication? I have established identical id and password on both machines - the only difference between the IDs is the machine name. However, the ID I wish to use is NOT the ID that I use to log onto the publisher computer. This userid is inserted because I'm using Windows Authentication, and I cannot find any means to override it. So I set up the same ID on the publisher, but it doesn't matter what ID I use. I only have TCP/IP turned on because these machines are on different networks, and neither machine is joined to a domain. The alias uses the IP address (but we know that works because I have connectivity under SSMS).
Where can I turn and how do I get this done? I've been struggling with this for 3 weeks, and I'm still not convinced I'm asking the right question.
View 1 Replies
View Related
Apr 16, 2007
I am not extremely familiar with SQL Server replication, but I am trying to perform trans replication to a secondary SQL 2000 Enterprise server. The destination server has a full copy of the database, so I assumed I could do this fairly easily. Below is the error that is generated after I start the distributor agent.
Cannot drop index 'cndx_PrimaryKey_DocumentIndex' because it enforces the full-text key for table 'DocumentIndex'.
What are the best practices for SQL Server replication?
View 3 Replies
View Related
Jan 4, 2007
I need to merge replicate data to two different types of subscribers:
Clients subscribers which will have a very small percentage of the data from the central database. The data on these machines will be managed using dynamic filtering on host_name()
Server subscribers which will manage a copy of all the data from the central database
There will be far fewer server subscribers than client subscribers.
As I see it I have two options for the configuration
1) Use two separate merge publications €“ one which is filtered and one which isn€™t
2) Use a single merge publication and setup the filtering so that the server subscribers receive all the rows
Which option is likely to lead to better performance?
With option 1) there would be 2 complete sets of replication metadata which need to be maintained €“ so I am tending towards option 2. Are there any disadvantages in using a dynamic filter to return a very large number of rows?
View 6 Replies
View Related
Jan 18, 2008
Windows 2003 Server
My site has 2 IP addresses. My Report Server Manager was working until I updated Sharepoint to 2007.
I had installed the Report Server first, but then I installed Sharepoint to the primary IP. At that point Report Services Manager stopped working ( I can still access reports created). I want to move Report Server to the alternate IP. At that IP it's the same situation. I can run previously created reports, but cannot get to Report Manager.
When I try to access /Reports, my URL gets munged into:
http://nn.nn.nn.33/Reports/(S(rm1jwon4f33mbr45knksr0um))/Pages/Folder.aspx
and the message is
The request failed with HTTP status 400: Bad Request.
Where could those extra characters be coming from ? How can I make my Report Services Manager work again?
View 1 Replies
View Related
Oct 18, 2007
Hi Guys,
I've got a merge replication set up between boxes. They're on separate sites both behind an ADSL Nat modem router. The publisher connects to the subscriber via a port forward / Nat translation at the router. This replication set up has been running for some months now. This morning I got this failure message from the merge agent on the publisher.
"the specified remote server name may not be the network name of the remote server or the remote server is unreachable due to network problems. The step failed"
Currently the Enterprise Mgr at the publisher can see the subscriber as can query analyzer running on the publisher.
The host name of the subscriber is the same name used in the server registration at the publisher. The registration uses a Client Network Utility alias to resolve the name.
If I run a ping command at the publisher using the subscribers name I get replies (the resolution of that name is done via a hosts file entry)
Both machines are Win2k Server boxes running SQL Server 2000 Standard.
Any ideas why the agent can't see the subscriber despite the fact its usual communications channel is working just fine?
View 1 Replies
View Related
May 26, 2006
We have two servers using merge replication. I have updated one with SP1 and not the other (yet). Replication fails to work after the upgrade. I get the following error message:
Date 5/26/2006 2:09:08 AM
Log Job History (BB-CM1-SRV1-CountAndCrush-New Sync for Crusher-CC-SQLSRV-6)
Step ID 2
Server BB-CM1-SRV1
Job Name BB-CM1-SRV1-CountAndCrush-New Sync for Crusher-CC-SQLSRV-6
Step Name Run agent.
Duration 00:00:00
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
2006-05-26 06:09:08.316 Category:NULL
Source: Merge Replication Provider
Number: -2147199417
Message: The Publisher failed to allocate a new set of identity ranges for the subscription. This can occur when a Publisher or a republishing Subscriber has run out of identity ranges to allocate to its own Subscribers or when an identity column data type does not support an additional identity range allocation. If a republishing Subscriber has run out of identity ranges, synchronize the republishing Subscriber to obtain more identity ranges before restarting the synchronization. If a Publisher runs out of identit
2006-05-26 06:09:08.316 Category:SQLSERVER
Source: BB-CM1-SRV1
Number: 20663
Message: The publisher's identity range allocation entry could not be found in MSmerge_identity_range table.
View 3 Replies
View Related
Jun 13, 2007
We are using 2000 replication in a fairly basic way. To push tables etc outside our firewall to the webserver, to keep that data current (each night). So the server within the firewall is the Publisher and the external web server is the pushed subscriber.
The problem we have is that sometimes when the link becomes sluggish, the snapshot replication fails. Usually a Error 13, Network error.
The trouble is, by that time it has already cleared the table on the subscriber, but never managed to push up it's new replacement data.
Is this how it works? I was wondering if there was a different approach we could take, perhaps something the equivalent of wrapping it within a transaction, so it would rollback if it fails?
Thanks,
David.
View 3 Replies
View Related
