Symptoms
After you install SQL Server 2012 SP1 on a computer, the Windows Installer (Msiexec.exe) process is repeatedly started to repair certain assemblies. Additionally, the following events are logged in the Application log:When this issue occurs, you experience high CPU usage.Additionally, you may experience one or more of the following issues:
-
Users cannot log in to Windows with their profile.
-
Insufficient resource related errors when starting services and applications.
-
The Windows registry appears to slowly expand.
Cause
This issue occurs because the SQL Server 2012 components reference mismatched assemblies, Microsoft.AnalysisServices.Wizard.v1.dll and Microsoft.DataWarehouse.Interfaces.dll. This behavior causes native image generation to fail repeatedly. Therefore, a repair operation is initiated on the installer package.
Resolution
To resolve this issue, use the appropriate method:Scenario 1: You did not install any hotfixes or Cumulative updates after installing Service Pack 1 for SQL Server 2012.In this scenario, we recommend that you install the Non Security Update for SQL Server 2012 SP1. The following files are available for download from the Microsoft Download Center:
119591 How to obtain Microsoft support files from online services Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file. Scenario 2: You installed either a hotfix or Cumulative Update 1 after installing Service Pack 1 for SQL Server 2012. In this scenario, we recommend that you install Cumulative Update 2 for SQL Server 2012 SP1. For more information about how to obtain this cumulative update package for SQL Server 2012 SP1, click the following article number to view the article in the Microsoft Knowledge Base:
2790947 Cumulative update package 2 for SQL Server 2012 Service Pack 1 Note Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2012 SP1 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2772858 The SQL Server 2012 builds that were released after SQL Server 2012 Service Pack 1 was released
Information about the Non Security Update for SQL Server 2012 SP1
Prerequisites
To apply this update, you must have SQL Server 2012 SP1 installed.
Restart requirement
You do not have to restart the computer after you apply this update.
The global version of this update has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.
For all supported x86-based versions of SQL Server 2012 Database Services Core Instance
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Sql_engine_core_inst_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:21 |
|
Sqlaccess.dll |
2011.110.3128.0 |
442,344 |
29-Dec-2012 |
05:24 |
|
Sqlagent.exe |
2011.110.3128.0 |
448,488 |
29-Dec-2012 |
05:10 |
|
Sqldk.dll |
2011.110.3128.0 |
1,649,640 |
29-Dec-2012 |
05:23 |
|
Sqllang.dll |
2011.110.3128.0 |
26,404,352 |
29-Dec-2012 |
05:23 |
|
Sqlmin.dll |
2011.110.3128.0 |
26,692,584 |
29-Dec-2012 |
05:23 |
|
Sqlos.dll |
2011.110.3128.0 |
25,088 |
29-Dec-2012 |
05:22 |
|
Sqlservr.exe |
2011.110.3128.0 |
160,768 |
29-Dec-2012 |
05:10 |
|
Sqltses.dll |
2011.110.3128.0 |
8,162,792 |
29-Dec-2012 |
05:23 |
For all supported x86-based versions of SQL Server 2012 Database Services Common Core
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.datawarehouse.interfaces.dll |
11.0.3128.0 |
37,888 |
29-Dec-2012 |
05:18 |
|
Sql_common_core_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:21 |
For all supported x86-based versions of SQL Server 2012 Business Intelligence Development Studio
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.analysisservices.project.dll |
2011.110.3128.0 |
2,109,416 |
29-Dec-2012 |
05:22 |
|
Microsoft.analysisservices.wizard.v1.dll |
11.0.3128.0 |
601,064 |
29-Dec-2012 |
05:18 |
|
Microsoft.analysisservices.wizard.v1.resources.dll |
11.0.3128.0 |
230,376 |
29-Dec-2012 |
05:18 |
|
Microsoft.analysisservices.wizard.v1.resources.dll |
11.0.3128.0 |
230,400 |
29-Dec-2012 |
05:18 |
|
Microsoft.analysisservices.wizard.v1.resources.dll |
11.0.3128.0 |
230,888 |
29-Dec-2012 |
05:19 |
|
Microsoft.analysisservices.wizard.v1.resources.dll |
11.0.3128.0 |
231,400 |
29-Dec-2012 |
05:19 |
|
Microsoft.datawarehouse.interfaces.dll |
11.0.3128.0 |
48,616 |
29-Dec-2012 |
05:22 |
|
Microsoft.datawarehouse.interfaces.resources.dll |
11.0.3128.0 |
19,432 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll |
11.0.3128.0 |
19,448 |
29-Dec-2012 |
05:20 |
|
Microsoft.datawarehouse.interfaces.resources.dll |
11.0.3128.0 |
19,456 |
29-Dec-2012 |
05:18 |
|
Microsoft.reportingservices.diagnostics.dll |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Reportingservicesnativeclient.dll |
2011.110.3128.0 |
155,624 |
29-Dec-2012 |
05:24 |
|
Sql_bids_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:21 |
For all supported x86-based versions of SQL Server 2012 Analysis Services
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Sql_as_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:21 |
For all supported x86-based versions of SQL Server 2012 Reporting Services
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.datawarehouse.interfaces.dll.deploy |
11.0.3128.0 |
48,616 |
29-Dec-2012 |
05:22 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,432 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,448 |
29-Dec-2012 |
05:20 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,456 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,944 |
29-Dec-2012 |
05:23 |
|
Microsoft.reportingservices.diagnostics.dll.deploy |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Microsoft.reportingservices.diagnostics.dll |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Reportingservicesnativeclient.dll |
2011.110.3128.0 |
155,624 |
29-Dec-2012 |
05:24 |
|
Reportingservicesnativeserver.dll |
2011.110.3128.0 |
124,392 |
29-Dec-2012 |
05:24 |
|
Sql_rs_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:21 |
|
Microsoft.datawarehouse.interfaces.dll.deploy |
11.0.3128.0 |
48,616 |
29-Dec-2012 |
05:22 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,432 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,448 |
29-Dec-2012 |
05:20 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,456 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,944 |
29-Dec-2012 |
05:23 |
|
Microsoft.reportingservices.diagnostics.dll.deploy |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Microsoft.reportingservices.diagnostics.dll |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Reportingservicesnativeclient.dll |
2011.110.3128.0 |
155,624 |
29-Dec-2012 |
05:24 |
For all supported x86-based versions of SQL Server 2012 Integration Services
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Msdtssrvr.exe |
11.0.3128.0 |
219,136 |
29-Dec-2012 |
05:21 |
|
Sql_is_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:21 |
For all supported x86-based versions of SQL Server 2012 Management Studio
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.analysisservices.wizard.v1.dll |
11.0.3128.0 |
601,064 |
29-Dec-2012 |
05:18 |
|
Microsoft.reportingservices.diagnostics.dll |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Microsoft.sqlserver.management.sqlstudio.dll |
11.0.3128.0 |
316,392 |
29-Dec-2012 |
05:24 |
|
Reportingservicesnativeclient.dll |
2011.110.3128.0 |
155,624 |
29-Dec-2012 |
05:24 |
|
Sql_ssms_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:21 |
For all supported x86-based versions of SQL Server 2012 Tools and Workstation Components
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.analysisservices.project.dll |
2011.110.3128.0 |
2,109,416 |
29-Dec-2012 |
05:22 |
|
Microsoft.datawarehouse.interfaces.dll |
11.0.3128.0 |
48,616 |
29-Dec-2012 |
05:22 |
|
Microsoft.sqlserver.chainer.infrastructure.dll |
11.0.3128.0 |
404,968 |
29-Dec-2012 |
05:21 |
|
Microsoft.sqlserver.configuration.sco.dll |
11.0.3128.0 |
2,035,200 |
29-Dec-2012 |
05:21 |
|
Sql_tools_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:21 |
For all supported x64-based versions of SQL Server 2012 Database Services Core Instance
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Sql_engine_core_inst_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:19 |
|
Sqlaccess.dll |
2011.110.3128.0 |
449,512 |
29-Dec-2012 |
05:20 |
|
Sqlagent.exe |
2011.110.3128.0 |
612,864 |
29-Dec-2012 |
05:21 |
|
Sqldk.dll |
2011.110.3128.0 |
2,080,232 |
29-Dec-2012 |
05:11 |
|
Sqllang.dll |
2011.110.3128.0 |
33,981,928 |
29-Dec-2012 |
05:11 |
|
Sqlmin.dll |
2011.110.3128.0 |
32,253,416 |
29-Dec-2012 |
05:11 |
|
Sqlos.dll |
2011.110.3128.0 |
26,088 |
29-Dec-2012 |
05:20 |
|
Sqlservr.exe |
2011.110.3128.0 |
192,000 |
29-Dec-2012 |
05:21 |
|
Sqltses.dll |
2011.110.3128.0 |
8,923,136 |
29-Dec-2012 |
05:11 |
For all supported x64-based versions of SQL Server 2012 Database Services Common Core
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.datawarehouse.interfaces.dll |
11.0.3128.0 |
37,888 |
29-Dec-2012 |
05:18 |
|
Sql_common_core_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:19 |
For all supported x64-based versions of SQL Server 2012 Business Intelligence Development Studio
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.analysisservices.project.dll |
2011.110.3128.0 |
2,109,416 |
29-Dec-2012 |
05:22 |
|
Microsoft.analysisservices.wizard.v1.dll |
11.0.3128.0 |
601,064 |
29-Dec-2012 |
05:18 |
|
Microsoft.analysisservices.wizard.v1.resources.dll |
11.0.3128.0 |
230,376 |
29-Dec-2012 |
05:18 |
|
Microsoft.analysisservices.wizard.v1.resources.dll |
11.0.3128.0 |
230,400 |
29-Dec-2012 |
05:18 |
|
Microsoft.analysisservices.wizard.v1.resources.dll |
11.0.3128.0 |
230,888 |
29-Dec-2012 |
05:19 |
|
Microsoft.analysisservices.wizard.v1.resources.dll |
11.0.3128.0 |
231,400 |
29-Dec-2012 |
05:19 |
|
Microsoft.datawarehouse.interfaces.dll |
11.0.3128.0 |
48,616 |
29-Dec-2012 |
05:22 |
|
Microsoft.datawarehouse.interfaces.resources.dll |
11.0.3128.0 |
19,432 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll |
11.0.3128.0 |
19,448 |
29-Dec-2012 |
05:20 |
|
Microsoft.datawarehouse.interfaces.resources.dll |
11.0.3128.0 |
19,456 |
29-Dec-2012 |
05:18 |
|
Microsoft.reportingservices.diagnostics.dll |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Reportingservicesnativeclient.dll |
2011.110.3128.0 |
155,624 |
29-Dec-2012 |
05:24 |
|
Sql_bids_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:19 |
For all supported x64-based versions of SQL Server 2012 Analysis Services
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Sql_as_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:19 |
For all supported x64-based versions of SQL Server 2012 Reporting Services
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.datawarehouse.interfaces.dll.deploy |
11.0.3128.0 |
48,616 |
29-Dec-2012 |
05:22 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,432 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,448 |
29-Dec-2012 |
05:20 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,456 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,944 |
29-Dec-2012 |
05:23 |
|
Microsoft.reportingservices.diagnostics.dll.deploy |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Microsoft.reportingservices.diagnostics.dll |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:19 |
|
Reportingservicesnativeclient.dll |
2011.110.3128.0 |
155,624 |
29-Dec-2012 |
05:24 |
|
Reportingservicesnativeclient.dll |
2011.110.3128.0 |
190,464 |
29-Dec-2012 |
05:20 |
|
Reportingservicesnativeserver.dll |
2011.110.3128.0 |
153,600 |
29-Dec-2012 |
05:20 |
|
Sql_rs_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:19 |
|
Microsoft.datawarehouse.interfaces.dll.deploy |
11.0.3128.0 |
48,616 |
29-Dec-2012 |
05:22 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,432 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,448 |
29-Dec-2012 |
05:20 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,456 |
29-Dec-2012 |
05:17 |
|
Microsoft.datawarehouse.interfaces.resources.dll.deploy |
11.0.3128.0 |
19,944 |
29-Dec-2012 |
05:23 |
|
Microsoft.reportingservices.diagnostics.dll.deploy |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Microsoft.reportingservices.diagnostics.dll |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:19 |
|
Reportingservicesnativeclient.dll |
2011.110.3128.0 |
190,464 |
29-Dec-2012 |
05:20 |
For all supported x64-based versions of SQL Server 2012 Integration Services
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Msdtssrvr.exe |
11.0.3128.0 |
218,600 |
29-Dec-2012 |
05:20 |
|
Sql_is_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:19 |
For all supported x64-based versions of SQL Server 2012 Management Studio
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.analysisservices.wizard.v1.dll |
11.0.3128.0 |
601,064 |
29-Dec-2012 |
05:18 |
|
Microsoft.reportingservices.diagnostics.dll |
11.0.3128.0 |
1,359,336 |
29-Dec-2012 |
05:22 |
|
Microsoft.sqlserver.management.sqlstudio.dll |
11.0.3128.0 |
316,392 |
29-Dec-2012 |
05:24 |
|
Reportingservicesnativeclient.dll |
2011.110.3128.0 |
155,624 |
29-Dec-2012 |
05:24 |
|
Sql_ssms_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:19 |
For all supported x64-based versions of SQL Server 2012 Tools and Workstation Components
|
File name |
File version |
File size |
Date |
Time |
|---|---|---|---|---|
|
Microsoft.analysisservices.project.dll |
2011.110.3128.0 |
2,109,416 |
29-Dec-2012 |
05:22 |
|
Microsoft.datawarehouse.interfaces.dll |
11.0.3128.0 |
48,616 |
29-Dec-2012 |
05:22 |
|
Microsoft.sqlserver.chainer.infrastructure.dll |
11.0.3128.0 |
404,968 |
29-Dec-2012 |
05:22 |
|
Microsoft.sqlserver.configuration.sco.dll |
11.0.3128.0 |
2,035,176 |
29-Dec-2012 |
05:21 |
|
Sql_tools_keyfile.dll |
2011.110.3128.0 |
24,064 |
29-Dec-2012 |
05:19 |
Workaround
To work around this issue, manually pause the NGEN service manually if you have installed SQL Server 2012 SP1. However, we do not recommend that you apply this workaround because the NGEN service resumes as soon as you restart SQL Server or install other SQL Server updates.
