Please This article explains how to replace an existing Noah application server when your SQL Server is configured with Mixed Mode Authentication. It assumes:

  • The SQL Server is already installed and operational.
  • The previous application server was successfully connected to the SQL Server.
  • You have the necessary credentials for the SQL Server instance.

Example Setup

For this guide, the computers are named as follows:

  • SQLTest – SQL Server
  • SQLTest2 – New Application Server

Step 1: Install Noah on the New Application Server

  1. On the new Application Server, install the version of Noah you want your practice to use.
  2. After installation, log in using the default username and password.
  3. Close Noah before proceeding to the next step.

Step 2: Run the SQLiteToMSSQL Tool

  1. Launch SQLiteToMSSQL.exe on the application server.
  2. Click Migrate, and then select Edit Configuration File.
  3. Enter the appropriate details to the Server connection parameters. For more detail on these parameters see Step 4 in the Configuring Noah with SQL Server directions here:
    • Instance Name: The SQL instance name.Server Name: The name of your SQL Server (e.g., SQLTest).Verify that the connection string reflects the correct user credentials.
    Example connection parameters:
  1. Click Migrate, then select Test MSSQL database connection.
  • Confirm the result is OK.

Step 3: Skip Database Creation and Data Export

Since the SQL database is already created and contains your data:

  • Do not create a new MSSQL database.
  • Do not export data to MSSQL.

Step 4: Update Settings Files

  1. In the tool, select Settings files update.
  2. Select the NoahDatabaseCore.dll file and click OK.
  3. Close SQLiteToMSSQL.exe when complete.

Step 5: Verify Database Connection in Noah

  1. Open Noah on the application server.
  2. Confirm that patient data from the SQL Server appears.

To verify Noah is using SQL (and not SQLite):

  • Open Noah Console.
  • Navigate to Database Administration.
  • You should see:
    “This tab is not accessible because Noah 4 is configured to use another database than SQL CE.”

Step 6: Connect Client PCs

Once the application server is confirmed to be working:

  • Connect your client PCs to the new Application Server.

Back to using SQL Server