SQL Server Database and Password FAQS

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 have SQL installed on the computer you’re planning to install the CurrentWare Server, it will install it with the following credentials:

SQL Account Name: sa
SQL Account Password: Currentware123!

Where is the CurrentWare SQL Database stored?

By default your CurrentWare SQL Database will be stored locally at:

C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\DATA

To do any changes to your SQL database you must install the SQL Server Management Studio.

  1. You can find that download here.
  • Go to the link provided.
  • Click on Download SSMS (SQL Server Management Studio).
  • Once downloaded run the SSMS setup file.
  • Follow the prompts to fully install SSMS.
  1. Once SSMS is installed you can type sql server management studio into the Start menu and open the Microsoft SQL Server Management Studio.
  2. Choose to connect with Windows Authentication and hit connect.
  3. Expand the groups under the Object Explorer by using the +/- tabs betside the folders. You want to Expand the Server > Security > Logins folders.

  1. Double-click the sa login user.

  1. Enter the new password in the password & confirm password fields and hit OK. Make sure to record this password securely to not forget your database password.

    • Related Articles

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

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

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

    • Backup and Restore the SQL Database

      It is important to back up your CurrentWare SQL database to ensure that you retain your historical information from CurrentWare’s solutions such as BrowseReporter and AccessPatrol. There are a few ways to back up the CurrentWare database. 1. Backup ...