If you are creating a fresh installation, install the configuration database in these steps:
Ensure that your configuration database is binary compatible
To support localization across multiple locales, your Microsoft SQL Server installation (2005 and 2008) that hosts the configuration database must be binary collated, such as SQL_Latin1_General_CS_AS.
Binary collation means that text is case sensitive and allows an application to differentiate values such as the labels Zip code and Zip Code. Binary collation also makes AppStudio user names case sensitive.
Run the configuration database installer
To run the configuration database installer:
Ensure that Microsoft SQL Server 2005, 2008, or 2012 is running.
Extract and run the configuration database installer on the database host machine. The installers are stored in the platform ZIP file:
There are two executables to choose from, each in its own ZIP file:
- PyxisMobileDatabaseInstaller_xxx_emptydb_2005.exe (SQL Server 2005)
PyxisMobileDatabaseInstaller_xxx_emptydb_2008.exe (SQL Server 2008)
PyxisMobileDatabaseInstaller_xxx_emptydb_2008.exe (SQL Server 2012)
On Windows 7, you must run the installer as the administrator.
- In the Run Package dialog box, set the following fields:
- Server: Set to the name of the server hosting the configuration database. It might take a moment for the pull-down menu to populate
- Choose an authentication type: Windows authentication, or SQL Server authentication. If you choose SQL Server authentication, supply login information—user name and password—in order to create a database and database objects.
- Select Make a database
- Click Advanced.
- In the configuration database options window, set the following fields:
- Database and Log: Set to the desired directories. By default, both are set to the same directory as the SQL server database.
- Set Collation: Set to the language of your enterprise data source.
- Recovery model and Database size (MB): Set as desired. Appery recommends setting the Recovery model to Simple for development and Full for production. You can modify these settings at any time.
- Click OK.
- In the Database field of the Run Package dialog box, enter a name for the configuration database. For example, AppStudio. Write down the name of this database as you need it later in the installation process.
- In the Run Package dialog box, click Run.
Click Yes. Then click OK once the package has executed successfully.
On Windows 7, if a “This Program might not have installed correctly” compatibility message appears, click on “This program installed correctly”.
The configuration database installation package creates the database on the server, and builds tables, stored procedures and user-defined functions.
Create a database user with owner permissions
After installing the configuration database, create a database user. The user must have owner permissions in SQL Server Enterprise Manager on the configuration database.
The user you create in SQL Server corresponds to an administrator user in AppStudio. For example, create a database user named "mpdemo" with a password of "mpdemo". When you log in to AppStudio, you are prompted for an administrator user name and password, as well as the database server name and configuration database. AppStudio uses that log in name and password to connect to the database, so it should match the user name and password of the database user.