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, ...

learn more… | top users | synonyms

7
votes
1answer
839 views

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 ...
1
vote
1answer
2k views

SQL Server 2012 Maintenance Plan succeeds but does not perform backup

I have a new SQL Server 2012 AlwaysOn Availability Group on Windows Server 2008 R2 Ent SP1. I'm creating a Maintenance Plan on the Primary Replica which is supposed to do Full (non-copy-only) backups ...
-1
votes
1answer
3k views

Licensing SQL Server 2012 Reporting Services w/ SharePoint 2010 [duplicate]

Possible Duplicate: Can you help me with my software licensing issue? Here's my situation: I have 1 VM that is running SharePoint 2010 SP1. I have a different physical server that is ...
3
votes
2answers
2k views

SQL Server 2012 - Transparent Data Encryption not available in this edition

Let me start by saying that the instance of SQL Server 2012 I am attempting to set up TDE (Transparent Data Encryption) on, is the Enterprise edition. However, when following the MSDN tutorial ...
3
votes
2answers
2k views

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

Restarting MSSQLSERVER service on the principal or on the mirror the database is set in “In Recovery” mode

I'm running MSSQL Server 11.0.2100 (SQL Server 2012) and every time I restart the MSSQLSERVER service on the principal or on the mirror, the database mirror breaks and the database is set into In ...
1
vote
1answer
108 views

When using Transparent Data Encryption for SQL Server 2012, can you use different encryption keys for each database?

I am new to using TDE for SQL Server and one of the requirements that a client has is that their database be encrypted using a different key that is unique to only their database. I was wondering if ...
0
votes
1answer
136 views

SQL Server on Hyper-V on SQL Server 2012

I saw that this is the feature of AlwaysOn for SQL Server 2012. Can anyone explain the meaning of this? I mean can anyone give example or scenario? SQL Server on Hyper-V SQL Server instances hosted ...
3
votes
3answers
762 views

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

SQL Server 2012 using MSA — SharePoint 2010 Powershell backups impossible?

I'm having trouble trying to do a simple backup of our 2-server SharePoint 2010 farm. I'm running the backup process with a Powershell command, backing up to a UNC shared folder on the SharePoint ...
3
votes
1answer
607 views

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 ...
1
vote
0answers
1k views

PowerPivot dashboard no data - Last successful refresh run: The cube has not been processed

I used AutoSPInstaller to install my farm, I then installed PowerPivot 2012 and configured with the following script: # Open PowerShell library from: C:\Program Files\Microsoft SQL ...
4
votes
3answers
2k views

How do I configure active directory when Sql Server 2012 is using a Virtual Account?

I'm getting the following event log entry from Sql Server 2012: SQL Server Scheduled Job 'Replication agents checkup' - Status: Failed - Invoked on: 2012-08-04 10:00:00 - Message: The job failed. ...
2
votes
1answer
820 views

SQL Server 2012 Mirroring / AlwaysOn - need for SAN?

There appears to be a great deal of conflicting information about whether or not SAN is required for a Sql Server 2012 Mirroring setup. I currently have an Active-Passive-Witness SQL 2008R2 setup ...
2
votes
0answers
681 views

Grant Kerberos Constrained Delegation to SQL Server 2012 running as Managed Service Account

I can't see how to grant Kerberos Constrained Delegation for a service identified by a Managed Service Account. I have a Windows 2008 R2 functional level single domain single forest, two 2008 R2 SP1 ...
0
votes
1answer
1k views

error when trying to load SQL server 2008 R2 native client x86

There's technically 2 problems interlinked with each other here... I'm currently working on connecting to a mssql database from a website and testing everything through Xampp on a VM. When running ...
0
votes
1answer
102 views

Upgrading SQL Server 2000 to 2012

please is there any checklist available for upgrading SQL server 2000 to 2012? What is your experience with performing this? Could be the upgrade performed directly at all, or will I need to go ...
0
votes
0answers
31 views

Cannot log in to SQL 2012 - no known login [duplicate]

Possible Duplicate: How to recover a MSSQL user's password? We recently installed SQL 2012 on one of our servers, but have been unable to log in. Another tech did the installation so I ...
1
vote
1answer
454 views

Can an instance of amazon ec2 be upgraded automatically from sql server 2008 r2 to sql server 2012?

Is there a tool from Amazon or Microsoft to automatically upgrade an ec2 instance's sql server 2008 to 2012? Or do I have to create a new instance and then import all the databases?
0
votes
1answer
150 views

Upgrading SQL Server 2008 to 2012

I have SQL Server 2008 running on my development machine that I wish to upgrade to the 2012 release. In your experience, is it better to use the upgrade wizard or to remove the SQL Server 2008 and ...
1
vote
0answers
463 views

MSSQL 2012 cluster - inactive node trying to access shared disk?

I've got an odd issue with a SQL 2012 cluster. The cluster itself uses FC shared storage, and generally works perfectly. The SQL service works, and failover occurs as expected. The issue I have is ...
1
vote
1answer
428 views

How do I resolve the message “Validating WSFC quorum vote configuration - Action Required.”

I have a 3 node AlwaysOn Availability Group on a 3 node WSFC using node majority. 2 nodes are setup as synchronous with automatic fail-over, the 3rd is setup as asynchronous with manual fail-over. ...
3
votes
3answers
2k views

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 ...
13
votes
4answers
10k views

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 ...
5
votes
1answer
1k views

Should I Use the Default SQL Server 2012 Accounts or Make Specific Ones?

I'm installing the 180 day trial of SQL Server 2012 on a virtual machine with the intent of buying a license for it later on. From past experiences with installing SQL Server I would always make ...
3
votes
3answers
9k views

AlwaysOn SQL Server 2012 - any option for true active/active?

I'm about to upgrade and consolidate a group of SQL Server 2008R2 to a single SQL Server 2012. I want have high availability and looking for the different options. The number of databases is fairly ...
-4
votes
1answer
454 views

Is SQL Server 2012 Express Edition a Production Release? The download still has RC on the end

I though SQL Server 2012 Express Edition was "Released for Production", however when I download it, it still states "RC". Maybe I don't understand "RC" fully, but I though that was just before the ...
2
votes
1answer
442 views

Cannot log in to SSRS 2012 using any account

I have installed SQL Sever 2012 along with Reporting Services. I have configured Reporting Services using the Reporting Services Configuration Manager. It seems like the service is running properly, ...
1
vote
3answers
2k views

SQL Server 2012 and SQLMail - will it still work?

We are considering upgrading our SQL Server, which is currently running 2005. We use SQLMail heavily in the organization, both to send e-mails and to import some into a database. I've read on various ...
-4
votes
1answer
998 views

Does SQL Server 2012 Developer Edition exist? [closed]

On my server, I have SQL Server 2008 R2 Developer Edition installed, and setup don't want to upgrade it to SQL Server 2012 Express. Does SQL Server 2012 Developer Edition exist?
3
votes
1answer
783 views

Is SQL Management Studio 2012 avaliable, without Engine itself?

On my dev machine, I have SQL Management Studio 2008 R2 installed. I tried to upgrade to SSMS 2012 Express, setup finished but nothing happened. Is it possible to get SQL Management Studio 2012 ...
0
votes
2answers
3k views

SQL server agent job to execute SSIS package fails, package succeds if run manually

I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is ...
0
votes
1answer
2k views

Converting Sql Server 2012 RTM from trial to licensed edition

Similar questions have been asked about 2008, but there appears to be a dearth of information on SQL Server 2012. Does it require a reinstall? Will it go through an upgrade process (and what does ...
0
votes
1answer
1k views

sqlcmd backup script failing

I'm trying to use a simple batch script to backup a local instance of SQL Express 2012, as follows: @echo off SET BACKUP_DIR=E:\BackupData SET SERVER=.\\sqlexpress set dom=%date:~0,2% set ...
1
vote
0answers
765 views

SQL Server 2012 - Linked Server to SQL Server 2000

I'm trying to use the SQLNCLI 10 driver to set up a Linked Server to a legacy SQL Server 2000 instance on our network. I understand you cannot use Version 11 as it doesn't support SQL Server 2000 ...
3
votes
2answers
3k views

destination directory for SQL Server 2012 is greyed out

I tried to install SQL Server 2012 Standard on Windows 2008 and on Windows 7 (I only wanted to install management studio on Win7). Same ISO; both machines are newly built. However, on Windows 7 Shared ...
2
votes
1answer
95 views

What are the exact storage requirements for an AlwaysOn implementation?

We're investigating implementation options for SQL Server AlwaysOn. AlwaysOn is dependant on Windows Clustering, and I have read several articles that state shared storage is no longer a requirement ...
7
votes
4answers
25k views

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 ...