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.

270 questions
27
votes
5 answers

What is SQL Server Core Edition?

I was browsing my technet downloads for SQL Server 2012 and I noticed a bunch of products labelled "core" edition: Is this something to do with their new per-core licensing model, or something else?
Mark Henderson
  • 69,083
3
votes
2 answers

Best Practice - SQL 2012 & IIS in VMWare

We are pretty new to VMWare and looking for some thoughts on our environment. We have a VMWare cluster that has on one host: VM#1: MS Windows 2008 R2 Enterprise & SQL Server 2012 VM#2: MS Windows 2008 R2 Standard & IIS The IIS asp.net app talks…
Dan Ribar
  • 31
1
vote
0 answers

[SQL Server Native Client 11.0]Unable to complete login process due to delay

We have one SQL Server 2012 Fail-over cluster instance where 11 database is running. Application is installed in different server. Application connects from application server to database server. Today application team informed us they got below…
Arif
  • 11
1
vote
2 answers

SQL Server 2012 support for TLS 1.2, 2 downloads, Which One?

If you disable TLS 1.0 and SSL 3.0 for PCI, SQL Server will stop working. SQL Server 2012 r2 out-of-the-box only supports SSL protocols up to and including TLS 1.0 by default. Unfortunately, PCI has required the obsolescence of SSL 3.0 and TLS 1.0.…
Michael Barber
  • 165
1
vote
1 answer

The server principal 'A' is not able to access the database 'B' under the current security context

I have a trigger that accesses another database. but I receive an error: "The server principal 'A' is not able to access the database 'B' under the current security context" Where A is is User login. I then set it to execute as a user which with…
jpo
  • 123
1
vote
0 answers

SQL Server Service refusing to start

Have attempted a number of things to get this service (SQL Server (MSSQLSERVER)) started without any luck Attempted to start service with local admin, domain admin, separate admin & standard accounts Attempted to change logon account for the…
Cold T
  • 2,401
  • 2
  • 18
  • 29
1
vote
1 answer

"CREATE DATABASE permission denied in database 'master'" to sysadmin user in SQL Server Express 2012

I'm seeing some odd behaviour with SQL Server 2012 Express Edition, where a sysadmin user does not have permission to create databases. The evolution of this installation has been somewhat trying: Host machine initialised SQL Server 2012 Express…
alastairs
  • 3,235
1
vote
5 answers

Accessing SQL with the PC name not the IP

I'm trying to connect to a SQL instance (default instance) on a machine. When using the IP of the machine it connects to the machine. Using the name of the machine on that machine you are able to establish a connection to the SQL instance but using…
Cornelius
  • 131
1
vote
0 answers

SQL Express 2012 - Unable to select "Force Encryption" option in SQL Configuration Manager 11

Sorry if this is a completely stupid question, but I don't know where else to look. I'm not seeing any options under the "Force Encryption" for my SQL Express 2012 instance. Here's a screenshot. screenshot of the issue Might be hard to tell, but the…
Blaine Lafreniere
  • 11
0
votes
1 answer

How to change concurrent users = 0?

First I was facing a network issue whenever I was trying to connect to my remote SQL Server. Some times the error was not shown and connected successfully but sometimes it was giving me this kind of error so to resolve this issue, I googled and…
Gayatri Gokhale
  • 101
0
votes
1 answer

default service account for maintenance plan backups on SQL Server 2012

What is the default service account used for backups created with the Maintenance Plan Wizard? I am trying to put the backup files on a share on a different server, and that service account will require access to the folder there.
Tim
  • 213
0
votes
1 answer

SQL Server 2012 Copy Database for Test DB fails

I'm trying to copy a database from our live system to the test system. (same Server, different DB) The Test DB has been deleted in preparation so we have a clean slate. I've tried backing up the DB, then restoring it but it fails saying it doesn't…
SysAdminUK
  • 113
0
votes
1 answer

SQL Server 2012 Service not starting (Probably related to Service Agent issue)

I have an application (Dynamics AX 2012) that can't connect to the SQL server. I log onto the SQL server, and open SQL Server Management studio and can't connect to the database engine. I check the Sql Server configuration manager and all the…
Doug
  • 101
0
votes
2 answers

SQL Server: Upgrade CPU or add a second CPU?

Currently have a 2 socket server with a single xeon e5-2407 @2.2Ghz running SQL Server 2012. There are no performance issues at the moment but wondering for the future if it would be better to upgrade the existing CPU (higher clock speed, more…
Fahd
  • 9
0
votes
1 answer

How do I upgrade sql server 2012 RTM to sql server 2012 SP1

I'm really confused by the 2 different editions of SQL Server 2012. There is RTM and SP1 which both seem like different code branches. How do I upgrade an RTM install to a SP1 install. I've tried upgrade and that doesn't let me choose the old RTM…
Terry Jones
  • 3
1
2