Software

   nutraCoster 3.0 Desktop

   nutraCoster 3.0 Cloud

   nutraCoster 2.1

   stockCoster 2.1

   SmallPICS 2.0

   Ingredient Library 2&3

   Nutrition Data Share

Services

   Nutrition Analysis

Support

   Support Articles

   User Group

Prices/Ordering

   Desktop Versions

   Cloud Version

Links

   Labeling Regulations/
   Government Sites

About SweetWARE

   Testimonials

   Press Releases

   Contact Us

   Privacy Policy

Configure SQL Server Services and Protocols

applies to: nutraCoster 3.0

nutraCoster Setup automatically configures SQL Server. Use these instructions to manually configure SQL Server if necessary.

  1. Run SQL Server Configuration Manager.
    • Windows 10: Right click the Start button, and choose Run. Type "sqlservermanager12.msc" into the Run field and click OK.
    • Windows 7: Click the Start button. Type "sqlservermanager12.msc" into the Search field and click the Search icon (Search Icon).

  2. Configure SQL Server Network Protocols.
    • Under SQL Server Configuration Manager (Local), expand SQL Server Network Configuration (32bit or 64bit).
    • Click Protocols for SWEETWAREDATA.
    • If Shared Memory is not enabled, right click and choose Enable.
    • If Named Pipes is not enabled, right click and choose Enable.
    • If TCP/IP is not enabled, right click and choose Enable.
  3. Config SQL Server

    Configure SQL Server Network Protocols

  4. Configure SQL Server Services.
    • Under SQL Server Configuration Manager (Local), click SQL Server Services.
    • If SQL Server (SWEETWAREDATA) is not running, right click and choose Start.
    • If SQL Server Browser is not running, right click and choose Start.
    • nutraCoster 3.0 does not use SQL Server Agent (SWEETWAREDATA).
  5. Config SQL Services

    Configure SQL Server Services

  6. Configure TCP/IP.
    • Under SQL Server Configuration Manager (Local), expand SQL Server Network Configuration (32bit or 64bit).
    • Click Protocols for SWEETWAREDATA.
    • Right click TCP/IP and select Properties.
    • Under the IP Addresses Tab, scroll all the way to the bottom to IPAll.
    • Set the TCP Port to 50001.
    • Click Apply. You will be prompted to restart your SQL Server Services. Refer to Step 3 above. Right click each service, and chooose Stop. After it stops, right click the service again and choose Start.
  7. Config TCP Port

    Configure TCP/IP