How do I Setup CurrentWare with SQL Express

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 own SQL Express server with Microsoft SQL Server Management Studio.

Overview

  1. Install SQL Express
  2. Install SQL Server Management Studio
  3. Setting up your SA (Server Administrator) account in SSMS for CurrentWare
  4. Changing Authentication to Mixed Mode (SQL and Windows Authentication)
  5. Add the sqlsvr.exe into Window’s Firewall Inbound Rule list
  6. SQL Server Network Configuration Settings
  7. Connecting CurrentWare to my newly setup SQL Server

Install SQL Express

To get started you must download SQL Express. Download the free version of SQL Express from the following link: SQL Express Server 2019
NOTE: Windows 8.1 and older will not work with SQL Express Server 2019. You can also use SQL Express Server 2017.

Once you open the Installer choose basic and follow the steps of the installer.



When you get to the end of the SQL Server Express installation it will prompt you to install SSMS (SQL Server Management Studio). You need to install this to manage your SQL Server.


Install SQL Server Management Studio

Find the download for SQL Server Management Studio here: Microsoft SQL Server Management Studio (SSMS)

Open and run the Microsoft SQL Server Management Studio installer.

Follow the installation steps. After installing SQL Server Management Studio you need to restart your PC/Server.


Setting up your SA (Server Administrator) account in SSMS for CurrentWare

  1. Open SSMS (SQL Server Management Studio)
  2. Hit the “Connect Button”
  3. Go to Security > Logins on the left side in the Object Explorer
  4. Double click “sa” account
  5. In General change the password to something easy that you wont forget and turn off password policy. An example would be “password”.

  1. Go to Status within the Login Properties of the sa account
  2. Change Login to Enabled


Changing Authentication to Mixed Mode (SQL and Windows Authentication)

CurrentWare uses SQL Server authentication instead of Windows authentication. When setting up SQL express for the first time, make sure you select “Mixed Mode (SQL Server and Windows authentication)”. Without this, you won’t be able to connect your cwServer to your SQL server.

  1. Right click your SQLEXPRESS Server from the Object Explorer Panel
  2. Go to properties > Security
  3. Change server authentication to “SQL Server and Windows Authentication mode”
  4. Hit OK. You should be prompted to restart your SQL Server
  5. Right click your SQLExpress Server from the Object Explorer Panel and “Restart” it

Add the sqlsvr.exe into Window’s Firewall Inbound Rule list

  1. Go to Control Panel > System and Security > Windows Firewall > Advanced Settings
  2. Right click on Inbound Rule and select New Rule…

  1. For Rule Type, select Program and click Next
  2. For Program, browse to your SQL Server installed path and select sqlservr.exe
  3. For Action, select Allow the connection and click Next.
  4. For Profile, leave all 3 profiles checked.
  5. Enter the name as “CurrentWare SQL” and click Finish.

SQL Server Network Configuration Settings

  1. Open the SQL Server Configuration Manager
  2. Ensure that the SQL Server Browser service is running and the start mode is set to
    automatic.

      3. Under SQL Native Client Configuration > Client Protocols, ensure TCP/IP is enabled.

  1. Right click on TCP/IP and select Properties.
  2. Ensure the Default Port is 1433

  1. Under SQL Server Network Configuration > Protocols for MSSQLSERVER (Alternitivly this may say Protocols for SQLEXPRESS) , right click on TCP/IP and select Properties
  2. Click on the IP addresses tab and ensure the TCP Dynamic Ports is set to 0


Connecting CurrentWare to my newly setup SQL Server

  1. Fresh Installation of CurrentWare
  2. Migrate Firebird Database to a SQL Database

Fresh installation of CurrentWare

  1. Run the CurrentWare Installer
  2. Continue through the installation until you are prompted to select your Database Server Selection.
    Note: This will only happen if you are installer a pre 6.0.2 version.
  1. Choose the proper SQL Server and use the previously setup “sa” SQL account and password.

  1. Choose Install to proceed with the installation.

Next through until the installation until you are prompted to finish and the CurrentWare Console opens. You should be able to see that you have a new database created in your SQL Server Management Studio.

Congratulations! Your CurrentWare SQL Database is created and setup.


If you have further issues with your CurrentWare Solutions, contact our technical support team.


    • Related Articles

    • 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 ...
    • How do I connect CurrentWare to my SQL Server?

      From your CurrentWare Server, go to C:\Program Files (x86)\CurrentWare\cwServer\ In this folder you can run the CWSM.exe file. This will bring up the CurrentWare Server Manager. Select Database > Selection > SQL Server. Enter your SQL Server details: ...
    • Move the CurrentWare server to another computer with network SQL database

      When moving your CurrentWare software to a new server/PC you need to make sure you do not have both consoles connecting to the same networked database. Here are the steps to take. #1 Back up your existing cwServer Database Before you migrate your ...
    • Security & SQL Database Best Practices

      Security and Workflows Connection to the Web Console Starting with v8.0.1, the CurrentWare web console will have a preconfigured self-signed SSL certificate that is enabled by default. This will ensure that network communication to and from the ...
    • Configure Port Forwarding for Remote Workers (SQL)

      Connecting the CurrentWare Clients (Remote workers) To connect your CurrentWare Clients to the CurrentWare Server over the Internet, you will need to port forward the CurrentWare traffic from your network’s router to the CurrentWare Server computer. ...