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
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
  • 1
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
  • 2
0
votes
2 answers

Add SQL-feature with what Servicepack

I need to add an SQL-feature (SQL-replication) to an existing SQL-instance. It's SQL Server 2012 Standard SP1 that has been upgraded to SP3 a few years ago. What installation media should I use to add the SQL-feature? SQL Server 2012 Std with SP1…
Andreas
  • 309
  • 1
  • 5
  • 17
0
votes
1 answer

How to keep Active Directory and SQL users from breaking after a database restore?

I'm trying to copy production CRM MSSQL data to another isolated server stack (server 2) via a backup-and-restore process. Server 2 already has most of the data after a restore I did from the production data backup a few months ago. The initial…
Cohaven
  • 51
  • 6
0
votes
1 answer

How to run SQL server 2012 instead of 2014 when both are installed and 2014 is currently running?

I need to backup a DB using SQL server 2012 to match another server it is going to. However on my local machine I'm currently running 2014. I can see that SQL server 2012 is installed along with various other versions. How can I change which…
Rob
  • 31
  • 7
0
votes
1 answer

Transaction backup job is run event Full and Different job can't run

I'm very new to DBA. I've SQL SERVER 2012. On that, Backup schedule jobs(under Maintenance Plan) runs for Full, Differential and Incremental Backups. The specific DB are selected in SSMS, . Full and Differential .bak are missing after…
Pugal
  • 103
  • 3
0
votes
2 answers

schedule backup job runs up to 9 hrs without errors

I'm very new to administration job... I have SQL server 2012, on that my senior scheduled a job for schedule backup. But, recently I noticed, after 8-May-2018(up to 26-May-2018) the backup files are missing. Then I realize that, the schedule job …
Pugal
  • 103
  • 3
0
votes
0 answers

Amazon RDS SQL Server permissions with legacy application

I am trying to run a legacy Windows application in AWS without modifying the code. The application uses Windows Authentication for the DB connection so this is what I have set up: a Simple Directory Service instance (with "real" AD not the Samba…
macbutch
  • 141
  • 7
0
votes
1 answer

How to restart windows server - not just SQL Server after a job completes?

I know. It's a stupid question, or at least a dangerous one, but my supervisors are having to restart DP jobs every time I run a LOG truncation job that reduces the size of our LDF file from what was 300GIG down to 5GIG. This is because the…
Fandango68
  • 103
  • 5
0
votes
0 answers

SQL Server 2012 not reinstalling

I have uninstalled everything from control panel with sql server 2012 It can never get past the first window of installation which has product key, license terms, product updates, install Setup files. after it has has installed Setup files the next…
BobTheCat
  • 1
  • 1
0
votes
1 answer

sql server 2012 service not running

When starting my VM with windows server 2012 R2 which is my SQL-server, I get the following error: My SQL-server service won't run if I start it or if it gets started automaticly. What I have done so far: Ran C:\Program Files\Microsoft SQL…
SPottuit
  • 111
  • 3
  • 7
0
votes
2 answers

Not sending mail job notifications

I have a job created to do a backup of all my dbs with a schedule time and I have set to this job a notification by mail to my email when the job completes, but I am not receiving any. So I will post here what I have done to set this notitication to…
marafado88
  • 412
  • 2
  • 9
  • 31
0
votes
1 answer

SQL server authentication is grayed out when connecting to integration services

Why SQL server authentication is only available for connecting to Database Engine but grayed out for rest of all services, AS, RS and IS? I am on SQL Server 2012. How can I enable the sa login to AS, RS and IS?
Root Loop
  • 902
  • 4
  • 24
  • 45
0
votes
1 answer

Unable to login to stand alone SSRS 2012 from domain joined computers

We have a non-domain joined SQL 2012 server running in Azure supporting several web sites, earlier this week an issue popped up where domain joined computers could not log in. There were no updates or changes applied to the server, no login errors,…
Matt Bear
  • 874
  • 3
  • 12
  • 28
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.
TRomano
  • 111
  • 7
1 2 3
…
17 18