Upgrading SQL 2000 To SQL 2005 Very Large Database

May 29, 2007

My question is two fold:



We have a database 65 GB in size and has grown over 12 years.



1) How can I upgrade to 2005 without downtime?

2) Our upgrades on SQL 2000 now can take upwards of 10 hours to add just a column and rebuild index tables?



Any way we can speed this up without detaching the database and going offline?



thanks,

Larry Sitka

View 6 Replies


ADVERTISEMENT

Upgrading Source Database From 2000 To 2005

Apr 17, 2007

I have one 32-bit SQL 2000 server that is our enterprise-wide reporting server (we'll call it RS) and another 32-bit SQL 2000 server that serves as a stored proc data source for certain reports on that server (we'll call it DS). I am about to go through an upgrade/migration of DS to 64-bit SQL 2005 and was wondering if:

it is possible to just change the data source location on RS and point the old reports against the new DS server?
there are any necessary steps to take within RS to make the data source (DS reference on RS) compatible with the destination (report on RS)?
it is possible/easy to bulk-migrate all the RDL's for a particular data source from RS to DS?

Does anyone know any of the answers to these questions?

Thanks in advance!

View 1 Replies View Related

Upgrading From 2000 To 2005

Nov 19, 2007

Ok another "I Don't crap about SQL and should read the book" question:

I am purchasing new servers for a company that currently runs SQL 2000 in a Windows 2k3 environment. Not sure why, but they want to upgrade to SQL 2005. The have 4 SQL 2000 Standard editions. Three with 1 processor licensing and 1 with per device licensing. The new servers will have 2 x Quad core processors. Since I know licensing is per "Physical Processor" I need to purchase an additional license for a second processor on each machine that has two. How do I purchase a second one? Can do this online? Whats the cost? Another question I have is: Do I need to buy SQL 2005 Standard (Full Standard Version) install on the new machine and migrate by databases from SQL 2000 over to the new ones? Or is there like an upgrade kit where I install SQL 2000 on the new ones then buy a update to SQL 2005 disc? Please don't laugh at my questions, I am by no means a SQL GURU. Thanks in advance.

View 1 Replies View Related

Upgrading From SQL 2000 To SQL 2005

May 28, 2008

I was with online chat with Microsoft, and the guy said there is no upgrade option between SQL versions like there is from Windows XP home to Pro, or 2000 to XP. Is this true? Has anyone else done this before? I'm wanting to upgrade from SQL 2000 to SQL 2005. I was hoping there was a 32-bit to 64-bit upgrade as well within the versions, but that doesn't seem available either. I will settle for SQL 2005 32-bit if I can upgrade, but if I have to buy a whole other license for it, I might as well get x64. If anyone has done this or has experience in this, any information would be much appreciated!

View 1 Replies View Related

Need Help On Upgrading Sql 2000 To Sql 2005.

Aug 7, 2007

Any expert in the house willing to show me how to upgrade from SQL2000 to SQL2005?

Thanks!

View 4 Replies View Related

Upgrading From SQL 2000 To 2005

Dec 11, 2007



Hi everyone,

I want to upgrade SQL server 2000 to SQL server2005, what are the issues which I have to look at during my upgrading process, what sort of problems might be faced during the upgrading?

Lot of thanx

View 1 Replies View Related

Upgrading From SQL 2000 To SQL 2005

Aug 8, 2007


Please recommend best learning material for quickly upgrading skill sets from SQL 2000 to SQL 2005

View 5 Replies View Related

Upgrading From SQL 2000 SP3 To SQL 2005 SP2

May 21, 2008

Hey all!
I currently am running 8.00.760 which is the Standard Edition of SQL 2000 SP3 (or it might be 3A - no way to tell)

I have downloaded and am preparing to install 9.0.3042.1 SQL 2005 SP2 but when I run the exe file it informs me that "This machine does not have a product that matches this installation package."

Both are 32 bit versions and the precise exe I'm attempting to run is: SQLServer2005SP2-KB921896-x86-ENU.exe

I'm logged on as the server admin.
The server is running Windows Server 2003 Standard Edition SP2.
It has dual Xeon 3.2ghz dual core processors and 4gb of RAM

All of the documentation indicates that this upgrade path is acceptable.

The only thing I have noticed in the Sys Requirements (http://www.microsoft.com/downloads/details.aspx?FamilyId=d07219b2-1e23-49c8-8f0c-63fa18f26d3a&displaylang=en)
is that the supported OS is Windows 2003 SP1 (and no sign of SP2 in the list!) could that be what the issue is?

Does anyone have any advice on where I should look to tackle this issue? I'd like to explore all free avenues before dropping any money for the paid SQL support services.
Thanks for any help.
Geoff Garcia
March of Dimes
ggarcia@marchofdimes.com
914-997-4275

View 3 Replies View Related

Upgrading From SQL Server 2000 To 2005

Nov 29, 2006

I restored a 2000 database back up in to my 2005 database and it works fine. THe only problem is that I cannot create diagrams.

I get the following message:

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

I have checked the db_owner and that is a valid owner.

I changed a few times to different owners and still could not install the diagrams..



Any ideas?

thanks

View 1 Replies View Related

Upgrading SQL Server 2000 To 2005

May 9, 2006

I have to upgrade and move SQL Server 2000 databases from a platform using Server 2000 to one running SQL Server 2005. The server nameinstances will need to be the same so that a number of third party applications and front end systems that connect, and are outside of my control, will not need any data source changes. The servers will be on the same network and can't co-exist with the same name so I guess that I have to go "big bang".

Does anyone have any suggestions for a strategy that I can use?
Does anyone know of any issues that I should be aware of?

I have run the SQL Server 2005 Upgrade Advisor and it tells me the databases should upgrade OK with a few minor issues that can be fixed after.

Thanks,

View 1 Replies View Related

Problem While Upgrading SQL 2000 SP4 To SQL 2005

Feb 5, 2008



Hi All

I am upgrading an SQL 2004 Sp4 server to SQl 2005 which is incalled on a High Availability NSCS cluster

I am facing the following problem in the process

Summary.log file contents

--------------------------------------------------------------------------------
Machine : <Node B of Cluster>
Product : Microsoft SQL Server 2005
Product Version : 9.00.1399.06
Install : Failed
Log File : \Node AC$Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_NodeB_SQL.log
Last Action : ValidateUpgrade
Error String : Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Service pack requirement check:
Your upgrade is blocked because of service pack requirements. To proceed, apply the required service pack and then rerun SQL Server Setup. For more information about upgrade support, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Error Number : 29543

____________________________________________

Following is the logs in file \Node AC$Program FilesMicrosoft SQL Server90Setup BootstrapLOGFilesSQLSetup0005_NodeB_SQL.log


*********************************************************************************************************************************************

Loaded DLL:
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlboot.dll
Version:
2005.90.1399.0

Action "
languageUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER
" will be skipped due to the
following restrictions:

Condition "differentLanguage_with_1033_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Condition "allowableBaseVersion_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Loaded DLL:
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlboot.dll
Version:
2005.90.1399.0

Action "
maintenance_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER
" will be skipped due to the
following restrictions:

Condition "sameVersion_as_9.0.139906_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Loaded DLL:
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlboot.dll
Version:
2005.90.1399.0

Action "
skuUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER
" will be skipped due to the
following restrictions:

Condition "NOT_sameSKU_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Condition "allowableBaseVersion_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Loaded DLL:
C:Program FilesMicrosoft SQL Server90Setup Bootstrapsqlboot.dll
Version:
2005.90.1399.0

Action "
versionUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER
" will be skipped due to the
following restrictions:

Condition "allowableBaseVersion_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Action "
virtualization_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER
" will be skipped due to the
following restrictions:

Condition "virtualization_NotSupported_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Action "
warningPatchLevel_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER
" will be skipped due to the
following restrictions:

Condition "diffInstancePatchLevel_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Action "
warningSPLevel_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER
" will be skipped due to the
following restrictions:

Condition "diffInstanceSPLevel_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Action "
warningUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER
" will be skipped due to the
following restrictions:

Condition "warningUpgrade_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Condition "allowableBaseVersion_MSSQLSERVER SQL 8.0 SQL Server Standalone Product MSSQLSERVER" returned false.
Running:
FeaturePhaseAction
at:
Info 2008.2008
/
1
/
4

17
:
26
:
17

Complete:
FeaturePhaseAction
at:
Info 2008.2008
/
1
/
4

17
:
26
:
17
, returned
true

Error Code: 0x80077367 (29543)
Windows Error Text: Source File Name: sqlcaupgradeproduct.cpp
Compiler Timestamp: Mon Sep 19 01:07:45 2005
Function Name: sqls::UpgradeProduct::CanUpgrade
Source Line Number: 142

---- Context -----------------------------------------------

Setting status of unmanaged components and removing unmanaged resources

Error Code: 29543
MSI (s) (8C!A8) [17:26:39:194]: Product: Microsoft SQL Server 2005 -- Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Service pack requirement check:
Your upgrade is blocked because of service pack requirements. To proceed, apply the required service pack and then rerun SQL Server Setup. For more information about upgrade support, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

Error 29543. Your upgrade is blocked. For more information about upgrade support, see the "Version and Edition Upgrades" and "Hardware and Software Requirements" topics in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.
Service pack requirement check:
Your upgrade is blocked because of service pack requirements. To proceed, apply the required service pack and then rerun SQL Server Setup. For more information about upgrade support, see the Version and Edition Upgrades topic in SQL Server 2005 Setup Help or SQL Server 2005 Books Online.

<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='0'>
Doing Action: ValidateUpgrade
PerfTime Start: ValidateUpgrade : Mon Feb 04 17:26:39 2008
<Func Name='ValidateUpgrade'>
Added FTE to SqlUpgrade property
Added REPL to SqlUpgrade property
<Func Name='updateFeatureSellection'>
Error Code: 0x80077367 (29543)
Windows Error Text: Source File Name: sqlcaupgradeproduct.cpp
Compiler Timestamp: Mon Sep 19 01:07:45 2005
Function Name: sqls::UpgradeProduct::CanUpgrade
Source Line Number: 142

---- Context -----------------------------------------------


********************************************************************************************************************************************

I checked the version of teh SQL server on both teh nodes ...using select @@version query it shown as 8.00.2039 which is SP4.

But i do not understand why it is failing with this error.

Kindly suggest

Thanks
Naresh P.

View 1 Replies View Related

Error Upgrading Sql 2000 To Sql 2005

Dec 5, 2007



We are in the process of going through all test steps for upgrading one of our servers with SQL 2000 to SQL 2005. Currently Server 2000, which we will be upgrading as well after SQL is upgraded and running properly. We have Reporting Services installed as well. I am using a test server which is an exact mirrored image of the live server but is not added to the domain.

I am going through the steps of selecting the components, selecting the instance, and then selecting the installed components I want to upgrade (SQL Server 8.0.??? and Reporting Services 8.0.???) and click next.

The upgrade analysis begins. Everything is ok through the SQL Server analysis but when I click next to start the upgrade analysis on Reporting Services I get this error message, "SQL Server Setup requires administrator permissions for the upgraded SQL Server instance. To continue, log in with an administrator account." I am logged in as the local admin which should have the required permissions to upgrade Reporting Services, plus the local admin was ok for the SQL Server upgrade anaylis

I have no idea what could be causing this permissions issue. I did run the SQL 2005 Updrade Analyzer utility and performed all the "before" steps. What could be the issue?

View 2 Replies View Related

Upgrading From 2000 To 2005 DBCC Is It Necessary

May 23, 2008



I am in the position that my DR environment will be down while the upgrade from 2000 to 2005 is being done. The upgrade instructions say that update statistics and DBCC check database should be done. With the size of my database I estimate that this will take over 2 days to do. Is this step a necessary step for the upgrade. I am looking to reduce my expose. Keep in mind that DR get overwritten each night.

View 3 Replies View Related

Upgrading To SQL 2005 From 2000 - Seeking Advice

Nov 30, 2007

Hello everyone, I am upgrading from SQL Server 2000 to SQL Server 2005. Any caveats? Can I just detach the db's and attach them into 2005. Or is there any conversion I should run or import first?

Thanks,

View 4 Replies View Related

Upgrading SQL Server 2000 To 2005 Best Practices

Dec 23, 2007



Hello all,

I'm finding the documentation online to upgrading from 2000 to 2005 fairly poor.

What are the upgrading options and which one is the best option for a web server database.

Also what are best practices pre-upgrade, during upgrade and post-upgrade.

Cannot find much online.

Also since this question will be asked often might as well make it a sticky.

Thanks

View 3 Replies View Related

Problem Upgrading A SQL 2000 Server To SQL 2005

Oct 15, 2007

Hello

I'm trying to upgrade a Microsoft SQL 2000 (8.00.760 SP3) server to SQL 2005.

It€™s a standard install, std version, not very big databases, default instance, plenty of memory etc. OS is a 2003 server recently upgraded from 2000. All patches etc are installed.

Upgrade was going fine and had got approx 90% through, had started the 2005 db service and converted the databases before it got the following error:

SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Invalid connection string attribute Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.

The 'For help' link returned the helpful... €˜We are sorry but we can€™t help€™...

Worked through http://msdn2.microsoft.com/en-us/library/ms143698.aspx but not 100% applicable and didn€™t resolve.

Partially rolled back, rebooted and resumed install but failed in the same place. Ended going back to a backup snapshot so is now back running as SQL 2000.

Excerpt from install log is below...

Thanks in advance for any assistance.




<Finished SQL statement: Wed Oct 10 21:25:21 2007>
<Started SQL statement: Wed Oct 10 21:25:21 2007> BEGIN DECLARE @GroupName AS nvarchar(4000) SET @GroupName = QUOTENAME(N'PROPMAN-DATASQLServer2005MSFTEUser$PROPMAN-DATA$MSSQLSERVER') EXECUTE(N'grant execute on sp_fulltext_getdata to ' + @GroupName) END
<Finished SQL statement: Wed Oct 10 21:25:22 2007>
Service MSSQLSERVER is being stopped at Wed Oct 10 21:25:22 2007
Service MSSQLSERVER with parameters '' is being started at Wed Oct 10 21:25:34 2007
Attempt to start service when it is already running
SQL service MSSQLSERVER started successfully waiting for SQL service to accept client connections
Service MSSQLSERVER started at Wed Oct 10 21:25:40 2007
<EndServerDowntime Wed Oct 10 21:25:40 2007>
Loaded DLL:
C:WINNTsystem32Odbc32.dll
Version:
3.526.3959.0


SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=01S00, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL Native Client]Invalid connection string attribute

Error Code: 0x8007ea62 (60002)
Windows Error Text: Source File Name: libodbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005
Function Name: OdbcConnection::connect@upgradeconnect
Source Line Number: 148



---- Context -----------------------------------------------


sqls:equenceInstaller::launchAction
Staring action SqlScript
SqlUpgradeScriptHlpr
Connecting to SQL Server
ExecuteUpgradeSqlCommands
sqlConnect
Originial error was 8007ea62 (60002)



Error Code: 60002
MSI (s) (5C!20) [21:26:20:164]: PROPERTY CHANGE: Adding SqlUpgradeMessage property. Its value is 'SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Invalid connection string attribute Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.'.
SQL Server Setup could not connect to the database service for server configuration. The error was: [Microsoft][SQL Native Client]Invalid connection string attribute Refer to server error logs and setup logs for more information. For details on how to view setup logs, see "How to View Setup Log Files" in SQL Server Books Online.
Loaded DLL:
C:WINNTsystem32Odbc32.dll
Version:
3.526.3959.0


SQL_ERROR (-1) in OdbcConnection::connect
sqlstate=01S00, level=-1, state=-1, native_error=0, msg=[Microsoft][SQL Native Client]Invalid connection string attribute

Error Code: 0x8007ea62 (60002)
Windows Error Text: Source File Name: libodbc_connection.cpp
Compiler Timestamp: Fri Jul 29 01:13:53 2005
Function Name: OdbcConnection::connect@upgradeconnect
Source Line Number: 148



---- Context -----------------------------------------------

View 1 Replies View Related

Upgrading MSDE 2000 To SQL 2005 Standard

Apr 10, 2007

Does anyone know of a resource that describes the steps to upgrade an instance of MSDE(2000) to SQL 2005 Standard?



We found something on a MS site that indirectly indicated you could upgrade the MSDE to SQL Express and then upgrade Express to the full version of 2005, but that method created quite a bit of problems(System databases), which we were not able to resolve short of uninstalling MSDE and the apps and installing SQL 2005 and re-installing the apps; but I have to believe there is a better way.



Thanks! Bob McEuen

View 4 Replies View Related

How Do SQL 2000 Service Packs Play A Role In Upgrading?i.e.Can SQL 2000 Standard With No SP Be Upgraded To SQL 2005 Standard

Aug 2, 2006

How do SQL 2000 service packs play a role in upgrading? That is, can SQL 2000 Standard with no Service Packs(SP) be upgraded to SQL 2005 Standard, or does SQL 2000 Standard have to have a certain service pack??

View 1 Replies View Related

Can't Connect To SQL Sever 2005 After Upgrading From SQL Server 2000

Sep 6, 2006

I recently upgraded from SQL Server 2000 to SQL Server 2005. I have Oracle databases I need to share data with. I was using the Heterogeneous Services (hsodbc) from Oracle and connected to SS 2000 fine. Since I've upgraded, I can't use hsodbc to connect to my SS 2005 database. I get the following error:

ORACLE GENERIC GATEWAY Log File Started at 2006-09-06T09:40:07

hoainit (3): ; hoainit Exited with retcode = 0.

hoalgon (7): ; hoalgon Entered. name = edw.

DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL Server]Login

failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)

DRV_InitTdp: DB_ODBC_INTERFACE (2085): ; [Microsoft][SQL Native Client][SQL

Server]Login failed for user 'edw'. (SQL State: 28000; SQL Code: 18456)

nvRETURN (F:WorkConnect_4_6_3srcdrvDRV_BIND.C 356): -2220

nvRETURN (F:WorkConnect_4_6_3srcavNAV_BIND.C 293): -2220

hoalgon (7): ; hoalgon Exited with retcode = 28500.

View 6 Replies View Related

Problem Upgrading From SQL Server 2000 To SQLServer 2005

Sep 13, 2007

My upgrade of SQL Server 2000 to SQL Server 2005 is being blocked as follows:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding
FTCATALOGPATH
DEPRECATEDSP
FTCATALOGNAMERESTRICTION
FTNONPERSISTEDCOMPCOL

Many thanks
JMX

View 3 Replies View Related

Upgrading Reports From 2000 To 2005 And Saving History

May 8, 2007

Hi,

i've used sql 2000 to create reports. Now i have almost 100 reports with lot of history (snapshots). Now i've developed the same reports in 2005 (basically upgraded the reports). If i upload the new reports, the 2000 history will be lost. Is there anyway that i can upgrade to 2005 and save the history ??

Thanks

View 4 Replies View Related

Upgrading 2000 To 2005, Can I Just Move Data File?

May 2, 2007

I just installed SQL 2005 on a new box. I want to move a database from a SQL 2000 server to the new server. Can I detach the database, copy it and attach it in the new server without having problems?



I'm concerned that if the datafile is in SQL2000 format, when I connect it to SQL2005 server, will it still be in old format or will it upgrade?....or is this something you don't worry about....and why?





Thanks,

Craig

View 3 Replies View Related

Merge Replication: Problems Upgrading SQL-2000 To 2005

Dec 25, 2006

Hello!

We have a module in our business-application, that automatically installs merge replication of the business-application's database, both at publisher and subscribers. It's intended for Sql-2000. Now we need it to be applicable also for Sql-2005, so the module requires some changes, because, as we noticed, sql-2005's replication technology differs from Sql-2000's one.

A few questions to experts, familiar with Merge Replication in SQL-2005:

1. Is it possible to create hybrid replication, with publisher running at SQL-2000 (MSDE) and subscribers running at SQL-2005 Express? Merge publication is not supported in SQL 2005 Express, but some users may require option to use the application at free-of-charge database platform.

2. How deep are changes in merge replication implementation at system level? Is it just modified a bit since SQL-2000, or changed entirely? This knowledge is needed, because the module uses some low-level features (executing system sp's, querying replication-specified tables, etc.). For example, when we tried to create subscription of existing publication in SQL 2005 using the module as is, we found out that sp_addmergepullsubscription_agent doesn't use @encrypted_password parameter anymore, and subscription creation process failed.

3. If anybody has experience using merge replication creation/deletion/detection scripts, generated by SQL 2000, in SQL 2005! Please, tell - what more problems may happen?

Thanks!

View 3 Replies View Related

Problems Upgrading Msde 2000 To SQL Express 2005

Apr 4, 2007

I am having issues trying to do an in place upgrade of msde 2000 to sql express 2005. When I try to upgrade it bombs when it reaches "Running action to shutdown instance(Run As Normal User)" with the following error:
Service 'computername' could not be stopped. Verify that you have sufficient privileges to stop system services. The error code is (16386).
I've tried an upgrade on a clean test machine, and it goes through without any problems. I am logged into an account with local admin permissions. If any one has any ideas, they would be appreciated.

View 1 Replies View Related

Problems Upgrading To 2005 Trial From 2000 Standard Edition

Jan 5, 2006

I'm having problems upgrading to 2005 Trial from 2000 Standard Edition.Despite the ms docs saying this was a valid upgrade path and runningthe upgrade advisor which did not highlight a non-valid upgrade path, Iam getting the following error :-Name: Microsoft SQL Server 2000Reason: Your upgrade is blocked. ......Edition check:Your upgrade is blocked because of edition upgrade rules. ......Any ideas?Richard.

View 1 Replies View Related

SQL Server 2005 And Management Studio Driving Me CRAZY -Im UPGRADING To 2000

Feb 2, 2006

Is it just me, or are features missing in Management Studio? I mean, where is the "Export Objects" option when exporting data? Why is it so difficult to register a remote server? Why do the object views suck? And most important, why is the documentation  the worst software documentation I have EVER SEEN?!
Things that were easy in Enterprise Manager with Client Network Utility and Query Analyzer seem impossible, difficult, or maybe just hidden in Management Studio. If it is there, the documentation sure doesnt tell you how to find it.
Please someone tell me that it's just me. Tell me that the features are there but Im not doing something right. I feel like putting my head in between my door opening and banging the door against it.

View 2 Replies View Related

Problems Upgrading Database Engine 2005 Express To 2005 Standard

Nov 7, 2006

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

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

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



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

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

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

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

View 5 Replies View Related

RESTORE DATABASE Timeout In SQL 2000 With Large Backup Files

Sep 11, 2007



Hello,

I am attempting to restore the database from within VB.NET application I am making the following 3 calls:

RESTORE FileListOnly FROM DISK = 'C:MyDatabase.dat'

USE Master RESTORE DATABASE MyDatabase FROM DISK = 'C:MyDatabase.dat' WITH NORECOVERY, MOVE 'MyDatabase' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDataMyDatabase.mdf', MOVE 'MyDatabase_log' TO 'C:Program FilesMicrosoft SQL ServerMSSQLDataLDFMyDatabase.ldf', REPLACE

RESTORE DATABASE MyDatabase FROM DISK = 'C:MyDatabase.dat'


using SMO. This logic works fine with small *.dat files, however when using *.dat file of about 4Gb I get an error on the 3d restore database call:



ExecuteNonQuery failed for Database 'master'.

An exception occurred while executing a Transact-SQL statement or batch.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Operator aborted backup or restore. See the error messages returned to the console for more details.

ExecuteNonQuery failed for Database 'master'.

An exception occurred while executing a Transact-SQL statement or batch.

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Operator aborted backup or restore. See the error messages returned to the console for more details.



The same program/logic also works fine when I use MS SQL 2005 and it runs fine from MS SQL 2005 Query Analyzer for both 2005 and 2000 databases. There seem to be only problem with MS SQL 2000 from within VB.NET. Anybody has any idea? I'd appreciate any response. Thanks

Eugene

View 6 Replies View Related

Problems With Merge Rep After Upgrading From Sql Server 2000 Sp3a To Sql Server 2005 Build 2153

Mar 6, 2007

Hi,

We just upgraded 2 sql servers from sql server 2000 sp3a to sql server 2005 build 2153, and merge rep exists between these 2 servers.

However, after sql server upgrade, we had to reinitialize merge replication and now the merge agent is reporting 2 errors

1)

Error messages:


The Merge Agent failed to upgrade triggers, metadata and stored procedures on the Subscriber to versions compatible with SQL Server 2005. Restart synchronization, and if this failure continues to occur reinitialize the subscription. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199403)
Get help: http://help/MSSQL_REPL-2147199403

Invalid column name 'metadata_select_proc'. (Source: MSSQLServer, Error number: 207)
Get help: http://help/207

Invalid column name 'delete_proc'. (Source: MSSQLServer, Error number: 207)
Get help: http://help/207

2)

Command attempted:


{call sp_MSensure_single_instance (N'Merge Agent Name', 4)}

Error messages:


The merge process could not connect to the Publisher 'Server:database'. Check to ensure that the server is running. (Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199368)
Get help: http://help/MSSQL_REPL-2147199368

Another merge agent for the subscription(s) is running or the server is working on a previous request by the same agent. (Source: MSSQLServer, Error number: 21036)
Get help: http://help/21036

looking inside the sp_MSensure_single_instance stored procedure, it's trying to obtain an exclusive lock on resource 'Merge Agent Name' but fails and returns -1

this is the stored procedure executed by sp_MSensure_single_instance and @retcode = -1 and thus cannot obtain exclusive lock on resource

EXEC @retcode = sys.sp_getapplock @Resource = 'Merge Agent Name',

@LockMode = 'Exclusive',

@LockOwner = 'Session',

@LockTimeout = 0,

@DbPrincipal = 'MSmerge_PAL_role'

so i think it's failing because for some reason MSmerge_PAL_role database role does not have enough rights to obtain exclusive lock on necessary resources

i've tried many things to fix this, including scripting out and dropping all merge rep, turning off replication db option and reapplying replication create scripts on the server, and even manually deleting the MSmerge_PAL_role database role but still doesn't work

can anyone help?

Thanks

View 9 Replies View Related

Upgrading Sql Server 2000 Databases To Sql Server 2005

Aug 8, 2007



I don't have any idea about upgrading databases.I am been given this task.
It would be great if you let me know what are all the things to be considered upgrading the sql server 2000 databases to sql server 2005.

Please let me know

Thanks

View 1 Replies View Related

SQL SERVER 2005 Database Mirroring For Large Number Of Databases

May 30, 2006

I am trying to enable database mirroring for 100 database.
It goes error free till 59 databases (some times 60 databases) with the
status (principal, synchronized) on principal. on the 60th or 61st database
it gave the status (principal, disconnected). Also mirror starts acting
abnormal. connection to mirror starts to give connection timeout and it is
not enabling database mirroring on any more databases. I have SQL SERVER
2005 Enterprise with SP1 on the servers. witness is not included yet.

this are my test servers... i have more than 500 databases on my production
servers.

principal and mirror both are using port 5022 for ENDPOINT communication.

View 1 Replies View Related

SQL SERVER 2005 DATABASE MIRRORING For Large Number Of Databases

Jun 1, 2006

I am trying to enable database mirroring for 100 database.
It goes error free till 59 databases (some times 60 databases) with the
status (principal, synchronized) on principal. on the 60th or 61st database
it gave the status (principal, disconnected). Also mirror starts acting
abnormal. connection to mirror starts to give connection timeout and it is
not enabling database mirroring on any more databases. I have SQL SERVER
2005 Enterprise with SP1 on the servers. witness is not included yet.

these are my test servers... i have more than 500 databases on my production
servers.

principal and mirror both are using port 5022 for ENDPOINT communication.

All of the databases are critical and all must be included in the Database Mirroring.
so, after that I tried to implement database mirroring again......
System has 3 GB of RAM, SQL SERVER (Mirror) using 85 MB of RAM but still
giving this error while trying to enable database mirroring for 37th
Database.....

"There is insufficient system Memory to run this query"

WHY?

View 19 Replies View Related

Upgrading SQL Server 2000 Enterprise Edition To SQL Server 2005 Standard Edition

Nov 9, 2007



Hi,

I would like to find out if there is any way to upgrade SQL Server 2000 (Ent) to 2005 (STD)

The Instance has many logins and jobs etc and I dont want to loose those

A document or some advice on how to go about it would help

Thanks

View 10 Replies View Related







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