Biztalk nuggets and other related findings
Translate This Page
Translate this page
BizTalk 2006 R2
BizTalk 2013 R2
BizTalk Server 2009
Microsoft BizTalk Server
Microsoft BizTalk Server 2013
SQL Server 2005
SQL Server 2008
SQL Server 2014
SQL Server Analysis Services
SQL Server Reporting Services 2008
Windows Failover Clustering
Windows Server 2008
Windows Storage Server 2008
Browse by Tags
sql server 2005
Tagged Content List
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 this during install as part of the basic script, because we'll be doing a lot of SQL installs and we want to eliminate manual effort where possible. I looked around and the few samples I found were using...
13 Mar 2012
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 static port (e.g. 2375 for something random), that you do not need to use the instance name when connecting to the SQL instance? For example, if I setup a server, called Server1, and I setup a named instance...
7 Apr 2010
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 time has proven over and over, permissions and environment variables tend to trip even the most careful planners up when deploying artifacts to non-development environments. I have developed a BAM solution...
28 Jul 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 Server Analysis Services. On my local dev box, I wanted to fully emulate the permissions from my full-blown dev environment, so in my Services MMC, I changed the Analysis Services log on account from LocalSystem...
14 Jul 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 thought it might also be helpful to list the various security settings which need to be set to allow SSAS to not only run but accept connections. Again, in a dev environment, if your "service account" is an...
25 May 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" world was that in our post-dev environments SQL is clustered and we would be installing Analysis Services to a cluster which already has SQL Server installed, so I decided to "practice" installing Analysis...
18 May 2009
Page 1 of 1 (6 items)
© 2015 Microsoft Corporation.
Privacy & Cookies