Step 1 – SQL Database Component Installation

Before you Begin

•      Supported versions of Microsoft SQL Server are: 2005 with SP 3, or 2008 with SP1
Note:  Microsoft SQL Server 2000 with SP4 is supported only for those upgrading to NotifyLink Enterprise Server version 4.7.x from an older version.  By the next major release of NotifyLink Enterprise Server, all new installations, as well as upgrades will require the SQL Server versions listed above.

•      Upgrades:  Before you begin an upgrade of the existing database, STOP all of the NLES Services and web services (IIS or Apache).

•      If you are using SQL Server 2005, you should enable TCP before you begin.

In SQL Server Configuration Manager, select SQL Server 2005 Network Configuration > Protocols for MSSQLServer, and enable TCP/IP

 

 

 

1.  Select the SQL Database button, and then click Install. (Not necessary if you chose “Install All 3 Components.”) 

2.  Answer Yes at the popup dialog to begin running the NotifyLink SQL Installer.

3.  Read through the Welcome screen and click Next.

4.  Read the License Agreement carefully and select 'I accept the License Agreement' to continue. Click Next to display the Readme Information.  Read this information carefully. 

5.  Click Next to view the Destination Folder dialog.  Choose your Destination Folder for the Enterprise Server software, and then click Next.   You can change the drive, but leave the ProgramFiles/NLES path.  This is required so that, in the future, you can run the NotifyLink Patch Installer to apply software updates.

6.  At the SQL Server Information screen, enter the following:

•      From the drop-down list select the SQL Server to which you will install the database.  This allows you to install to the local server or a remote server.  It will add the required Enterprise Server database to the server's SQL Server Database.

•      Enter the sa password defined at the installation of SQL Server.

•      Create a username and password for the SQL Server login.  Jot it down, as the Messaging and Web installers will prompt for this username/password.  This will be used by the NotifyLink components to access the database. 

Upgrades:  Database login credentials will default to the current username and password when upgrading.

•      Click Next > to finish the SQL Database Component installation.  When it is completed, you will see a screen that reads "The SQL Database Component has been installed/upgraded successfully!"

Note:  Several warning messages appear near the completion of the Database Component installation.  This is expected behavior and the messages can be ignored.

EX: Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'CheckForPolicyDiffsByClass'. The stored procedure will still be created.

 

 

Administrator’s Tip: Changing Database Login Password

The password is encrypted for security purposes.  Should you wish to change the database password after installation, you must contact Notify Technical Support.  A technical support representative must decrypt, change the value of, and re-encrypt the password, then change in the registry.

 

 

Proceed with Step 2 – Web/HTTP Server Component Installation