Direct and Indirect Data Store Connection
A MetaFrame Presentation Server can connect to the IMA Data Store in two ways. Depending on the type of database software you decide to use, MPS servers make either a direct connection or an indirect connection.
A direct connection to the IMA Data Store means that the database software resides on a dedicated server and all the MetaFrame servers connect directly to this dedicated database server and plug into the IMA Data Store. This type of connection is associated with Microsoft SQL Server, Oracle, and IBM DB/2 databases.
An indirect connection to the IMA Data Store means that the first MetaFrame server you install in the farm hosts the Data Store, which is in the format of a Microsoft Access or an MSDE database. All MPS servers added thereafter will connect to the first MPS server, which hosts the IMA Data Store and will then connect to the Data Store, thereby making an indirect connection. The MPS servers can’t connect directly to the Data Store database but first have to connect to the MPS server and then to the Data Store it hosts.