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
4
votes
3 answers

How to sysprep SQL Server Express?

We plan to deploy Hyper-V VHD with Windows Server 2008 R2 and SQL Server 2012 Express installed to multiple hosts. From my understanding, the correct way to do this is to install SQL Server in prepartion mode, sysprep Windows, then complete SQL…
Jim
  • 629
  • 2
  • 7
  • 20
3
votes
1 answer

IIS8 Application Pool Identity with Integrated Security to a SQL Server in a non-trusted domain?

Here is the scenario that we are experiencing and why we are trying to solve this: We are a consulting company that support a particular third-party software application for a number of clients. The application is written in ASP.NET and runs on IIS…
ACummins
  • 33
  • 4
3
votes
2 answers

SQL 2012 Standard - AlwaysOn FCI - Single point of contact?

I am looking at HA options for SQL 2012 Standard. I like the look of AlwaysOn FCI. I am using a SAN, so I think I can meet all of the requirements, but one of the applications I am looking at cannot have an alternative DB configured, only a single…
mwiggs
  • 33
  • 4
3
votes
1 answer

What happens to running queries when stopping a Microsoft SQL Server instance?

Consider that a MS SQL Server instance is executing a long-running query the service is stopped via services.msc or - as it actually happening - a system shutdown triggered by a UPS as the server is in a developing country which experiences rolling…
alifen
  • 165
  • 2
  • 11
3
votes
1 answer

Unattended installation of MS SQL Server (2008|2012) EXPRESS?

My goal is to install MS SQL Server 2012 R2 Express. I've downloaded SQLEXPRADV_x64_ENU.exe and used /ACTION=Install /UIMODE=Normal to generate and modify a configuration file. No matter how I fiddle with the configuration, it will either install a…
KlaymenDK
  • 135
  • 1
  • 7
3
votes
2 answers

Can I access the failover server on AWS RDS?

I am trying to create a working proof-of-concept in AWS for our web application which suddenly needs to scale out very quickly. Currently it is hosted on a local VMware server and we are migrating to AWS. I am working on configuring an MS SQL…
LegendaryDude
  • 204
  • 4
  • 10
3
votes
0 answers

Why is SQL Server using all ephemeral ports connecting to itself and causing TIME_WAITs?

I've got an AWS server with Windows 2008 R2, SQL Server 2012, and Tomcat 7. When I run netstat -ano the screen is flooded with TIME_WAIT. I posted the output in a Gist. When I run CurrPorts, filter on port 1433, and turn on Auto Refresh, I can see…
jordanbtucker
  • 159
  • 1
  • 1
  • 4
3
votes
1 answer

What are the downsides of running all SQL Servers under same domain account?

I am running two SQL Servers 2012 (for Always On) under the same domain account and would like to know what are the downsides in doing so. Few articles that I have read prior setting up the servers suggest different domain account for each sql…
jM2.me
  • 301
  • 2
  • 6
  • 15
3
votes
2 answers

Failover Cluster Client Access Point Only Responds to Pings on the Owner Node

Background We're running two VMs (Windows Server 2012 R2) on Azure with SQL Server installed, set up as an availability group. We also, of course, have another VM as a dedicated DC. These are all connected through a single Virtual network. This…
Matthew Haugen
  • 143
  • 1
  • 9
3
votes
1 answer

How can I set up a SQL file share that doesn't need sysadmin access to write to it?

We have a SQL Server 2012 installation with the file share feature enabled. We then have an IIS application that can write directly to the \localhost\MSSQLServer... share that the database creates. The problem I have is that to get this to work, I…
David Arno
  • 81
  • 5
3
votes
2 answers

Dealing with Stretch (Geo) Cluster Node Failures

Scenario: Three node (shared nothing) cluster on Windows Server 2012. Two nodes in the primary data center, both with votes (node weight = 1), and a file share witness. The third node is in a remote data center and has no votes (node weight of…
Steven Murawski
  • 1,570
  • 3
  • 14
  • 25
3
votes
2 answers

Restore transaction log backup - media family error

Our backup procedure is as follows: midnight full backup, every 8 hour differential backups, and every 5 minutes transaction log backups. Maintenance plans keep everything rolling and tidy. To restore to a specific point in time (let's say yesterday…
MikeMurko
  • 204
  • 2
  • 12
3
votes
3 answers

AWS RDS (SQL Server): SSL Connection - The target principal name is incorrect

I have a Amazon Web Services (AWS) Relational Database Service (RDS) instance running SQL Server 2012 Express. I've installed Amazon's aws.amazon.com/rds certificate in the client machine's Trusted Root Certification Authorities store. However,…
AX1
  • 1,269
  • 3
  • 23
  • 39
3
votes
1 answer

SQL Server 2012 Installation Hangs

We have a Windows 8 machine that we installed SQL Server 2005 on first. We then uninstalled it and installed SQL Server 2012 - unsuccessfully. The installation wizard hung at the point where it…
Rivka
  • 353
  • 2
  • 3
  • 12
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
  • 2
1 2
3
…
17 18