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

prevent replace sql database files with old one

i have a database that i use in my application. the operation i want to prevent is if i stop sql server and take the database files to another location then start the sql server and make some ...
-1
votes
0answers
16 views

Where can I download the MS SQL Express 2012 R2 for the Dutch Locale? [on hold]

One of my Software uses the localized version of the MS SQL Server 2012 Express Installer. I could get the maximum Languages but I can't find the Installer for the Dutch Language. Can any one suggest ...
3
votes
0answers
21 views

AlwaysOn Availability Group error after Windows Update in environment without a failover cluster [migrated]

Our SQL Server service was down this morning which brought down some of our websites. When I went to check the Windows Event Viewer I saw the following errors: Script level upgrade for database ...
0
votes
0answers
33 views

What happens on an SQL Server when a snapshot is taken by VMWare?

Recently I saw in our SQL Server logs that a snapshot could not be taken at the specific time and he retried it later on. During that timespan we had a huge performance problem. Besides the SQL Server ...
0
votes
1answer
45 views

Exporting a Subset of Data in Microsoft SQL Server to Script

We are running a Microsoft 2012 SQL Server and are looking at a way to dump a subset of data (based on queries) to .sql scripts we could then run on another server to pull that data back in. We have ...
1
vote
0answers
24 views

How many MSDTC clustered services (if any) are needed for a multiple-instance SQL Server 2012 cluster?

I'm creating a new SQL Server 2012 cluster, running on 2 physical nodes (the O.S. is Windows Server 2012 R2); the cluster will host multiple SQL Server instances; the exact number is yet to be ...
0
votes
0answers
61 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
22 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
36 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
52 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
38 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
32 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 ...
1
vote
0answers
61 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 ...
1
vote
0answers
488 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
53 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
59 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
64 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
32 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
62 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
46 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
124 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
63 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
328 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
126 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
218 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
61 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
81 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
549 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
176 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
64 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
421 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
193 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
64 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
39 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
119 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
1k 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
72 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
194 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
105 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
34 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
109 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
468 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
95 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
44 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
71 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
245 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
248 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
125 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
246 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 ...