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

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
.