Page Comparison

...

1. Run SQL Server Management Studio from the desktop or Start > Programs > Microsoft SQL Server.
   

...

1. Image Modified
   The Connect to Server window is displayed.

...

1. 
   Image Modified
   
   
2. Enter the login details for the server running SQL Server.
3. Click AnchorO_26377O_26377Click .
   The Microsoft SQL Server Management Studio window is displayed.

...

1. 
   Image Modified
2. Select View > Object Explorer, if Object Explorer is not already displayed.

...

1. 
   Image Modified
   The Object Explorer pane is displayed on the left-hand side of the window.

...

1. 
   Image Modified 
2. Drill into the following by clicking the plus sign +" next to:
   • [+] Microsoft SQL Servers
   • [+] SQL Server Group
   • [+] (Your Server Name)
   • [+] Security

...

1. 
   Image Modified
2. Right click Logins.
   The following menu is displayed.
   

...

...

1.  Image Modified
   
   
2. Select New Login.
3. Enter the user details. If you are using:
   • Windows authentication, add a group not a user
   • SQL authentication:
   • Type the user's SQL Server login name in the Login Name field.
   • Select SQL Server Authentication.
   • Type the user's initial password in the Password and Confirm password fields.
   • Select SynergyOne from the Default Database drop-down list.
   

...

1. Image Modified
   See also Resetting another user's Synergetic password

   Anchor
   H_1465 H_1465

   (on page ).
   Note: Leave default language as Default. 
   
2. Click User Mapping on the Login - New window.
   The User Mapping tab of the Login - New window is displayed.

...

1. 
   Image Modified 
   Tip: To edit the user mapping, locate the user in the Object Explorer Details tab, right click and select Properties.

...

1. 
   Image Modified
2. Select the Map field next to the SynergyOne database.

...

1. 
   Image Modified
2. Select public only, unless the user designs Crystal Reports or uses Microsoft Query.

...

...

1. Image Modified
2. If the user needs access to financial resources, select the Map field next to the SynergyOneFinance database.

...

1. 
   Image Modified
   Note: Other database areas can be set up too. By default, the user can only access information through Synergetic, not other programs like Microsoft Excel. Contact Synergetic Management Systems for more information.
   
2. Select the Map field next to the SynergyOneMedia database.

...

1. 
   Image ModifiedClick Anchor
2. O_26390O_26390Click .
3. Create the user in Synergetic. See Creating new users (on page ).
   

...

1. Image Added