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

0
votes
1answer
1k 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
0answers
32 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
6 views

Error installing Accelerator for HL7. Installation cannot be performed because user account is not a member of Biztalk Server Administrators group

Please consider the following error when trying to run the HL7 Accelerator Setup.exe executable. I'm installing on a Windows Server 2012 R2 VM. BizTalk 2013 is already installed and configured ...
1
vote
1answer
132 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
26 views

SQL Server 2012 Copy Database for Test DB fails

I'm trying to copy a database from our live system to the test system. (same Server, different DB) The Test DB has been deleted in preparation so we have a clean slate. I've tried backing up the DB, ...
0
votes
1answer
18 views

Why is SSIS reading so much data from my hard drive?

We're running SQL Server 2012 on Windows Server 2008 R2 for a our CRM and ERP services. Unfortunately, the majority of the setup was outsourced to an "expert" company who neglected to provide any ...
1
vote
1answer
2k 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 ...
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 ...
0
votes
1answer
1k 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 ...
3
votes
3answers
4k views

AWS RDS (SQL Server): SSL Connection - The target principal name is incorrect

I have a Amazon Web Services (AWS) Relational Database Service (RDS) instance running SQL Server 2012 Express. I've installed Amazon's aws.amazon.com/rds certificate in the client machine's Trusted ...
0
votes
1answer
90 views

Ubuntu - SQL Server 2012 - Microsoft ODBC Driver 13 - Error: 18456, Severity: 14, State: 8

I have been attempting to get "Microsoft ODBC Driver 13 for SQL Server" running in Ubuntu for two days now, and I am out of ideas / have exhausted Google. My test machine is a vagrant VM, and these ...
0
votes
0answers
44 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 ...
2
votes
2answers
9k views

MS SQL Server 2012 - Unable to access Instance on localhost

5 days ago I was access able to access SQL Server on my localhost machine via SSMS perfectly, no errors logging in with credentials. Now I get this error: =============================================...
2
votes
2answers
16 views

SQL 2012 Standard - AlwaysOn FCI - Single point of contact?

I am looking at HA options for SQL 2012 Standard. I like the look of AlwaysOn FCI. I am using a SAN, so I think I can meet all of the requirements, but one of the applications I am looking at cannot ...
0
votes
1answer
28 views

Should I continue to use MSDTC in my new virtual environment for MSSQL?

In the past I have used a two node cluster setup. All the services (SQL, File Server, App Server, DTC) were passed back and forth within the cluster as normal. Now I take a different approach. I ...
1
vote
0answers
48 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 ...
0
votes
0answers
13 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 ...
3
votes
1answer
27 views

What happens to running queries when stopping a Microsoft SQL Server instance?

Consider that a MS SQL Server instance is executing a long-running query the service is stopped via services.msc or - as it actually happening - a system shutdown triggered by a UPS as the server is ...
1
vote
0answers
21 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
25 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) ...
3
votes
1answer
3k 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 ...
3
votes
1answer
4k 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
7 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
1answer
27 views

MS SQL replication run only with system account

I'm trying to configure a new replication with SQL Server 2012 I configured the distribution While configuring the publication, it asked for a user to run the snapshot agent. I set a strong user ...
0
votes
2answers
97 views

Publish-AXReport Gives Error “Name cannot begin with the ' ' character”

Running the below PowerShell script (i.e. to deploy all SSRS reports for AX) gives an error: $axdllname = "Microsoft.Dynamics.AX.Framework.Management.dll" $gacfolder = join-path $env:windir "assembly\...
0
votes
1answer
80 views

Install WSUS with remote SQL on port different to default

How do I specify the connection parameter to a remote MSSQL Server during WSUS setup that's default instance is not running on the default port?
0
votes
0answers
18 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
27 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
1answer
1k 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 ...
-2
votes
1answer
14 views

SQL 2012 Integration Services installation

Can you please suggest me the EXE to install SQL integration and Analysis services I have installed SQLEXPRADV_x64_ENU.exe, SQLEXPR_x64_ENU.exe from MSDN site.however, I could not find the integration ...
1
vote
2answers
506 views

SQL Server 2012 support for TLS 1.2, 2 downloads, Which One?

If you disable TLS 1.0 and SSL 3.0 for PCI, SQL Server will stop working. SQL Server 2012 r2 out-of-the-box only supports SSL protocols up to and including TLS 1.0 by default. Unfortunately, PCI has ...
0
votes
2answers
81 views

Unable to start SQL server agent automatically

I am working on SQL 2012, I already been set up my SQL server agent in automatic start up mode in windows services as well in SQL config. Even though it was not starting automatically. How can I fix ...
0
votes
3answers
59 views

Changes to data ordering between SQL Server 2000 and 2012

My company recently migrated a .NET 1.1/SQL Server 2000 web application to SQL Server 2012. We've had a couple of support calls relating to unusual behaviour - particularly with stored procedure ...
0
votes
1answer
42 views

Sql Express 2012 Upgrade to SP1

I have Sql Server Express 2012 installed on one server. As I'm trying to install TFS 2015 and it require Sql Express 2012 with SP1 I would like just to update my instance to SP1, but I can't find a ...
0
votes
0answers
43 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 Landing....
0
votes
1answer
48 views

SQL Server 2012 event ID 18487

Good morning guys. We have a SQL 2012 instance we use to store data on the parts we create. We have software that goes and pulls data out of the PLC on the machine and dumps the data into the SQL ...
1
vote
2answers
460 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 ...
0
votes
3answers
2k views

SQL 2012 server alias works locally but not remotely

I'm preparing for a server migration and am attempting to redirect a named instance of SQL Server 2012 (DW) to the default instance. There is currently no DW instance on the test server - I'd like to ...
4
votes
1answer
779 views

Unattended installation of MS SQL Server (2008|2012) EXPRESS?

My goal is to install MS SQL Server 2012 R2 Express. I've downloaded SQLEXPRADV_x64_ENU.exe and used /ACTION=Install /UIMODE=Normal to generate and modify a configuration file. No matter how I fiddle ...
1
vote
2answers
836 views

SQL Server express - Management studio installation hangs at native images installation

I've been trying to install SQL server express edition (2014) with management studio and consistently failing to do so because installation stalls at step 'Install_sql_common_core_Cpu64_Action : ...
0
votes
0answers
46 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 ...
2
votes
2answers
74 views

Can I access the failover server on AWS RDS?

I am trying to create a working proof-of-concept in AWS for our web application which suddenly needs to scale out very quickly. Currently it is hosted on a local VMware server and we are migrating to ...
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 ...
1
vote
1answer
51 views

I'm getting a warning that disk space on C: is below 5% when it's not

It's a database server running SQL Server 2012 on Windows Server 2012 R2. C: is the boot/windows drive, but does NOT contain the data (mdf), log (ldf), or temp files (tempdb.mdf) for the database. So ...
3
votes
1answer
2k views

Random connection failures between IIS8 and MSSQL 2012 in RackSpace Cloud [closed]

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
122 views

Restoring a differential database file “the backup set holds a backup of a database other than the existing”

I am trying to test restoring a SQL database using a full/differential approach to a different server than it was backed up from. The database is in simple recovery mode as it is a test data warehouse....
4
votes
1answer
135 views

Best practice for application logging database replacement

Our web apps (30 or so) log application specific stuff to a centralized logging database (Sql Server 2012) with log4net, so the logging database gets huge quickly. Thus we decided to replace it every ...
0
votes
1answer
35 views

What is Best Practice for migrating SQL 2012 system databases to failover cluster?

What is the best practice for copying system databases when migrating from SQL Server 2012 (no SP) to 2012 SP2 in a Failover Cluster? Just backup and restore? Or, script out and script in?
1
vote
3answers
653 views

SQL Server Management Studio 2012 - password lag and failure

In a new installation of SQL Server 2012 Standard, we have mixed-mode authentication enabled. Using Windows authentication, I can authenticate and use SQL Management Studio as expected. Using SQL ...
0
votes
1answer
850 views

Azure network latency between VM and Cloud Service

We have recently setup a virtual network that consists of one virtual machine (A3) running MSSQL, and one cloud service (Medium) running a web role. Our web role will connect to the database using ...