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
1k 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
308 views

Classic asp site, randomly slow DB connection

We are running a site with classic asp and ASP.NET MVC 4 (C#) side by side. During high traffic, database queries are running really slow in the asp pages. At the same time, in the same site, C# ...
2
votes
1answer
54 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
452 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
332 views

Can we use FILESTREAM in case of SQL Server cluster

I saw this point on Technet article about RBS. The local FILESTREAM provider is supported only when it is used on local hard disk drives or an attached Internet Small Computer System Interface ...
3
votes
0answers
257 views

Local DTC is missing on server 2008r2

I've recently had an issue where MSDTC was unable to start up. The error in the command line when running net start msdtc indicated that there were configuration issues. I went into the registry and ...
3
votes
0answers
930 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 ...
2
votes
0answers
142 views

Why is SQL Server using all ephemeral ports connecting to itself and causing TIME_WAITs?

I've got an AWS server with Windows 2008 R2, SQL Server 2012, and Tomcat 7. When I run netstat -ano the screen is flooded with TIME_WAIT. I posted the output in a Gist. When I run CurrPorts, filter ...
2
votes
0answers
807 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 ...
2
votes
0answers
181 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
32 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 ...
1
vote
0answers
36 views

Client to IIS to SQL Server Kerberos authentication

I would like to have a setup where my IIS web server sits on a different virtual server from where my SQL Server is installed, and Windows Authentication should be used for all connections. I am ...
1
vote
0answers
18 views

Windows Server 2008 R2 alias or Cname

On one of our client server, Windows Server 2008 R2 is installed. On the same machine, on SQL Server 2012, I am seeing 2 server names MHMSDB01 and user_DB1 are actually same server (IP address.) host ...
1
vote
0answers
23 views

Strange error in SQL Server from ASP.NET app

I posted this question on stack overflow, but to no avail. Getting desperate here. So we have an extremely random error (by which I mean, there appears to be no usage pattern that precedes the error) ...
1
vote
0answers
188 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
308 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
390 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
126 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
351 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
518 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
605 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
829 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
48 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
585 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
1k 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
20 views

SQL Server with Veritas HA

I am configuring SQL Cluster using VERITAS HA and DR replication using VVR, I have configured the cluster and storage as per the cluster implementation document for SQL Server 2012 but in SQL Server ...
0
votes
0answers
27 views

Virtual machine snapshot fails, followed by a hung server

We've had a rather annoying incident yesterday. During a routine snapshot backup, a machine failed with the following error: Backup virtual machine Cannot complete the operation. See the event log ...
0
votes
0answers
10 views

My server side migration setting doesn't seem to work in SSMA

My server side migration setting doesn't seem to work. It fails without any error message. Any fix resolutions you can suggest to me? Also i see only one table under the sysdb in SQL server 2012 ...
0
votes
0answers
6 views

Unable to access Reporting Services using Administrator account Windows 2012R2 / SQL Server 2012

We have a standalone Windows 2012 R2 server with SQL Server 2012 installed. The Windows 2012 server has an Administrator account only in the group "Administrators". This Administrator account is ...
0
votes
0answers
16 views

SQL Server semaphore timeout period extended procedures fails unless non-standard port

Querying my SQL Server 2012 database on Windows Server 2012 using extended/metadata procedures fails when connected via SSMS using a VPN with the following error: TCP Provider,error: 0 – The ...
0
votes
0answers
22 views

SQL Server Management Studio 2012 DB Backup script

I have SQL Server Management Studio 2012 installed on a VM. We have an active DB (attached to an ASP.Net application whose target Framework is 4.0). What I was looking for is a script to backup a DB ...
0
votes
0answers
39 views

asp.net website intermittent slowness

I have published a asp.net web application in azure which has the configuration of D-13. The domain has been registered with GoDaddy. These are the list of webpages I am using Login.aspx ...
0
votes
0answers
32 views

Dynamics AX Database Autogrowth Recommendations

Question Best practices recommendations for AX2012 state that autogrowth for TempDB, Data and Log files should be a fixed size between 100MB and 500MB. Many sites recommend a value of 1024MB, which ...
0
votes
0answers
11 views

SQL Server Express 2012 R2 shuts down when trying to connect via SQL authentication

I've been Googling this for a while, and I am stuck. Has anyone seen a resolution for this issue? I have a newly-installed server running Windows 2012 R2, and I installed SQL 2012 R2 Express in ...
0
votes
0answers
13 views

Data is re-inserted when replication is done

I have a transactional publication done between two databases on different Virtual machines connected with a network. I noticed that for some reason Every time replication is happening (which is every ...
0
votes
0answers
219 views

Memory usage on db.t2.micro

I just brought up an RDS-MSSQL instance which this page says has .6GB of memory. However, the console shows this: I haven't added any databases, but the Memory Threshold looks like its peaking at ...
0
votes
0answers
40 views

MDX run slower in SSRS than in Management Studio

I have an mdx dataset for a SSRS 2012 report. Running MDX in Management Studio takes 1 sec, but in report it takes 1 minute. This is a critical report and the user want it as fast as possible. I have ...
0
votes
0answers
254 views

SQL Server 2012 Microsoft-Windows-Perflib Error Message Event Code 1010

I am seeing the below error message occur every 15 minutes on a Hyper-V guest running Server 2012 R2 with SQL Server 2012 with SP2 (DB, SSIS, SSRS). I am wondering how to diagnose what this error ...
0
votes
0answers
77 views

Considerations for SQL Server 2012 when performing in-place OS upgrade to 2012 R2

I'm running SQL Server 2012 Enterprise (11.0.3381.0) on Server 2012 (6.2.9200) and am preparing for an in-place OS upgrade to 2012 R2. We've got an Always-On Availability Group in a 2-server cluster ...
0
votes
0answers
125 views

SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for User

I am trying to get SQL 2012 AlwaysOn Availability Groups working for an application. The cluster has 2 SQL nodes and 1 witness server. Everything appears to be failing over successfully when I do ...
0
votes
0answers
14 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
486 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
248 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
1k 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
27 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
321 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
43 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
530 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
248 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 ...