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
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
  • 68,316
  • 31
  • 175
  • 255
20
votes
3 answers

Trying to add a new SQL Server user throws the error "is not a valid login or you do not have permission”

I am trying to add a new user to an SQL Server 2012 database using SQL Server Management Studio. I right-click and select 'Add User' under Security -> Users, fill out the user information, and click OK. Management Studio throws the the error…
culix
  • 551
  • 1
  • 3
  • 13
15
votes
3 answers

How to change default recovery for new databases?

How can i configure the database server on our development server so that when new databases are created that they are Simple recovery model by default? Currently if we remember, when creating a database we have to click on the options tab and…
Valamas
  • 355
  • 1
  • 4
  • 9
10
votes
1 answer

SQL Server express service is not starting

I've bought my first VPS yesterday, and I have installed Microsoft SQL Server 2012 Express on it. Then I have restarted my VPS. But SQL Server Service didn't start. I've tried to start it manually, but It can't start: What is the problem? How to…
Mahdi Ghiasi
  • 341
  • 2
  • 4
  • 15
8
votes
1 answer

Does an SQL Server instance allow both secure and non-secure connections at the same time?

we have an application running MS SQL Server 2012. For one specific use case we'd like to SSL protect the jdbc connection. I've checked the following links: How to enable SSL encryption for an instance of SQL Server by using Microsoft Management…
kaidentity
  • 183
  • 1
  • 1
  • 5
8
votes
1 answer

Very uneven CPU utilization with SQL Server 2012 on 2 processor computer with 16 cores / processor

After installing SQL Server Enterprise 2012 with the Server + Cal license model, on a computer with 2 processors each with 16 cores (and no hyperthreading involved) and putting the server under extremely heavy load the 16 cores on the first…
cooplarsh
  • 91
  • 1
  • 2
7
votes
1 answer

TLS Error 70 issues

I have a web application (IIS 8) on one server (Windows Server 2012) connecting to SQL Server Reporting Services 2012 on another server (Windows Server 2008) that until recently was working fine. About a week ago, it stopped working, and since…
Tom A
  • 218
  • 1
  • 3
  • 10
7
votes
1 answer

Can only connect to sql server express 2012 via named pipes

I have sql server express 2012 installed on windows 2008, locally everything works just fine i can connect via tcpip and named pipes. Remotely i can connect with ssms only using named pipes. By remote i mean within the same LAN, they are plugged…
YetAnotherDeveloper
  • 151
  • 7
7
votes
1 answer

SQL Server Debugging: "Unable to Step. Invalid operation"

I'm debugging a call to a Stored Procedure in SSMS (2012). Frequently, and various random points in the code, a dialog pops up: Microsoft SQL Server Management Studio: Unable to Step. Invalid Operation. Once I dismiss the dialog, it appears that…
CJM
  • 730
  • 2
  • 12
  • 28
7
votes
4 answers

Limitations of SQL Server 2012 Express version?

I'm aware that the SQL Server 2008 R2 Express was limited to 1 CPU and 10 GB Databases. It's not clear if Microsoft bumped those numbers up to be more reflective of 2012. I looked at several places but I still don't have a clear idea. Yes, I…
DeepSpace101
  • 698
  • 5
  • 12
  • 25
6
votes
4 answers

How do I install SQL Svr Native Client 10.1 after SQL 2012 has been installed

On a Windows Server 2012 I have SQL Server 2012 installed which has the SQL Server Native Client version 11. I am being told by a developer that he needs the SQL Server Native Client version 10.1 (SQLNCLI10.1). I downloaded a native client…
user49352
  • 123
  • 2
  • 4
  • 12
6
votes
0 answers

SQL server language media doesn't support the language of the OS

While trying to install SQL server 2012, I get the error: "SQL server language media doesn't support the language of the OS" I've downloaded the SQL server 2012 in English language only (2 times to make sure due to this silly feature/bug) and the…
TCM
  • 161
  • 6
6
votes
1 answer

Will SQL Server 2012 install + run Windows 2003

I can't seem to find any information but can I install SQL Server 2012 Standard Edition on a server running Windows Server 2003 R2 x64? I don't intend to use this for production just for testing and I am unable to rebuild the OS at the moment.
Seph
  • 185
  • 2
  • 2
  • 5
5
votes
1 answer

Medialayout Silent installation sp1 sql2012

My silent installation for SQL Server 2012 SP1 is failing and giving an error as below. Any ideas? TITLE: SQL Server Setup failure. SQL Server Setup has encountered the following error: The specified value for setting 'MEDIALAYOUT' is invalid. The…
demokritos
  • 153
  • 1
  • 5
5
votes
3 answers

SQL Server Collation settings for System Center Service Manager 2012

There is a lot of conflicting or confusing information surrounding the required collation settings for SQL Server, as it pertains to hosting the SCSM 2012 database and associated data warehouse databases. During installation, this error appears if…
MDMarra
  • 100,183
  • 32
  • 195
  • 326
1
2 3
…
17 18