Page Comparison

...

1. Run SQL Server Management Studio from the desktop or Start > Programs > Microsoft SQL Server.
   Image RemovedImage Added
   The Connect to Server window is displayed.
   Image RemovedImage Added
   
   
2. Enter the login details for the server running SQL Server.
3. Click Image RemovedImage Added.
   The Microsoft SQL Server Management Studio window is displayed.
   Image RemovedImage Added
4. Select View > Object Explorer, if Object Explorer is not already displayed.
   Image RemovedImage Added
   The Object Explorer pane is displayed on the left-hand side of the window.
   Image RemovedImage Added 
5. Drill into the following by clicking the plus sign +" next to:
   • [+] Microsoft SQL Servers
   • [+] SQL Server Group
   • [+] (Your Server Name)
   • [+] Security
   Image RemovedImage Added
6. Right click Logins.
   The following menu is displayed.
   
    Image RemovedImage Added
   
   
7. Select New Login.
8. 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.
   Image RemovedImage Added
   See also Resetting another user's Synergetic password AnchorH_1465H_1465 (on page ).
   Note: Leave default language as Default. 
   
9. Click User Mapping on the Login - New window.
   The User Mapping tab of the Login - New window is displayed.
   Image RemovedImage Added 
   Tip: To edit the user mapping, locate the user in the Object Explorer Details tab, right click and select Properties.
   Image RemovedImage Added
10. Select the Map field next to the SynergyOne database.
    Image RemovedImage Added
11. Select public only, unless the user designs Crystal Reports or uses Microsoft Query.
    Image RemovedImage Added
12. If the user needs access to financial resources, select the Map field next to the SynergyOneFinance database.
    Image RemovedImage Added
    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.
    
13. Select the Map field next to the SynergyOneMedia database.
    Image RemovedImage Added
14. Click Image RemovedImage Added.
15. Create the user in Synergetic. See Creating new users (on page ).
    Image RemovedImage Added