Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Biztalk nuggets and other related findings
The Azure PowerShell session has not been properly initialized.
I recently tried to update my Azure PowerShell version and noticed that even though I had run the...
Date: 07/06/2017
Little gotcha in Docker for Windows
I am writing a small ASP.NET Core Web Application and decided to add Docker support. However, even...
Date: 03/29/2017
Moving databases to new storage within an Availability Group
I had a customer come to me for help in adding storage for their SQL servers which were supporting...
Date: 03/06/2017
Creating a Hyper-V host with Nano Server – Part 3
In Part 2, I covered initially connecting via PSRemoting and domain joining the Nano Server. In...
Date: 12/24/2016
Creating a Hyper-V host with Nano Server – Part 2
In Part 1 I went over how to create the Nano Server image and configure the physical computer to...
Date: 12/24/2016
Creating a Hyper-V host with Nano Server - Part 1
Recently I decided to re-build my home lab cleanly with Windows Server 2016 and System Center 2016....
Date: 12/24/2016
Updating multiple SQL instances simultaneously
A customer I was working with has undergone a lot of growth recently, and to support their...
Date: 04/28/2016
Yet another cause for "Enterprise Single Sign-On Server: Unspecified error"
My customer's BizTalk environment uses a 2-node failover cluster to host the SQL instances where the...
Date: 01/13/2015
Activating a Windows 2012 R2 Server offline
If you're trying to activate a server which has no internet connectivity or access to a KMS server,...
Date: 10/15/2014
BizTalk 2013 R2 Redistributable CAB file locations
As of today (June 23rd, 2014) BizTalk 2013 R2 is available on MSDN! In keeping with some previous...
Date: 06/23/2014
BizTalk 2013 Wcf-Sql adapter fails because it could not load Microsoft.BizTalk.Interop.SSOClient
In a remarkably similar post to my last post I noticed that my Wcf-Sql receive locations were...
Date: 01/31/2014
BizTalk 2013 hosted WCF Service fails because it could not load Microsoft.BizTalk.Interop.SSOClient
I'm in the midst of migrating my customer from BizTalk 2009 to BizTalk 2013, migration being...
Date: 08/14/2013
Updated BizTalk Redistributable CAB locations for BizTalk 2013, 2010
In a previous post I'd listed out the links to the redistributable CAB file locations for BizTalk...
Date: 04/26/2013
Unspecified automation error when launching Excel with the BAM add-in enabled
Right when I needed to make a change in a hurry to a BAM Activity, I started throwing an...
Date: 11/28/2012
Windows 8 - First impressions and the Hyper-V startup trick
I've been running Windows 8 as my primary OS since the Consumer Preview was released and thus far...
Date: 10/02/2012
Exporting XML columns from SQL to file in SSIS
I had a requirement to facilitate some testing with an internal customer which involves periodically...
Date: 06/01/2012
Setting the SQL TcpPort value via PowerShell and WMI
My customer has a requirement that all SQL instances use a non-standard port, and I wanted to set...
Date: 03/13/2012
Error on adding a SQL cluster node (or more simply "Ooops")
I was installing a new clustered SQL (2008) instance via command line scripts, something that I've...
Date: 09/17/2011
The saga of SSRS 2008 and the FipsAlgorithmPolicy
I'm in the process of rolling out a new environment at the customer site and as part of this...
Date: 08/29/2011
IE9 slow performance (Or "How I learned to remember to keep my drivers updated")
For once this isn't a blog about BizTalk, SQL, PowerShell or the like (though from the tardiness of...
Date: 05/09/2011
Location of the BizTalk 2009 Redistributable CAB files
We're in the midst of upgrade from BizTalk 2006 R2 to 2009 at my customer. In this environment, only...
Date: 04/15/2010
Using SQL instance name when using a static port
Did you know that if you have a named instance of SQL, and that SQL instance is setup to use a...
Date: 04/07/2010
Enumerating the AddLocal parameters for a quiet BizTalk installation
More adventures in scripting - I've been using the Microsoft Deployment Toolkit (MDT) 2010 to work...
Date: 03/22/2010
Creating a completely virtualized cluster using Hyper-V and Windows Storage Server 2008
I've been doing a lot of scripting work lately, automating product installs, OS configuation and...
Date: 12/23/2009
An update to BAM SSIS pre-requisites
I got a call today from a client who was doing his initial install of BizTalk 2009 and had a similar...
Date: 08/04/2009
Perms, perms, perms (or deploying BAM activities with cubes when Analysis Services runs as a different service account)
This will be the first of a two part blog post about real-world adventures in BAM deployment. As...
Date: 07/28/2009
The right tool for the right job
Here's a little gem I discovered today. I am running down a permissions issue with BAM and SQL...
Date: 07/14/2009
Do I need to install SSIS on my BizTalk server to configure and use BAM? NO!
The various supporting components required to support BizTalk are very well understood - we need...
Date: 05/25/2009
Minimal security settings for a Analysis Services service account
As an add-on to my previous post about adding Analysis Services to an existing SQL cluster, I...
Date: 05/25/2009
Setting up Analysis Services on an existing SQL cluster
Another infrastructure issue that I ran into while deploying my BAM solution out into the "real"...
Date: 05/18/2009
Setting up SSIS on a SQL Server which does not have a default SQL instance
This one caught me a few weeks ago setting up the infrastructure to support my BAM solution in a new...
Date: 05/16/2009
Welcome to my blog!
Who am I? My name is John Scott and I'm a consultant for Microsoft Consulting Services, located in...
Date: 05/16/2009