beautypg.com

Setting up sql server properties for the dsm, Setting up the newsshare server – Grass Valley Network Attached Storage System Serial ATA Network User Guide v.1.0.04 User Manual

Page 177

background image

Appendix

Setting Up the Database System Manager

176

Digital News Production

Setting Up SQL Server Properties for the DSM

To set up SQL Server properties:

1. Select

Start | Programs | SQL Server | Enterprise Manager

.

2. Click “

+

” next to

Microsoft SQL Servers

and then next to

SQL Server

Group

to reveal the DSM machine.

3. Right-click on the DSM’s icon and select

Properties

.

4. Click the Security tab; under Authentication, select

SQL Server and

Windows

.

5. Click the Memory tab and use the Maximum slide bar to set the memory

limit.

The memory limit should be the maximum memory of the machine minus
128 MB.

6. Click

OK

.

Setting Up the NewsShare Server

In order for the NewsShare NAS to operate properly as a news database, you
need to run the SetupNewsShareServer installer.

The installer will not modify or delete customer data in existing News
databases; it simply makes compatibility changes for programming interfaces.
Nonetheless, it is strongly recommended that backups be made of existing,
server-mounted News databases prior to running the installer. See “Using
Database Utilities” on page 177 for more details.

To run the installer:

1. Log on to the DSM machine as Administrator.

2. Make sure that the DSM is not in active service to NewsShare clients.

3. Locate the file, SetupNewsShareServer.exe, on the NewsroomSuite CD-

ROM.

4. Double-click the installer icon,

SetupNewsShareServer.exe

.

The installer runs and copies files onto the DSM.

5. Click

OK

.