, , , ,

Integrating Aware IM with MS SQL Server database

If you do not have MS SQL Server database software you can download the free version (SQL Server Express) from the Microsoft web site. Make sure that MS SQL Server or SQL Server Express is running and perform the integration steps described below.

important

Support for the full version of MS SQL Server database is optional in Aware IM. Before integrating this database with Aware IM make sure that this option is available in your Aware IM edition.
  1. Make sure that your MS SQL Server database is configured to use TCP/IP protocol – please refer to the MS SQL Server manual for details.
  2. Start the Aware IM Control Panel
  3. Select the Settings/Database menu item and select SQL Server as the database engine
  4. Enter credentials of the SQL Server account.
  5. Specify SQL server name and the port number where SQL Server listens to requests (if these are different from the default values)
  6. Click OK and restart Aware IM

If you installed Aware IM as Windows service you can perform database integration manually without using the Aware IM Control Panel. To do this:

  1. Delete the default AwareIM/bin/BASServer.props file which contains default database settings
  2. Rename the file BASServerMSDE.props to BASServer.props
  3. Use any text editor to modify the following lines in the BASServer.props file located in the BIN directory of your Aware IM installation:
DriverURL=jdbc:sqlserver://localhost:1433;user=sa;password=password;databaseName=BASDB
DriverTestURL=jdbc:sqlserver://localhost:1433;databaseName=BASDBTEST;user=sa;password=password;
BootstrapURL=jdbc:sqlserver://localhost:1433;user=sa;password=password;
DriverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
DatabaseComponent=com.bas.basserver.persistence.dbplugins.MSSQLServerInterface

Change values for user and password properties in the first three lines above to provide the credentials of your MS SQL Server account.

If you are running a specific instance of the SQL Server configure this instance to listen on a particular TCP/IP port and specify this port in the URL above

Troubleshooting MS SQL Server database integration.

Cause of failure What to do
Aware IM fails to authenticate with MS SQL Server. Check that you specified correct user name and password in the BASServer.props file
Aware IM cannot connect to the MSQL Server through the default TCP/IP port1. Check that SQL Server is configured to use TCP/IP. Restart the SQL Server service after you make the changes.

2. If SQL Server is listening for connections on a different port than the default port 1433, specify this port number in the BASServer.props‎ file‎ after‎ localhost‎ in‎ the 3 lines mentioned in the previous sections, for example localhost:1450

3. Check that the port on which SQL Server is listening for connections is not blocked by a firewall.

If Aware IM does not start it could be for reasons described in the following table (which also suggests what to do):