This project has moved and is read-only. For the latest updates, please go here.

Previous Install Notification Services Manual Install Install Semantic Search Next

Install StreamInsight

FineBuild can install and configure StreamInsight as part of the SQL Server install process.

StreamInsight is written by Microsoft. It was chosen to be included in FineBuild because it allows real-time analysis of high-volume streams of data, also known as Complex Event Processing (CEP).

If you install StreamInsight you must also Install SQLCE.

StreamInsight home page
StreamInsight download
StreamInsight Team blog
StreamInsight video

FineBuild StreamInsight Install

Automated silent installation of Stream Insight is performed by Process Id 4SJ and is controlled by the parameters below:

Install Parameter Build SQL2005 SQL2008 SQL2008 R2 SQL2012 SQL2014
SetupStreamInsight FULL N/A No No No No
SetupStreamInsight WORKSTATION N/A No No No No
SetupStreamInsight CLIENT N/A No No No No

In order to maintain compatibility with older versions of SQL FineBuild, the parameter InstStreamInsight can also be used.

SQL Version Install Notes
SQL2008 R2 or above StreamInsight is provided as an optional package for SQL Server. FineBuild can use the install media provided with SQL Server, or will use a more recent version if you download the StreamInsight install file and place it in the Additional Components folder.
SQL2008 You must download the StreamInsight install file and place it in the Additional Components folder if you want to install StreamInsight on SQL 2008.
SQL2005 StreamInsight will not be installed for SQL 2005

FineBuild also uses the following parameters to help configure StreamInsight:
Parameter Default Value Description
InstStream DEFAULT StreamInsight Instance Name
GroupDBA GBGGDBAS01 DBA Sysadmin Group

FineBuild will not by default install StreamInsight, because most sites do not need this functionality.
If you want FineBuild to install StreamInsight, then you must add the following parameter when you run FineBuild:
The FineBuild install for StreamInsight includes the following:
  • Install StreamInsight
  • Setup StreamInsight Security

Manual StreamInsight Install

The following steps show what you would have to do to install StreamInsight manually. FineBuild does all of this work for you automatically.

Install StreamInsight

1) Navigate to the relevant folder and double-click on the StreamInsight install file.

Original location \StreamInsight\x64\1033_ENU\StreamInsight.msi
Download location Additional Components\StreamInsight.msi

2) The Welcome window is displayed. Click Next to continue.
StreamInsight Welcome.png
3) The License Agreement window is displayed. Accept the license and click Next to continue.
StreamInsight License.png
4) The Registration window is displayed. Enter the registration details and click Next to continue.
StreamInsight Registration.png
5) The Instance window is displayed. Type DEFAULT for the Instance name and click Next to continue.
StreamInsight Instance.png
6) The Product Key window is displayed. Type the product key used for your installation of SQL Server and click Next to continue.
StreamInsight PID.png
7) The Configuration window is displayed. Ensure Create the StreamInsight Host Windows service box is ticked, then click Next to continue.
StreamInsight Configuration.png
8) The Ready to install window is displayed. Click Install to continue.
StreamInsight Ready.png
9) The Installing window is displayed. Wait until this window closes.
StreamInsight Progress.png
10) The Installation Complete window is displayed. Click Finish to exit.
StreamInsight Welcome.png
SQL Server Compact Edition must be installed outside of FineBuild before StreamInsight can be used.

Setup StreamInsight Security

The DBA Sysadmin group is configured to be the StreamInsight administrator.

1) Run the following command to create the StreamInsight administration group and give the DBA Sysadmin group administrator rights in StreamInsight. The value GroupDBA should be replaced by the DBA Sysadmin group name and the value of Instance should be replaced by the StreamInsight instance (the default instance name is DEFAULT).
NET LOCALGROUP "StreamInsightUser$Instance" /ADD
NET LOCALGROUP "StreamInsightUser$Instance" "GroupDBA" /ADD
Copyright © 2011 - 2014 Edward Vassie. License and Acknowledgements
Previous Install Notification Services Top Install Semantic Search Next

Last edited Oct 23, 2014 at 12:29 PM by EdVassie, version 8