Connecting the Business Services to the SQL Server database

Open the Business Services Configuration Tool.

Switch to the Database tab.

Under PACS Database Settings, select SQL Server.

In the SQL Server Name field, type the SQL Server database server name.

Click Configure ODBC.

In the ODBC Data Source Administrator dialog, switch to the System DSN tab.

Click Add.

In the Create New Data Source dialog, select SQL Server. Click Finish.

In the Create a New Data Source to SQL Server dialog, as the Name, type mvf_sql.

As the Description, type mvf.

From the Server list, select the name of the SQL Server. Click Next.

Click SQL Server Authentication.

Ensure that the Connect to SQL Server to obtain checkbox is selected.

As the Login ID, type mvf.

As the Password, type mvf.

Click Client Configuration.

In the Add Network Library Configuration dialog, ensure that TCP/IP is selected. Click OK.

Click Next.

Select the Change the default database to checkbox.

From the list, ensure that mvf is selected. Click Next.

Clear the Perform translation for character data checkbox. Click Finish.

To test the connection, click Test Data Source.

When prompted that the connection was successful, click OK.

To close the ODBC Microsoft SQL Server Setup dialog, click OK.

To close the ODBC Data Source Administrator dialog, click OK.

In the IMPAX Business Services Configuration tool, click Test.

If the message Connection to SQL Server database successful appears, click OK.

If the test fails, verify that the SQL Server Name is correct and test the connection again.