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

0
votes
1answer
23 views

PowerShell 'get-ClusterQuorum' output is not showing 'QuorumType' column

PowerShell cmdlet get-ClusterQuorum output is not showing QuorumType column. Has anybody seen this before?
0
votes
1answer
20 views

What happens when Core Cluster Group is failed over to another node? Will it take the whole cluster down? Single point of failure?

http://bit.ly/1lKJFIa "Cluster group" fail-over will cause cluster go offline. Really? Single point of failure? Am I missing something? What happens when Core Cluster resources (Cluster Group) are ...
0
votes
0answers
15 views

SQL Server 2012 : recover lost symmetrical encryption key or just disable encryption

We currently face a huge problem and we hope you can help us. We have two systems (Dynamics CRM 2013) on two different servers, both use SQL Server 2012. One on our dev server the other on our live ...
0
votes
0answers
9 views

SqlServer 2008/2014 different Collation on column names and data?

We're trying to migrate an third party application from DB2 to SqlServer. DB2 seems to be case insensitive when it comes to column names. The problem is that the application for some reason uses ...
0
votes
0answers
18 views

migrate plus move existing biztalk server database from sql server 2008 R2 to sql server 2012

we are planning to move biztalk database from one place to another as well as upgrade the sql server. the initial database is in sql server 2008 R2 and target is sql server 2012. but the thing is ...
0
votes
0answers
12 views

Can't successfully install Sql Server 2012 Dev Edition

I don't know if this best place to pose this problem, but here goes. I am trying to install Sql Server 2012 Developer Edition on my Windows 7 64-bit workstation, and keep getting a failure to install ...
1
vote
1answer
44 views

SAN Synchronous Replication and SQL Server - Is RPO of 0 possible?

I am working on a solution that is using SQL Server 2012 SP2, but without the use of AlwaysOn availability groups. This is due to cross-database transactions, that does not work for this scenario. ...
1
vote
0answers
15 views

SQL Server Background Task Running?

I am developing a web application, which consists of a .NET application, using Entity Framework, and MS SQL 2012 back end. Every now and then we experience a slowdown in the system, which causes ...
1
vote
1answer
60 views

Can SQL server 2012 Service Pack 2 be applied to an Express Edition instance?

I need to upgrade an instance of SQL Server 2012 Express Edition (SP1) to Service Pack 2. Can the standard Service Pack 2 package be applied to an Express Edition instance, or do I need to run the ...
1
vote
0answers
53 views

MSDTC Errors: QueryInterface failed for “ITransactionDispenser”: 0x8004d01c(XACT_E_CONNECTION_DOWN)

I’m having some issues with a server where MSDTC is not working properly. This started happening about two days ago. I’ve tried a number of different things including restarting the VM and I’ve ...
0
votes
0answers
33 views

Remove Cluster Nodes after Cluster Object was deleted

While building new 2012 servers to move to we had some change in requirements. We are using Availability Groups on the new servers. Here's where we started. Servers: Serv1a Serv1b Serv2a Serv2b ...
2
votes
1answer
31 views

Does an SQL Server instance allow both secure and non-secure connections at the same time?

we have an application running MS SQL Server 2012. For one specific use case we'd like to SSL protect the jdbc connection. I've checked the following links: How to enable SSL encryption for an ...
0
votes
0answers
25 views

Is it possible to store a credential for Windows Authentication to an Analysis Services server?

SQL Server Analysis Services uses Windows authentication for server connections. Typically, you assign your domain account to a role (or the server administrator list), and then connect to the server ...
2
votes
1answer
141 views

5.7.1 SMTP error when running stored proc using DB Mail in SQL Server 2012

I am getting an error in SQL Server 2012 Database Mail when executing a stored proc to send an email from a specified address to a specified address using Office 365 as the SMTP server. The mail ...
0
votes
2answers
65 views

Add an Excel file as a linked server in SQL 2012

I'm trying to add a linked server to an Excel 2010 file from SQL Server 2012. Every reference I've found online for doing this is using older versions of SQL Server, and the driver that they tell you ...
2
votes
0answers
35 views

Failover_Partner connection in file DSN not working

I have an application which uses file DSNs to connect to a central database server. This database server is mirrored onto a secondary server, and in the event of a failover, it is my understanding ...
1
vote
1answer
120 views

deploy ssis 2012 packages on 2008r2 server

We've developed SSIS packages on ssis 2012, but now upon deployment, we need to deploy these to sql server 2008. I've been searching but haven't found a solution to do this. Is this even possible and ...
0
votes
1answer
74 views

SQL Server Management Tools available on SQL Server 2012 express?

My goal is to access a server with some cube data and query it. If I understand correctly I need Analysis Services in order to accomplish this. My Current install of SQL Server Management Studio ...
1
vote
0answers
36 views

MSTDC in SQL Server 2012 - Windows Server 2012 R2 with high availability

We had implemented SQL Server High Availability on two physical servers over the VPN network. SQL Server 2012, Windows Server 2012 R2. It was noted that, Distributed Transaction was working perfectly ...
0
votes
0answers
22 views

SQL Server Reporting Services 2012 Chinese Language

When running reports in SQL Server 2012 Reporting Services (SSRS), Chinese (Asian) characters show up as question marks (?). Any idea on how to have the characters display properly in reports? ...
1
vote
1answer
95 views

MS SQL Server connection reset on AWS if column has more than 39kb

We migrated an app that does some business inteligence, so it does manage a lot of data. This app works perfectly on our own environment, but when running in AWS we received a lot of "connection ...
1
vote
1answer
590 views

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

SQL 2012 SQL server Agent Jobs

I am trying to figure out how to troubleshoot a situation with SQL Server Agent (2012). A job that has been running nightly (user SQL Server Agent as its scheduler) for over a year in 2 to 4 seconds ...
0
votes
1answer
67 views

SQL Server database backup to Windows Azure Recovery Service

I have some VMs on Windows Azure and IIS and SQL Server 2012 is installed on them. I also created a Backup Vault on Windows Azure and installed the Windows Azure Backup Agent on the VMs. It works ...
1
vote
0answers
55 views

Can SharePoint 2013 and Microsoft Dynamics GP 2013 run on the same server?

We have a new Windows 2012 server with SQL Server 2012 and Microsoft Dynamics GP 2013 running on it. I have been asked to install SharePoint 2013 on this server also. I know GP 2013 now uses SSRS for ...
1
vote
1answer
21 views

Error in cross server sqlcmd execution due to firewall issue

I have an application server with an IP of 10.107.0.100 and one database server on which SQL Server 2012 is installed, with an IP of 10.107.0.101. Remote connections are made to this server, and the ...
4
votes
1answer
63 views

Regarding High Availability for MSSQL Server

Already used in MySQL : Real Time Replication (synchronization) between primary and secondary server is done using master and slave commands. So What is the equivalent feature for MsSQL. Which ...
0
votes
2answers
274 views

SQL Server 2012 Reporting Services to export CSV

I have an SQL Server 2012 Reporting Services instance, and by default, it can only export to PDF, Excel and Word. Users require CSV export as well. All I found is that there are different extensions, ...
-1
votes
0answers
42 views

CPU 99% in new server [closed]

Two of our clients have recently upgraded to brand new servers running Windows server 2012, but servers worked great for a while (a month or so) after that the cpu utilization is steady at 99% At ...
2
votes
1answer
66 views

Shrinking Database using the AUTO_SHRINK ON , helpful or is it consuming to many resources?

I have multiple databases which are constantly growing. So from time to time, I truncate the log table and shrink the biggest databases. For the biggest one (>40gb) it takes quiete some time. So I ...
1
vote
2answers
28 views

Is this the correct way to wait for an idle database catalog before restoring a log (for Sql Server log shipping)?

I want to have a separate instance of Sql Server dedicated to a "reporting" role. I've decided to populate that server via Log Shipping (since mirroring won't work, and Availability Groups is ...
1
vote
1answer
47 views

Installing SQL Server 2012 on older instance

I have SQL Server 2008R2 installed on my server which I can connect either by providing server name "xyz" or IP address "127.xx.xx.xxx". Does it mean my installation is done with default instance? ...
0
votes
1answer
46 views

How can I get SQL 2012 Web Edition?

If I want to get a copy of SQL 2012 Web Edition, do I have to go through a hosting provider such as Rackspace? What about if I am in the MS Select program and a Volume Licensing account? How is it ...
1
vote
0answers
148 views

SQL Server 2012 permissions from AD group login not refreshed until server restart

We have some IIS sites which runs under Managed Service Accounts (Windows Server 2012). Theese MSAs are members of resource groups in Active Directory. We are using resource groups as logins in SQL ...
0
votes
2answers
117 views

SQL Server Failover Cluster on Azure (HA Strategy)

In the context of SQL Server 2012 Standard Edition, is it possible to make Azure Blob storage available to a SQL Failover cluster directly as a shared SCSI resource on a Windows Cluster? An Azure blob ...
-1
votes
1answer
95 views

Unable to install SQL Server 2012

Unable to install SQL Server 2012 Error SQL Server Setup has encountered the following error: 1: 2229 2: Q:\PCUSOURCE\1033_ENU_LP\x86\setup\x86\sqlncli.msi 3: Property 4: SELECT Value FROM Property ...
1
vote
0answers
163 views

SQL Server 2012 Cluster BSOD

I'm trying to set up a SQL Server 2012 SP1 "AlwaysOn Failover Cluster Instance" on top of a Windows Server 2012 R2 cluster (cl01) consisting of 2x 2012 R2 nodes (sql1 and sql2). Hosted on VMWare ESXi ...
0
votes
0answers
141 views

Disabling locked page allocations in SQL Server 2012

Locked page allocations are enabled in my instance of SQL server 2012 even though I have no accounts with the "lock pages in memory" user right. This article by Microsoft - ...
0
votes
0answers
98 views

Use AWS ephemeral drives for SQL Server for redundancy/read-only/other live purposes

Are there any good uses for the ephemeral drives on AWS Windows instances when using SQL Server besides putting TempDB and the pagefile there? I'm wondering, for example, if one could replicate the ...
0
votes
1answer
152 views

How do I upgrade sql server 2012 RTM to sql server 2012 SP1

I'm really confused by the 2 different editions of SQL Server 2012. There is RTM and SP1 which both seem like different code branches. How do I upgrade an RTM install to a SP1 install. I've tried ...
0
votes
0answers
48 views

Automatic failover in SQL server alwayson availability group

I have 2 nodes in my SQL server fail over cluster. I use SQL server 2012 always on feature for HA purpose. The problem is that when one my server goes down the automatic fail over does not happen! ...
0
votes
1answer
231 views

SQL server databases are stucked in restoring state

I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that ...
0
votes
1answer
656 views

SQL Server 2008/2012 Express install fails on scenarioengine.exe [closed]

I'm trying to install SQL Server 2012 Express on a Windows 7 64-bit PC. It also fails to install SQL Server 2008 R2. The bootstrapper extracts all the files, runs setup.exe (with UAC popup) then ...
3
votes
1answer
62 views

High Available SQL Server without SAN by using AlwaysOn feature

I have two Microsoft SQL Servers (v 2012) and I want to make them mirror and when one of them goes down the second one will be replaced. AlwaysOn is a new feature in SQL Server 2012 that is ...
1
vote
1answer
177 views

Setting up a SQL Server 2012 Failover Cluster Instance on an Azure VM

I'm trying to set up a test lab in Windows Azure for a SQL Server 2012 Standard Failover Cluster. When deploying a SQL Server 2012 VM through the gallery, the instance that's created is pre-installed ...
1
vote
1answer
73 views

Colliding/overlapping full and differential backups in SQL Server

I am trying to set up a monthly full backup and a daily differential. The full backup is currently on the 1st, but I might change it to the first Saturday. I need to retain full backups for a few ...
-1
votes
1answer
49 views

Cannot install Microsoft SQL Server 2012 prerequisites on Windows Server 2008 Core

I have the server with Windows Server 2008 core SP2 and I need to install SQL Server 2012 in it. The problem is that SQL Server requires .NET 4.5 and when I try to install .NET 4.5, the OS gives an ...
0
votes
1answer
69 views

TFS 2012 Backups w/DPM

I have a few servers running (mixture of 2012 and 2012 R2) and am playing with Microsoft's DPM as a backup solution. One of the things it complained about during installation was ensuring the SQL ...
1
vote
1answer
100 views

Does Win 2012 Standard Edition support clustering of SQL 2012 Enterprise Edition?

Can you cluster SQL 2012 Enterprise Edition on Win 2012 Standard Edition? The features doesn't seem to clarify whether it allowed or not. We are seeing warning “Cluster Nodes Failed" in the SQL ...
0
votes
2answers
59 views

Does it change anything when I disable obsolete parameters in SQL Backups? SKIP , stats, Nounload , norewind etc

I am pretty new in managing Computersystems but I always want to know everything to get out the maximum. When we last time deployed a new version of our application I was given a backup script to ...