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
0
votes
1 answer

SQL Server 2008 side-by-side with SQL Server 2012, possible issues with SAP Business One 8.81 PL:07?

We have a Windows Server 2008 R2 Enterprise system running SQL Server 2008 Enterprise (x64) version 10.0.4067.0 and SAP Business One 8.81 PL:07. We would like to install a named instance of SQL Server 2012 (side-by-side with 2008), leaving all the…
Ethan
  • 103
  • 5
0
votes
1 answer

Configuring SQL Server 2012 instance to have multiple instance names

I just installed SQL Server 2012 Standard Edition and set up a new default instance. Is there a way to "forward" connections from the old .\sqlexpress to the new default instance? Or do I need to hunt down and change all connection strings?
Mike Cole
  • 203
  • 2
  • 5
  • 15
0
votes
1 answer

Multiple SQL Standard Instances on 4 Processor/32-core Server

We have a large 4 processor/32-core server with 192GB of memory available in the data center and over twenty small SQL Standard databases to consolidate. They are a mix of SQL 2012 and 2008 R2 for 3rd-party apps. Is there any issue with simply…
Theowood
  • 1
0
votes
2 answers

Unable to connect to SQL Server 2012 Enterprise local instance

Just installed SQL Server 2012 Enterprise on my work machine, and I'm unable to connect to my local instance (MSSQLSERVER). I get the "Login failed..." message. I enabled the SQL Server Browser service, and have tried many different combinations of…
smoothgrips
  • 115
  • 1
  • 4
0
votes
1 answer

SQL Server 2012 Evaluation has stopped working: is that expiration behavior?

We placed an order for physical media and CALs when the evaluation expired last week. SSMS said the evaluation had expired, and it would not connect to the database. The package with the CALs has not arrived yet and this morning the SQL Server…
Tim
  • 203
  • 1
  • 4
  • 11
0
votes
1 answer

Get permissions in fixed or user-defined server roles in SQL Server 2012

I'd like to know how to get a list of permissions that belong to fixed and/or user-defined server roles in SQL Server 2012. In previous versions there was an sproc sp_srvrolepermission but this is deprecated in 2012 and it returns only permissions…
rwwilden
  • 369
  • 1
  • 5
  • 13
0
votes
3 answers

SQL 2012 server alias works locally but not remotely

I'm preparing for a server migration and am attempting to redirect a named instance of SQL Server 2012 (DW) to the default instance. There is currently no DW instance on the test server - I'd like to avoid re-creating it and consolidate all of our…
davejroth
  • 3
  • 1
  • 2
0
votes
1 answer

AlwaysOn Automatic Failover Using Two Nodes with SQL Standalone Instances

We are building a new SQL 2012 cluster for our web environment. We decided to use two nodes and utilize AlwaysOn Availability Groups for High Availability. Server01 and Server02 have had a Standalone Instance of SQL installed and both have been…
Dion Pezzimenti
  • 177
  • 1
  • 1
  • 10
0
votes
0 answers

Allow VM2 access VM1's SQL Server Database

I have two VMs running on a Mac Server using VM Fusion 4. Both VMs are running windows 7, and I have SQL Server 2012 installed and data imported into VM1. Right now, I'm trying to figure out a way to access the data on VM1 from VM2. I have tried to…
Firyn
  • 111
  • 2
0
votes
0 answers

Failure running SQL2012 on Windows 8 with local service accounts

I have installed SQL2012 on a Windows 8 laptop that is on a domain. The domain includes a group policy that defines accounts that can "Log on as a service". I installed SQL Server 2012 using the default settings, including the use of local service…
Martin Robins
  • 109
0
votes
1 answer

SQL Server 2012 Multiple Instance Priority

I'm in the process of upgrading our small SQL databases to SQL Server 2012. We have at least 3 instances, (1) Critical work databases, (2) low-importance System Maintenance databases, (3) WSUS. Can I specify a priority with which these instances…
Dom
  • 741
  • 1
  • 8
  • 19
0
votes
1 answer

LINQPad and SQL2012 management studio cannot talk to network Database Servers (SQL2008R2)

I installed LinQPad 4.0 on my machine. LinQPad can talk to local database servers on my machine, but cannot communicate or add a connection to network database servers on the network. SQL2008 Management studio on my same machine can talk to these…
Mohan Deval
  • 1
0
votes
1 answer

Package run on SQL Server Job Agent - Login failed for user

I created a package on my SQL Server (2012) through the import/export data wizard which exports data to another SQL Server (2008). I set up a job which runs this package but I get an error: Description: Failed to decrypt protected XML node…
Rivka
  • 353
  • 2
  • 3
  • 12
0
votes
1 answer

DB access account for SharePoint 2013

I am installing SharePoint Server 2013 on Windows Server 2008 R2 SP1 with SQL 2012 on a VMware. During the SharePoint Configuration Wizard, I need to provide a DB access account. The VM is not part of a domain as well. I tried VMname\Admin &…
user1847609
  • 145
  • 1
  • 7
0
votes
1 answer

SQL Server 2012 Memory usage

Since i upgraded to SQL Server 2012 I've noticed that it almost doesn't consume any memory at all. Before when i used SQL Server 2008 R2 it used at least 2-4 GB of RAM and now it only used like 150 MB or something. I haven't really noticed any…
Olaj
  • 183
  • 1
  • 2
  • 8
1 2 3
…
17 18