Feedback will be sent to By pushing the send button, your feedback will be provided to boost products and also services. Privacy policy.

You are watching: New features in sql server 2012

In this article

Applies to:

SQL Server (all sustained versions)

This release Notes document describes known concerns that you should read around before you download or troubleshoot SQL Server 2012). This release Notes document is available online only, not on the environment media, and also it is update periodically.

For information around how to acquire started and install SQL Server 2012, watch the SQL Server 2012 Readme. The Readme file is easily accessible on the installation media and from the Readme download page. You can likewise find much more information in SQL Server books Online and on the SQL Server Forums.

1.0 before You Install

Before installation SQL Server, consider the complying with information.

1.1 rules Documentation for SQL Server 2012 Setup

Issue: SQL Server Setup validates your computer system configuration prior to the Setup procedure completes. The various rules that room run during the SQL Server Setup procedure are captured using the mechanism Configuration Checker (SCC) report. The documentation around these setup rule is no longer obtainable on the MSDN library.

Workaround : You have the right to refer come the system configuration check report to learn an ext about these setup rules. The mechanism configuration check generates a report that includes a short description because that each enforcement rule, and also the execution status. The system configuration examine report is situated at SQL Server110Setup BootstrapLog\.

1.2 adding a local User Account because that the spread Replay Controller organization Might terminate Setup Unexpectedly

Issue: In the Distributed Replay Controller web page of SQL Server setup, once attempting to add a neighborhood user account for the distributed Replay Controller service, setup will certainly be terminated unexpectedly through a "SQL Server Setup failure" error message.

Workaround: during SQL setup, perform not add local user accounts via one of two people "Add present User" or "Add...". After setup, add a neighborhood user account manually by making use of the complying with steps:

Stop the SQL Server spread Replay controller service

On the controller computer on which the controller company is installed, native the command prompt, kind dcomcnfg.

In the Component services window, navigate to Console Root -> Component Services -> Computers -> My Computer -> Dconfig ->DReplayController.

Right-click DReplayController, and then click Properties.

In the DReplayController Properties window, top top the Security tab, click Edit in the Launch and also Activation Permissions section.

Grant the regional user account Local and also Remote activation permissions, and also then click OK.

In the access Permissions section, click Edit and also grant the regional user account Local and Remote access permissions, and also then click OK.

Click OK to close the DReplayController Properties window.

On the controller computer, add the neighborhood user account to the Distributed COM Users group.

Start the SQL Server spread Replay controller service.

1.3 SQL Server Setup might fail while trying to start the SQL Server web browser service

Issue: SQL Server Setup could fail when trying to begin the SQL Server internet browser service, through errors similar to the following:

The following error has actually occurred: organization "SQLBrowser" begin request failed. Click "Retry" to retry the failed action, or click "Cancel" come cancel this activity and continue setup.or

The following error has actually occurred: SQL Server browser configuration for attribute "SQL_Browser_Redist_SqlBrowser_Cpu32" was cancelled through user after ~ a previous installation failure. The critical attempted step: starting the SQL Server browser service "SQLBrowser", and waiting for as much as "900" secs for the procedure to complete.Workaround: This can occur when SQL Server Engine or analysis Services falls short to install. To settle this issue, refer the SQL Server Setup logs, and also troubleshoot the SQL Server Engine and evaluation Services failures. For an ext information, check out View and Read SQL Server Setup log Files. For much more information, see View and Read SQL Server Setup log in Files.

1.4 SQL Server 2008, 2008 R2 evaluation Services Failover cluster upgrade to SQL Server 2012 might fail after ~ renaming the network name

Issue: after ~ you change the network name of a SQL Server 2008, or 2008 R2 analysis Services failover cluster circumstances using the windows Cluster Administrator tool, the upgrade operation could fail.

Workaround: To resolve this problem update the ClusterName it is registered entry adhering to the instructions in the resolution section of this KB article.

1.5 installation SQL Server 2012 on home windows Server 2008 R2 Server Core company Pack 1

You can install SQL Server on windows Server 2008 R2 Server main point SP1, through the following limitations: SQL Server 2012 does not support Setup using the installation wizard on the Server core operating system. As soon as installing ~ above Server Core, SQL Server Setup supports complete quiet mode by utilizing the /Q parameter, or Quiet simple mode by making use of the /QS parameter.

Upgrade the an earlier version that SQL Server come SQL Server 2012 is not supported on a computer that is running windows Server 2008 R2 Server main point SP1.

Installing a 32-bit version of SQL Server 2012 edition is not supported on a computer running home windows Server 2008 R2 Server core SP1. SQL Server 2012 can not be set up side-by-side with previously versions the SQL Server ~ above a computer system that is running home windows Server 2008 R2 Server main point SP1.

1.6 Semantic Search needs You come Install an additional Dependency

Issue: statistics Semantic find has secondary prerequisite, the semantic language statistics database, i m sorry is not mounted by the SQL Server Setup program.

Workaround: To set up the semantic language statistics database together a prerequisite because that semantic indexing, execute the following tasks:

Move the database to an proper data folder. If you leave the database in the default location, friend must readjust permissions before you can attach it successfully.

Attach the extract database.

Register the database by phone call the save procedure sp_fulltext_semantic_register_language_statistics_db and also providing the name the you offered to the database when you enclosed it.

If these work are no completed, you will see the following error message once you shot to develop a semantic index.

Msg 41209, Level 16, State 3, heat 1 A semantic language statistics database is no registered. Full-text indexes utilizing "STATISTICAL_SEMANTICS" cannot be produced or populated.

1.7 installation Prerequisite managing During SQL Server 2012 Setup

The adhering to items define the prerequisite installation habits during SQL Server 2012 Setup:

Installing SQL Server 2012 is supported only on home windows 7 SP1 or windows Server 2008 R2 SP1. However, Setup does not block installation SQL Server 2012 on windows 7 or home windows Server 2008 R2.

The .NET frame 3.5 SP1 is a necessity for SQL Server 2012 when you select Database Engine, Replication, understand Data Services, report Services, Data top quality Services (DQS), or SQL Server administration Studio, and the frame is no longer set up by SQL Server Setup.

If you operation Setup top top a computer system with either the windows 7 SP1 or home windows Server 2008 R2 SP1 operation system, you must allow the .NET structure 3.5 SP1 prior to you install SQL Server 2012.

Use one of the following methods to permit .NET structure 3.5 SP1 on windows Server 2008 R2 SP1:

Method 1: use Server Manager

In Server Manager, click Add Features to display screen a perform of possible features.

In the Select Features interface, expand the .NET structure 3.5.1 Features entry.

After you expand .NET structure 3.5.1 Features, you view two examine boxes. One check box is for .NET frame 3.5.1 and also other examine box is for WCF Activation. Choose .NET framework 3.5.1, and also then click Next. You cannot install .NET framework 3.5.1 features unless the required duty services and also features are likewise installed.

In the Confirm installation Selections, testimonial the selections, and also then click Install.

Let the installation procedure complete, and also then click Close.

Method 2: usage Windows PowerShell

Click Start | All Programs | Accessories.

Expand Windows PowerShell, right-click Windows PowerShell, and also click Run together administrator. Click Yes in the User Account Control box.

At the PowerShell command prompt, kind the complying with commands and press go into after each command:

Import-Module ServerManager Add-WindowsFeature as-net-framework Use the following technique to permit .NET framework 3.5 SP1 on home windows 7 SP1:

Click Start | Control Panel | Programs, and then click Turn Windows features on or off. If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

To permit .NET structure 3.5.1, choose the examine box next to the feature. To turn a Windows attribute off, clean the examine box.

Click OK.

Use Deployment image Servicing and also Management (DISM.exe) to allow .NET frame 3.5 SP1:

You deserve to also permit .NET framework 3.5 SP1 making use of Deployment picture Servicing and also Management (DISM.exe). For an ext information about enabling Windows features online, see permit or disable Windows features online. The complying with are the indict to permit .NET framework 3.5 SP1:

At the command prompt, form the complying with command come list all of the features obtainable in the operating system.

sm /online /Get-Features Optional: in ~ the command prompt, type the following command to perform information about the certain feature you room interested in.

Dism /online /Get-FeatureInfo /FeatureName:NetFx3 kind the following command to permit a .NET structure 3.5.1.

Dism /online /Enable-Feature /FeatureName:NetFx3 The .NET frame 4 is a necessity for SQL Server 2012 . SQL Server Setup installs the .NET framework 4 during the feature installation step.

SQL Server 2012 refer does not install the .NET structure 4 as soon as installing top top the home windows Server 2008 R2 SP1 Server main point operating system. As soon as installing SQL Server 2012 express (Database only) .NET frame 4 is not required if .NET framework 3.5 SP1 is present. Once .NET structure 3.5 SP1 is not existing or when installing SQL Server 2012 administration Studio Express, SQL Server 2012 Express v Tools, or SQL Server 2012 refer with progressed Services, you need to install the .NET frame 4 prior to you download SQL Server2012 to express on a windows Server 2008 R2 SP1 Server core operating system.

To make sure that the intuitive Studio component can be installed correctly, SQL Server calls for you to install an update. SQL Server Setup checks because that the presence of this update and then calls for you come download and also install the update prior to you can proceed with the SQL Server installation. To stop the interruption throughout SQL Server Setup, you have the right to download and install the update as described below prior to running SQL Server Setup (or you can install all the updates for the .NET framework 3.5 SP1 that are accessible on home windows Update):

If you download SQL Server 2012 top top a computer system with the home windows 7 SP1 or windows Server 2008 R2 SP1 operating system, this update is currently installed on the computer.

Windows PowerShell 2.0 is a prerequisite because that installing SQL Server 2012 Database Engine components and also SQL Server management Studio, however Windows PowerShell is no longer installed by SQL Server Setup. If PowerShell 2.0 is not current on her computer, friend can allow it by complying with the instructions on the windows Management structure page. Exactly how you get Windows PowerShell 2.0 counts on which operating system you space running:

Windows Server 2008 - home windows PowerShell 1.0 is a feature and also can it is in added. Windows PowerShell 2.0 versions space downloaded and installed (effectively as an OS Patch).

Windows 7/Windows Server 2008 R2 - windows PowerShell 2.0 are mounted by default.

1.8 sustained Operating equipment for SQL Server 2012

SQL Server 2012 is sustained on the windows Vista SP2, home windows Server 2008 SP2, home windows 2008 R2 SP1, and also Windows 7 SP1 operation systems.

1.9 Sync structure Is Not consisted of in the environment Package

Issue: Sync frame is not had in the SQL Server 2012 surroundings package.

Workaround: Download the suitable version of Sync frame from this Download center page.

1.10 If visual Studio 2010 company Pack 1 is uninstalled, the SQL Server 2012 circumstances must it is in repaired to restore specific components

Issue:SQL Server 2012 (11.x) installation is dependency on some materials of the intuitive Studio 2010 company Pack 1. If girlfriend uninstall company Pack 1, several of the shared components are downgraded come their original versions, and a couple of other contents are completely removed native the machine.

Workaround: repair the instance of SQL Server 2012 (11.x) indigenous the original resource media or network environment location.

Launch the SQL Server Setup routine (setup.exe) native SQL Server surroundings media.

After prerequisites and system verification, the Setup program will display the SQL Server environment Center page.

Click Maintenance in the left-hand navigation area, and also then click Repair to begin the repair operation. If the Installation center was introduced using the Start menu, friend will require to provide the ar of the environment media in ~ this time.

Setup support ascendancy and file routines will run to ensure that your system has actually prerequisites installed and that the computer system passes Setup validation rules. Click OK or Install to continue.

On the Select Instance page, choose the instance to repair, and then click Next to continue.

The fix rules will run come validate the operation. To continue, click Next.

The Ready come Repair page suggests that the operation is prepared to proceed. To continue, click Repair.

The Repair Progress web page shows the status of the repair operation. The Complete page shows that the operation is finished.

For an ext information on exactly how to repair an circumstances of SQL Server, check out Repair a failure SQL Server 2012 Installation.

1.11 An circumstances of SQL Server 2012 could fail after ~ an OS upgrade

Issue: An instance of SQL Server 2012 can fail v the following error after you update the operating device to windows 7 SP1 from home windows Vista.

Setup has actually detected that the .NET structure version 4 demands to it is in repaired. Perform not restart your computer until Setup is complete.

Workaround: Repair your installation of the .NET frame 4 after you update your operating system. For an ext information, see exactly how to repair an existing installation that the.NET Framework.

1.12 SQL Server version upgrade calls for a restart

Issue: as soon as you edition upgrade an circumstances of SQL Server 2012, several of the functionalities linked with the new edition could not be caused immediately.

Workaround: Restart the an equipment after the edition update of an instance of SQL Server 2012. For much more information around supported upgrades in SQL Server 2012, see supported Version and also Edition Upgrades.

1.13 Database through read-only filegroup or papers cannot it is in upgraded

Issue: girlfriend cannot upgrade a database by either attaching the database or restoring the database from backup if the database or the files/filegroups are set to read-only. Error 3415 is returned. This issue also applies when performing an in-place upgrade of an instance of SQL Server. The is, you effort to change an existing circumstances of SQL Server by installing SQL Server 2012 and one or an ext of the existing databases is collection to read-only.

Workaround: prior to upgrading, ensure the the database and its files/filegroups are collection to read-write.

1.14 Reinstalling an circumstances of SQL Server Failover Custer fails if you use the same IP address

Issue: If you specify an untrue IP attend to during an environment of a SQL Server Failover cluster instance, the surroundings fails. After girlfriend uninstall the fail instance, and if you try to reinstall the SQL Server failover cluster instance with the same instance name, and correct IP address, the installation fails. The failure is due to the fact that of the duplicate resource group left behind by the vault installation.

Workaround: To settle this issue, use a various instance name throughout the reinstallation, or manually delete the resource group before reinstalling. For much more information, see add or remove Nodes in a SQL Server Failover Cluster.


2.0 analysis Services

2.1 SQL editor and also AS editor cannot attach to their respective server instances in the same SSMS instance

Issue: Cannot connect to an analysis Services server using the MDX/DMX editor once the SQL editor is already connected.

When utilizing SQL Server monitoring Studio 2012 (SSMS), if a .sql paper is open up in the editor and also is connected to a SQL Server instance, an MDX or DMX file when opened in the same instance of SSMS cannot attach to an instance of as server. Likewise, if an MDX or DMX file is currently open in the editor in SSMS and connected to an together server instance, a .sql document when opened up in the same instance of SSMS cannot connect to an circumstances of SQL Server.

Workaround: Use among the following options to solve this issue.

Start an additional instance of SSMS to open the MDX / DMX file.

Disconnect the SQL editor and also then connect the MDX / DMX editor to an as server.

2.2 Cannot produce or open Tabular Projects once BUILTINAdministrators team Name can not Be Resolved

Issue: You have to be one administrator on a workspace database server before you can develop or open tabular projects. A user can be included to the server administrators team by adding the user surname or group name. If you room a member the the BUILTINAdministrator group, girlfriend cannot produce or edit BIM documents unless the workspace database server is join to the domain from which it was originally provisioned. If you open or create the BIM file, it will certainly fail through the complying with error message:

"The BIM file cannot it is in opened. The server connected to is not valid. Reason: You space not an administrator of server ."


Re-join the workspace database server and also SQL Server Data tools (SSDT) computer to the domain.

If the workspace database server and/or SSDT computer systems are not going to it is in domain joined at every times, include individual user names rather of the BUILTINAdministrators group as administrators on the workspace database server.

2.3 SSIS materials for as Tabular Models perform Not work-related as Expected

SQL Server Integration services (SSIS) materials for analysis Services (AS) do not occupational as intended for tabular models. The adhering to are known worries that may take place when you try to create an SSIS package because that working with tabular models.

Issue: The AS connection Manager cannot use a tabular version in the exact same solution as a data source.

Workaround: You need to explicitly attach to the together server before configuring the AS handling Task or the as Execute DDL Task.

There are difficulties with the AS handling Task as soon as you work with tabular models:

Issue: rather of databases, tables, and partitions, you see cubes, measure groups, and dimensions. This is a limitation that the task.

Workaround: You can still process your tabular version using the cube/measure group/dimension structure.

Issue: part processing options supported by as running in tabular mode are no exposed in the AS processing Task, such as procedure Defrag.

Workaround: use the analysis Services Execute DDL task instead to execute an XMLA script that has the ProcessDefrag command.

See more: Read Pdf The Bullet Journal Method Pdf Download Free, The Bullet Journal Method

Issue: part configuration choices in the tool room not applicable. For example, "Process related objects" have to not be supplied when handling partitions, and the "Parallel Processing" configuration option consists of an invalid error post stating that parallel processing is not supported on the standard SKU.

Workaround: None


3.0 publications Online

3.1 assist Viewer for SQL Server Crashes in settings Configured to Run only IPv6

Issue: If your atmosphere is configured to run just IPv6, the aid Viewer for SQL Server 2012 will crash, and also you will be presented v the complying with error message: