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
8 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
14 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
11 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
48 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
17 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
22 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
1answer
23 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
146 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
13 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
1answer
37 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 ...
2
votes
2answers
44 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
10 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
29 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
463 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
238 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
42 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 ...
4
votes
1answer
100 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
28 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
28 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
27 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
56 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
158 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
407 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
313 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
200 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
154 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
32 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
116 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
49 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
171 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
66 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
67 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 ...
0
votes
0answers
86 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 ...
2
votes
1answer
122 views

Hyper-V Guest data encryption

I have a new requirement to encrypt the data inside an sql database while it is at rest. So far I've looked at Bitlocker (see below), and other commercial products (I won't name because I'm not ...
0
votes
1answer
330 views

Install SQL Server 2012 to Windows Server 2008

I'm trying to install SQL Server 2012 in Windows Server 2008 R2 Standard Operating System. However this Error keep appearing even though I installed both .NET Framework 3.5.1 and 4.0 The operating ...
1
vote
2answers
66 views

Can't connect after NEW Install SQL Server 2012 on Win 7 Pro SP1 with Windows Auth or SQL Server Auth

Trying to install SQL Server 2012 (Eval) to work with the new BI tools using AdventureWorksDW tutorial. Therefore, I feel I've gotten bogged down in SA activities that would be done by others in the ...
0
votes
0answers
69 views

Can an SQL Server File Table UNC be exposed via DFS?

Can a Sql Server File Table UNC be exposed via DFS?
0
votes
1answer
307 views

Does the amount of disks in a RAID10 matter for a Microsoft SQL server in regards of the block size?

We are planning to deploy a Microsoft SQL Server and to store the databases on a RAID10 (RAID1+0) block-level-storage. Does it matter how many drives altogether I put into the array for optimum ...
-1
votes
1answer
189 views

What are my options to run MS SQL 2012 on Amazon RDS for development if I only have MSDN license? [duplicate]

I want to run MS SQL 2012 SE BYOL on Amazon RDS under my own MSDN license but it looks like MSDN license doesn't allow me to run MS SQL unless I host it on the dedicated hardware Microsoft Volume ...
4
votes
2answers
463 views

How much memory does my SQL need?

I have a VM (SQL database server) that I think has more memory then it needs, however I'm not sure what I can reduce it to because I don't understand exactly what "In use", "Available", "Committed" ...
1
vote
1answer
238 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 ...
0
votes
1answer
53 views

How to setup user accounts on a secondary server in High Availability?

Working with two Microsoft SQL 2012 servers in Always On High Availability configuration running on Windows Server 2012 R2. Setup works well and failover is almost flawless. However, the software ...
0
votes
3answers
430 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
0answers
270 views

Sharepoint 2013 Access denied/file not found on login

I'm trying to setup a little sharepoint developement enviroment but i can't get it working. We use Sharepoint 2013 Foundation and Server 2012 R2 and SQL Server 2012 BI edition. If i try to login with ...
0
votes
2answers
62 views

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all ...
2
votes
0answers
123 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 ...
0
votes
1answer
101 views

Slow merge replication over a WAN link - only downloads

We've been using SQL Server merge replication for a few years to synchronise data between our data centres, but we are now suffering with a big performance issue. This may be because the amount of ...
0
votes
0answers
89 views

Upgrading SQL Server from 2008 to 2012 doesn't respect existing install paths

Basic Information : Running Microsoft Windows Server 2008 with MS SQL Server 2008 (version 10.0.5869), trying to upgrade to SQL Server 2012. Currently working in a cloned VM of our production server ...