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).
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).
No comments:
Post a Comment