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.- 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.
- Start the Aware IM Control Panel
- Select the Settings/Database menu item and select SQL Server as the database engine
- Enter credentials of the SQL Server account.
- Specify SQL server name and the port number where SQL Server listens to requests (if these are different from the default values)
- 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:
- Delete the default
AwareIM/bin/BASServer.props
file which contains default database settings - Rename the file
BASServerMSDE.props
toBASServer.props
- Use any text editor to modify the following lines in the
BASServer.props
file located in theBIN
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 port | 1. 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):