Installation guide

Installation Guide AMS Suite: Intelligent Device Manager
NOVEMBER 2013
25
Database–Microsoft SQL Server 2008
AMS Device Manager 12.5 uses a named instance, Emerson2008, of SQL Server 2008
R2, Service Pack 2 for its database. The default password for this named instance is
42Emerson42Eme. The size of your database determines which edition of SQL Server
2008 you must use:
• If your database is less than 10 GB, you can use SQL Server 2008 R2 Express,
Service Pack 2. The AMS Device Manager setup installs this version.
• If your database is greater than 10 GB or will be at some future time, you must
install a full version of SQL Server 2008 R2, Service Pack 2
before you install AMS
Device Manager.
• If the AMS Device Manager system will support more than 3000 AMS Tags or
use the Device Configuration Reporting utility, a full version of SQL Server is
recommended regardless of database size.
A full version of SQL Server must be purchased separately (if you do not already have
it). The full version of SQL Server recommends server operating systems.
The AMS Device Manager installation program installs or updates SQL Server on your
PC as follows:
• If no SQL Server is installed, the AMS Device Manager installation program will
install SQL Server 2008 R2, Service Pack 2 and create an Emerson2008 named
instance with a password of 42Emerson42Eme.
• If an instance of SQL 2008 R2 Express, Service Pack 2 is installed, but not the
Emerson2008 named instance, the AMS Device Manager installation program
will create the Emerson2008 named instance with a password of
42Emerson42Eme.
• If the SQL Server 2008 R2, Service Pack 2 Emerson2008 named instance is
already installed, the AMS Device Manager installation program will continue
with the next part of the installation program. Access to the SQL Server system
administrator (‘sa’) account is required. If you do not have access, contact your
network administrator for more information.
Note
The AMS Device Manager database must be located on the AMS Device Manager Server
Plus Station. Any other location is not supported.
NOTICE
Do not use the Windows compress feature on the PC drive where AMS Device
Manager is installed. AMS Device Manager will be unable to open your database
information. Reinstallation of AMS Device Manager will be required.