How do I connect CurrentWare to my SQL Server?

How do I connect CurrentWare to my SQL Server?

  1. From your CurrentWare Server, go to C:\Program Files (x86)\CurrentWare\cwServer\
  2. In this folder you can run the CWSM.exe file.
  3. This will bring up the CurrentWare Server Manager.
  4. Select Database > Selection > SQL Server.
  5. Enter your SQL Server details:
    1. SQL Server name and instance
    2. Authentication: SQL Server Authentication (recommended)
    3. SQL Account name and password
  6. A new SQL database called CWNPSQL.mdf will be created on your SQL Server.

Is SQL Server required to run CurrentWare?

By default, CurrentWare uses a SQL database. SQL Server is an additional download packaged with the CurrentWare installation. SQL Server is recommended to manage your CurrentWare Servers database.

Which version of SQL Server is compatible with CurrentWare?

CurrentWare is compatible with most SQL Servers – 2012, 2014, 2016, 2017,2019 (Express, Standard and Enterprise).

Don’t have a SQL Database server installed yet?

The steps to install and setup your SQL Server to use with your CurrentWare Solutions are here: SQL Express Setup with CurrentWare

Troubleshooting

Visit https://support.currentware.com/portal/en/kb/articles/sql-troubleshooting to see the troubleshooting steps for setting up an SQL Server


    • Related Articles

    • Remote CurrentWare Console is unable to connect to CurrentWare Server using SQL database

      If you have setup a Remote CurrentWare Console to be able to access your CurrentWare server running off a SQL database and are having connection issues. This is usually caused by either Firewall blocking or SQL Server settings. Solutions Turn OFF ...

    • 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 ...

    • SQL Server Database and Password FAQS

      This page has some of the most frequently asked questions with how your SQL server interacts with CurrentWare. What is the default SA password for the CurrentWare SQL database? The CurrentWare installer is prepackaged with SQL Express. If you don’t ...

    • 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 ...

    • 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 ...