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

3
votes
1answer
565 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 ...
2
votes
1answer
37 views

What are the downsides of running all SQL Servers under same domain account?

I am running two SQL Servers 2012 (for Always On) under the same domain account and would like to know what are the downsides in doing so. Few articles that I have read prior setting up the servers ...
2
votes
1answer
200 views

Where Does sqlpackage.exe Store Database Backups?

I have a deployment script which uses sqlpackage.exe to deploy incremental changes to a database. (The project is maintained in the database edition of Visual Studio 2012 Express.) One of the flags ...
1
vote
1answer
115 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
1answer
114 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 ...
1
vote
1answer
852 views

Missing menu items for Azure SQL tables within SQL Server Management Studio?

I have a table (say Table1) that is replicated via SQL Data Sync Agent across a local SQL Server 2012 as well as an Azure SQL Server (part of Microsoft Azure). Everything about Table1 (schema, table ...
1
vote
1answer
408 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. ...
0
votes
1answer
25 views

Setting up Multi server environment in Sql Server 2012 - Enlist Failed Error

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012. I changed : MSXENCryptChannnelOptions # Changed from 2 to 0 AllowDownloadedJobsToMatchProxyName # ...
0
votes
1answer
36 views

TFS Database migration miss the detach step issue

We currently doing the TFS database migration, originally, we suppose to upgrade to 2012 which support SQL 2008 R2, after a period of time, we decide to upgrade to 2013, and unfortunately we are ...
0
votes
1answer
207 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 ...
0
votes
1answer
93 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
1answer
269 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 ...
0
votes
1answer
128 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 ...
0
votes
1answer
341 views

If a SQL Server Replication Distributor and Subscriber are on the same server, should a PUSH or PULL subsciption be used?

Thanks in advance for any help. I'm setting up a new Microsoft SQL Server replication and I have the Distributor and Subscriber running on the same server. The Publisher is on a remote server (as it ...
0
votes
1answer
677 views

Failing SQL Server Cluster installation, Addnode: Remote registry call failed

I'm adding a node to a SQL Server failover cluster. The installer throws the error "Addnode: Remote registry call failed. Unable to retrieve primary node Filestream settings" when adding node two ...
0
votes
1answer
595 views

No file access permissions after restore database

I have a strange phenomon. When I restore a SQL-Server 2012 database to a folder on my D-Drive, it gets restored just fine. I can access the database and basically it works fine. But when I check the ...
2
votes
0answers
87 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 ...
2
votes
0answers
28 views

SQL Server 2012 database availability design?

Can anyone please suggest me what is the best practice for me to follow when consolidating multiple stand alone DB from SQL Server 2005 - 2008 boxes into just 2x SQL Server 2012 Enterprise nodes in ...
2
votes
0answers
644 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 ...
1
vote
0answers
83 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 ...
1
vote
0answers
185 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
848 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 ...
1
vote
0answers
114 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
0answers
177 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 ...
1
vote
0answers
81 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 ...
1
vote
0answers
160 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
0answers
290 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 ...
1
vote
0answers
319 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 ...
1
vote
0answers
462 views

SQL Server Service refusing to start

Have attempted a number of things to get this service (SQL Server (MSSQLSERVER)) started without any luck Attempted to start service with local admin, domain admin, separate admin & standard ...
1
vote
0answers
42 views

SQL Server 2012 : Installing on D:

i am trying to install SQL Server 2012 i choose D: for everything but still it told me during installation itself that it's going to install config file on C: following is the path C:\Program ...
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 ...
1
vote
0answers
452 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
0answers
732 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 ...
0
votes
0answers
11 views

SQL Server 2012 Web uses max 4CPUs. AZ RDS allows deployment on R3.2xLarge (8vCPU) instance. Why?

According to MS documentation, SQL Server 2012 Web Ed. is limited to use 4CPUs. However, Amazon RDS allows it to be deployed on R3.2xLarge instance. BTW, R3.2xLarge offers 8vCPUs. So is it helpful ...
0
votes
0answers
15 views

Kerberos and SQL server connection string

I am working on a project to migrate a legacy ASP program (NOT .NET!!) from W2k3 to W2K12 R2 (also from SQL server 2K -> 2K12). The ASP program file has a config for SQL server connection string which ...
0
votes
0answers
12 views

SQL Server Chain Permission

We have the 2 databases. Reporting HR There are some users who want to extract data from HR database. But we don't want to give direct access to that HR database. So, we created the special views in ...
0
votes
0answers
53 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
0answers
114 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
50 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
0answers
114 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
47 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
103 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
100 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 ...
0
votes
0answers
420 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 ...
0
votes
0answers
20 views

Unintended SQL Server 2008 Express instance installed

I installed SQL Server 2008 R2 Expess with an instance name SQLX08, then I installed SQL Server 2012 Expess with an instance name SQLX12. Now in the SQL Server Configuration Manager I see, along with ...
0
votes
0answers
52 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? ...
0
votes
0answers
138 views

After installing MS SQL Server 2012 not able to log into SSMS

Okay, lot's of posts around the internet on this subject. But I haven't been able to find an answer I was looking for. I installed SQLS 2012 on Windows Server 2012. I installed the Engine and the ...
0
votes
0answers
37 views

Allow VM2 access VM1's SQL Server Database

I have two VMs running on a Mac Server using VM Fusion 4. Both VMs are running windows 7, and I have SQL Server 2012 installed and data imported into VM1. Right now, I'm trying to figure out a way to ...
0
votes
0answers
316 views

Getting “error: 26 - Error Locating Server/Instance Specified” all of a sudden

Alright, a little explanation. I have two separate PCs, both of which have virtually an identical installation of SQL Server 2012 Express on them. During installation for both, I had chosen the ...
0
votes
0answers
194 views

Failure running SQL2012 on Windows 8 with local service accounts

I have installed SQL2012 on a Windows 8 laptop that is on a domain. The domain includes a group policy that defines accounts that can "Log on as a service". I installed SQL Server 2012 using the ...