{{tag>Index Installation Integration DB MSQL}}
[<10>]
===== Integrating AwareIM 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.

<callout type="warning" icon="true" title="important">Support for the full version of MS SQL Server database is optional in AwareIM. Before integrating this database with AwareIM make sure that this option is available in your AwareIM edition.</callout>

  - 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 AwareIM 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 AwareIM



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



  - Delete the default ''AwareIM/bin/BASServer.props'' file which contains default database settings
  - Rename the file ''BASServerMSDE.props'' to ''BASServer.props''
  - Use any text editor to modify the following lines in the ''BASServer.props'' file located in the ''BIN'' directory of your //**AwareIM**// installation:

<code>
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
</code>


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  ^
^AwareIM fails to authenticate with MS SQL Server.    |Check that you specified correct user name and password in the BASServer.props file|
^AwareIM 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 //**AwareIM**// does not start it could be for reasons described in the following table (which also suggests what to do):


{{simplenavi>docs:1100_inst_guide:0350_db_integration:0200_msql:}}