4. 3^rd Party IMA Data Store Installation Instructions  

During the design phase of the project plan, you decided which server will act as the data store, if you will be utilizing a Microsoft SQL solution, follow the following installation instructions.   If you will be using Oracle please refer to the MetaFrame XP Advanced Concepts guide.  If you will be using the Access data store, it will be installed by the MetaFrame installation on the first server in the farm.

4. 1.        How to create the MetaFrame XP Data Store with SQL Server 2000

The following table documents how to create a data store database with Microsoft SQL Server 2000

1.       Run SQL Enterprise Manager on your Microsoft SQL server (Start  Programs  Microsoft SQL Server  Enterprise Manager).

2.       In the Enterprise Managers left pane, expand the tree until you reach the folder level.

3.       Right-click the Databases folder and choose New Database

4.       A dialog box appears. In the Name box, enter a name and click OK.

5.       Expand the Security folder

6.       Right-click Logins and choose New Login.

7.       A dialog box appears with the General tab displayed. In the Name box, enter a name. Make note of the name because you will need to enter it during the MetaFrame XP installation.

In the Authentication section of the General tab, click SQL Server authentication and enter a password. Remember the password; you must enter it during the MetaFrame XP installation.

In the Defaults area of the General tab, change the Database to the name you specified in Step 4.

8.       Click the Database Access tab. In the Database list, select the database name specified in Step 4.

In the Database Roles list, select DB_Owner. Leave other selected roles checked.

9.       Click OK. You are prompted to confirm your password. Doing so completes database creation.

4. 1. 1 How to Change the Default Login Authentication Mode

If you installed Microsoft SQL Server 2000 using the Typical installation option or by using the Sqlins.iss file for a typical unattended installation then you will need to set the default SQL authentication mode.   By default Windows Authentication is the default security model therefore, when you try to connect a MetaFrame server to the newly created data store by using a standard login like system administrator (SA), you will receive the following error message:

Note: This behavior is different than from Microsoft SQL Server 7.0. In SQL Server 7.0 the default authentication mode is Mixed (Windows NT Authentication Mode and SQL Server Authentication).

To prevent this behavior you will need to change the authentication mode to Mixed.

To change the authentication mode from Windows NT Authentication Mode (only) to Mixed Mode, use the following steps:

1.       Run SQL Enterprise Manager on your SQL server (Start  Programs  Microsoft SQL Server 2000 Server  Enterprise Manager)  

2.       Expand a Server group and  right click a server name, and then click Properties .

3.       Click the Security tab and under Authentication, click the SQL Server and Windows radio button.

4.       Restart SQL Server in order for the change to take effect.

Note: For additional information please refer to the following Microsoft support articles:

INF: How to Change the Default Login Authentication Mode to SQL While Installing SQL Server 2000 Desktop Engine by Using Windows Installer (Q285097)

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q285097

INF: Windows Authentication is the Default Security Mode After a SQL Server 2000 Typical Installation (Q269587)

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q269587