Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


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

    The Connect to Server window is displayed.

  2. Enter the login details for the server running SQL Server.
  3. Click .
    The Microsoft SQL Server Management Studio window is displayed.
  4. Select View > Object Explorer, if Object Explorer is not already displayed.

    The Object Explorer pane is displayed on the left-hand side of the window.
  5. Drill into the following by clicking the plus sign +" next to:
    • [+] Microsoft SQL Servers
    • [+] SQL Server Group
    • [+] (Your Server Name)
    • [+] Security
  6. Right click Logins.
    The following menu is displayed.


  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.

    See also Resetting another user's Synergetic password.
    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.
    Tip: To edit the user mapping, locate the user in the Object Explorer Details tab, right click and select Properties.
  10. Select the Map field next to the SynergyOne database.
  11. Select public only, unless the user designs Crystal Reports or uses Microsoft Query.
  12. If the user needs access to financial resources, select the Map field next to the SynergyOneFinance database.

    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.
  14. Click .
  15. Create the user in Synergetic. See Creating new users.