3 setup sql server communications, 3.1 overview – Innotech eServer User Manual

Page 84

Advertising
background image

eServer Setup and Site Installation Instructions

Page 84

© Mass Electronics Pty Ltd 2009

Edition 5.0 dated 07/01/2014

4-3 Setup SQL Server Communications

4-3.1 Overview

The following information is intended to provide qualified technical personnel with the required

settings for a manual setup of a Microsoft SQL Server 2008 R2 Express Edition database.

SQL Server 2008 R2 Express Edition is required for site which are using historic Trends or ATOM Reporting functionality.

Innotech recommends where possible to use the Innotech Chronicle Server Installation Package which automates the

installation and configuration of SQL Server to operate correctly with eServer. Contact Innotech Sales for more

information on Chronicle, ATOM and other BMS solutions. Note that this requires a computer which has not had

any version of SQL Server installed previously.

To integrate with an existing SQL Server, or upgrade to SQL Server 2008 R2 Express Edition, consult with the Site IT

Manager to ensure that the SQL Server settings are correctly configured as listed below in

4-3.2 Default SQL Server

2008 R2 Express Edition Settings

.

IMPORTANT

NOTE

Advertising