Please consult the following information to see if it helps. If you are still experiencing difficulty, please open a support ticket with the Visix Helpdesk at http://www.visix.com/technical_support_request.html.
For EMS Enterprise 4.x, gather the following information. Consult your network administrator and/or database administrator for help.
1. EMS Server host name or IP Address
2. EMS SQL database instance name
3. EMS SQL database name
4. If using Windows Authentication;
a. Windows account name (Domain and Name)
b. Windows account password
5. If not using Windows Authentication;
a. EMS SQL login username
i. Note: If necessary, an SQL script is available from Visix or Dean Evans & Associates to create an EMS SQL Login for AxisTV
b. EMS SQL login password
Log into AxisTV with administrative privileges and go to Events | Dean Evans EMS Adapter. Select the correct version of EMS from the "EMS Version" drop-down list. Note: In earlier versions of AxisTV, you must select Enterprise (3.x) when connecting to EMS Enterprise 4.x.
When you use Enterprise 4.x, you must tell AxisTV the name of the SQL Server computer. This name can be a DNS name or an IP address. Enter it in the "Enterprise/Professional 9.x SQL Server" field.
• Some versions of EMS use a "named" instance of SQL Server by default, usually named “EMS”. In these cases, you will have to enter the SQL Server name in the following form: computer-name\sql-instance-name, e.g., "EMS_Server_Name\EMS".
• Also, in some cases, it may be necessary to enter the TCP port number that the EMS SQL Server is listening on, in the following form: computer-name,port-number. By default, the port number would be 1433, e.g., "EMS_Server_Name,1433" (no space after comma).
• Finally, sometimes you must use both instance name and port number, e.g., “EMS_Server_Name\EMS,1433”.
After you specify the name of the SQL Server computer you must give the name of the database on the server. Enter the EMS SQL database name in the "SQL Database" field.
Choose whether you are using Windows Authentication based on the way the EMS SQL Server Database is configured to allow logins.
• If you are using Windows Authentication, select Yes from the "SQL Uses Windows Authentication?" drop-down list. Make sure that the Windows account (domain & name) is made a member of the AxisTV content server’s local Administrators group, that all of the AxisTV services that require a named account are configured to log on as the account, and that you are logged onto the AxisTV content server with that account. Refer to the Network Administration section of the AxisTV Administrator Guide.
• If you are not using Windows Authentication, select No from the "SQL Uses Windows Authentication?" drop-down list. You need to provide an EMS SQL Login Username and Password. Enter this information in the "SQL User ID" and "SQL Password" fields, and click Save Password. If necessary, an SQL script is available from Visix or Dean Evans & Associates to create an EMS SQL Login for AxisTV.
Hint: If you are experiencing difficulty in connecting to the EMS database, consider this: How would your database administrator connect to the EMS database using Microsoft's ODBC tool from the AxisTV content server? The answer to this question should assist in obtaining the necessary paths, accounts, credentials, etc. to get connected. You may want to actually establish a temporary ODBC SystemDSN connection from the AxisTV content server to the EMS database for testing purposes. One common problem is port blocking on the network.
Once you have set all the information that AxisTV needs to find and communicate with the Dean Evans EMS database you can test the connection by clicking Connect. When successful, the lower portion of the screen will contain the Event Rooms, Types and Statuses found in the Dean Evans EMS Database. If any errors occur, then you will be given those connection errors on your screen so you can get assistance from your network or database administrators.