| If you will be utilizing the Resource Manager summary database feature of Feature Release 2 and above, you will need to create a database on a SQL Server and of course, MetaFrame XP Server itself requires a Data Store and SQL Server is a prime candidate. Knowing this, I recommend utilizing the following procedures to install Microsoft SQL Server 2000. 1. Insert the Microsoft SQL Server 2000 Standard or Enterprise Edition CD and click the SQL Server 2000 Components button. 
2. Click the Install Database Server button to continue. 
3. Click Next 
4. Click Next 
5. Click Next to continue 
6. Enter you name and company and click Next. 
7. Click Yes to agree to the license agreement. 
8. Click to select the Server and Client Tools radio button and click Next. 
9. Click Next 
10. Click the Browse button(s) to change the destination folder for SQL Server and its databases. 
11. Click the Use a Domain User Account radio button and enter a username and password for the associated service account. Click Next when finished. 
12. Click to select the Mixed Mode radio button and enter a password for the SA account. Click Next when finished. Note: A password is required in order to keep with basic security best practices 
13. Click Next. 
14. Enter the appropriate Microsoft SQL Server licenses and Click Continue when finished. 
15. Click Finish 
You have now successfully installed Microsoft SQL Server 2000 and are ready to apply any service packs (SP3a) and create the MetaFrame XP IMA database.
For security, stability and functionality reasons I recommend keeping current with the latest SQL Server service pack level. Service Pack 3a also is a requirement to prevent against the Slammer worm. To download the latest service pack please visit: http://www.microsoft.com/sql/downloads/2000/sp3.asp The following details how to install Service Pack 3a for Microsoft SQL Server 2000 1. Extract the contents of the download and double click on setup.bat to install Service Pack 3a. 
2. Click Next to continue. 
3. Click Yes to agree to the license agreement. 
4. Select the instance you want to apply the service pack to and click Next. 
5. Select the account that has access to update the SQL server and click Next. 
6. Verify the Upgrade Microsoft Search and apply SQL Server 2000 SP3 (required) check box is checked and click Continue. 
7. Click the OK button to continue. Note: I also recommend keeping the check box enabled so any possible issues you run in to will be sent to Microsoft so they can begin to addresses their bugs. 
8. Click Next to start the installation. 
9. Setup reminds you to backup the databases and prompts you to click OK to continue. 
10. Click Finish to complete the installation of Microsoft SQL Server Service Pack 3. 
If you installed Microsoft SQL Server 2000 using the Typical installation option or via unattended installation procedures (sqlins.iss file) 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 XP Server to the newly created data store by using a standard SQL login like system administrator (SA), you will receive the following error message: | Unable to connect to server SERVER_NAME:
Server: Msg 18452, Level 16, State 1[Microsoft][ODBC SQL Server Driver][SQL Server]
Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection. | Note: This behavior is different 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 changes 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 Mode After a SQL Server 2000 Typical Installation (Q269587) http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q269587
The following table documents how to create a data store database with Microsoft SQL Server 2000 1. Click Start click Programs click Microsoft SQL Server click 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. Click the Data Files tab and click the Space allocated (MB) text field assoicated with the new XP Datastore database and enter the space needed for the IMA database. For more information on IMA datastore file usage please refer to the Citrix MetaFrame Advanced Concepts guide found on www.citrix.com. 
6. Click the Transaction Log tab and click the Space allocated (MB) text field assocated with the new XP Datastore database and enter the space needed for the IMA database. For more information on IMA datastore file usage please refer to the Citrix MetaFrame Advanced Concepts guide found on www.citrix.com. 
7. Expand the Security folder 
8. Right-click Logins and choose New Login. 
9. 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 will also want to document the username and password you choose as you must enter it during the MetaFrame XP installation and any future installations. In the Defaults area of the General tab, change the Database to the name you specified in Step 4. 
10. 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. 
11. Click OK. You are prompted to confirm your password. Doing so completes database creation. 
|