Moving Reports and Report Subscriptions to another SQL Server

On a project where we did a lync 2013 to Skype for Business migration we came across the need to migrate reports and report subscriptions from the old lync 2013 environment to the new Skype for Business environment. In this case the reports where form Anywhere365, a Unified Contact Center software. I’ve tried different kind…

SQL AlwaysOn Availability Groups Bug

When you’re using SQL AlwaysOn Availability Groups pay attention when applying the following patches: SQL 2012 SP2 CU3 SQL 2012 SP2 CU4 SQL 2014 CU5 The Availability Group may stop synchronizing due to blocking between user queries and a system session. The fix is to disable automatic failover if it is activated, restart the SQL Server instance…

Installing SQL 2014

Installing SQL 2014 isn’t quite as different as installing SQL Server 2012. Sure there are some minor UI changes when installing SQL, but it’s all the same. In order for SharePoint to work with SQL, we only need the database engine. I don’t want to click my way through the setup every time I need to install SQL server.…

SQL Server 2014 Download Links

As of April 1st, SQL Server has been made available to download. If you have a MSDN subscription you will be able to download the bits. If you don’t have an MSDN subscription you can download the evaluation bits on the TechNet evaluation center. Remember! In order for SharePoint 2013 to work with SQL Server…

SQL Server 2014 Release

SQL Server 2014 has been released to manufacture (RTM) on March 18th by Microsoft. On April 1st the download of SQL Server 2014 will be made available. Brings up the question if SharePoint will support SQL Server 2014, well the answer is yes. However, SharePoint 2013 will not be able to work with SQL Server…

Installing SQL Service Pack 1 on a SQL Core installation

So how do we install SQL Server 2012 Service Pack 1 on a core server? Download SQL Server Service Pack 1 from the Microsoft download site. (http://download.microsoft.com/download/3/B/D/3BD9DD65-D3E3-43C3-BB50-0ED850A82AD5/SQLServer2012SP1-KB2674319-x64-ENU.exe) Type: \\<servername>\SQLServer2012SP1-KB2674319-x64-ENU.exe /x:”c:\SQLSERVER2012SP1″ (when your Service Pack resides on a different server). Type: X:\<folder>\SQLServer2012SP1-KB2674319-x64-ENU.exe /x:”c:\SQLSERVER2012SP1″ (when your Service Pack resides on your local server). When the extraction is…