How to Create a Citrix Datastore in SQL Server 2008 R2
Created by Guillermo Musumeci - Date: July 9, 2010

This procedure explains how to create a Citrix Data Store in SQL Server 2008  step by step.

STEP 1: Open SQL Server Management Studio console, choose Database Engine and enter Server name if you are accessing a remote server.

STEP 2: Right Click in Databases and select New Database

Step 3: Enter a database name. Optional: set Initial Size and Autogrowth for both Primary filegroup and the log file.

Step 4: Verify the new database appears under Databases

Step 5: Expand Security, then right click on Logins. Select New Login.

Step 6: using the Search button, select an Active Directory account (recommended) or a local account if you are using workgroup for testing purposes.

Step 7: Click in User Mapping and choose db_owner as Database role membership and in the Default Schema select dbo using the Browse button (Window below).