Install Notification Services - SQL-FineBuild/Common GitHub Wiki

Previous Install System Views Map Manual Install Install StreamInsight Next

FineBuild can install and configure Notification Services as part of the SQL Server install process. If you do not want to include Notification Services in your FineBuild install, then do not download it.

Notification Services is written by Microsoft. It was chosen to be included in FineBuild to allow use of legacy Notification Services applications in SQL 2008 and above.

Notification Services was introduced as an optional component of SQL Server 2000 and became a standard part of SQL Server 2005, but it is not included in SQL Server 2008 or above. It can be installed as an optional component, but it is recommended that Notification Services is not installed unless it is already being used within SQL Server 2000 or 2005.

Notification Services is no longer supported by Microsoft.

Item Location
Notification Services home page https://www.microsoft.com/en-us/download/details.aspx?id=51958 (Contents need further download)
Notification Services Download Microsoft has retired the Notification Services Download page
Notification Services introduction https://www.devx.com/dbzone/Article/28522

This section is only relevant for SQL Server 2008 and above. For SQL 2005, Notification Services is included as part of the Microsoft SQL Server install process.

FineBuild Notification Services Install

Automated silent installation of Notification Services is performed by Process Id 4SI and is controlled by the parameters below:

SQL Version Parameter FULL Build WORKSTATION Build CLIENT Build
SQL2019 /SetupSQLNS: N/A N/A N/A
SQL2017 /SetupSQLNS: N/A N/A N/A
SQL2016 /SetupSQLNS: N/A N/A N/A
SQL2014 /SetupSQLNS: N/A N/A N/A
SQL2012 /SetupSQLNS: N/A N/A N/A
SQL2008R2 /SetupSQLNS: Yes Yes N/A
SQL2008 /SetupSQLNS: Yes Yes N/A
SQL2005 /SetupSQLNS: Yes Yes N/A

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

FineBuild also uses the following parameters to help install Notification Services:

Parameter Platform Default Value Description
/SQLNSX86msi: 32-bit SQLServer2005_NS.msi Name of Notification Services install file
/SQLNSX86msi: 64-bit SQLServer2005_NS_X64.msi Name of Notification Services install file

Notification Services can not be installed as part of a Client build.

The FineBuild install for Notification Services includes the following:

Top

Manual Notification Services Install

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

This process is only needed for SQL 2008 or above.

Install SQL Notification Services

  1. Navigate to the Additional Components folder

    Double-click on the Notification Services install file

    Platform File
    32-bit SQLServer2005_NS.msi
    64-bit SQLserver2005_NS_X64.msi

    ![Explorer](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/NotificationServices/SQLNS Explorer.png)

  2. The Welcome screen is displayed

    Click Next to continue

    ![Welcome](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/NotificationServices/SQLNS Welcome.png)

  3. Accept the License Terms

    Click Next to continue

    ![License](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/NotificationServices/SQLNS License.png)

  4. Supply the Registration Information

    Click Next to continue

    ![Registration](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/NotificationServices/SQLNS Registration.png)

  5. Setup now has enough information to run the install

    Click Install to continue

    ![Ready to Install](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/NotificationServices/SQLNS Ready.png)

  6. A progress window is displayed

    Wait until this window closes

    ![Progress](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/NotificationServices/SQLNS Progress.png)

  7. Setup has completed successfully

    Click Finish to end

    ![Complete](https://raw.githubusercontent.com/wiki/SQL-FineBuild/Commonhttps://github.com/SQL-FineBuild/Common/blob/master/Blob/ExtraComponents/SQLServerExtras/NotificationServices/SQLNS Complete.png)

Setup Menu Item

The Notification Services menu item is created within the Microsoft SQL Server 2005 menu structure. It is moved to the Microsoft SQL Server menu structure so that all tools are in one place.

  1. Move the menu item for Notification Services Command Prompt from the SQL Server 2005 menu structure

    Place it in the ‘All Users’ SQL Server Configuration Tools folder

  2. Delete the Microsoft SQL Server 2005 menu structure

Copyright FineBuild Team © 2011 - 2021. License and Acknowledgements

Previous Install System Views Map Top Install StreamInsight Next