Export (0) Print
Expand All
Creating Audit Tables, Invoking COM Objects, and More
Exception-handling Techniques
Exploring SQL Server Triggers: Part 2
Deliver User-Friendly Reports from Your Application with SQL Server Reporting Services
SQL Server: Display Your Data Your Way with Custom Renderers for Reporting Services
Updating Data in Linked Servers, Information Schema Views, and More
XML Features in SQL Server 2000
Expand Minimize
2 out of 6 rated this helpful - Rate this topic

Notification Services Quick Start Guide for Sample Installation

SQL Server 2000
 

Microsoft Corporation

February 2003

Applies to:
     Microsoft® SQL Server® Notification Services

Summary: Microsoft SQL Server Notification Services provides four sample applications that show how to use its various features: Flight, Weather, Stock, and Realtor. (5 printed pages)

Contents

Introduction
Step 1: Install Software
Step 2: Configure the Sample Applications
Step 3: Test the Stock Sample
Using Visual Studio .NET with the Samples
Using the Documentation

Introduction

This quick start guide provides step-by-step procedures for:

  • Setting up Notification Services on a single computer.
  • Installing the Notification Services samples, and configure them to use a domain account with local administrator privileges.
  • Testing the Stock sample to ensure that sample installation and configuration succeeded.
Note   Three of the samples use the SMTP protocol to deliver notifications: Flight, Weather, and Realtor. Currently, the SMTP protocol requires the message sender to be a local administrator. This means that the Microsoft Windows® service that runs Notification Services must be associated with an account having local administrator privileges.

To simplify sample configuration, this quick start guide focuses on the Stock sample, but the procedures in this document will work for all samples.

For additional configuration options, and more information about running the sample applications, see Notification Services Books Online.

Step 1: Install Software

Notification Services Books Online outlines the required hardware and software for Notification Services. In this quick start guide, Notification Services, Microsoft Visual Studio® .NET, and SQL Server 2000 are installed on the same computer, which streamlines some of the installation. The following process ensures your computer has the required software:

  1. Verify that the server operating system is Windows 2000 SP2 or later, or Windows XP Professional.
  2. Go to the Microsoft Windows Update Web site , and check for operating system updates. Install any critical updates before proceeding.
  3. If not already installed, install Internet Information Services (IIS).
  4. Verify that Microsoft .NET Framework version 1.0.3705 is installed. If necessary, you can download it from the Microsoft Download Center. .NET Framework can also be also installed using Windows Update, so check your system before downloading a new copy.
  5. If not already installed, install a default instance of SQL Server 2000.

    You can use SQL Server 2000 Standard Edition, SQL Server 2000 Enterprise Edition, or SQL Server 2000 Developer Edition on the Windows 2000 Server, Advanced Server, or Datacenter Server operating systems. You can also use SQL Server 2000 Developer Edition on the Windows 2000 Professional or Windows XP Professional operating systems. Notification Services is not compatible with the Microsoft Data Engine (MSDE).

    Note   For deployed notification applications, you must use either SQL Server 2000 Standard Edition or SQL Server 2000 Enterprise Edition.
  6. If you have not already done so, apply the latest service pack to your instance of SQL Server.
  7. Install Visual Studio .NET, including Microsoft Visual C#™ .NET, Microsoft Visual C++® .NET, and Microsoft Visual Basic® .NET.

    Installing Visual Studio .NET after SQL Server automatically registers SQL Server with Visual Studio .NET. Installing Visual Studio .NET before SQL Server, in contrast, does not register SQL Server with Visual Studio .NET. In this case, you must add the SQL Server Binn folder (C:\Program Files\Microsoft SQL Server\80\Tools\Binn by default) to the Visual C++ path as follows:

    1. Launch Visual Studio .NET.
    2. On the Tools menu, click Options.
    3. In the left pane of the Options dialog box, expand the Projects folder, and then select VC++ Directories.
    4. In the Show directories for box, select Executable files. Verify that the SQL Server Binn folder (default C:\Program Files\Microsoft SQL Server\80\Tools\Binn) is not already in the list of executable directories.
    5. To add the SQL Server Binn folder to the list, click the folder button above the directory window. This will add a new line in the directory window. Then click the ellipsis button on the new line to open a standard Windows dialog box where you can browse for a directory to add. Navigate to your SQL Server Binn folder, and then click Open.
  8. Check for the ASPNET account by opening the User Accounts directory in Control Panel. If the ASPNET account was not created during your installation of Microsoft Visual Studio .NET, run windows_directory\Microsoft.NET\Framework\v1.0.3705\aspnet_regiis.exe to create it.
  9. Install SOAP Toolkit 2.0 SP2, which is available from the SOAP 2.0 Toolkit SDK and Samples Download Center.
  10. Install SQLXML 3.0, which is available from the Microsoft SQL Server Web site on Microsoft.com.
  11. Install Notification Services, making sure to install all components (Engine Components, Client Components, Database Components, Documentation, and Sample Applications).

Step 2: Configure the Sample Applications

After you install Notification Services, you can configure the sample applications for your environment. For the quick start configuration, run the SetupSamples command, following these steps:

  1. After installation is complete, open a command prompt and navigate to the Samples folder.
    1. On the Start menu, point to Programs, point to Microsoft SQL Server Notification Services, and then click Notification Services Command Prompt.
    2. At the command prompt, type cd Samples.
  2. To configure the samples, at the command prompt, type
    SetupSamples "Domain\User" "Password" ComputerName.

    For example, assume the following information:

    • User is ScottB.
    • Domain is AdventureWorks.
    • The user's password is w0r!dAsh.
    • Server name of the computer hosting the default SQL Server instance is TIGGER.

    The command line would then be as follows:

    SetupSamples "AdventureWorks\ScottB" "w0r!dAsh" TIGGER
    

    Close the command prompt window when SetupSamples has finished running.

    The domain user account must have a SQL Server login account on the default instance of SQL Server. The SetupSamples utility grants the necessary database permissions to the login account.

    SetupSamples assigns the user name and password to the Windows services that run the sample applications and grants the account the necessary permissions in Windows.

    For more information about the samples and the SetupSamples utility, see Notification Services Books Online.

Step 3: Test the Stock Sample

After you set up the samples, test the Stock sample to make sure that Notification Services and the samples are working properly.

  1. On the Start menu, point to Programs, point to Microsoft SQL Server Notification Services, and then click Notification Services Command Prompt.
  2. To navigate to the Stock folder, type cd Samples\Stock at the command prompt.
  3. At the command prompt, type RunSample.

    The RunSample command builds the databases for the sample, creates the NS$StockInstance service that runs the sample application, starts the service, and then drops XML event data to a folder. The service runs for 60 seconds. During this time, Notification Services generates notifications and posts them to a folder.

  4. Using Windows Explorer, navigate to ..\Program Files\Microsoft SQL Server Notification Services\v2.0.2114.0\Samples\Stock\Test\Notifications.

    In this folder, you should see a file named FileNotifications.txt. This file contains notifications from the Stock application that were delivered using the standard File protocol.

  5. Open FileNotification.txt with Notepad and verify that it contains notifications.

    If the sample fails to produce notifications, check the Notification Services Readme.txt file for troubleshooting tips.

Using Visual Studio .NET with the Samples

After you verify that installation and initial configuration worked by testing the Stock application, you can use Visual Studio .NET to work with the samples.

To use the Samples Setup Web page to interact with the samples:

  1. On the Start menu, point to Programs, point to Microsoft SQL Server Notification Services, point to Samples, and then click Samples Setup.
  2. Follow the quick start instructions for using the samples, starting with Step 3. You do not need to run the SetupSamples utility again. SetupSamples needs to be run only once per installation of Notification Services.

Using the Documentation

Use Notification Services Books Online to learn more about the samples and how to run them. You can go directly to the samples documentation from the Start menu:

  • On the Start menu, point to Programs, point to Microsoft SQL Server Notification Services, point to Samples, and then click Samples Documentation.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.