Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2012]

Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is a version of Microsoft's SQL database server software. It includes new features and upgraded functionality from its predecessor, SQL Server 2008 R2, went RTM on March 6th, 2012 and to general release on April 1st, 2012.

SQL Server 2012 logo

Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is the latest version of Microsoft's SQL database server software. It includes new features and upgraded functionality from its predecessor, SQL Server 2008 R2, went RTM on March 6th, 2012 and to general release on April 1st, 2012.

SQL Server 2012 is available in several "mainstream" editions, as well as some "special" editions not widely available for wide, such as a Development edition, an Azure edition and a Massively Parallel Processing Edition.

The mainstream editions are:

  • Enterprise Edition
  • Business Intelligence Edition
  • Standard Edition
  • Express Edition
  • Web Edition
  • Compact Edition

The complete feature set of SQL Server 2012 is massive, and probably too big to list, but Microsoft has a large page devoted to the topic, and includes feature comparison across the various mainstream editions. SQL Server 2012 adds new features focused on increasing the availability and scalability of the SQL Server product line, most notably a "AlwaysOn High Availability" feature, a dedicated Disaster Recovery feature, "scale-out reads" functionality and database mirroring capabilities.

268 questions
5
votes
1 answer

Re configure TFS 2012 reporting services

I have a TFS 2012 installation that is working perfectly. I've installed TFS using advanced configuration and choose to not configure at that moment the Reporting and Sharepoint features. Now, I want to configure the Reporting but when I try to do…
Agustin Meriles
  • 205
  • 4
  • 12
5
votes
2 answers

SQL Server 2012 - Transparent Data Encryption not available in this edition

Let me start by saying that the instance of SQL Server 2012 I am attempting to set up TDE (Transparent Data Encryption) on, is the Enterprise edition. However, when following the MSDN tutorial tutorial, I get to the following line: create database…
bobble14988
  • 235
  • 2
  • 8
5
votes
1 answer

Should I Use the Default SQL Server 2012 Accounts or Make Specific Ones?

I'm installing the 180 day trial of SQL Server 2012 on a virtual machine with the intent of buying a license for it later on. From past experiences with installing SQL Server I would always make specific user accounts for the SQL Server to use.…
Gup3rSuR4c
  • 661
  • 3
  • 14
  • 29
5
votes
3 answers

AlwaysOn SQL Server 2012 - any option for true active/active?

I'm about to upgrade and consolidate a group of SQL Server 2008R2 to a single SQL Server 2012. I want have high availability and looking for the different options. The number of databases is fairly high (150+) so DBMirroring is out of the…
NicolajB
  • 93
  • 1
  • 1
  • 5
5
votes
3 answers

destination directory for SQL Server 2012 is greyed out

I tried to install SQL Server 2012 Standard on Windows 2008 and on Windows 7 (I only wanted to install management studio on Win7). Same ISO; both machines are newly built. However, on Windows 7 Shared features directories are set to C:\Program…
Felix
  • 543
  • 5
  • 10
  • 23
4
votes
1 answer

Best practice for application logging database replacement

Our web apps (30 or so) log application specific stuff to a centralized logging database (Sql Server 2012) with log4net, so the logging database gets huge quickly. Thus we decided to replace it every year, like renaming the current logging database…
Yoo Matsuo
  • 91
  • 4
4
votes
0 answers

Local DTC is missing on server 2008r2

I've recently had an issue where MSDTC was unable to start up. The error in the command line when running net start msdtc indicated that there were configuration issues. I went into the registry and set the configuration settings to the same values…
Reaces
  • 5,597
  • 4
  • 38
  • 46
4
votes
2 answers

How much memory does my SQL need?

I have a VM (SQL database server) that I think has more memory then it needs, however I'm not sure what I can reduce it to because I don't understand exactly what "In use", "Available", "Committed" and "Cached" memory mean. The following is a…
kralco626
  • 143
  • 5
4
votes
1 answer

Random connection failures between IIS8 and MSSQL 2012 in RackSpace Cloud

Background For years I hosted all of my server functionality, including IIS, Apache, MySql, and MSSQL on a single server instance, yikes! As my client base grew this led to persistent SQL Timeouts when the server got busy. Over the past year I've…
Ty H.
  • 178
  • 1
  • 8
4
votes
1 answer

Regarding High Availability for MSSQL Server

Already used in MySQL : Real Time Replication (synchronization) between primary and secondary server is done using master and slave commands. So What is the equivalent feature for MsSQL. Which Replication method should be used for real time…
darshan doshi
  • 51
  • 3
4
votes
1 answer

High Available SQL Server without SAN by using AlwaysOn feature

I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced. AlwaysOn is a new feature in SQL Server 2012 that is designated to High availability solutions. I must say that…
Pooya Yazdani
  • 277
  • 5
  • 12
4
votes
2 answers

Unable to Install SQL Server on Server 2012

The problem I have been trying to install SQL Server 2012 on Windows Server 2012. I continually get the same error: Managed SQL Server Installer has stopped working Problem signature: Problem Event Name: CLR20r3 Problem Signature 01:…
Jeff
  • 701
  • 8
  • 13
  • 26
4
votes
1 answer

SQL Server 2012 Management Studio Express - no server

I am having trouble with SQL Server 2012 Management Studio. There is no server name. Earlier I installed the 2008 version but something wasn't right so I uninstalled and installed 2012. Upon installation 2nd time round there wasn't an instruction…
Adrian McGuinness
4
votes
3 answers

How do I configure active directory when Sql Server 2012 is using a Virtual Account?

I'm getting the following event log entry from Sql Server 2012: SQL Server Scheduled Job 'Replication agents checkup' - Status: Failed - Invoked on: 2012-08-04 10:00:00 - Message: The job failed. Unable to determine if the owner (AD\Administrator)…
Mike
  • 1,271
  • 5
  • 18
  • 31
4
votes
0 answers

Grant Kerberos Constrained Delegation to SQL Server 2012 running as Managed Service Account

I can't see how to grant Kerberos Constrained Delegation for a service identified by a Managed Service Account. I have a Windows 2008 R2 functional level single domain single forest, two 2008 R2 SP1 DCs, newly built. I have installed my new SQL…
Alasdair C-S
  • 329
  • 1
  • 7
1
2
3
…
17 18