Page Comparison

You first of all need to consider whether to use SQL authentication or Windows (or trusted) authentication as your SQL authentication method.
Use Windows authentication when your SQL Server belongs to a Microsoft Active Directory. If no Active Directory domain is available, SQL authentication can be used to create local accounts.

Benefits of Windows authentication

...

Notes
Even if you use Windows authentication, SQL Server must still be set for Mixed Mode authentication to enable Crystal Reports to run. Mixed Mode allows both SQL and Windows accounts to be created.

Procedure to add a new user to SQL Server
To add a new user to SQL Server to enable them to access the Synergetic database:

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

...

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

...

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

...

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

...

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

...

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

...

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

...

...

1.  Image Added
   
   
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 Added
   See also Resetting another user's Synergetic password

...

1. .
   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 Added 
   Tip: To edit the user mapping, locate the user in the Object Explorer Details tab, right click and select Properties.
   

...

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

...

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

...

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

...

1. Image 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.
   
2. Select the Map field next to the SynergyOneMedia database.
   

...

1. Click AnchorO_26390O_26390 Image RemovedImage Added
2. Click Image Added.
3. Create the user in Synergetic. See Creating new users (on page ).
   

...

1. Image Added