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

learn more… | top users | synonyms

2
votes
1answer
721 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
599 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
99 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
380 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
143 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
439 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
373 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
7k 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
4answers
8k 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
442 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
394 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
943 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
677 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
2k 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 ...
1
vote
0answers
699 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
2k 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
94 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 ...
5
votes
4answers
22k 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 ...