Installing CurrentWare with Local SQL on a Domain Controller

Installing CurrentWare with Local SQL on a Domain Controller

When you install CurrentWare it is not recommended to use a Domain Controller and SQL on the same PC. If it is necessary to do so, you may run into errors when installing SQL. This is related to the permissions that are created on the SQL Services, as the domain controller cannot properly assign them.

To resolve the installation issue:

A. If you are preparing to install CurrentWare on a Domain Controller
  1. Go the Microsoft website and download the SQL Express version you are going to install. Ensure it is compatible with your Operating System.
  2. Run the installation package. When prompted to choose between “Recommended Installation” and “Custom Installation”, select Custom Installation.
  3. You can next through the steps. When you reach “Server Configuration” there is an input needed.
    • For “SQL Server Database Engine”
      • Account Name Column: Enter your Domain\Administrator credentials.
      • Password Column: Enter the Domain\Administrator account password.

B. If you have already installed CurrentWare on a Domain Controller
  1. Open your Windows Services.
    • Search “Services.msc” in your windows search bar.
  2. Search for “SQL Server (SQLEXPRESS)”.
    • If you entered a different name for the SQL Server during the install, it will be SQL Server (YourName) as the SQL server service.
  3. Right-click “SQL Server SQLEXPRESS” and choose Properties.
  4. Go to the Log On tab.
  5. Under “This account:” enter the domain credentials.
  6. Enter the Password in the “Password:” and “Confirm Password:” entry boxes.
  7. Press Apply to save the changes, and the SQL Server should now be able to start.


    • Related Articles

    • SQL 2012 Troubleshooting steps

      Windows Server 2012 R2 uses old and outdated technologies. Since the newer versions of SQL tend to install smoothly it is recommended to use a SQL 2016/17/19 instance. If you run into issues installing SQL when using SQL 2012 here are steps to ...

    • Troubleshooting SQL Server Connection Issues with CurrentWare Server

      If the CurrentWare Server is unable to connect to the SQL server, you may need to configure the Windows Firewall and SQL Server Configuration Manager to allow SQL Server access. Add the sqlsvr.exe into Window’s Firewall Inbound Rule list Go to ...

    • How do I Setup CurrentWare with SQL Express

      Welcome to the SQL Express Database Installation and Setup page. Benefits of using a SQL Database with the cwServer are an increase in overall performance and stability of client connections. Here are the steps to download, setup and configure your ...

    • Installing CurrentWare on Amazon Web Services (AWS)

      Follow the 4 simple steps to get started on your CurrentWare setup on AWS . Create a Windows virtual machine Configuring your VM to Accept CurrentWare Client Connections Install the CurrentWare Server Deploy the CurrentWare Clients Step 1: Create a ...

    • Which databases does the CurrentWare Server support?

      The CurrentWare Server is compatible with the following databases: SQL Server Express (default) SQL Server Standard SQL Server Enterprise SQL Server As of v6.0.1, SQL Server is necessary as a database for Currentware. Please see our informative guide ...