Configuring the database system manager (dsm), Installing windows 2003 server and sql server, Configuring sql server – Grass Valley Aurora Edit LD v.6.5 Installation User Manual
Page 24: Installing the newsshare server

10
Aurora Edit Installation Guide
November 25, 2008
Chapter 2 Introducing NewsShare
Configuring the Database System Manager (DSM)
You must perform the following steps on each DSM to use NewsShare:
• Install Windows 2003 Server and SQL Server software
• Configure SQL Server
• Install the NewsShare server
• Configure IP addresses (NAS only)
Installing Windows 2003 Server and SQL Server
Install the Windows 2003 Server and SQL Server software following the network
configuration for your news station. See the Microsoft documentation for details.
Configuring SQL Server
To configure the SQL server:
1. Select
Start | Programs | Microsoft SQL Server | Enterprise Manager
.
2. Expand the Tree view to reveal the DSM machine by clicking the “+” next to
“Microsoft SQL Servers” and also next to “SQL Server Group.”
3. Right click on the DSM icon and select
Properties
. (Except as noted in the following
steps, do not change default values.)
a. Click the Security tab. Under Authentication, make sure that
SQL Server and
Windows
is selected.
b. Click the Memory tab and verify that
Dynamically configure SQL Server memory
is
selected. Set the memory limit to 256 MB less than the server’s memory size.
4. Click
OK
to save settings and close the SQL Server Properties dialog box.
Installing the NewsShare Server
You must install a NewsShare server on each NAS DSM. This installation does not
modify or delete existing News databases; it makes changes for programming interface
compatibility only. Nonetheless, it is strongly recommended that you back up existing
News databases before running the installer. See Appendix B for backup utilities.
To install the NewsShare Server:
1. Log in to the DSM machine as Administrator.
2. Stop the Failover Monitor Service and make sure the unit is not in active service to
NewsShare clients or SmartBin Services.
3. On the Aurora Suite CD, go to the
NewsShare
directory and double-click
Setup.exe
.
The installer can be run directly from the CD, a network volume, or a local drive.
After the installer has been run on both DSMs, they can be returned to service.