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

-1
votes
0answers
10 views

SQL Insert Statement Persists Two Records When I Need Just One [migrated]

I have altered it to include hardcoded variables when I pulled this chunk of code from the stored procedure. I ran it independent of the application with the same result. I need one insert statement ...
0
votes
0answers
37 views

PHP Startup - unable to load dynamic library - Access Denied?

I have some Problems installing the sqlsrv_extension for a PHP 5.6 Installation. (Running SQL Server 2012 on Windows Server 2012) Currently there are no official drivers available, but there are a ...
0
votes
0answers
10 views

sql web replication ?diag errors

Trying to configure web replication, and running into a number of issues. When running replisapi.dll?Diag, I receive the following errors: CLSID_SQLReplErrors FAILED 0x80040154 replrec.dll classes ...
0
votes
1answer
28 views

SQL Server 2012 Express - silent installation.

I am failing to silently install SQL Server 2012 Express (Advanced). I followed the guidance and this is my command: Setup.exe /q /ACTION=Install /FEATURES=SQL,Tools /INSTANCENAME=MSSQLSERVER ...
1
vote
1answer
28 views

The server principal 'A' is not able to access the database 'B' under the current security context

I have a trigger that accesses another database. but I receive an error: "The server principal 'A' is not able to access the database 'B' under the current security context" Where A is is User ...
0
votes
2answers
31 views

SQL Server 2012 which user is using Memory and CPU

For sql server 2012 I am looking for a way to see which active user logins are using how much memory and cpu. I have done a search but it seems there is only a way to see aggregates or how much each ...
1
vote
1answer
19 views

Trying to add a new SQL Server user throws the error "is not a valid login or you do not have permission”

I am trying to add a new user to an SQL Server 2012 database using SQL Server Management Studio. I right-click and select 'Add User' under Security -> Users, fill out the user information, and click ...
0
votes
0answers
33 views

Azure Variable Table v Temp Table

This is a bit long; but I have been working through queries figuring out where a performance issue is coming from. Appreciate you taking the time to read it. I have an application running on a ...
0
votes
0answers
278 views

Random connection failures between IIS8 and MSSQL 2012 in RackSpace Cloud

Background For years I hosted all of my server functionality, including IIS, Apache, MySql, and MSSQL on a single server instance, yikes! As my client base grew this led to persistent SQL Timeouts ...
0
votes
1answer
42 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
47 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
41 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
22 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
45 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
33 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
95 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
39 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
247 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
102 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
164 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
47 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
60 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
405 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
131 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
54 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
301 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
146 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
1answer
60 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
33 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
112 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
897 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
66 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
141 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
88 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
30 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
98 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
393 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, ...
2
votes
1answer
84 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
41 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
51 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
60 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
236 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
218 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
112 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
224 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
217 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
120 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
248 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
1answer
91 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
745 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 ...