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
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 ...
0
votes
1answer
17 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 ...
0
votes
1answer
23 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
0answers
31 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
41 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
1answer
83 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
1answer
25 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 ...
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 ...
1
vote
0answers
46 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
25 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) ...
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
26 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
1answer
77 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
17 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
26 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 ...
-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 ...
0
votes
2answers
80 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
1answer
40 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 ...
4
votes
1answer
758 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 ...
0
votes
0answers
45 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
2answers
95 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\...
2
votes
2answers
73 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
50 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 ...
1
vote
2answers
819 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 : ...
1
vote
2answers
496 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
1answer
120 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
134 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
34 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?
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
1answer
29 views

Why are SQL Backups slower on Server OS?

We are a hardware and software provider to small government agencies, where many offices have just 1-3 computers, with a few others that are bigger having 5-12 workstations. For the small offices we ...
0
votes
1answer
33 views

IIS 8 with SSL Fails To Connect to Remote SQL Server

I have recently setup a new testing environment consisting of a load balancer routing HTTPS traffic to a single IIS 8 webserver (more will be added once I work through this issue). The IIS 8 webserver ...
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
0answers
230 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
1answer
836 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 ...
1
vote
1answer
784 views

In SQL Server 2012 Failover Clustering, we are getting “The action 'Move' did not complete. Error Code: 0x80071398”

We have setup 2 VM Nodes for SQL Server 2012 Failover Clustering. The iSCSI drives are on our SAN. Cluster setup and SQL Server 2012 SP2 install succeeded without errors. Connecting to SQL Server from ...
2
votes
1answer
339 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# ...
3
votes
0answers
296 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 ...
0
votes
0answers
16 views

Any advice on those server upgrades? [duplicate]

Currently, im planning to upgrade some servers. 2 Dell R610 as Application Servers with 2x 4 Core Cpu Planning to put 32 gb ram, and 2x intel dc s3610 200g(Samsung 850 pro 256g, if money is a ...
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
1answer
222 views

SQL Server 2012 Service not starting (Probably related to Service Agent issue)

I have an application (Dynamics AX 2012) that can't connect to the SQL server. I log onto the SQL server, and open SQL Server Management studio and can't connect to the database engine. I check the ...
2
votes
1answer
85 views

Manage SQL Agent Jobs On Multiple Servers

Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
0
votes
0answers
283 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
78 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 ...
1
vote
1answer
103 views

Latency & SQL Connections over Fiber WAN - Application E-manage

I am hosting an encrypted SQL server database (SQL Server 2012) on a VMware host at my Salt Lake location. My Salt Lake data pipe is 100 Mbps over fiber via Comcast. My Phoenix side has a 50 Mbps over ...