Grass Valley Xmedia Server Vertigo Suite v.5.0 - Manual (Page 60)

XMS Configuration Guide 5-3
Verifying the XMS’s database settings
The server and database names can be obtained by opening the SQL S ERVER
M ANAGEMENT S TUDIO .
a. Open the SQL S ERVER M ANAGEMENT S TUDIO by selecting S TART > P ROGRAMS >
M ICROSOFT SQL S ERVER 2008 R2>SQL S ERVER M ANAGEMENT S TUDIO .
b. Click C ONNECT in the C ONNECT TO S ERVER window.
c. In the Object Explorer panel of the Microsoft SQL Server Management Studio
window, expand the D
ATABASES folder to display the name of the database.
d. Verify that the server name and database name match those specified on the
Xmedia Server Control Panel’s Database settings page.
5. Verify that the U SER NAME and P ASSWORD fields are accurate.
The U SER NAME and P ASSWORD provides a security measure to ensure that only the
qualified user (i.e. the system administrator) has permission to connect, write, and read
to the database.
By default these fields are both set to sa. Contact your system administrator if the U
SER
N AME or P ASSWORD appear to be different than the default.
6. Verify that C ONNECTION P OOLING is enabled and set to 10.
When this setting is enabled, the value specified establishes the number of
connections in the connection pool. Having a connection pool helps the Xmedia Server
service its clients in a timely fashion. When this setting is disabled, it will not use a
connection pool to the database and it will have only a single connection.
7. Click the T EST C ONNECTION button to verify the validity of the settings and the
connection to the database.
If the T
EST DATABASE CONNECTION pop-up window again reports a failed connection,
contact our Technical Support department for assistance ( [email protected] ).
Server name
Database name