RMS 3 Interface
Contents
1. D RB B amp RH amp EI User Filter Policies Roles Facets Ej Sche Asymi Start PowerShell Certifi Symm Reports m Dateb Refresh E gj Security 0 Server Objects gj Replication E E Management 5 SQL Server Agent Agent XPs disabled Ready FIG 12 Databases gt Security gt New User This opens the New User dialog FIG 13 NOTE xi User name RMS Login name EBMPANYARMS el C Certificate name Key name C Without login Default schema Schemas owned by this user Owned Schemas db_ddladmin db_denydatareader db_denydatawriter db owner db securityadmin guest Database role membership Role Members db datareader db datawriter db ddladmin db denydatareader db denydatawriter db securityadmin FIG 13 Add Domain User Account to RMS Database 5 Enter the RMS login name and select the domain user account RMS as shown above The domain user account should be defined in the form of domain user You can use the search button to locate the domain user account if needed 6 Select the db owner role under Database Role Members 7T Click OK to save the user account and permissions to the RMS database The db owner privilege will grant the RMS user account full permissions over the RMS database If you require more restrictive access refer to the Database User Permissions section on page 31 4 Configure RMS for Windows Authenti2. Created 6 of 7 views view_PrestigeLevels Procedures O0 h Created 34 of 227 procedures sp GetUserGroupBylD FIG 32 Database Wizard Database Structure 6 Once the database installation is complete the Database Wizard will close and return you to the RMS Configuration Wizard FIG 33 Resource Management Suite Configuration Wizard BI dud Resource Management Suite Configuration Wizard C Welcome E Database V Connection Configuration C Updates Pr fas 5 5 5 F FIG 33 RMS Configuration Wizard Database Installed amp Connected After installing the RMS database you may need to create database user account and grant specific permissions access Refer to the Database Authentication section on page 5 Referto the Database User Permissions section on page 31 After the database installation is complete if you need to change the RMS database user account to a more restrictive access account than the one that was used to create the RMS database then in the RMS Configuration Wizard select Configuration under the Database node FIG 34 Resource Management Suite Configuration Wizard AJ rv Resource Management Suite Configuration Wizard Configure SQL Server Database Connection Settings Database Server Nsgespress w C Use Windows Authentication Use SQL Server Authentication Username ims 5 Licensing J Presso
3. al EAM Database Administrator s Guide RMS Resource Management Suite v3 3 or higher Resource Management Suite Enterprise Applications Last Revised 4 15 2011 AMX Software License and Warranty Agreement LICENSE GRANT AMX grants to Licensee the non exclusive right to use the AMX Software in the manner described in this License The AMX Software is licensed not sold This license does not grant Licensee the right to create derivative works of the AMX Software The AMX Software consists of generally available programming and development software product documenta tion sample applications tools and utilities and miscellaneous technical information Please refer to the README TXT file on the compact disc or download for further information regarding the components of the AMX Software The AMX Software is sub ject to restrictions on distribution described in this License Agreement AMX Dealer Distributor VIP or other AMX authorized entity shall not and shall not permit any other person to disclose display loan publish transfer whether by sale assignment exchange gift operation of law or otherwise license sublicense copy or otherwise disseminate the AMX Software Licensee may not reverse engineer decompile or disassemble the AMX Software ACKNOWLEDGEMENT You hereby acknowledge that you are an authorized AMX dealer distributor VIP or other AMX autho rized entity in good standing and have the right to enter
4. Click Next to continue Proceed until the user has successfully been added to the Active Directory RMS Database Administrator s Guide 11 NOTE If your active directory is configured to use Microsoft Exchange then you will be prompted to create an Exchange mailbox while you are cresting this new RMS user account If you intend to interface the Resource Management Suite product with your Exchange system then you will want to create the mailbox account for this new user 2 Add Domain User Account to SOL Server 1 Open Microsoft SQL Server Management Studio and connect to your SQL database server 2 Expand the Security folder right click the Logins folder and select New Login FIG 10 E Microsoft SQL Server Management Studio File Edit View Tools Window Community Help New Query Ly i i So Ls or el 3 Object Explorer Connect 89 Be T 2 S Databases Security Filter Start PowerShell Reports Refresh E 9 Credentials 9 Cryptographic Providers Audits Server Audit Specifications Server Objects Replication Management B SQL Server Agent Agent XPs disabled x E E E E Ready FIG 10 Security gt Logins gt New Login This opens the Login New dialog FIG 11 Database Authentication FIG 11 Login New dialog 3 Inthe Login Name field enter the ne
5. general recommendations for most users however may not apply to all customers where certain sites may require more advanced database services Consult the Microsoft SQL Server Web site for a full listing of the feature comparison and feature limitations imposed by the SQL Express edition http msdn microsoft com en us library cc645993 aspx Forinstructions on installing SQL express refer to the nstalling SQL Server 2005 Express Edition section on page 43 3 It is important to note that RMS does not require a dedicated Microsoft SQL server The RMS database catalog may be installed into an existing Microsoft SQL server or cluster as long as it meets the minimum requirements outlined above 4 Installation of RMS requires an administrative account on the local RMS server and database administrative access The RMS installation RMS Configuration Wizard and all other RMS maintenance tools must be run on the RMS server while logged on with an administrative account 5 If your company has a staffed Database Administrator DBA who will be responsible for the RMS database it is important to provide this document to them and that they carefully review the installation requirements and database access requirements for RMS 2 NOTE Additional Documentation Refer to the following supplemental RMS documents available to view download from www amx com RMS Installation Checklist The RMS Installation Checklist is provi
6. is selected and enter the login account password Ensure the Enforce password expiration and User must change password at next login options are not checked 5 Click OK to save the new user account l 6 RMS Database Administrator s Guide 2 Add SOL Login Account to RMS Database need to install the RMS database and then come back to this step to complete the If the RMS database has not yet been installed on your SQL server then you may permissions configuration for the RMS SQL Login NOTE With the RMS user account added to the SQL database server in the previous step we now need to add the RMS user and grant permissions to the RMS database Open Microsoft SQL Server Management Studio and connect to your SQL database server Expand the Databases folder and find the RMS database Expand the RMS folder and the Security folder Right click the Users folder and select New User FIG 3 E Microsoft SQL Server Management Studio File Edit view Tools Window Community Help T wew Query Oy c vl fo D OF el S PONS Conect S9 39 m FG local SQL Server 10 0 1600 a 9 Databases Ca System Databases 49 Database Snapshots a J Rms CB Database Diagrams E Tables Lj Views E Synonyms 39 Programmability Lj Service Broker Lj Storage E Security THERA It Filter A Policies G E Roles Facets Lj Asym Start PowerS
7. lim s mix amp mBpI 9 mid v amp t Active Directory Users and Computer 177232 Se objects E Saved Queries D 1 company com Builtin Administrator User Computers fficet Publishers Security Group 3 25 Domain Controllers BonsAdmins Security Group ForeignSecurityPrincipals fi cert Publishers Security Group MyBusiness PonsAdmins Security Group amp f pnsUpdateProxy Security Group Delegate Control ain Admins Security Group Find ain Computers Security Group Computer All Tasks gt Contact 2 Group view InetOrgPerson New Window from Here Query based Distribution Group Refresh MSMQ Queue Alias Export List Printer User Create anew objec Properties Shared Folder Help FIG 7 Active Directory Users and Computers New gt User i Database Authentication This opens the first New Object User dialog FIG 8 FIG 8 New Object User dialog 1 3 Enter the username and login credentials 4 Click Next to continue to the next New Object User dialog FIG 9 FIG 9 New Object User dialog 2 5 Enter a password for the new user account Since this is a user account that will run the RMS services in an unattended mode make sure to select the Password never expires option Also uncheck the User must change password at next logon option
8. the Feature Selection window select Client Components gt Connectivity Components gt Entire feature i Microsoft SQL Server 2005 Express Edition Setup Feature Selection Select the program features you want installed Click an icon in the Following list to change how a feature is installed Feature description Database Services Installs command line tools B connectivity components E3 v Connectivity Components programming models management X Software Development Kit tools and development tools This feature requires 39 MB on your hard drive It has 1 of 2 subfeatures selected The subfeatures require 21 MB on your hard drive Installation path c Program Files Microsoft SQL Server Disk Cost FIG 40 Feature Selection 4 Finish the default install Setup 1 Goto Start Microsoft SQL Server 2005 SQL Server Configuration Manager 2 Goto SQL Server 2005 Network Configuration gt Protocols for SQLExpress SQL Server Configuration Manager File Action View Help eo amp mium ES SQL Server Configuration Manager Local Protocol Name status SQL Server 2005 Services Shared Memory Enabled SQL Server 2005 Network TL ane Af Named Pipes Disabled Protocols for S TCP IP Disabled SQL Native Client Configuration va Disabled FIG 41 SOL Server 2005 Network Configuration 3 Right click TCP IP select Enable 4 Goto SQ
9. to RMS Database If the RMS database has not yet been installed on your SQL server then you may need to install the RMS database and then return to this step NOTE With the DOMAIN RMSServerMachineName account added to the SQL database server in the previous step we now need to add the DOMAIN RMSServerMachineName account and grant permissions to the RMS database Open Microsoft SQL Server Management Studio and connect to your SQL database server Expand the Databases folder and find the RMS database Expand the RMS database folder and the Security folder Right click the Users folder and select New User FIG 28 E Microsoft SQL Server Management Studio File Edit View Tools Window Community Help T New Query D ty P Ls ES A 3 Object Explorer Pons aL 49 m YRS 4 local SQL Server 10 0 1600 Lg Databases Lj System Databases Jj Database Snapshots j Rms E Database Diagrams E Tables Lg Views E Synonyms E Programmability E Service Broker Lj Storage E Security 1 RB RE RB RB FH FH E ra i Filter T Policies Ca Facets E Lg Sche E gg Asymi Start PowerShell RF Lg Certifi E Symma Reports E Datab n Refresh Security Lg Server Objects Replication gj Management B SQL Server Agent Agent XPs disabled Ready FIG 28 Databases Security Users New User This opens the
10. tool to create a database and apply these script files If you do not already have one of these tools you can download and install the Microsoft SQL Server Management Studio Express free edition directly from the Microsoft web site http go microsoft com fwlink LinkId 65110 Manual Installation Steps 1 Open the SQL database management tool and establish a connection to the SQL server or SQL cluster to which you wish to install RMS You will need to connect using the sa account or other user account with database creation and database security management privileges FIG 35 i Connect to Database Engine Microsoft Microsoft AY Windows Server System SQL Server 2005 Database Engine Server name database server database instance Authentication SAL Server Authentication Login sa xxx Password C Remember password FIG 35 Connect to Database Engine SQL script file in the next step depending on the SQL database management tool you You may not be prompted to connect to the database server until to attempt to open a are using NOTE wi EE 2 Open the ASPNet sql SQL script file in your SQL database management tool connect to database here if prompted This script file contains a variable placeholder token for the RMS database catalog name 3 Perform a global search and replace on the text RMS PLACEHOLDER 2112 Replace this text with th
11. 624 8000 e 469 624 7153 fax 800 932 6993 technical support www amx com 93 3002 09 REV B
12. ETWORK SERVICE Account to RMS Database If the RMS database has not yet been installed on your SQL server then you may need to install the RMS database and then return to this step NOTE With the NT AUTHORITYWETWORK SERVICE account added to the SQL database server in the previous step we now need to add the NT AUTHORITYWETWORK SERVICE account and grant permissions to the RMS database 1 Open Microsoft SQL Server Management Studio and connect to your SQL database server 2 Expand the Databases folder and find the RMS database 3 Expand the RMS database folder and the Security folder 4 Right click the Users folder and select New User FIG 24 E Microsoft SQL Server Management Studio File Edit View Tools Window Community Help ad New Query Liy i to fo D 1 lel 3 Object Explorer Connect 39 39 m VRS 4 local SQL Server 10 0 1600 gj Databases F Lj System Databases E Database Snapshots j Rms gj Database Diagrams 0 Tables E views E Synonyms E Programmability E Service Broker E Storage a 0 Security E ra i Filter r Policies C Roles Facets Ll Sche E Lg Asymi Start PowerShell C Certifi E C3 Symm Reports Lj Datab Refresh 9 Security i Ll Server Objects E Replication gj Management B SQL Server Agent Agent XPs disabled Ready FIG 24 Databases Security Users New User This o
13. FIG 39 RMS Configuration Wizard Connected to database successfully Database Backup Overview The RMS database should be incorporated into your organizations regular backup schedule All RMS usage and room configuration data is stored in the RMS database RMS does not provide an automated database backup mechanism if you do not already have a database backup system in place you should highly consider implementing some form of database backup solution In the event of server hardware failure or data corruption all RMS data may be lost without a regular backup Additional Online References MICROSOFT Backing Up and Restoring Databases in SQL Server http msdn microsoft com en us library ms187048 aspx Database Backup 42 RMS Database Administrator s Guide Installing SOL Server 2005 Express Edition Overview This information is intended to assist you in installing and configuring SQL Server 2005 Express Edition for use with the RMS application The Network Administrator should perform this type of configuration Resource Management Suite does support Microsoft SQL Express 2005 databases however the RMS services and website must connect using a TCP IP connection or named pipes NOTE Connecting to SQL Express 2005 via shared memory is not supported Installation 1 Download the SQL Server 2005 Express Edition SP1 min from Microsoft 2 Run the SQLEXPR EXE 3 Follow the default installation except as follows In
14. L Native Client Configuration Client Protocols Ensure TCP IP is enabled If it is not right click TCP IP select Enable f SQL Server Configuration Manager File Action View Help e miim A HS SQL Server Configuration Manager Local i SQL Server 2005 Services F Shared Memory 1 Enabled SQL Server 2005 Network Configuration SF TCP IP 2 Enabled He Protocols for SQLEXPRESS Named Pipes 3 Enabled B 8 SQL Native Client Configuration Y VIA Disabled Client Protocols Aliases FIG 42 SOL Native Client Configuration 5 Goto SQL 2005 Services SQL Server Configuration Manager File Action View Help eo eee E SQL Server Configuration a Local Ly SQL Server 2005 5 SOL Server Browser Stopped Other SQL Server 2005 Network Configuration ESOL Server SQLEXPRESS Running Autor amp Protocols for SQLEXPRESS eue SQL Native Client Configuration Client Protocols Aliases FIG 43 SOL 2005 Services 6 Right click SOLEXPRESS select Restart After the database has restarted you may exit the SOL 2005 Configuration Manager Installing SOL Server 2005 Express Edition RMS Database Administrator s Guide 45 us EAM It s Your World Take Control 4 11 92011 AMX All rights reserved AMX and the AMX logo are registered trademarks of AMX AMX reserves the right to alter specifications without notice at any time 3000 RESEARCH DRIVE RICHARDSON TX 75082 USA 800 222 0193 469
15. New User dialog FIG 29 iof x m Script 5 Help E M User name JDOMAINNAMSServerMachineNameS Login name DOMAINWRMSServeMachimName zd Certificate name a C Key name Without loan Default schema je Schemas owned by this user Owned Schemas db_ddladmin db_denydatareader db denydatawriter db owner db securityadmin AT BeOS guest Database role membership Role Members db_datareader db_datawriter db_ddladmin db_denydatareader 3 db denydatawriter i db_owner db_securityadmin FIG 29 New User dialog 5 Enter the DOMAIN RMSServerMachineName user name and select the login name DOMAIN RMSServerMachineName as shown above Q You cannot use the Search button to find this account it must be manually entered NOTE 6 Select the db owner role under Database role membership 7T Click OK to save the user account and permissions to the RMS database account full permissions over the RMS database If you require more restrictive access please see the DATABASE PERMISSION The db owner privilege will grant the DOMAINIRMSServerMachineName user NOTE section of this document for more information NOTE Additional Online References e MICROSOFT How To Connect to SQL Server Using Windows Authentication in ASP NET 2 0 http msdn microsoft com en us library ms998292 as
16. POSSIBILITY OF SUCH DAMAGES BECAUSE SOME STATES COUNTRIES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES THE ABOVE LIMITA TION MAY NOT APPLY TO LICENSEE U S GOVERNMENT RESTRICTED RIGHTS The AMX Software is provided with RESTRICTED RIGHTS Use duplication or disclosure by the Government is subject to restrictions as set forth in subparagraph 1 ii of The Rights in Technical Data and Computer Software clause at DFARS 252 227 7013 or subparagraphs 1 and 2 of the Commercial Computer Software Restricted Rights at 48 CFR 52 227 19 as applicable SOFTWARE AND OTHER MATERIALS FROM AMX COM MAY BE SUBJECT TO EXPORT CONTROL The United States Export Control laws prohibit the export of certain technical data and software to certain territories No software from this Site may be downloaded or exported i into or to a national or resident of Cuba Iraq Libya North Korea Iran Syria or any other coun try to which the United States has embargoed goods or ii anyone on the United States Treasury Department s list of Specially Designated Nationals or the U S Commerce Department s Table of Deny Orders AMX does not authorize the downloading or exporting of any software or technical data from this site to any jurisdiction prohibited by the United States Export Laws This Agreement replaces and supersedes all previous AMX Software License Agreements and is governed by the laws of the State of Texas a
17. SOL Server eese eene nennen nnne ennn nennen 5 2 Add SOL Login Account to RMS Database eese eene eene ennn nennen 7 3 Configure RMS to use SOL Login ssp erene eee enne eene nnne nenne nnns nntnn nnne 9 Windows ridi ipie piro RR 10 1 Create Domain User Account csccsscesecsscssccssccsccnsccsccsscesccsecesccescesccsscesceseceeceees 10 2 Add Domain User Account to SOL Server sccccsssscccsssscccsesccccsssccecesscceeesscsensseceees 12 3 Add Domain User Account to RMS Database ccccssscccsscccssccescessccscccesceesseees 14 4 Configure RMS for Windows Authentication esses eee ener 16 a RMS NT S rvicessiscecscscedessccssdscceceeedesucacsecens IULEPUETMEEMTES 17 b RMS Web Application ASP NET cccccscccssccccsscssssesssssssssessssssseescesceeeeeseeeeeeeeeeeeoes 21 Add NT AUTHORITY NETWORK SERVICE Account to SQL Server ccsccceseeeeeeeeeseneeeseees 21 Add NT AUTHORITY NETWORK SERVICE Account to RMS Database sss 23 Add NT DOMAIN RMSServerMachineName Account to SQL Server esses 25 Add DOMAIN RMSServerMachineName Account to RMS Database sss 27 Additional Online References sesssssssssssesseeeneee nennen nennen neret ne nnne nennen nnns 29 c RMS Configuration Wizard amp RMS Database Wizard eene 29 D
18. Windows Active Directory domain authenticated permissions rather than a direct SOL username and password login account This option may be required under the policies of your Information Technology department SOL Login To configure the RMS software for use with a SQL login account please follow the instructions below 1 Add SOL Login Account to SOL Server 1 Open Microsoft SQL Server Management Studio and connect to your SQL database server 2 Expand the Security folder right click the Logins folder and select New Login FIG 1 E Microsoft SQL Server Management Studio File Edit view Tools Window Community Help Ei New Query Ly c ey So D oF A S Connect S 39 m Y s 5 local SQL Server 10 0 1600 E Databases E Security E Logins P eum e amp Filter gt A E E A Start PowerShell A p A Reports A Refresh i un m Lj Credentials Lj Cryptographic Providers Lj Audits Lj Server Audit Specifications E Server Objects Lj Replication E Management B SQL Server Agent Agent XPs disabled x E Rm IE Ready FIG 1 Logins New Login This opens the New Login dialog FIG 2 ed n VG Database Authentication default FIG 2 New Login dialog 3 In the Login Name field enter the new RMS Login name 4 Next make sure the SQL Server Authentication option
19. X RMS Server AMX RMS NetLinx Connection Manager AMX RMS Communication Manager AMX RMS Scheduling Manager When attempting to Register the RMS services in the RMS Configuration Wizard the user will be prompted to provide a user account for each RMS service in the Register Service dialog FIG 17 Register Service RMS Server Service If using Windows Authentication to connect to the RMS Database then you must configure a Log On s user account below with a user account that has NT domain Active Directory permissions to the RMS database If you are using a SQL Express database server installed locally on the same server as the RMS application then the Local System account should work without requiring a custom user account Log on as Local System account This account RMS xxx Password Confirm Password Register Service Cancel FIG 17 Register Service dialog If you are using RMS with SQL Express and the SQL Express database server is installed on the same server then the Local System account may be used If you are using RMS with a remote SQL server then you must provide a domain user account that has access to the RMS database You may enter a domain account in the form of domain user The drop down list will not contain domain user account only accounts on the local C computer However you can type in the domainluser account directly in the text ent
20. ame followed by the computer name with a trailing character e g DOMAIN RMSServerMachineName Add NT DOMAINNRMSServerMachineName Account to SOL Server 1 Open Microsoft SQL Server Management Studio and connect to your SQL database server 2 Expand the Security folder right click the Logins folder and select New Login FIG 26 d amp Microsoft SQL Server Management Studio File Edit view Tools Window Community Help id New Query Ly c C So el 3 Object Explorer Connect S9 32 m Y s A E Databases E Lj Security E Ly S t amp Filter b A ZSE A Start PowerShell A B A Reports A z CB Ser Refresh 9 Credentials 59 Cryptographic Providers Lj Audits E Server Audit Specifications E Server Objects E Replication E Management B SQL Server Agent Agent XPs disabled ER EE amp amp Ready FIG 26 Security gt Logins gt New Login This opens the Login New dialog FIG 27 Database Authentication FIG 27 Login New dialog 3 In the Login Name field enter the DOMAIN RMSServerMachineName user account Since this is a domain account and not a local computer account you will need to enter the account login name in the form of domain machinename Also make sure the Windows Authentication option is selected 4 Click OK to save the new user account 26 RMS Database Administrator s Guide Add DOMAIN RMSServerMachineName Account
21. atabase User Permissions o iri eii ape sno ovale agus ME vapore ria Pedes und dne MU HE 31 enum 31 Flexible ACCESS co sivedeicoxs pou iFu da peur bano cuu ceea REOR epe EsaP EERE eov era ir Ea Eee Uso Pa gp DP CEU PUE 31 Restrictive ACCESS iie ree eee ee sonors aaa eV anuo Fan so ay auo Fauno se su be oko ee o Ya eae dos lo ae PE YN U Ee Ee eoo ao nau 31 Database Installation 2 25 parit ii pone ober dI E Ia FEIUR PRATER KERN RR IR EErR PRSE RR PIER RREN REM PAPE RE iS 33 our M 33 Manual Database Installation 1 paupe oa Ino OE rep o EU FR PE FS EO VET LEO pU PEE EVE TOSS YES U IA 37 etl q 37 Manual Installation Step xccsccc5ccesccnncexsnscaiensssexoeesacerasnns adt nei Cine FIOR ERR UI PAIR EAR Aba ES US 37 Database Backup T 41 Suas qe c ninns betanKeN 41 Additional Online References e Liiirere ettet etre t pereo tate eres terere eee npe aep etas 41 Installing SOL Server 2005 Express Edition eee 43 OvervieW e 43 Installation T 43 SGU 44 RMS Database Administrator s Guide Overview The AMX Resource Management Suite RMS is a line of software solutions d
22. ative access to the database server where the RMS will be installed consult your IT administration or DBA The RMS Configuration Wizard and RMS Database Wizard are executable utilities that run under the context of the logged on user account When attempting to use these administrative tools for RMS server installation or RMS server maintenance the user should logon with a domain user account that has administrative access to the local RMS server During the installation process of RMS on the RMS server the RMS Configuration Wizard will provide the options to connect to an existing RMS database catalog or create a new RMS database FIG 30 JY Resource Management Suite Configuration Wizard fe fe jx A nes Resource Management Suite Configuration Wizard Database Resource Management Suite requires a database connection to continue Please select from the following options Supported Database Servers Microsoft SQL Server 2000 Microsoft SQL Server 2005 Microsoft SQL Server 2005 Express Edition E Fro 2 Eg We m3 se e se o E Sy ear 1 Upgrade An Existing RMS 2 3 or earlier Database Connect To An Existing RMS 3 0 or later Database FIG 30 RMS Configuration Wizard Create a New RMS Database If you have an existing RMS database or your RMS database that was installed manually by the DBA then select the option to Connect To An Existing RMS 3 0 or later Database 1 Tocreate a new RMS database s
23. be granted dbo owner permissions to the RMS database catalog If this option is selected then the RMS services and web site will be able to read write execute stored procedures and alter the database schema Future RMS upgrades may require database schema and data modification and if the users have owner permissions to the RMS database catalog all database updates can be automated via the RMS Server Installation process Restrictive Access RMS can operate with restrictive access permissions The minimum database permissions that must be granted to all RMS database user accounts are Read all Tables Write all Tables Modify Table Data Delete Table Data Execute all Stored Procedures If this option is selected then the RMS services and web site will be able to read write and execute all stored procedures Future RMS upgrades that require database schema and or data modification may require database administrator access to apply the database update scripts The automated database update mechanism built into the RMS Server Installation process may fail to apply the database update scripts if the configured user does not have rights to ALTER CREATE DROP etc Database User Permissions 32 RMS Database Administrator s Guide Database Installation NOTE Overview To create and configure the initial RMS database catalog database administrator privileges are required If you do not have administr
24. cation 1 When configuring the database connection in the RMS Configuration Wizard select the Use Windows Authentication option to use windows database authentication FIG 14 E Resource Management Suite Configuration Wizard AM Resource Management Suite Configuration Wizard ES Welcome r Configure SQL Server Database Connection Settings f Database Cc ction a E Database Server Asqlexpress ES T a bes C Use SQL Server Authentication Usemame Password Database Name RMS ggggggy FIG 14 Use Windows Authentication 2 Ifthe database connection is successful then the following dialog will be displayed FIG 15 E Resource Management Suite Configuration Wizard AM Resource Management Suite Configuration Wizard FIG 15 Connected To Database Successfully If the database connection fails please recheck the domain user account assigned permissions to the RMS database When configuring the database connection in the RMS Configuration Wizard if the option to Use Windows Authentication is selected then the following warning message will be displayed FIG 16 E Resource Management Suite Configuration Wizard bawur AM Resource Management Suite Configuration Wizard r Database Windows Authentication m Welcome c E Database Attention i iv Connection 1 e to Using Windows authentication for database access requires that eo 4 each RMS serv
25. ded to ensure all the necessary prerequisites are met and all the necessary configuration option are identified prior to the installation of the RMS server RMS IT Administrator s Guide This document outlines the installation prerequisites installation guidelines server access permissions and other important IT related information for the RMS application server installation RMS Administrators Guide This document provides information and instructions for the RMS System Administrator RMS NetLinx Programmers Guide This document provides detailed NetLinx programming information for RMS systems RMS Plug In Installation Guides A separate installation guide is provided to describe installing each of the RMS plug ins i e EMS Scheduling Plug in Exchange Mailbox Plug in Groupwise Mailbox Plug in Lotus Notes Appointment Interface Plug in Outlook Scheduling Plug in PeopleCube Scheduling Plug in Planon Scheduling Plug in R25 Scheduling Plug in etc RMS Quick Start Guide This document provides basic instructions for getting started with RMS RMS User Manual This document describes various end user functions of RMS System Requirements Minimum Hardware Requirements Processor Intel Pentium IV 3 GHz x86 or Intel Pentium Dual Quad Core 2 0 GHz Memory 2 GB Display 1280x1024 resolution Hard Disk 500 MB available space RMS must be installed on a dedicated server class machine Supported Platforms Windows Serve
26. e name of the RMS database catalog you with to create The default catalog name typically used is simply RMS Make sure to replace all instances of this placeholder token there are a number of locations in this script file where this placeholder text is embedded Ri Microsoft SQL Server Management Studio Express ga MER Ele Edit View Query Tools Window Community Help Dawn 3 Gd PB S 3 P 169 X nerd master gt Y Execute Y swdblab ASPNet sql Go DECLARE dbname nvarchar 128 DECLARE Bdboptions nvarchar 1024 SET Bdboptions SET dbname IF NOT EXISTS aster dbo sysdatabases Bdbname BEGIN PRINT Creating the dbname database DECLARE 8cmd nvarchar 500 SET 8cmd CREATE DATABASE dbname Bdboptio EXEC B cmd 3 Connected swdblab amxdb 3 0 RTH SWDBLAB rsavage 58 master 00 00 00 Orows Find and Replace QuickFind i Quick Replace Find what IRMS PLACEHOLDER 2112 Current Document i Find options Find Next FIG 36 ASPNet sql SOL script file LE LAAAA a 4 After the database catalog name text replacement is complete you can execute the script This should create the new database catalog and then create all the necessary ASP NET related tables and stored procedures a When the script is complete make sure the query was executed successfully and there are no errors b You may now close t
27. elect Create A New RMS Database 2 Click Next to launch the RMS Database Wizard and display the Database Wizard Create Microsoft SQL Database dialog FIG 31 El Database Wizard A c Database Wizard Create Microsoft SQL Database Microsoft SQL Server Asglespress Search C Use Windows Authentication Use SQL Server Authentication Username sa Password New Database Name Catalog RMS Cancel FIG 31 Database Wizard Create Microsoft SOL Database 3 Enter the Microsoft SQL Server path the preferred database Authentication method and User Credentials if needed and the New Database Name Catalog to create To successfully create a new RMS database the SQL server database account or if using Windows Authentication the logged on user domain account must have database creator privileges on the target SQL server Without the proper database administrative permission the RMS database will fail to create a new catalog 4 Select Next to proceed and attempt to create the new RMS database catalog 5 Ifa successful connection to the database server is established and the RMS Database Wizard can successfully create the new RMS database catalog then the installation of the database tables views stored procedures and default data will proceed FIG 32 Database Wizard AM Database Wizard Database Structure Tables Created 57 of 57 tables RFIDTagHistory Views
28. esigned for IT professionals facility managers and meeting classroom users looking for a way to manage monitor and or schedule up to 1 000 rooms and an unlimited number of assets The RMS application is a client server application where the NetLinx system acts as the client and the RMS application server listens for connections from NetLinx systems NetLinx and the RMS application server communicate using TCP IP sockets In order to establish communication each NetLinx system must be able to resolve and connect to the RMS application server This can be accomplished with a variety of Network configurations including local area networks LAN wide area networks WAN and the Internet This document outlines the installation prerequisites installation guidelines database access permissions and other important database related information for the RMS database installation 1 RMS must be installed on a Microsoft SQL server The list below includes the supported version of SQL servers 8 Microsoft SQL Server 2008 b Microsoft SQL Server 2005 2 RMS can utilize the Microsoft SQL Express edition database at no cost for small installations with a limited number of rooms and users The following guidelines should be considered when evaluating if your site is a candidate for using the Microsoft SQL Express edition If your RMS installation is planned to exceed 300 rooms the Express edition should not be used The guidelines listed above are
29. hell EB Symm Reports Refresh E E E EE E EH a E E Security Ea Server Objects gj Replication 59 Management B SQL Server Agent Agent XPs disabled E RJ RH Ready FIG 3 Users New User This opens the New User dialog FIG 4 5 Enter the RMS login name and the local SQL login name of RMS as shown in FIG 4 You can use the search button to locate the SQL login account if needed Jal xi LS Script L3 Help User name RMS Login name RMS jl C Certificate name C Key name C Without login Default schema El Schemas owned by this user Owned Schemas db_ddladmin r db denydatareader db denydatawriter db owner db securiyadmin guest NTAUTHORITY NETwWORK SERVICE i m db datareader db datawriter db ddladmin db denydatareader db denydatawriter i db owner db securityadmin FIG 4 New User dialog 6 Select the db owner role under Database Role Membership 7T Click OK to save the user account and permissions to the RMS database RMS database If you require more restrictive access refer to the Database User Q The db_owner privilege will grant the RMS user account full permissions over the Permissions section on page 31 NOTE 3 Configure RMS to use SOL Login 1 Inthe RMS Configuration Wizard on the database configuration step enter the RMS user account and passw
30. his SQL script file 5 Open the RMSDBiInstall sql SQL script file in your SQL database management tool connect to the same database server using the same logon credentials here if prompted You will need to select which database catalog that this script will be applied to 6 Select the RMS database catalog that was created in the previous steps FIG 37 E Microsoft SQL Server Management Studio Express efr BAR File Edit view Query Tools Window Community Help n Mew Query nea 1 Execute V E 30 Agdao Ea xX Please ensure these MET directives remain in the file The format MUST be MET KEYNAME meta value No spaces between the comment identifier and the key No spaces on either side of the sign The meta key name MUST be all upper case prefixed with DB Version meta tags MET VERSION N ME Resource Management Suite Database lt m 33 Connected swdblabNamxdb 3 0 ATM SwDBLAB rsavage 58 RMS 00 00 00 rows FIG 37 RMSDBinstall sql SOL script file RMS database catalog selected This step is very important If the wrong database catalog is selected you may potentially inadvertently install a number of RMS tables and stored procedures into another applications database catalog CAUTION 7 With the appropriate RMS database catalog selected you can execute this script When the script query had executed successfully you should not see any errors FIG 38 E Micros
31. ice and the RMS ASP NET web application each C Updates are configured with an account that has database access RMS NT Services When registering each RMS NT Service you must assign the Log On As user account with an account that has Windows authentication permissions to the RMS database RMS ASP NET Web Application By default the RMS ASP NET web application uses specialized domain accounts These domain accounts must be granted access to the RMS database on the SQL database server 2 2 2 8 duuduad Please see the RMS Database Administrator s Guide for more information FIG 16 Database Windows Authentication Warning This warning message is provided to help identify that choosing the Windows Authentication option for the database connection will have additional configuration requirements that must be setup correctly to ensure that RMS can successfully communicate with the RMS database For Windows Authentication to work properly and permit the RMS processes to access the RMS database it is important to understand and identify each of the RMS processes and how they interact with the RMS database RMS processes run under distinct principal user contexts each requiring access to the database server a RMS NT Services RMS contains 4 Windows NT services Each of these service run under their own unique process and all must be configured to use a user account that has Windows Domain permissions to the RMS database AM
32. into and be bound by the terms of this Agreement INTELLECTUAL PROPERTY The AMX Software is owned by AMX and is protected by United States copyright laws patent laws international treaty provisions and or state of Texas trade secret laws Licensee may make copies of the AMX Software solely for backup or archival purposes Licensee may not copy the written materials accompanying the AMX Software TERMINATION AMX RESERVES THE RIGHT IN ITS SOLE DISCRETION TO TERMINATE THIS LICENSE FOR ANY REA SON UPON WRITTEN NOTICE TO LICENSEE In the event that AMX terminates this License the Licensee shall return or destroy all originals and copies of the AMX Software to AMX and certify in writing that all originals and copies have been returned or destroyed PRE RELEASE CODE Portions of the AMX Software may from time to time as identified in the AMX Software include PRE RELEASE CODE and such code may not be at the level of performance compatibility and functionality of the GA code The PRE RELEASE CODE may not operate correctly and may be substantially modified prior to final release or certain features may not be generally released AMX is not obligated to make or support any PRE RELEASE CODE ALL PRE RELEASE CODE IS PROVIDED AS IS WITH NO WARRANTIES LIMITED WARRANTY AMX warrants that the AMX Software other than pre release code will perform substantially in accor dance with the accompanying written materials for a period of ninety 90 days from
33. lays Permission Not Set then you will need to select the Grant Permissions option to apply the correct DCOM permissions for all the user accounts 6 After granting the proper permissions select View Permissions to visually confirm that all accounts now have the proper DCOM permissions In RMS installations that are integrating with Microsoft Exchange the NT service account for the RMS Scheduling Manager service must use a domain account with permissions to the Exchange server If possible use the same dedicated RMS domain account that you created for the database permissions If it is not possible to use this same dedicated domain account and a unique domain account is required for interfacing to the Exchange system then this additional user account will also need to be added to the RMS database and granted the proper permissions b RMS Web Application ASP NET The RMS ASP NET Web application by default runs under the Network Service account When configured to use Windows authentication for database access this account must also be granted access to the RMS database If the SQL server is running on the same server computer as RMS for example if you are running SQL express on the same server then you can simply add the NT AUTHORITYWETWORK SERVICE account to the database server security logins and then add the account and grant permissions to the RMS database catalog Add NT AUTHORITY NETWORK SERVICE Account to SOL Serve
34. n m OS Permissions ferret Lag System Settings Database Name RMS Y New Connection ie FIG 34 RMS Configuration Wizard Configure SOL Server Database Connection Settings Here you can change the database user credentials as needed When complete select Next to test the database connection using the new credential and to proceed with the RMS server configuration Manual Database Installation Overview Some corporate database policies require that all database installed to their database servers be manually installed from the database scripts This is to prevent malicious code from running on the database server The default method of installing RMS is by using the automated database installer via the RMS Configuration Wizard however using the steps outlined below you can use the existing database scripts to manually install the RMS database The RMS database installation scripts are located in the following installation path on the RMS server C Program Files AMX Resource Management Suite Database The two script files used to install the RMS database are ASPNet sql this script installs all the Microsoft ASP NET application database framework tables and stored procedures e RMSDBInstall sql this script installs the RMS application database tables stored procedures and default data You will need Microsoft SQL Enterprise Management Studio Microsoft SQL Enterprise Manager or similar SQL database management
35. nd all disputes will be resolved in the courts in Collin County Texas USA For any questions concern ing this Agreement or to contact AMX for any reason please write AMX License and Warranty Department 3000 Research Drive Richardson TX 75082 Table of Contents RMS Database Administrator s Guide cccccccssssssssssececcceeeeesssesceceeeeeeeeeeees 1 eau me M 1 Additional Documentation ssssecssseeececcccccccccccceccceccceessssssssessssssssseeceeeeeceeeeeeceaeoes 2 System RECUNCIM CIES eR 2 Minimum Hardware Requirements cesses eene eene eene nnn nnne senses nnnnnnnn 2 Supported Platforms m E M M 2 RMS Supported Databases err entree tena reote tro enata aerea KESKE epo PEEreeR 2 RMS Supported Scheduling Interfaces eese n nnne nennen 3 RMS Supported Web Browsers eese nennen eene nennen nnn iosia sorsi isossa 3 RMS SDK Support oreet ern eaa a aa iae ra ES RR RR AERE ERR RE ERR ANNA NR A NAE RES REN R S RAN ERR aA EEARRRAREY 3 Additional System Requirements eee eene nennen nnne nnne ene ttn nnne nnns nnns 3 Database Authenticati i ausscndusinddasusek ebd Qe bl Gb tivpsxl MU PLU nS AERE 5 enun ES 5 SOL LOGI a 5 1 Add SOL Login Account to
36. ocess is running This connection method is also known as Trusted Connection and SSPI Security Support Provider Interface When opting to use Windows Authentication a domain user account must be created in the Active Directory This user account must explicitly be granted user permissions to the RMS database This same domain user account should also be configured as an Administrator on the local RMS server by adding the domain account to the Administrators group on the RMS server Please note this does not mean that this RMS user account must be a member of the Administrator s group in the Active Directory domain In addition to the RMS domain user account the computer that is running the RMS server must also have a computer account defined in the Active Directory domain and the SQL server hosting the RMS database must be a server computer defined in the domain The instructions and screenshots provided here may vary depending on the version and edition of Windows Server you may be using NOTE 1 Create Domain User Account To create a new domain user account you must log on to a domain controller server with a Domain Administrator account 1 Open the Active Directory Users and Computer configuration utility from the Start gt Administrative Tools menu 2 Onthe Users folder right click and select New User FIG 7 4 Active Directory Users and Computers IC xi amp File Action View Window Help PST ES e amp
37. oft SQL Server Management Studio Express oA EIE File Edit view Query Tools Window Community Help Huwae D Gid DOBRA 4 39 Hl Rms f Execute J M35 a An oo da swdblab RMSDBInstall sql Please ensure these META directives remain in the file gt Query exec swdblabkam db S 0RTM SWDBLAB savage 58 AMS 00 00 15 Orows FIG 38 Execute the RMSDBinstall sql SOL script file After installing the RMS database you will need to create database user account and grant specific permissions access to these account RMS supports both SQL login accounts and Windows Authentication Refer to the following sections for details on user configuration Seethe Database Authentication section on page 5 Seethe Database User Permissions section on page 31 This completes the RMS database installation You will now need to run the RMS Configuration Wizard to ensure the database connection is configured properly FIG 39 Z3 Resource Management Suite Configuration Wizard AJ ro Resource Management Suite Configuration Wizard Database E Welcome FS Database Connection Configuration Connected to database successfully Updates Product Selection E Web Services E Services Database Name E Licensing Database Version 3 0 7 3 28 2008 g Z os Permissions DB Server Name Microsoft SQL Server a ga System Settings DB Server Version 09 00 3042 Ca Fishen osoase 8
38. ord under the Use SQL S Server Authentication database connection option FIG 5 E Resource Management Suite Configuration Wizard AM Resource Management Suite Configuration Wizard ES Welcome r Configure SQL Server Database Connection Settings c Database omm tes ve g aque C Use Windows Authentication Use SQL Server Authentication Username Ims Password p Database Name RMS X FIG 5 RMS Configuration Wizard Configure SQL Server Database Connection Settings 2 Click Next to test the database connection If the database connection is successful then the following dialog will be displayed FIG 6 Resource Management Suite Configuration Wizard baas AMA Resource Management Suite Configuration Wizard Connection V Configuration 3 0 7 3 28 2008 12 00 00 PM 1 000 1600 FIG 6 RMS Configuration Wizard Connected to database successfully Ifthe database connection fails re check the SQL login account password and assigned permissions to the RMS database hdi EK Once connected successfully you can proceed with the RMS configuration no other settings or configuration is required for database authentication Windows Authentication The second authentication method supported is Windows Authentication Under this configuration each RMS process will attempt to access the RMS database using the Windows Active Directory account under which that pr
39. pens the New User dialog FIG 25 NOTE inl x L Script L3 Help User name NT AUTHORITYSNETWORK SERVICE Login name NT AUTHORITYNETWORK SERVICE CA C Certificate name i C Keyname ll C Without login Default schema EA Schemas owned by this user Owned Schemas db ddladmin db denydatareader db denydatawriter db owner db securityadmin FIEL EFEITI TI guest Database role membership Role Members db datareader db datawriter db ddladmin db denydatareader db denydatawriter E db owner db securityadmin FIG 25 New User dialog 5 Enter the NT AUTHORITYWETWORK SERVICE user name and select the login name NT AUTHORITYWETWORK SERVICE as shown above You can use the search button to locate the NT AUTHORITY NETWORK SERVICE account if needed 6 Selectthe db owner role under Role Members 7 Click OK to save the user account and permissions to the RMS database The db owner privilege will grant the NT AUTHORITY NETWORK SERVICE user account full permissions over the RMS database If you require more restrictive access refer to the Database User Permissions section on page 31 If the SQL server is running on a remote server then you will need to add the RMS server machine account to the database server security logins and then add the account and grant permissions to the RMS database catalog The computer domain account is expressed in the form of domain n
40. px MICROSOFT Explained Windows Authentication in ASP NET 2 0 http msdn microsoft com en us library aa480475 aspx c RMS Configuration Wizard amp RMS Database Wizard The RMS Configuration Wizard and RMS Database Wizard are executable utilities that run under the context of the logged on user account When attempting to use these administrative tools for RMS server installation or RMS server maintenance the user should logon with a domain user account that has administrative access to the local RMS server and administrative access to the RMS database To create a new RMS database or to perform certain database updates the logged on user account must have database creator privileges on the SQL server See the Database User Permissions section on page 31 for information on the required level of access permissions required for these database user accounts Database Authentication 30 RMS Database Administrator s Guide Database User Permissions NOTE Overview To create and configure the initial RMS database catalog database administrator privileges are required If you do not have administrative access to the database server where the RMS will be installed please consult your IT administration or DBA The RMS database catalog may be configured under two security models Flexible Access If you wish to provide for the most flexible access to the RMS database then each user account associated to the RMS database may
41. r 1 Open Microsoft SQL Server Management Studio and connect to your SQL database server 2 Expand the Security folder right click the Logins folder and select New Login FIG 22 on Microsoft SQL Server Management Studio File Edit View Tools Window Community Help zd New Query Liy ti itty P D US lal S Conect S9 92 m Y amp E local SQL Server 10 0 1600 E Databases F 1 uw I a c x Filter Start PowerShell Reports Refresh 9 Credentials 9 Cryptographic Providers E Audits Lg Server Audit Specifications Server Objects Replication Management amp SQL Server Agent Agent XPs disabled E E EE E EH Ready FIG 22 Security gt Logins gt New Login This opens the Login New dialog FIG 23 Database Authentication FIG 23 Login New dialog 3 In the Login Name field enter the NT AUTHORITY NETWORK SERVICE user account Since this is a domain account and not a local computer account you will need to enter the account login name in the form of domain Wser Also make sure the Use Windows Authentication option is selected If you use the Search button to find the account it will be displayed as NETWORK SERVICE in the search results listing 4 Click OK to save the new user account 22 RMS Database Administrator s Guide Add NT AUTHORITY N
42. r 2003 Standard SP2 32 bit only Windows Server 2003 Enterprise SP2 32 bit only Windows Server 2008 Standard 32 bit only Windows Server 2008 Enterprise 32 bit only RMS Supported Databases Microsoft SQL Server 2008 Express Edition for systems with less than 300 rooms only download available free from Microsoft Microsoft SQL Server 2008 Standard Edition Microsoft SQL Server 2008 Enterprise Edition Microsoft SQL Server 2005 Express Edition for systems with less than 300 rooms only download available free from Microsoft Microsoft SQL Server 2005 Standard Edition Microsoft SQL Server 2005 Enterprise Edition NOTE NOTE For RMS systems with more than 300 rooms the database must be installed on an external database server and not installed on the same server machine as the RMS software RMS Supported Scheduling Interfaces Scheduling Interfaces have been removed from the standard RMS installation Please visit www amx com for specifications and ordering information Supported Scheduling Systems Microsoft Exchange Microsoft Outlook Lotus Notes Groupwise EMS R25 Peoplecube Planon RMS is capable of supporting multiple up to 12 instances of Scheduling on a single NetLinx Master If you intend to run multiple instances of Scheduling on a Master then that Master should be dedicated solely to RMS Scheduling For instructions on installing and configuring the
43. ry field of the drop down box NOTE Alternatively the RMS NT services can also be configured manually via the Services manager under Administrative Tools on the Windows server FIG 18 Mame Status Startup Type Log On s By AMX RMS Communications Manager Started Automatic Local System By AMX RMS NetLinx Connection Manager Started Automatic Local System By AMX RMS Scheduling Manager Started Automatic Local System Sy AMX RMS Server Started Automatic Local System FIG 18 Services manager under Administrative Tools on the Windows server 1 Select each RMS NT service and edit the properties to display the Server Properties dialog Use the options on the Log On tab to specify the computer or domain account to use for each service FIG 19 AMX RMS Server Properties Local Computer 3 m z General Log On Recovery Dependencies Log on as Local System account Allow service to interact with desktop This account AMS Password seeececeseeeeeee Confirm password eeeeseeeeceecee You can enable or disable this service for the hardware profiles listed below Hardware Profile Service Profile 1 Enabled FIG 19 Server Properties dialog Log On tab 2 After making the changes to each of these NT services and configuring the Log On As account with the new dedicated RMS domain user account re run the RMS Configuration Wizard to correc
44. t any NTFS file permissions 22 Resource Management Suite Configuration Wizard A IM Resource Management Suite Configuration Wizard OS Permissions Configuration Web IS ASP NET e C Welcome e E Database Operating system permissions must be configured for a Product Selects User Accounts en SASS IUSR_RSAVAGE5224 ASPNET NETWORK SERVICE MeetingManager Resources MeetingManager Temporary Files Directory Permissions Are Set MeetingManager Dynamic Images Directory Permissions Are Set inished Operating system permissions are configured cd ca FIG 20 RMS Configuration Wizard Use SOL Server Authentication 3 Open the RMSDCOMConfig EXE tool in the RMS program installation directory wh ER NOTE 4 Run this tool and make sure the new dedicated RMS domain user account list included in the list of accounts FIG 21 B AMX Resource Management Suite Service Registration A IL AMX Resource Management Suite DCOM Permissions Configuration Utility This utility program will automatically configure the proper DCOM permissions configuration settings neccessary for the RMS application VI IUSR RSAVAGE5224 VI ASPNET vi SYSTEM v NETWORK SERVICE v Administrators Ua iS Remove View Permissions Grant Permissions Remove Permissions FIG 21 AMX Resource Management Suite DCOM Permissions Configuration Utility 5 Next select View Permissions If any item in the result list disp
45. the date of receipt AMX DISCLAIMS ALL OTHER WARRANTIES EITHER EXPRESS OR IMPLIED INCLUDING BUT NOT LIMITED TO IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE WITH REGARD TO THE AMX SOFTWARE THIS LIM ITED WARRANTY GIVES LICENSEE SPECIFIC LEGAL RIGHTS Any supplements or updates to the AMX SOFTWARE including without limitation any if any service packs or hot fixes provided to Licensee after the expiration of the ninety 90 day Limited Warranty period are not covered by any warranty or condition express implied or statutory LICENSEE REMEDIES AMX s entire liability and Licensee s exclusive remedy shall be repair or replacement of the AMX Soft ware that does not meet AMX s Limited Warranty and which is returned to AMX in accordance with AMX s current return policy This Limited Warranty is void if failure of the AMX Software has resulted from accident abuse or misapplication Any replace ment AMX Software will be warranted for the remainder of the original warranty period or thirty 30 days whichever is longer Outside the United States these remedies may not available NO LIABILITY FOR CONSEQUENTIAL DAMAGES IN NO EVENT SHALL AMX BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING WITHOUT LIMITATION DAMAGES FOR LOSS OF BUSINESS PROFITS BUSINESS INTERRUPTION LOSS OF BUSINESS INFORMATION OR ANY OTHER PECUNIARY LOSS ARISING OUT OF THE USE OF OR INABILITY TO USE THIS AMX SOFTWARE EVEN IF AMX HAS BEEN ADVISED OF THE
46. various scheduling plug ins available for RMS refer to the Installation Guide provided with your particular Plugin RMS Scheduling Plugin documentation is also available to view download from www amx com RMS Supported Web Browsers Windows Platform Microsoft Internet Explorer 6 Microsoft Internet Explorer 7 Mozilla FireFox 2 0 Macintosh Platform Mozilla FireFox 2 0 RMS SDK Support All NetLinx hardware platforms Touch panel files for G4 NetLinx modules RFID supported only on Duet enabled NetLinx hardware Additional System Requirements Microsoft NET Framework 2 0 Internet Information Services IIS 6 0 for Windows 2003 servers Internet Information Services IIS 7 0 for Windows 2008 servers Adobe Acrobat Reader 7 0 5 or later RMS Database Administrator s Guide 4 RMS Database Administrator s Guide Database Authentication Overview The RMS service and RMS website can access the RMS database using one of the two following authentication methods SQL Login This option provides the simplest configuration requirements A dedicated user account for RMS is defined directly in the SQL server The username and password for this dedicated user account must be configured in the RMS Configuration Wizard Once configured RMS will use these account credentials for all RMS database operations e Windows Authentication This option is a bit more complex to setup and configure but permits you to use
47. w RMS domain user account Since this is a domain account and not a local computer account you will need to enter the account login name in the form of domain user Also make sure the Windows Authentication option is selected 4 Click OK to save the new user account RMS Database Administrator s Guide 13 3 Add Domain User Account to RMS Database need to install the RMS database and then come back to this step to complete the Q If the RMS database has not yet been installed on your SQL server then you may permissions configuration for the RMS SQL Login NOTE With the RMS domain user account added to the SQL database server in the previous step we now need to add the RMS domain user and grant permissions to the RMS database 1 Open Microsoft SQL Server Management Studio and connect to your SQL database server Expand the Databases folder and find the RMS database Expand the RMS database folder and the Security folder Right click the Users folder and select New User FIG 12 T a Microsoft SQL Server Management Studio File Edit View Tools Window Community Help Quee Oy Eh D Go Ds oF lal S oe Object Explorer Ax PON Connect 3 3 m TES E 4 local SOL Server 10 0 1600 Databases System Databases Ea Database Snapshots E j Rms 9 Database Diagrams Tables Lg Views L3 Synonyms Lg Programmability E Service Broker Storage Security
Download Pdf Manuals
Related Search