Configure SQL Server Logins

applies to: nutraCoster 3.0

nutraCoster Setup automatically configures SQL Server logins. Use these instructions if you need to configure logins manually.

This procedure requires Microsoft SQL Server Mangement Studio 2014 or SQL Server Management Studio 2016. This is a free utility you can download from Microsoft at the following location.

Microsoft SQL Server Mangement Studio

Configure SQL Server Login

  1. Open Microsoft SQL Server Management Studio.

  2. In Connect to Server, set:
    • Server type to Database Engine.
    • Server name to "xxx\SWEETWAREDATA" (where "xxx" is your computer name or domain name).
    • Authentication to Windows Authentication.
    • Click Connect.

    SQL Server

    Connect to Server

  3. In Object Explorer, expand Security, expand Logins. If nutraCoster Users is not already listed, proceed to step 4.

  4. Right click Logins and select New Login...

  5. Under Select a page, General:
    • Under Login name, select Search. SQL Server 9


    • In Select User, Service Account, or Group, click Object Types...

      SQL Server 2

      Select User, Service Account, or Group

    • In Object Types, select Groups. Click OK.

      SQL Server 3

      Select Groups

    • In Select User, Service Account, or Group, enter "nutraCoster Users" into Enter the object name to select field. Click Check Names. Click OK.

      SQL Server 4

      nutraCoster Users

    • In Default database, choose CostDB.

    SQL Server 5


  6. Under Select a page, User Mapping:
    • Under Users mapped to this login, select CostDB.
    • Under Database role membership for: CostDB, select db_owner and public.

      SQL Server 6

      User Mapping

  7. Under Select a page, Securables:
    • Click the Search button. Under Add Objects, select The server "xxx\SWEETWAREDATA", and click OK. SQL Server 7


    • Under Permissions for "xxx\SWEETWAREDATA", Grant permissions for Connect SQL and View any definition. SQL Server 8

      Securables, Permissions

  8. Click OK to finish.